BPC 10 NW - E Fact Table not found

[Former Member]

Hello,

I cannot find the E fact table in my BW system which relates to my Consolidation model. When I go to SE16 I see there are 3 tables that match the pattern /B28/*<CUBE ID>. They are as follows:

- /B28/F<CUBE ID> "Consolidation"

-/B28/D<CUBE ID>P "Data Package"

-/B28/5<CUBE ID> "Delta Staging Tabelle"

Where can I find the E fact table? My understanding is that when running the Light Optimize the records will be compressed from the F to the E fact table. Please advise.

Thanks

[former_member186338 · Accepted solution]

May be you are using BPC on HANA? For BPC on HANA there is no need to move data from the F-table to the E-table, as there is only one fact table in HANA optimized cubes.

https://wiki.scn.sap.com/wiki/display/BI/SAP+HANA-optimized+BW+Objects+-+Infocubes

[Former Member · Accepted solution]

Thanks Vadim. Can you elaborate on the performance benefit of running the light optimize for BPC on HANA? Currently we are just compressing the Consolidation cube without running the optimize. Right now I can see 72 out of 76 million records are compressed. Looking at the Lite Optimize process chain log in RSA1 it seems it hasn't been run since 2015.

[former_member186338]

Please provide details about your BPC and BW version and SP

In my system (BPC on BW750 SP12) I can see both F and E tables!

[former_member186338]

For model Consolidation with technical name N2ISDIA I can see in SE16:

What do you want to achieve?

[Former Member]

I want to run the light optimize, and see that the compressed records are moved from the F to the E table. However there is no E table so am wondering where the records will go once the light optimize is run.