Require "Update Date" in Cube

[Former Member]

Hi,

When we right click on "Infocube" and select "manage" in RSA1, we get the details like update date, records updated, records transfered, etc.

I want to include this "update date" in infocube as a field. Is this possible? if yes then please guide me.

Thanks

Anuj

[former_member185181 · Accepted solution]

add 0calday in your cube.

then in transformation routine, you can assign sy-datum to 0calday so that you get the updated date of request.

[Former Member]

Hi Anuj,

You can use 0CALDAY in the cube and in the transformation for this field use a rule type of ABAP routine and write the below single line code.

RESULT = sy-datum.

regards

Kulmohan

[Former Member]

Hi Anuj,

Update date is nothing but the date when the request was loaded to the cube. This will always be the system date. So you can add a date field to the cube and map it to the system date. It will give you the update date.

This would not work onky in cases where is data volume is huge and crosses a day.

-Vikram