How to check F table data logs

[Former Member]

Hi Guys,

I was wondering if anyone can help me.

I would like to check how many records were in the F table before the lite optimize was run. I would also like to check historical data.

Is there a way of checking this?

Regards

Avni

[damovand]

Hello Avni,

Why do you need to see this information?  As you probably know Fact tables do not provide any type of audit or historical views.  If you are checking to see how much data is sent to the table each day you should find that statistics manually or if you have a strong background in ABAP maybe an ABAP function module can do that.

Regards,

Leila

[Former Member]

Hello Avni,

Light Optimization moves records from the F to the E fact tables. So, you can check the E table content.

For more details, please refer to: http://scn.sap.com/community/epm/planning-and-consolidation-for-netweaver/blog/2012/04/13/lite-optim...

I hope this helps.

Best regards,

Nedra.

[harsha_jalakam]

Hi,

To check the number of entries in the F table,

Goto the required cube->Click on Contents Tab ->Fact Table

then click on Number of Entries(Ctrl+F7),

This would give you the number of entries in F table at the instance.

Regards,

Harsha

[Former Member]

Hi Harsha,

This only gives the number of records at current state not the historical records. Do you know how I can get historical record?

Regards

Avni

[harsha_jalakam]

I don't think we have any such option to store historical  records.Please refer to the below doc.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c035d300-b477-2d10-0c92-f858f7f1b...