Skip to Content

Condition Aggregation at Node level in query

Dear All

I have a requirement where user needs to see the Effective active trucks based on hierarchy. While expanding the hierarchy count is correct at plant level. But at the node data is aggregated and this shows to total count of individual plant. While user requirement says that if a truck is going to two plant then in total this has to be add only 1 time not twice.

Data available in Cube:

For this requirement I have an option to add the new key figure also if required. Please suggest.

Regards

Lalit Tyagi

Data available.JPG (28.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 07, 2015 at 07:59 AM

    Hi Lalit,

    you need to work with exception aggregation.

    if possible, do it in the info object (your count key figure) and set exception aggregation to max or average on char "truck no".

    if you can not do it in the info object, create a calculated key figure, put in only your count, define the exception aggregation for truck no.

    regards

    Cornelia

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 24, 2015 at 03:15 PM

    Dear Cornelia

    Thanks for the suggestion, but I think that the requirement is not possible, because I need the summation at hierarchy node which expand to plants while as per my exception aggregation I need that to be done on Truck number which cannot be possible.

    Please suggest if there is any other way to achieve this.

    Regards

    Lalit Tyagi

    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.