Experts, is that true you should always check with zero elimination when you compress infocubes. Subsequent compression of the same infocube will be from the beginning again. This paper provides the step by step procedure on how to archive data in odsinfocube using adk method. The user defined partition is only affecting the compressed efact table. After compression the data cannot be deleted by request ids. Go to contents tab and click on infocube contents click on continue again click on continue. During infocube compression one of the following errors is encountered. From now on, the child aggregate for the leaf rolls up data from basis aggregate instead of from the infocube. Download sap bw icon power point augustineeverh1s blog. Sap infocube compression tables compressing a fact table is done in the infocube administration and is based on the request id number.
Learn sap bw modeling step by step from the scratch. Below is the basic information available for this sap report including which objects it interacts with such as tables, function modules, includes etc. So, you still have opportunity to move ahead in your. Depending on the datamodel of the infocube and the frequency of loads as well as the content of the loaded data this can have a significant impact on the datavolume. After completion of this course, you can work on sap bw projects. I was reading the famous sap doc how to handle inventory management scenarios in bw, the screen shots for cube compression does not have that checkbox checked. If you perform compression for a noncumulative infocube, the compression time including the time to update the markers is about 5 ms per data record. Information about infocube compression infocube compression. Sap netweaver business warehouse delivers preconfigured authorization objects under the collective term bi content. Remote cubes gather metadata from other bw systems. Information life cycle management data archiving in.
Posts about infocube compression written by rahul sindhwani. There are lot of opportunities from many reputed companies in the world. Compression creates a new cube that has consolidated and summed duplicate information. An infocube can function as both a data target and an infoprovider. It is a selfenclosed data set encompassing one or more related business processes. Sap delivered infocubes begins with a number usually 0. Infocube is data storage area in which we maintain data which we are extracting from source system physically. Infocubes are the central multidimensional data model in bi. Sap bi performance activity cube compression compression. Only the partitioning for the efact tables can be defined by the user. Every infocube has a datapackage dimension that holds the request id. Top sap bibw interview questions and answers for 2020. Bw on sap hana in combination with sap businessobjects bi 4.
Compression transfers the data from the f fact table to the e fact table while eliminating the request information in the infocube. From a reporting point of view, an infocube can be described as a selfcontained dataset. Idocs are used for communication between logical systems like sap r3, r2 and nonsap systems using ale and for communication between an sap r3 system and a nonsap system. Your own infocube should begin with a letter from a to z and that it should be 3 to 9 characters in length. Sap db, microsoft sql server ibm db2400 does not support table portioning. The root cause of the performance issues with bw cube compression are described in detail in the first sap note.
Infocubes ultimate sap biw concepts explaination sap blogs. Compression has in general the following advantages. Infocube is classified in to three types based on the way of maintaining and distributing the data. You can schedule compression as part of a process chain. In sap bi, an infocube contains extended star schema as shown above. Instead, the compressed data now appear in the e fact table.
According to research sap bw has a market share of about 22. Use the following objects depending on your bw and r3 or plugin releases. When you load data into the infocube, entire requests can be added at the same time. Hi, yes,it is possible to load data from infocube to dso, but we should maintain the update mode as summation only for key figures but not for characteristics we can change the update mode in the transformation by selecting the required rule and go to rule details and now there is a property called agregation we need to set it to sum.
Table partitioning helps to run the report faster as data is stored in the relevant partition. To understand this we take an example of a sales manager, who wants all the information like sales, market share, product quality, sales and service cost etc to enable him to make effective decision. Procedure or navigation steps for infocube compression. Non cumulative key figures dont maintain data in the infocube but the value is calculated at the run time of the query. Compression in bw infocubes sap netweaver business warehouse scn wiki. The bw cube compression uses the sql server merge command in sql server 2008 and all newer releases. You can extract data from bi archives in order to reload it into the infoprovider. Infocube compression is used to eliminate zero values as key figures are contained in the infocube. This means that the reports will include no transactions from the day the report is physically processed. Fact tables of sap bi aggregates are automatically partitioned the same way as the underlying infocube. When you compress, bw does a group by on dimensions and a sum on measures. It helps the consultants to decide when to compress the infocube data based on the data volume. Then select infocube right click manage select request tab.
An infocube consists of a fact table which is surrounded by 16 dimension tables and master data that is lying outside the cube. The purpose is to explain detailed technical procedure of adk archiving, deleting and reloading archived. Data are written directly into such cubes bypassing updaterules 3. The database specific information presented in this article is. Sap bi compression status for infocubes document explains abap code to get the compression status for all the infocubes in sap bi system which is never compressed. In bw, an idoc is a data container for data exchange between sap systems or between sap systems and external systems based on an edi interface. Increasing bw cube compression performance running sap. In this list of interview questions you will find what is table partition, multiprovider, types of multiproviders, infocube, operational data store, infoobjects, tcode for infocube and data target administration. Sap bi provides you with a range of tools that support you in generating interactive reports, and thereby facilitate decisionmaking at every level. Compression in bw infocubes sap netweaver business. Archives october september august non cumulative key figures dont maintain data in the infocube but the value is calculated at the run time of the query. Infocube compression sap bw infocube compression i was dealing with the tab compression while managing the infocube, was able to compress the infocube and send in the e table but was unable to find the concrete answer on the following isssues. The entire request ids will be deleted and compressed into a single request.
This paper relies on an understanding of sap systems based upon release sap netweaver 7. Data flow in sap business intelligence data from various sources sap systems, nonsap systems, flat files, xml data, databases etc. You must be certain that the data loaded into the infocube is correct. It is important to note that bi is refreshed once daily each morning. Part of my requirement is that the program may be executed again later on, and that some records that were previously inserted are no longer necessary and will be delet. Sql0964c the transaction log for the database is full adm1541w application with application handle and application id executing under authentication id. Sap bw infocube learn sap bw in simple and easy steps starting from overview of sap bi, data warehousing, data flow, transformation, infoarea, object. You must be logged on to comment or reply to a post.
As an alternative, you can use the archive connection for the export datasource of an infocube or datastore object. Infocube partitioning sap bi pdf if there is a cube with uncompressed requests and 10 dimensions every dimension brings with it a local bitmap index than there are. Finally, do you have zero knowledge in sap bw and wants to become master in it. We have compiled a list of sap bibw interview questions and answers to help you with your sap bibw job interview. B in update rule routine, if we want to return multiple records, instead of single value, we can use this return table. The system takes care of the partitioning for psa and ffact tables. Compression of non cumulative infocubes are mandatory. Infocube is data storage area in which we maintain data which we are extracting. What is happening behind the scene is after the compression, the f fact table contains no more data. Below is the pattern details for this fm showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions specific to the object.
Compression of infocubes sap note 590370 too many uncompressed request f table partitions sap note 1461926 faq. Compression is critical, as the compressed data can no longer deleted from the infocube using its request ids. Scenario 1 converting a regular infocube to an inmemory optimized infocube. This blog is intended as a stepbystep guide for increasing bw cube compression.
1216 419 1413 1415 1494 874 145 1032 1154 203 858 532 1438 215 1255 1119 948 275 27 1437 837 173 1223 523 885 478 1450 1034 208 228