Compression has in general the following advantages: BW on SAP HANA: Performance of InfoCube compression; SAP. What Is an Infocube in SAP BI/BW? How To Create One? What is Infocube? Infocube is data storage area in which we maintain data which we are extracting . Posts about Infocube Compression written by Rahul Sindhwani.
|Published (Last):||20 May 2014|
|PDF File Size:||8.64 Mb|
|ePub File Size:||5.69 Mb|
|Price:||Free* [*Free Regsitration Required]|
No search term specified. You can schedule compression as part of a process chain. April 18, at When you load a data target, say a cube, the data is stored in the F fact table. What is a compression exactly? There is no worry for data integrity. You can execute the query once compression is finished. Subsequent compression of the same InfoCube will be from the beginning again. Create a free website or blog at WordPress. Zero Elimination means deleting the record from the cube after compression if and only if, the entire key figures of the particular record is zero.
Compressing a fact table is done in the InfoCube administration and is based on the request id number.
This unnecessarily increases the volume of data and affects system performance when you analyze data, since each time you execute a query, the system has to perform aggregation using the request ID. October 11, at 6: Comments Leave a Comment Categories Uncategorized.
Any request mid-compression will be rolled back. Conclusion There are a couple of advantages and disadvantages compressing an InfoCube or not.
Improve performance – by compressing the fact table #SAP #BW
This makes it possible to pay particular attention to individual requests. You must be Logged on to comment or reply to a post. October 11, at 7: So in short Compression: In this case, the entries where all key figures are equal to 0 are deleted from the fact table. If you do not want the InfoCube to contain entries with zero values for key figures in reverse posting for exampleyou can run zero-elimination at the same time as compression. Features You can choose request IDs and release them to be compressed.
During upload of data, a full request will always be inserted into the F-fact table. By continuing to use this website, you agree to their use.
Infocube Compression | SAP BW Overview
A t tachments 0 Page History. Hi Martin, Nice document. Purpose To explain the concept and reasons behind compressing requests in B Overview InfoCubes should be compressed regularly. Nice information for fresher…. The F-table uses b-tree indexes the E-Table uses bitmap indexes. April 26, at 6: You cannot run zero-elimination for InfoCubes that contain non-cumulative values.
With non-cumulative InfoCubes, the marker for non-cumulatives is also updated. Activities For performance reasons, and to save space on the memory, compress a request as soon as you have established that it is correct and is not to be removed from the InfoCube.
An aggregation of the data across datapackages by removing the request id can shrink the datavolume of the factable dramatically without any downfall from a business perspective. Compressing the fact table is one option that optimized the access to basis infocubes.
Compression – SAP NetWeaver Business Warehouse – SCN Wiki
This feature enables you, for example, to delete a request from the F-fact table after the upload. WelcomeGuest Login Register. This means that less data has to be read for a non-cumulative query which reduces the response time. One advantage of the request ID concept is that you can subsequently delete complete requests from the InfoCube. Archives October September August October 11, at 8: October 10, 2 minute read. When you compress, a query will read one accumulated line of records as opposed to reading each record.
Once the data has been compressed, some functions are no longer available for this data for example, it is not possible to delete the data for a specific request ID.
Can cube compression be run in a way, that reporting stays available while it is executed? During compression, these records are summarized to one entry with the request Ccompression ‘0’. This allows bw to store the data in a granularity which is not necessarily required from a business perspective. Yes, you can kill the compression.