Presentation of a query in different crosstabs

[rahulvilas_chaudhari]

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

[rahulvilas_chaudhari]

Hi Ingo,

I used another syntax available for cell usage.

I wrote below code for On Startup event:

TEXT_1.setText(DS_1.getDataAsString(

"009ZVKYB3L9Q2CAH0ZN2B6KG1", { "0FISCVARNT": "Z1"}));

This populated text field with value from table cell & I could re-arrange the single executed datasource.

Sincerely appreciate your guidance. Thanks.

Rahul