on 01-27-2005 11:33 AM
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 its not possible to solve in the report Im ready to restructure the flow.
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.
GFV
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
Andreu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.