SAP-BI@Compression of Info Cube
Compression of Info Cube:-
-------------------------
* /F AND /E are the 2 fact tables.
* when we load data into the Info Cube it goes into /F table and when we compress the Cube it deletes the request id information and aggregates the records based on the Characteristic value combination and puts the Data into the /E table.
* When we do reporting on the Info Cube data comes from /F and /E tables.
* Once compress is done in the Info Cube we cannot delete data based on the request in the Info Cube, But we can solve the problem by doing request reverse posting only if data is available in PSA.
* In Collapse Tab when we specify a request and compress the cube - it only compresses the specified request and all the request below it.
* With Zero Elimination - after compression if it finds any records with all its keyfigure values being zero it deletes those records.
-------------------------
* /F AND /E are the 2 fact tables.
* when we load data into the Info Cube it goes into /F table and when we compress the Cube it deletes the request id information and aggregates the records based on the Characteristic value combination and puts the Data into the /E table.
* When we do reporting on the Info Cube data comes from /F and /E tables.
* Once compress is done in the Info Cube we cannot delete data based on the request in the Info Cube, But we can solve the problem by doing request reverse posting only if data is available in PSA.
* In Collapse Tab when we specify a request and compress the cube - it only compresses the specified request and all the request below it.
* With Zero Elimination - after compression if it finds any records with all its keyfigure values being zero it deletes those records.
Labels: Android, Big Data Analytical Skill, FREE SAP BW BI TRAINING, hot News India, IPL, SAP, SAP BI ABAP Course English India Jobs Career, SAP BW Powered by SAP HANA
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home