Q: E-table vs F-table

[Former Member]

Hi Experts,

I have a question regarding size of F-table and E-table. I have run the program SAP_INFOCUBE_DESIGNS and can see number of records in the different tables.

As I understand, the E-table are for compressed entries and F-table is the original. Is this correct?

In most cases this seems logical, but in some cases the E-table is much bigger than the F-table, how can this be?

Thank you in advance,

Mikael

[Former Member · Accepted solution]

Hi

You can find the table related to InfoCube by following the below mention naming convention.

/BI<C OR DIGIT>/<TABLE CODE><INFOCUBE><DIMENSION>

<C or digit>: C = Customer-defined InfoCube

Digit = SAP-defined InfoCube

<table code>: D = Dimension table

E = Compressed fact table

F = Uncompressed fact table

<InfoCube>: The name of the InfoCube without leading digits (if any)

<dimension>: (only used for dimension tables)

P = Package dimension

U = Unit dimension

T = Time dimension

0-9, A, B, C = User-defined dimension tables

And you can find info about the size of infocube:

F table will be there.

But u cant find the data.All the data will be moved to E table after compression.

U can juz check it up by giving the name of the Cube

bic(cubename)f.. after the compression.

in RSRV, run the test: All elementary > database > Database Info about Infoprovider tables. Supply the name of your cube and execute it.

(Take a look: )

After compression you will have only entries in the E table.

Take a look: http://help.sap.com/saphelp_nw2004s/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset.htm

regards

gaurav

[Former Member]

Hi,

Does anybody know what the compression factor is between the F-table and the E-table?

I.e. when you move 100 rows from the F-table, how many rows will be added to the E-table?

Thank you in advance,

Mikael

[Former Member]

Hi,

There is no conversion factor. All the request id's are deleted when u compress the Cube and the records are aggregated based on the remaining dim id's.

Ex- suppose there is only one customer with C100 is doing Transactions & in 100 rerquests there are 100 records.

Then when u eliminate the request all records are aggregated to 1 record.

If there are 100 customers and u enterd each customer data in each request. then when u do compression there will be 100 records still because the customer no. Varies,

REDDY

[Former Member]

Hi,

this is possible as after the compression the records are transferred from F table to E table.

so the size of table increases very slowly with time but the size of E table may become huge if the amount of data loading everyday is huge.

Thanks

Ajeet

[Former Member]

Hi,

After compression the contenets of the F table are moved to E table, henec over the period of time the size of E table becomes more than that of the F table.

Please refer the below mentioned link for more details in Compression process.

http://help.sap.com/saphelp_nw70/helpdata/EN/ca/aa6437e7a4080ee10000009b38f842/frameset.htm

Hope thie helps...

Regards,

Umesh