Skip to Content
0

Do drill down/up on crosstab triggers data source again and again?

Jan 18, 2017 at 12:55 PM

43

avatar image
Former Member

Hi All,

I am using design studio 1.6 and having performance issue with crosstab while drill-up and drill-down in run time using context menu.

Lets, say i have country as dimension and few measures values. when i drill down on country dimension to see state level data it takes more time to display the data with country and state level. same case when I drill up also.

My question is, whenever I drill-down or drill-up is the datasource being triggered again and again? if not any other tips to make drills little faster?

our backend is HANA 1.0 sp12

Thanks in advance

Regards,

Mathivanan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Jan 18, 2017 at 01:00 PM
0

Please run profiling in Design Studio - see Karol's blog here: https://blogs.sap.com/2015/06/30/understanding-profiling-and-statistics-in-design-studio/

And Martin's blog - https://blogs.sap.com/2013/12/08/design-studio-tips-and-tricks-measuring-performance/ it should tell you where things are running and how long

Share
10 |10000 characters needed characters left characters exceeded