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

what is performance tuning and the tools supposed to be used? and explain in detailed about aggregates, bw statistics and bi accelerator? uses of those tools?

1551


Performance monitoring and analysis tools in bw

534


How does the time dependency works for bw objects ?

495


What are the steps to do the creating classes in sap-bw.

483


What does the VARIABLE_SCREEN URL parameter do?

1784






What is a repair request?

1505


What is extended star schema?

536


You want to see the error idocs. Tell the navigation you would use.

460


process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations

1206


Describe your experience with bw extractors

547


What are the destination target options?

1565


What are the do?s and don?ts?

1628


what is direct schedule and what is meta chain

1722


What is the dimension in bw?

506


What are the sap enhancements to enhance fir data?

514