PDA

View Full Version : Document



jkaheng
10-29-2003, 03:34 PM
Dear Sir,
May we know whether there is any manual for Mondrian OLAP ?
Thanks

sgwood
10-29-2003, 04:01 PM
http://apoptosis.dyndns.org:8080/open/mondrian/doc/index.html
which is listed as the Home Page on SourceForge.
After reading through that, if you have any questions, plese do not hesitate to ask on this forum.
You may get confused between Mondrian functionality and the JPivot web user interface - lots of folks do. Ask, and we will do our best to help you...
Cheers,
Sherman

jkaheng
11-02-2003, 06:38 PM
Dear Sherman,
Thanks. I'm looking for a detail documentation on the XML schema that we need to generate. I try to look for that at the http site that you mention, but can't find.
I got error when I run below.
<Schema>
<Cube name="Sales">
<Dimension name="Product" >
<Hierarchy hasAll="true" primaryKeyTable="sale" >
<Join leftKey="prod_id rightKey="prod_id">
<Table name="sale"/>
<Table name="product"/>
</Join>
<Query>
<SQL dialect="generic">
SELECT *
FROM "sale", "product"
WHERE "sale"."prod_id" = "product"."prod_id"
</SQL>
</Query>
<Level name="Product" column="prod_name" uniqueMembers="true"/>
</Hierarchy>
<Measure name="Sales Amount" column="sale_amt" aggregator="sum" formatString="Standard"/>
</Cube>
</Schema>
Thanks

sgwood
11-03-2003, 12:18 AM
Try this:
<Schema>
<Cube name="Sales">
<Dimension name="Product">
<Hierarchy hasAll="true" primaryKeyTable="sale" >
<Join leftKey="prod_id" rightKey="prod_id">
<Table name="sale"/>
<Table name="product"/>
</Join>
<Level name="Product" column="prod_name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Measure name="Sales Amount" column="sale_amt" aggregator="sum" formatString="Standard"/>
</Cube>
</Schema>
You had some invalid XML.
The Query tag is no longer used, I think - its not in the schema DTD.
Cheers,
Sherman

jhyde
11-03-2003, 04:57 AM
Did you check out 'Writing a schema',
http://apoptosis.dyndns.org:8080/open/mondrian/doc/schema.html
The definition of the XML format (from which the DTD is generated) is
http://apoptosis.dyndns.org:8080/open/mondrian/src/main/mondrian/olap/Mondrian.xml

jkaheng
11-03-2003, 10:33 PM
Dear Sherman, Julian,
Thanks for the info.
I try to click the mondrian.dtd in
http://apoptosis.dyndns.org:8080/open/mondrian/src/main/mondrian/olap/Mondrian.xml
but it return
//open/mondrian/src/main/mondrian/olap/mondrian.dtd - no such file(s).
Thanks

sgwood
11-04-2003, 05:01 AM
You can find the DTD in the Mondrian distribution.

jkaheng
11-04-2003, 10:20 PM
Dear Sherman,
I try using the schema that you stated, but it return parsing error.
If I use other SQL tool and do
select * from sale, product where sale.prod_id=product.prod_id, I got the result.
Thanks

sgwood
11-05-2003, 01:29 AM
What was the parsing error?

jkaheng
11-05-2003, 02:32 PM
Dear Sherman,
Below is the error.
Thanks
javax.servlet.ServletException: Internal error: while parsing catalog jndi:/localhost/mondrian-0.5/WEB-INF/queries/db3.xml
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.testpage$jsp._jspService(testpage$jsp.java:909)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:56)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:62)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:536)

sgwood
11-05-2003, 04:14 PM
It looks like something is swallowing an exception.
Does the document exist in the JNDI store?
What does your jsp look like?

jkaheng
11-06-2003, 04:56 PM
Dear Sherman,
This one was working
Thanks
<Schema>
<Cube name="Sales">
<Table name="sale"/>
<Dimension name="Product" foreignKey="prod_id" >
<Hierarchy hasAll="true" primaryKey="prod_id" primaryKeyTable="sale" >
<Join leftKey="prod_id" rightKey="prod_id">
<Table name="sale"/>
<Table name="product"/>
</Join>
<Level name="Product" table="product" column="prod_name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Measure name="Sales Amount" table="sale" column="sale_amt" aggregator="sum" formatString="Standard"/>
</Cube>
</Schema>