Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Document

  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Default Document

    Dear Sir,
    May we know whether there is any manual for Mondrian OLAP ?
    Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Document

    http://apoptosis.dyndns.org:8080/ope...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

  3. #3
    Join Date
    Oct 2003
    Posts
    6

    Default RE: Document

    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

  4. #4
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Document

    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

  5. #5
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Document

    Did you check out 'Writing a schema',
    http://apoptosis.dyndns.org:8080/ope...oc/schema.html
    The definition of the XML format (from which the DTD is generated) is
    http://apoptosis.dyndns.org:8080/ope...p/Mondrian.xml

  6. #6
    Join Date
    Oct 2003
    Posts
    6

    Default RE: Document

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

  7. #7
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Document

    You can find the DTD in the Mondrian distribution.

  8. #8
    Join Date
    Oct 2003
    Posts
    6

    Default RE: Document

    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

  9. #9
    Join Date
    Sep 2002
    Posts
    475

    Default RE: Document

    What was the parsing error?

  10. #10
    Join Date
    Oct 2003
    Posts
    6

    Default RE: Document

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.