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

Restricted Key figure in Qery

I have a critical problem - many points for a solution :). In my cube (Purchasing data - 0PUR_C01) I have several invoices that correspond to a material. Each invoice has an invoice date and an invoice amount;

Cube contents:

Material A - 2004-01-14 - 1000 USD

Material A - 2004-03-05 - 1500 USD

Material A - 2004-12-20 - 1700 USD


Material B - 2004-03-15 - 100 USD

Material B - 2004-04-17 - 200 USD

Material B - 2004-11-30 - 300 USD

Now, in the report I need to define a restricted (or calculated, or anything) key figure containing the amount from the latest invoice for each material. In the examples above the result would be:

Material A - 1700 USD

Material B - 300 USD

The restricted key figure is later to be used as a base in price development calculations.

How can I solve this, if it’s not possible to solve in the report I’m ready to restructure the flow.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 27, 2005 at 11:44 AM

    Did you tried to define an calculated KF (=invoice) with Exception Aggregation LAST value on the Time Characteristic?

    The CKF must be "global", so deifned at InfoCube level to use exception aggregation

    Hope it helps.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2005 at 11:53 AM

    Hi Daniel,

    You can achieve it with the Aggregation settings of the Key Figure as follows:

    Aggregation: SUM

    Exception aggregation: Last value

    Agg. referen. char 0CALDAY or whatever temporary characteristic you use in the cube.

    You must consider that this setting will affect the KPI aggregation procedure and probably this won't be the expected result in the other queries so you better create a copy of the KPI with this settings and map it with initial KPI in the Update rules of the cube.

    Hope it helps,


    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.