aggregation in query level for key figure

[Former Member]

i have face some problem in 7.0 with aggregating key figures and the problem is that it is shown diable and i wanted to do average of key figures but i can not . but if i make the query in 3.5 then i am able to do that. so please help to solve the problem.

[Former Member]

Amit,

If you want to do at the keyfigure level then go to keyfigure change mode and go to the aggregation tab and change the property there. If you want to do the same at the query level then create a CKF for the same, and go to ehnace and select after aggregation.

Hope this helps..

Gattu

[Former Member]

In the infoobject screen in RSD1 for that particular key figure in the BEx explorer tab, check Exception aggregation settings and Aggregate reference charecteristics. The combination of settings in this 2 fiels affect query results for the key figure