on 04-10-2013 11:55 AM
Hi,
If we are loading the infocube daily and its a delta load. There is 1 zfield in the infocube, its called zdate, this gets the value of sy-datum ( system date/current day's) date while loading the infocube. This zdate field is displayed in the report in free characteristics.
My question: Can we get the last value in the report for this field, and can we get the last date when the cube was loaded. For example, this gets loaded 2 days back. IN the report, if we put last value for this zdate field as the property. Can we get 2 day's back date in the report ? It should not display any other value, ....if the data get's loaded today. the value should be today's date as today is the last value for that zdate field.
How to satisfy this requirement ? Our requirement is to display the last loaded date in the infocube ? Please suggest any options, lookup's , variable,s customer exits, formula's...whatso ever...Its an infocube and gets delta load every 10 or 15 days. I appreciate it.
Thank You,
Daniel
Hi Daniel,
Such a requirment, you can perform it at BEX level.
You can choose option MAX to get the last date.
Or an exception aggregation last value directly on your keyfigure.
Hope it helps.
Amine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.