For Basis InfoCubes in SAP BW, there are two fact tables for
including transaction data: The F and the E fact table.
Unlike the E fact table, the F fact table contains the information
about the request from where the transaction data originates
When loading data (when receiving requests), the system writes data
into the F fact table.
During "compression", the system summarizes data from different
requests and writes it to the E fact table.
To ensure good reporting performance, it is important that you only
keep data from a few requests in the F fact table, which means that you
should compress requests as soon as possible.
Also bear in mind that deleting transaction data according to the
request is only possible from the F fact table, as only this table
contains the information regarding which data belongs to which
request.
You should therefore compress a request as soon as you are certain
that the data loaded is correct. When you install BW on an ORACLE database, BITMAP indexes are created on the fact tables to improve the reporting performance of the system
And yes try to search on help.sap, there is plenty of information.
You also have dimension tables which are related to cube. Number of tables will be equal to number of dimensions in the cube. Dimension table will have DIM IDs created for a combination of SIDs for characteristics used in that dimension.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.