SQL for BI-IP query reads all Key figures from the cube

[Former Member]

Hi All,

The real-time Infocube on which the planning query (BI-IP, BI 7.0 , ABAP SP 14) is based has a large number of key figures (> 100) . I have created an aggregation level with only 1 Key figure. The ready-for-input query contains only 1 key figure. The SQL statement created - when you execute this query - however reads all the keyfigures in the cube:

SELECT

/*+

STAR_TRANSFORMATION FACT(F)

*/

"DT"."SID_0FISCPER" AS "S____002" ,

SUM ( "F"."ADMNSTRTN" ) AS "Z____055" ,

SUM ( "F"."ADVERTISNG" ) AS "Z____056" ,

SUM ( "F"."G_AERLOS" ) AS "Z____057" ,

SUM ( "F"."G_ASTDPR" ) AS "Z____058" ,

SUM ( "F"."G_AVVA10" ) AS "Z____059" ,

SUM ( "F"."G_AVVA15" ) AS "Z____060" ................etc

If the query is a normal BW query - the generated SQL reads only 1 key figure from database. Any thoughts on - whether it is designed to work this way or we need to correct this issue are welcome.

I am in the in process of reviewing the OSS note:

001063768 Performance of plan queries with high no. of key figures --> but I am not sure if this will correct the issue.

thanks

Arvind

[Former Member]

Set the star transformation field to active/enable mode. your queries will start executing fast