ji 1.1.0 and Sugar CRM OLAP Example

[hoko]

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

[hoko]

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