Long Time Duration for displaying chart

[achitreskyitgroup]

We have a pivot table with more than 25 Dimensions and 8 Metrics.
The Data takes really long time to render on the screen. It increases with added metrics and dimensions. I have undergone following changes:

1. Moving Pivot Table to Straight Table
2. Flattening the Data model to pull from single table
3. Adding Limit to the number or rows displayed (The Pivot calculates all the expression before limiting the data)
4. Dimensions are pulled without any calculations

These did not make much of a difference to the times.

Is there a way to dynamically generate the row count before the chart calculations are triggered so that we can limit the number of rows.

PS: We do have filter more as an option but keeping it as our last resort as the client does not like it.

Any ideas would be appreciated

[Lisa_P]

Do you have any calculated dimensions or complex expressions that can be simplified ?

[Brett_Bleess]

The easiest way to get further help on this one would be to attach the app in question, so folks can see the data model and all the expressions etc., otherwise likely going to be a bit difficult to really provide much useful advice.

Regards,
Brett