Performance Issue

[krishna20]

Hi Friends,

I'm using pivot table with 6 Dimensions and 10 Expressions. In the dimensions Policy No's, start Date,End Date,Insurer names are having vast data. This chart is taking much time to load with these dimensions and expressions. I'm loading the data only for three years in this table by using condition like if(policy_year>=2013,Policy_no) but no use. when i'm checking in the access point this sheet is not loading.

How can i achieve this pls anyone suggest me

Regards

Krishna

[petter]

First of all using an If() does not prevent the three year table being scanned and furthermore the If() is quite expensive operation. A Set Expression which filters out the [policy_year] is much better. It has to be used in each of the expressions tough like for example this:   Sum( { < [policy_year={2013} > } Amount ).

To find out where the performance issue is you should start by disabling all but one of the expressions and see if that helps on the performance. Misplaced fields that should be dimensions but being used as if they were measures can create major problems performance wise - make sure you are not in that situation.

A sample of your data together with the QVW showing your exact chart with the dimensions and expressions could be helpful to give you some more advice on where you should look...