Skip to Content
author's profile photo Former Member
Former Member

Key Figures and Aggregation options

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2005 at 11:35 AM

    > 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)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2005 at 12:18 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.