on 08-04-2009 9:57 PM
Hi gurus!
I have an InfoCube wich is loaded manually every month but not the same day of every month. In the query I must show the last value that is loaded in the InfoCube. I've got the Plant and the 0NET_VALUE Key Figure in the query. If the user doesn't load the current month yet I need that the query shows the last value that is loaded in the Cube (in this case the past month).
Does exist a formula, a variable or something like this to achive this?
Thanks in advance.
Regards.
Create a CKF equal to Net Value, define exception aggregation (in Bex designer) for this CKF as
'Last Value' with reference characteristic 'CAL Month' (or date if you have that).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.