What is compression or collapse?
Answers were Sorted based on User's Feedback
Answer / narasa
compression is process. in this data will go to the F table
to E table on Cube by deleting the requests and make a
Single request no. it will save a space and data redundency.
if its wrong send mail correct ans to me.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
Answer / guest
This is the process by which we delete the request ids.
this saves space
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / siva
it is used for to delete the request ids and save the space
once we compress the data moves from f table to e table.
If we want to see the compress data, go to se11
give /bic/e<cubename> we can find out here.
Is This Answer Correct ? | 5 Yes | 2 No |
Explain variable offsets?
Can we create hyperlink at universe level ? can u please explain with real time example
What are text variables?
what is delta mechanisum in SAP bi with example
what is line item dimension? when we need them? how we will come to know we need to create line item dimensions?
Does it have delta facility?
What happens when you use several conditions in a query?
What is an exception cell?
what is virtual kef figures? what are the uses and in which case supposed to be use?
which object based you created extended star schema?
What is the start routine?
Does any other erp software use bw for data warehousing.