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 |
How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?
What is the maximum number of key figures you can have in an info cube?
what are the data types for the characteristics info object?
Can you define aggregates on time dependent navigational attributes?
What are the components of sap bw system?
what are the errors in process chain,how can we solve them?
What are the data sources supported?
What is v1,v2 and v3 updates?
What is the t-code for query monitor?
Can you make an info object as info provider and why?
WHAT IS THE T-CODE FOR PSA PARTIATION. IS IT POSSIBLE TO PARTITATION AN ODS? IF YES HOW.
Hi frnds , this is kondaiah iam new to SAP kindly can u people help me some basic material for sap-BW/BI Thanks in advance. BestRegards Kondu