Register Login
Python Photoshop SAP Java PHP Android C++ Hadoop Oracle Interview Questions Articles Other

What is F table and E table?

Updated May 18, 2018

Hello SAP Gurus,

I want to solve some of my query and they are as follow:

  • What is F table and E table?
  • What is the use of aggregates?
  • Where aggregates will be stored?
  • What is difference between reporting on dso and infocube other than detailed level and aggregated level?

Please solve the aforementioned terms.

Thanks in Advance!

Comments

  • 05 Feb 2011 11:05 am Vamsi Best Answer
    F Fact Table: firstly data is stored in F fact table when we delete the data then data is moved from F fact Table to E fact Table.
     
    Aggregates: are baby cubes.
     
    We create aggregates to store for fast access of frequently retrieved information. if we create aggregates query performance also increases.
     
    We need to do reporting on Cube since we get summerised data from infocube but where as dso we get data from active table so mostly we do reporting on infocube only.
  • 24 May 2011 3:09 pm sathish Helpful Answer
    HI,

    at the time of cube craetion it self it forms efact table and f fact table , by default wen the dat ais loaded the data will be stored in f fact table.when you do the compression (the records will be compressed based on common characterstics of those records) those compressed records will be moved to e fact table ,due to that the performance willbe increased in query execution time.

    use of aggrigates ---- data will be stored redudently in small tables based on the aggrigated characersti (like sales region , sales office)if you want at granular level basd on the key fields you can go for teh dso , if summarised level go for teh cube level.
  • 25 Feb 2013 4:33 pm Guest Helpful Answer
    AN info cube maintain fact tables and dimenshion tables ,once you loaded the data into infocube the data goes to f fact table . after compression the data goes to E fact table ... compression is used to save the memory space and also improve performence
  • 10 Nov 2017 12:53 pm rekha Helpful Answer

    The info cube contains two fact tables - E and F and both the structures are same. 

    The "F Table" or "Fact Table" is the main table of the InfoCube. It will contain the values for the Key Figures and references (Foreign Keys) to the dimensions of the InfoCube. When load data into the InfoCube, this data will go to the Fact Table.

    The "E Table" or "E-Fact Table" will contain only the loaded data that has already been compressed. When you compress requests from the InfoCube, the data will be transferred from the F Table to the E Table. The information will be the same, and there should be no difference between a query run over data from the E Table or from the F Table (before compressing).

    When the requests are compressed all the request ids are lost (set to NULL) and you would not be able to select/delete the data by request id. The data in the E fact table is compressed and occupies lesser space than F fact table.

    When you load a data target, say a cube, the data is stored in the F fact table. If the cube is compressed, the data in the F fact table is transferred to the E fact table.
Recommended Posts:
×