Pivot table performance issue

[Anonymous]

Hi All,

I have dataset of 10million..and this data has been consumed by Pivot table and date field is being pivoted...which is taking lot of time to display..literally hanging the application and refreshing back to landing page. Please let me know if you have any solutions or any other alternative approaches to resolve performance issue.

Regards,

Chetan Kumar Gopinath

[vvira1316]

Hi Chetan,

Would you be able to share a sample of your data and app? It will help to help you, without that not I'm not sure how someone will be able to provide any suggestion.

BR,

VIjay

[Anonymous]

Hi Vijay,

As I mentioned we have approx 10 milliion fact data, as of now i have exttracted 5weeks dataset for your reference and attached the same along with application screenshot.

Regards,

Chetan

[vvira1316]

Hi Chetan,

Thanks for sharing it. As it is limited set and also not sure what your data model actually looks like. It will be difficult to replicate scenario and know what may be impacting. I've tried recreating pivot table.

Please advise what your scenario looks like, if it is different then what I've done so far. Expression, data model, etc.

[Anonymous]

Hi Vijay,

I was on vacation, sorry for the delayed response.

I reviewed the app you have prepared with data I provided and its right. Now since same data in my data model takes approx. 5-6 to load entire data, however there is a chances of refreshing the entire application. I am repeating same, my data model has huge number of records, like ~10 million. No complicated expression in pivot too. Lets say now you increase same data by 5 times. I am very sure performance will take a hit.

I know you may ask to handle in data model to load faster, expect the pivot chart rest other objects loads faster. So I need your input for alternative solution or techniques to load pivot faster. Any thoughts?

Regards,

Chetan