Key Figures and Aggregation options

[Former Member]

Hi All,

There are three aggregation options:Minimum,Maximum,Sum on the Aggregation Tab when creating a Key Figure on the Admin Work Bench. I understand that these aggregation rules are set for the Key figure BEx default settings. Does this affect at all how the data is loaded into the cube?

Another question. If I have a Key Figure that I have set to Maximum, and would like to change to Sum.. Do I need to unload the data in the cube and load it again?

Thanks.

[Former Member]

Hi,

it is not possible to change the aggregation option of a keyfigure when it is already used in a cube and data loaded to the cube.

regards

Siggi

[Former Member]

I was able to edit the table RSDKYF and change the value for the Key Figure on field AGGRGEN. It changed from Maximun to Summantion. Howvere, when I execute the queries, I did not notice any change in the way that the Key Figure is aggregarate.

Thanks

[Former Member]

> There are three aggregation

> options:Minimum,Maximum,Sum on the Aggregation Tab

> when creating a Key Figure on the Admin Work Bench.

> I understand that these aggregation rules are set for

> the Key figure BEx default settings. Does this affect

> at all how the data is loaded into the cube?

Indeed: these are report relevant settings only.

> Another question. If I have a Key Figure that I have

> set to Maximum, and would like to change to Sum.. Do

> I need to unload the data in the cube and load it

> again?

I'm not sure about this one: Since it's a report-relevant setting only, i wonder there would be a reason why all the cubes where the KF is used should be empty...

(you can always change the setting directly in table RSDKYF, field AGGRGEN)