Question:
how can I get the newest data of an infocube ?
We load data each day and fill 0calday. Now I want to know the newest entry of 0calday. I need this info for another program.
I have searched for fubas but didn't find anything...
Thanks a lot for your help
Answer:
You can get the latest data with the request number of the latest load.
With this request ID number, you can select the latest data from the InfoCube.
Answer:
not every time...
example:
we load at the 01.10.2005 data with 0calday 25.09.2005. at the 02.10.2005 we load data with 0calday 20.09.2005.
So the latest request (02.10.2005) hasn't the newest data of 0calday....
Answer:
In fact is has the most recent data of 0calday, because the loading date is the most recent.
What you mean is to have the records where 0calday = highest in cube?