Skip to Content
0
G G
Aug 04, 2009 at 08:57 PM

Last value

38 Views

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.