cmoudy

Post your web.xml file there's nothing at the default web.xml file that is shipped with the product so we'll need to see yours.

Has anyone gotten REX to work with Jasper Intellegence v1.0? It looks like a very useful tool for developing MDX visually. However I cannot connect to the Mondrian server it does not let me because I must supply a username and password. Has anyone gotten this to work? http://sourceforge.net/projects/whex

Has anyone gotten Rex (waRehouse EXplorer) to work with Jasper? It seems like the xmla connection is expecting a username and password but there is no place to enter this information. It looks like it would be a helpful tool for MDX creation for those of us that do not know much about those things. Anyone tried it? http://sourceforge.net/projects/whex

You need to place your oracle driver within the lib directory of the web app. Example. jasperintelligence-1.0apache-tomcatwebappsjasperserverWEB-INFlib From there the app server will automatically pick it up and load the driver.

Actually just got it to work with several dimensions. Turns out what I needed to do for a work around was to provide a private synonym for the dimension tables then I don't have to fully qualify the tables. Honestly surprising there wasn't more about this well call it a "bug" out there, but thanks so much for your help.

That worked when I used the actual user of the schema! Now the only problem is the dimensions cannot be drilled down into. Does anyone know how to actually get this to work or work arounds for not having to fully qualify the tables? Thanks again sbirney!!! At least now I have something that sort of works even if I can't drill down and have a better understanding of the error!

I have been struggling to get a simple OLAP example to work against our development database after a nice presentation from the JasperSoft folks. When I dig into the error message it turns out the SQL query being generated actually contains the name of my fact table twice in the from clause. Of course Oracle throws an error saying the statement is not properly ended. I have double checked the data source, foreign keys, table names and so forth. Any help is greatly appreciated! Simple Schema definition: Code: <Schema name="EdwardSchema"> <Cube name="QuickClick"> <Table name="VASDS.SDS_ASSMT_RESULT_QC"/> <Dimension name="Grade" foreignKey="GRADE_ID"> <Hierarchy hasAll="true" allMemberName="All Grades" primaryKey="GRADE_ID"> <Table name="VAMDS.MDS_GRADE"/> <Level name="Grade" column="GRADE_CODE" uniqueMembers="true"/> </Hierarchy> </Dimension> <Measure name="Pass Count" column="PASS_CNT" aggregator="sum" formatString="#"/> </Cube> </Schema> Simple MDX query: Code:[code] select {[Measures].[Pass Count]} ON COLUMNS,{[Grade].[All Grades]} ON ROWS FROM [QuickClick] Nasty Error Returned: JPivot had an error ... org.apache.jasper.JasperException: javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy Digging into the log file a little results in finding the following… Code:[code] mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'select {[Measures].[Pass Count]} ON COLUMNS,{[Grade].[All Grades]} ON ROWS FROM [QuickClick]' However that looks correct still going down the stack trace we see the culprit. Code:[code] Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum("VASDS"."SDS_ASSMT_RESULT_QC"."PASS_CNT"«») as "m0" from "VASDS"."SDS_ASSMT_RESULT_QC" "VASDS"."SDS_ASSMT_RESULT_QC"] There are two of my fact tables listed in the From cause why???