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 |
Can any one explain me....Before coming luw's into Extractor queue(Lbwq),What Update mode(v1 or v2) will execute?
What is the option of ?pause Automatic Refresh??
what is the include program name?
What are the options for ?calculate single value as??
In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
What is update routines.
What are the types of reports you can use in reporting agent?
Will customers continue to receive support for older versions of sap bw?
what is openhub destination? what are the uses and in which case it suppose to be use? and difference in bi7.0/bw3.5?
What are the pre-requisites of DB connect?
what are the errors in process chain,how can we solve them?
What does rollup do?