Define a quantity characteristic, aggregable = Max or Min

[Former Member]

Hi

I populate a quantity characteristic in a cube.

This characteristic is defined as Quantity and she must be not aggregable (MAX or MIN).

In the characteristic definition, the Aggregation=SUM, the attribute is read only ?

How can i modify it to MAX or MIN

Thanks

Gilles F.

[Former Member · Accepted solution]

Hi Gilles,

I think you have to choose the aggregation at the infoobject creation.

You cannot change this in edit mode.

Regards,

Adrien.

[Former Member]

Hi,

I just created an other cfk with the correct aggregation information,

Its work find.

Thanks.

Gilles F.

[Former Member]

The aggregation seems to be read only, i canot change it to Max or Min

[Former Member]

hi,

Create a CKF and then define the exception aggregation on it.

regards,

Arvind.

[Former Member]

Nop, you can't,

Create another object if you can, or use the exception aggregation in the query it works for your needs.

Regards,

Adrien.

[Former Member]

Hi Gilles,

As i have said earlier you can not change it.

You need to create CKF or formulas and use quantity KPI in that, Then you will be able to change the aggregation setting of that new CKF or formulas.

Try it and let us know if you have any issue.

Regards,

Ashish

[Former Member]

Hi,

if you set the KF properties in RSD1 to Min / Max, be aware that whenever you create an aggregate on the cube, the aggregation characteristic will be added automatically. This may turn down the advantages you expect from aggregate. Therefore try to solve the issue in BEx (this works onky in BEx 7.x and not in 3.x)

Regards

Aban

[Former Member]

Hi,

You can change the Key figures perporties in Quantity info object .

Go to Quantity info object select change -> Aggreation Tab -> it's default selcted by sum you can change Select Max. or Min.

Hope it's hlep you.

Thanks and Regards,

Venkat.

[Former Member]

Hi Gilles,

Kindly use that Quantity Key figure in formulas.

or create restricted KF/Calculated KF.

then and only then you can change the aggregation setting of KPIs at query designer level.

Regards,

Ashish

[Former Member]

Hi Gilles,

You can do it in different ways,

1) Got RSD1 transaction and maintain your infoobject, goto aggregation tab and select the aggregation type as MIN or MAX.

2) Or if you want to use it in query then goto your query and goto the key figure properties, there will you will have the option "Calculate Single Value as" In the dropdown box you can set min or max.

Regards,

Durgesh.