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

Minimum in calculated key figure

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 04:27 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 04:31 PM

    Charla,

    Try out with exception aggregation.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2007 at 05:05 PM

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

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

    Hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2007 at 05:15 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 20, 2007 at 03:25 AM

    Hi Charla,

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

    Add a comment
    10|10000 characters needed characters exceeded

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.