cancel
Showing results for 
Search instead for 
Did you mean: 

Last value

guillermo_m
Active Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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).

Former Member
0 Kudos

Hi ,

As suggested by Ajay the CKF with the exception aggregation with reference to CALMONTH will do .

The CALDAY or the DATE may not give proper values.

Thanks

Mukesh

Answers (0)