Skip to Content
0
Jun 03, 2013 at 06:06 PM

Presentation of a query in different crosstabs

90 Views

I have a requirement to present the query in different formats. E.g. Query returns with 12 key figure values and I need to separate these 12 KFs in separate cross tabs. E.g. Query output in DS 1. KF1 KF2 KF3 KF4 KF5 KF6 KF7 KF8 KF9 KF10 KF11 KF12 100 120 140 160 180 200 220 245 265 285 305 315 Output expected in Crosstabs. Crosstab 1: KF1 KF2 KF3 100 120 140 Crosstab 2: KF4 KF5 KF6 160 180 200 and so on.. - Prime requirement is to execute the query only once but distribute to multiple crosstabs (with different fields in visible). - Query execution time is considerable, hence we need to reduce the execution of the same multiple times. - Query views has been attempted but no performance gain. Thanks,
Rahul