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

Author Topic: how to avoid cross join in analysis studio  (Read 2587 times)


  • Guest
how to avoid cross join in analysis studio
« on: 20 Oct 2010 11:13:36 pm »
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 ?