Statistics: last compressed request in infocube date & last aggregated comp

[Former Member]

Hi experts

I wonder if someone knows if there is any table where statistiscs regading:

Date of last compressed request in infocube.

Date of last compressed request for aggregate

appears.

We do know that could go infocube per infocube to get that information, but we would appreciate if you could provide the table as it will safe a lot time.

thank you very much in advance!

[Former Member]

Hello,

Check the Table :

RSDDSTAT

RSDDSTATAGGR

RSDDSTAT_OLAP

RSDDSTAT_DM

RSDDSTAT_WRITE

RSDDSTATAGGRDEF

Hope it will be helpful.

Regards

Vikas Sharma

Robert Bosch

[Former Member]

Hi,

Pls refer the list of tables in the below link

http://wiki.sdn.sap.com/wiki/display/BI/ImportantTablesinSAPBI%28NW2004%29

Hope this helps.

Thanks.

[Former Member]

Date of last compressed request in infocube.: RSDDSTATCOND

[Former Member]

Hi,

It seems that this table appear when the aggregate was created, but what i need is the date of when the last request was compressed and the last aggrated was also compresed.

thanks you!

[Former Member]

Hi,

On the Cube, right click -> Manage and under tab "Rollup" you see log button, here you get all options to select and get information you are looking for.

Also, on "Collapse" tab you can get information about when the Cube was compressed.

Hope this helps.

Thanks,

Naveen Rao Kattela

[Former Member]

Hi,

If you have installed BI Admin Cockpit, you can use the multiprovider 0TCT_MC11 to get the details. You can also check the tables RSMDATASTATE and RSMDATASTATE_EXT.

Regards,

Suzitha