Minimum in calculated key figure

[charla_robertson]

Hi All,

I am trying to use the minimum function in a calculated key figure for Net Contents (0NET_CONT).

In the cube we have:

Article Content Unit Net contents

2000 KG 10

2000 KG 5

2000 KG 1

In my Bex query, by article 2000, the Net Contents appears as 16. I want it to be the minimum of whats in the cube (in the above example I would want it to be 1)

In my calculated key figure, I am using MIN (Net Contents, Net Contents) as my formula. And in the extended properties, I have specified calculate Before Aggregation. In my query though, it still reports as 16 instead of 1.

Any suggestions?

Thanks

Charla

[Former Member · Accepted solution]

Hi,

I think you have to select after the aggregation in this case because before aggregation calculates every single record and you have to calculate with several records.

I hope it helps.

[former_member189638]

Hi Charla,

Is your issue solved or are u still facing the problem???

[former_member189638]

Or else try the following.

First u need to create a calculated Key Fig globally. You can do this at the extreme left end of the query Designer. Just right click on the Calculated key Fig and say New Calculated Key Figure

Give the description of the Key Fig and in the formula section just put the the key fig . 'Net Contents' in you case

When u say ok it will open the properties of the key fig there u can see Enhance>> at the bottom. Click on that make the exception aggregation to miminum and refernce characteristic Article.

Save this calculated key fig. Now use this newly created Calc Key Fig in the query.

[former_member189638]

Go to the properties of the key Fig <b>Net Contents</b>.

Set the <b>Calculate Result</b> as to minimum.

Hope this helps

[Former Member]

Charla,

Try out with exception aggregation.