What is compression or collapse?

Answer Posted / sapbhai

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 F fact table (uncompressed fact table) is moved to E fact table (compressed fact table). Compressed data occupies less space in many cases and thus a performance boost.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible for the users to convert the package group into a process chain? If so, how?

492


When you are using sap bi7.x, you can load the data to which component?

543


What is infoobject catalog?

558


What is Infoset Query?

598


How the dimensions are optimized?

495






What is geographical information in the sap bw and for what purpose it is used commonly?

542


What is the use of infocube in bw system?

510


How the query from BW is used?

1438


Where do we use write optimized dso?

517


What are the minimum no of dimensions in info cube?

507


You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?

527


What is the source for FIAR extractor from R/3?

1748


Which datastore object is used?

522


What is the procedure to implement structural authorization in BW?

1810


How do you install business content AWB?

1687