Wednesday, August 22, 2012

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.

Labels: , , , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home