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.