If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to avoid cross join in analysis studio

Started by kennyyeungkw, 20 Oct 2010 11:13:36 PM

Previous topic - Next topic

kennyyeungkw

Something about using analysis studio

I have a cube about 1GB.
crosstab information:
Column : Year - month - shipment_type
Row : For user selection


The performance of drag 1 dimension is fine .within 10 second.

But when i drag more than 1 dimension into the row ,the report become slower and slower .

Currently ,I have a dimension with more than 10000 member within one level (which like order no ,user dont want to be grouped)
..
When drag this to the row ,the report become extremely slow
I guess it is because of the cross job of 2 dimensional ,it there any solution ?