cancel
Showing results for 
Search instead for 
Did you mean: 

Simple doubt on data load/ report display value ?

former_member182467
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

amine_lamkaissi
Active Contributor
0 Kudos

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

former_member182467
Participant
0 Kudos

Hi Amine,

Thanks for the update. But this is a zchar IOBJ....and we cannot edit the cube as its a standard cube. We need to make use of this char IOBJ and get it resolved. Do you have any suggestions for the same ? Please suggest. I appreciate it.

Thank You,

DR