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

Exception Aggragation in Queries

Hi

I wanted to achieve the Balance type Keyfigure in the queries using the normal KF. So the idea was to use exception aggragation in the queries which is available in the Calculated KF Properties -> Enhance -> Exception aggragation as per the documentation.

But I am abel to just get After and before aggragation in the enhance option.Is there are special settings in the CKF to achieve Exception aggargatioon wrt a Char.

I did go through the white paper for Balance Sheet KF using the Cell editor but that doesn't satisfy my requirement.

Any help would be appriciated.

Best Regards,

Shiva

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 10:46 AM

    Hi Shiva,

    the settings are available due to formula complexity. If you define any calculations in the definition of calculated key figure, you will only be able to specify setting "time of calculation". If you insert a key figure from your InfoProvider into the definition of the calculated key figure, you will be able to define an exceptional aggregation.

    Best regards,

    Björn

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Shiva,

      unfortunately I do not know a workaround for "last value", I only know it is possible for "average" and "no aggregation"... How is the definition of your calculated key figure - you say, there is no further calculation?

      Best regards,

      Björn

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.