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. When you load data into the infocube, entire requests can be added at the same time. 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. From now on, the child aggregate for the leaf rolls up data from basis aggregate instead of from the infocube. An infocube consists of a fact table which is surrounded by 16 dimension tables and master data that is lying outside the cube. Infocube is classified in to three types based on the way of maintaining and distributing the data. After compression the data cannot be deleted by request ids. The user defined partition is only affecting the compressed efact table. It is a selfenclosed data set encompassing one or more related business processes. During infocube compression one of the following errors is encountered. 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. The database specific information presented in this article is.
Infocube is data storage area in which we maintain data which we are extracting from source system physically. This paper provides the step by step procedure on how to archive data in odsinfocube using adk method. Compression in bw infocubes sap netweaver business. Information about infocube compression infocube compression. This paper relies on an understanding of sap systems based upon release sap netweaver 7. Download sap bw icon power point augustineeverh1s blog. Subsequent compression of the same infocube will be from the beginning again. Increasing bw cube compression performance running sap. Compression has in general the following advantages. You can extract data from bi archives in order to reload it into the infoprovider.
Sap note 1522494 dtp requests can not be compressed sap note 407260 faqs. Procedure or navigation steps for infocube compression. Compression of infocubes sap note 590370 too many uncompressed request f table partitions sap note 1461926 faq. Infocubes are the central multidimensional data model in bi. 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. Sap bi performance activity cube compression compression.
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. We have compiled a list of sap bibw interview questions and answers to help you with your sap bibw job interview. It has fact table at the center and is surrounded by 16 dimension tables with master data lying outside the cube. As an alternative, you can use the archive connection for the export datasource of an infocube or datastore object.
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. It is important to note that bi is refreshed once daily each morning. In sap bi, an infocube contains extended star schema as shown above. Compression in bw infocubes sap netweaver business warehouse scn wiki. Sap db, microsoft sql server ibm db2400 does not support table portioning. Then, this is right course for you in great plat form udemy. Compression transfers the data from the f fact table to the e fact table while eliminating the request information in the infocube. 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. Learn sap bw modeling step by step from the scratch. So, you still have opportunity to move ahead in your. The bw cube compression uses the sql server merge command in sql server 2008 and all newer releases. What is happening behind the scene is after the compression, the f fact table contains no more data. Sql0964c the transaction log for the database is full adm1541w application with application handle and application id executing under authentication id. It helps the consultants to decide when to compress the infocube data based on the data volume.
Compression creates a new cube that has consolidated and summed duplicate information. This blog is intended as a stepbystep guide for increasing bw cube compression. 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. Infocube compression is used to eliminate zero values as key figures are contained in the infocube. There are lot of opportunities from many reputed companies in the world. Then select infocube right click manage select request tab.
Sap netweaver business warehouse delivers preconfigured authorization objects under the collective term bi content. Compressed infocubes require less storage space and are faster for retrieval of information. Below is the basic information available for this sap report including which objects it interacts with such as tables, function modules, includes etc. After completion of this course, you can work on sap bw projects. From a reporting point of view, an infocube can be described as a selfcontained dataset. Sap bi provides you with a range of tools that support you in generating interactive reports, and thereby facilitate decisionmaking at every level. Table partitioning helps to run the report faster as data is stored in the relevant partition.
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. Bw on sap hana in combination with sap businessobjects bi 4. Use the following objects depending on your bw and r3 or plugin releases. The entire request ids will be deleted and compressed into a single request. Posts about infocube compression written by rahul sindhwani. Non cumulative key figures dont maintain data in the infocube but the value is calculated at the run time of the query. Every infocube has a datapackage dimension that holds the request id. Sap infocube compression tables compressing a fact table is done in the infocube administration and is based on the request id number. Information life cycle management data archiving in. This means that the reports will include no transactions from the day the report is physically processed. The root cause of the performance issues with bw cube compression are described in detail in the first sap note. You can schedule compression as part of a process chain. Remote cubes gather metadata from other bw systems.
This allows bw to store the data in a granularity which is not necessarily required from a business perspective. Compression of non cumulative infocubes are mandatory. Infocubes ultimate sap biw concepts explaination sap blogs. Experts, is that true you should always check with zero elimination when you compress infocubes. X for smarties series tbw10 solution exercise 5 creating an infocube 2. An infocube can function as both a data target and an infoprovider. As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and. The system takes care of the partitioning for psa and ffact tables.
Sap bw infocube learn sap bw in simple and easy steps starting from overview of sap bi, data warehousing, data flow, transformation, infoarea, object. 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. According to research sap bw has a market share of about 22. When we perform the compression the data in the infocube moves from ffact table to the efact table.
B in update rule routine, if we want to return multiple records, instead of single value, we can use this return table. Your own infocube should begin with a letter from a to z and that it should be 3 to 9 characters in length. It aggregates records with equal keys from different requests. Dear readers, these sap bw interview questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sap bw. When you compress, bw does a group by on dimensions and a sum on measures. The purpose is to explain detailed technical procedure of adk archiving, deleting and reloading archived. It is intended to give the reader a basic awareness of the features of archiving available in bw 3. Go to contents tab and click on infocube contents click on continue again click on continue. Finally, do you have zero knowledge in sap bw and wants to become master in it. 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. Top sap bibw interview questions and answers for 2020. Fact tables of sap bi aggregates are automatically partitioned the same way as the underlying infocube. Sap delivered infocubes begins with a number usually 0. Compression is critical, as the compressed data can no longer deleted from the infocube using its request ids.
1584 301 1293 551 720 188 140 692 1150 1499 66 1608 1 473 1057 574 741 1217 1264 1087 265 1019 1116 218 243 400 72 1513 400 616 1665 693 1523 121 860 629 1473 595 435 68 1075 1430 76