Hi,
i wanna setup the example "Creating OLAP view with a Mondrian connection" from the JasperIntelligence-User-Guide.
* i make a import of the sugarcrm-db-dump-113005.zip Dumpfile into my Mysql Database
* then a make exactly the steps from the chapter 6.7.1
* at the "file resource" screen, i upload the file SugarCRMOppsSchema from the JI 1.1.0 archive, because i did not found the SugarCRMOpps.xml file from the chapter 6.7.1.5.
But my Problem is, i can't insert the MDX Query
"select {[Measures].[Total Sale Amount], [Measures].[Number of Sales], [Measures].[Avg Sale Amount], [Measures].[Avg Time To Close (Days)], [Measures].[Avg Close Probablility]} ON COLUMNS, NON EMPTY {([Account Categorization].[All Accounts], [Close Period].[All Periods])} ON ROWS from [SalesAnalysis] where [Sale State].[All Types].[Closed Won]
"
because JI say's "That is not a valid MDX Query: null"
Any idea? Did anybody get this example running?
best regards
Holger Koch
i wanna setup the example "Creating OLAP view with a Mondrian connection" from the JasperIntelligence-User-Guide.
* i make a import of the sugarcrm-db-dump-113005.zip Dumpfile into my Mysql Database
* then a make exactly the steps from the chapter 6.7.1
* at the "file resource" screen, i upload the file SugarCRMOppsSchema from the JI 1.1.0 archive, because i did not found the SugarCRMOpps.xml file from the chapter 6.7.1.5.
But my Problem is, i can't insert the MDX Query
"select {[Measures].[Total Sale Amount], [Measures].[Number of Sales], [Measures].[Avg Sale Amount], [Measures].[Avg Time To Close (Days)], [Measures].[Avg Close Probablility]} ON COLUMNS, NON EMPTY {([Account Categorization].[All Accounts], [Close Period].[All Periods])} ON ROWS from [SalesAnalysis] where [Sale State].[All Types].[Closed Won]
"
because JI say's "That is not a valid MDX Query: null"
Any idea? Did anybody get this example running?
best regards
Holger Koch
1 Answer:
Posted on October 19, 2006 at 2:09pm
i solved it by my self.
Instead of configure the whole olap view at once, i started to configure the olap view for the sugarcrm example step by step.
* datasource
* olap schema
* olap connection
and after all was successfully configured, i create the olap view.
This works for me even though i used exactly the same parameters, cube script and mdx query. curious
best regards
Holger Koch
Instead of configure the whole olap view at once, i started to configure the olap view for the sugarcrm example step by step.
* datasource
* olap schema
* olap connection
and after all was successfully configured, i create the olap view.
This works for me even though i used exactly the same parameters, cube script and mdx query. curious
best regards
Holger Koch
