PBS BW Analyzer
Contents
1. 208 ANOA oR Distribute InfoProvider data records according to time characteristic amp InfoProvider selection using a capacity analysis Reference analysis run 157 Number of InfoProviders ta be analyzed sorted by size 25 O Byname InfaFravider ta Infacubes Datastore Object Calendar day 4 OCALDAY OCALMONTH OCALQUARTER OCALYEAR OFISCPER OFISC YEAR Calendar year Month Calendar year Quarter Calendar year Fiscal year Period Fiscal year z user defineds Oy ony wy lt User detined If a time characteristic was notfound use first time characteristic of InfoProvider e 2 Skip InfoProvider C Diagram 15 Distribution analysis setup Transaction PBS ANA_BW_T1 In order to restrict the runtime of the distribution analysis in an acceptable manner the InfoProvider can be selected automatically using a reference capacity analysis run The InfoCubes and DataStore objects that require the most memory space can be determined from this run based on the size of the fact tables and their ag gregates for the InfoCubes and the amount of active data for the DataStore ob jects and a distribution analysis created for the specified number of InfoProviders PBSc software PBS BW Database Analyzer Manual 31 It is also possible to restrict InfoProviders by their technical name If you do not en ter a restriction t2. eee 2121 m PBS BW Analyzer Compare analysis results InfaProvider fa E 1 run 3 2 InfoProvider Iv Info cubes ODS objects W PSA tables Database e DataDictionary Sort InfoFrovider Size Show details Diagram 12 Comparison Analysis The options of the comparison analysis can be compared to those of the single analysis In addition to the data of the compared runs you can set in the area Op tions whether the output should contain detailed information for example on the fact tables InfoCubes or the activation queues DataStore objects PBS ca software 26 Manual PBS BW Database Analyzer g4 aaua 814 Ld 059 dA 286 Ed cea 921 k 9329 gNIHH3H cH BBg 5g AWLI FF 09 g4 9215 ga3ua 1al 111 80 18301 80 18301 20 gH Stas PHS Hole ON HHZ Mids HITN OU Und AVLoedey OU Und AVLoedey OL Wody eL WOJ EBBH sung eue Io unsLJedun EuE uosrJeduo d3zA wNU MS Sad spalqo 8do seqnanjul sjjnsei sisA eue ciazAjeuy Ag Sad Result of Comparison Analysis Diagram 13 PBS software PBS BW Database Analyzer Manual 27 Diagram 13 displays a comparison analysis with details and sizes of the Data Dic tionary During th
3. InfoCube InfoCube InfoCube name Name InfoProvider The name of the analyzed InfoProvider Size KB fact table Size of fact table in KB Size KB Dim tables Size of all dimensions available in the InfoCube in KB During the analysis both BasisCubes and AggregateCubes are considered How ever since the aggregates are assigned to one BasisCube they are directly dis played below the BasisCube marked in light blue BWLZFI H5 05 empty BWLZFI H5 100001 empty BWLZFI H5 100002 empty Diagram 8 Display of BasisCubes and corresponding aggregates PBSc software 21 Manual PBS BW Database Analyzer DataStore Objects 3 2 6 99g 91 835 4 H4 801 SEL abe Fel 991 gNIHH3H im a jud e sa dE Sd 448 4403 E701 SO QE4 Sd E gg 5329140 sgg ur 230 543a 500 N 80 uorsuaurp i2aej E310 sagngoiu 2 unis4a juaJ4na A ur suniido 154 2 sa ngej uoLsuawLp pue 1224 agngogul sale YSd 800 saqnajqul Mg Ajyioedey AAG Goo fer PBS software PBS BW Database Analyzer Manual 22 Object The archiving object which is assigned to the InfoCube DataStore object Name of DataStore object Name InfoProvider Name of the analyzed InfoProvider Size KB Act Size of active data in DataStore object in KB Size KB Queue Size of data in
4. can be started via the ABAP PBS ANA AS400 the database table DBSTATTDB4 must first be updated This is carried out via transaction 0802 In the case of a program termination a SAP correction order must be imported 3 1 2 Comments on Oracle database To determine the size of the tables the PBS BW Database Analyzer uses the sta tistical data that was previously created for the InfoProviders Please note that this information must be up to date in order to reap the maximum benefits of the PBS BW Database Analyzer PBSc software PBS BW Database Analyzer Manual 12 3 1 3 Special features of ORACLE If an Oracle database system is being used the user has a number of additional options available when starting the program Description Analysis for nfoProvider types InfoCubes ODS objects PSA InfaProviders by name Tablespaces Infacube options Fact and dimension tables e Fact table PSA options Current versions only e All versions All InfaProviders e InfaPravider with arch abjects Analysis options analyze index tables size via DDic additionally Diagram 2 ORACLE Capacity Analysis In addition to the InfoProvider types it is possible to limit the selection to names and tablespaces in which the tables reside Limiting the names has the advantage for example that an analysis can be performed in steps due to an otherwise long total r
5. relieves the OLTP system is SAP AG s Business Information Ware house To enable this relief it must be ensured that almost the complete reporting can be executed without having to access the original systems This means that the complete relevant dataset of the OLTP systems should be kept in the BW On the basis of this fact it is obvious that the dataset in a BW system can grow very fast which can result in unsatisfactory performance and extremely long response times during reporting Archiving as it is possible from SAP BW release 3 can solve this problem This is particularly beneficial in conjunction with the PBS ar chive add on CBW which allows the user to access archived InfoCube data and DataStore object data online since both the requests of the users and database administrators are taken into account The PBS BW Database Analyzer is a tool that supports you when determining your archiving strategy for BW InfoProviders It analyzes the InfoCubes DataStore ob jects and PSA tables which exist in your system and enables a clear presentation according to different criteria This manual informs you extensively about the scope of service and the functionali ty of the PBS BW Database Analyzer PBSc software Manual 5 PBS BW Database Analyzer Manual 6 Overview of the PBS BW Database Analyzer functionality The PBS BW Database Analyzer is a tool that enables you to check InfoProviders InfoCubes DataStore objects
6. 3 2 Evaluation of Analysis Capacity display BW InfoProvider d Fun na InfoProvider to Display options InfoCubes 1 DataStore objects Display mode InfaProvider 5 Tablespace from database Occupied size 7 Reserved size fram Data Dictionary Size InfoProvider O DAP InfoArea Last access Statistics Diagram 3 Evaluation of Analysis ORACLE After starting you have the possibility to select the number of a run that was car ried out To open a list showing the current capacity runs press function key F4 to select the requested run You can define the sequence of the InfoProviders that should be displayed in the area Sorting Using the option Last access BW statistics you can display the InfoProviders in the sequence of their last access for example query The pre requisite for this is that SAP BW statistics have been activated for the InfoProviders via the Data Warehousing Workbench Menu Tools Settings for BW Statistics PBS ca software Last data change sorts the InfoProviders according to the point in time at which the content of the InfoProvider changed e g loading of a request The criterion InfoProvider subtype groups the InfoProviders according to their particular char acteristic e g standard InfoCube non cumulative cube Hana optimized cube Show aggregates separately By setting this option ag
7. 42 714 95 598 57 969 51 189 60 681 78 748 67 989 75 804 115 599 Diagram 18 Distribution analysis of DataStore object ZMODS 05 The evaluation for the DataStore object ZMODS 05 is displayed in Diagram 18 as an example The characteristic OCALDAY was used for the analysis The overall result of the table s of an InfoProvider is marked in green it is only output if the table contains data records The specified overall sizes correspond to the value which was determined from the capacity analysis The period result is marked in light blue dark blue is the overall result of a year You can see from Dia gram 18 that the period 006 with 95 598 data records and a capacity of 8 391 KB needs most of the space in the year 1998 in the active table This corresponds to 13 6496 of the capacity of the active table PBS ca software Manual 8 27 7 30 8 66 11 24 9 70 18 78 16 50 3 87 4 02 5 18 13 54 Bre 7 30 8 66 11 24 9 78 10 70 16 50 HEMMING 28 02 2007 04 01 2007 18 147 01 3 585 46 3 719 92 5 647 10 12 638 75 7 553 92 6 767 56 8 022 47 10 411 06 8 988 64 9 916 88 15 283 03 33 PBS BW Database Analyzer Manual 34 4 3 Deletion of Distribution Analysis Distribution analyses which are no longer needed can be deleted This procedure is described in chapter 3 4 Deleting Analyses PBSc software PBS BW Database Analyzer Manual 35 5 Procedure The complete analysis o
8. AP transaction RSA1 PBSc software 37
9. PBS software BW Database Analyzer Part B User Manual Compatible with SAP BW Release 3 0 Release 3 1 Release 3 5 Release 7 0 Release 7 3 Release 7 4 July 7 2015 PBS BW Database Analyzer Manual 2 1999 2015 PBS Software GmbH Schwanheimer Strasse 144a 64625 Bensheim Germany Phone 49 6251 1740 49 6251 174 174 Email info pbs software com Internet www pbs software com PBS archive add ons is a registered trademark of PBS Software GmbH Bensheim SAP R 3 SAP ERP SAP NetWeaver ABAP and others are registered trademarks of SAP SE in Germany and in several other countries Acrobat Reader is a registered trademark of Adobe Systems Incorporated MS SQL Server is a registered trademark of Microsoft PBS ca software PBS BW Database Analyzer Manual Table of Contents 1 Introduction 5 2 Installation 7 2 1 PBS BW Database Analyzer Object Names 7 2 2 Supplied Menus 8 3 Capacity Analysis of the Database and the Data Dictionary 9 3 1 The Capacity Analysis 9 3 1 1 Comments on AS 400 database 11 3 1 2 Comments on Oracle database 11 3 1 3 Special features of ORACLE 12 3 2 Evaluation of Analysis 14 3 2 1 Selection of the size to be displayed 16 3 2 2 Errors during the table analysis 17 3 2 3 Navigation 17 3 2 4 Special features of ORACLE 17 3 2 5 InfoCubes 19 3 2 6 DataStore Objects 21 3 2 7 PSA Tables 23 9 3 Comparison Analysis 25 3 4 Dele
10. activation queue of DataStore object in KB Size KB CLog Size of data in ChangeLog of DataStore object in KB PBSc software PBS BW Database Analyzer PSA Tables 3 2 7 Diagram 10 Evaluation of Analyzed PSA Tables for InfoSources 84 992 8l 094 4434401 Le yo SaLQE 759 095 5 gg syoalqo sgg ur 230 543a 500 gH 801561 gg saqey uoisuauirp 32e4 610 sagnyoiu F aped HOLSE 8A Wana A LUD 754 uarsuaurp pue 4364 uarqda agngolu Fel 991 jo ALLIeded dddIAUddUdMI 3117 354 100 006 ck 0 EeBBe BL de 40 ou und Ajraedej SNIHH3H 25 20 sJaprAnggoju JO Aouednaan 510 4 2 Sad sale YSd 800 Mg Ajioedey HE WHE AD ea ____ PBS software PBS BW Database Analyzer Manual 24 Object The archiving object which is assigned to the PSA table as no SAP ar chiving objects exist at the moment this field is always empty InfoSource The InfoSource which is assigned to the PSA table Name InfoSource The InfoSource name Size KB Act Size of the active PSA table for the InfoSource in KB Size KB others Size of inactive PSA tables for the InfoSource in KB The size of the InfoSources is made up of the PSA tables which were filled under some circumstances by DataSourc
11. and PSA tables regarding their size in the database and in the Data Dictionary and supports you when making the decision whether archiving is required The PBS BW Analyzer comprises the following functions e lt analyzes the BasisCubes which are available in the system and addi tionally the AggregateCubes assigned to the InfoCubes You can choose whether to take into account the fact tables or additionally all dimension tables of the InfoCubes e All relevant tables of existing ODS DSO objects are analyzed in addition to the active data also the activation queue and the change log e All PSA tables in the system are checked whereby the versioning of ta bles is also taken into account You can choose whether just active ver sions within the validity period or all PSA table versions should be taken into consideration PBSc software PBS BW Database Analyzer Manual 7 2 Installation 2 1 PBS BW Database Analyzer Object Names As already explained in the installation manual part A PBS Software GmbH has its own namespace The programs and objects described in this manual have only names belonging to this namespace Report Transaction Description PBS ANA BW Analysis of BW objects PBS ANA BW KAPAZITAET Evaluation of analysis runs PBS ANA BW CLEAR Deletion of analysis interval Program PBS ANA BW ADA Analysis functionality for ADABAS database systems Program PBS ANA BW DB2 Analysis functionality for DB2 databas
12. e period from October 24 2003 run 2 to November 13 2003 run the capacity of the InfoCube ZMM 05 increased As a consequence the dif ference is marked in red PBSc software PBS BW Database Analyzer Manual 28 3 4 Deleting Analyses If a series of analyses were created it might be desirable to remove old analysis results which are not needed any more The ABAP PBS ANA BW CLEAR transaction PBS ANA BW CLR can be used for this purpose edge GHB osa iz fe er Removal of BW capacity runs m erenme i HOGS TEST 26 05 2003 08 37 42 0884 TEST 05 2003 15 33 44 8885 TEST 30 05 2003 22 aa C 9996 TEST 30 05 2003 11 19 46 Diagram 14 Deletion of Analysis Runs The analysis runs that are to be deleted can be selected and then removed using the trash can button Afterwards they are no longer available for evaluation PBSc software PBS BW Database Analyzer Manual 29 4 Distribution according to Time Characteristic Using a time characteristic that is defined in an InfoProvider a data record distribu tion for year and period can be set up Thus for example you can define a calen dar year if you have executed a capacity analysis run in advance This can be very important for a planned archiving Please note that a distribution analysis might have long runtimes PBSc software PBS BW Database Analyzer Manual 30 4 1 Distribution Analysis Setup
13. e systems Program PBS ANA BW DB6 Analysis functionality for DB6 database systems Program PBS ANA BW INF Analysis functionality for INFORMIX database systems Program PBS ANA BW MSSQL Analysis functionality for MSSQL database systems Program PBS ANA_BW_ORA Analysis functionality for ORACLE database systems PBS ANA BW Analysis of BW objects PBS ANA BW KAP Evaluation of analysis runs PBS ANA BW CLR Deletion of an analysis interval PBS ANA BW VGL Comparison of two analysis runs PBSc software PBS BW Database Analyzer Manual 8 2 2 Supplied Menus The menu for the PBS BW Database Analyzer can be started via transaction PBS ANA_BW_ANA All programs described in this manual can be called from the menu PBSc software PBS BW Database Analyzer Manual 3 Capacity Analysis of the Database and the Data Dictionary The following chapter describes the analysis of BW objects covers the object dependent functionality as well as the interpretation of displayed results 3 1 The Capacity Analysis Analysis BW InfoProvider 5 Description Analysis for Info cubes ODS objects PSA Infacube options Fact and dimension tables e Fact table PSA options Current versions only All versions Objects All InfoProviders EJ InfoProvider with arch abjects Diagram 1 Capacity Analysis PBSc software 9 PBS BW Database Analyzer Manual 10 Depending on the da
14. es of different source systems For this reason a detail view is displayed after double clicking PBS BW Analyzer Detailanzeige f r infoProvider ZPBS BU DATASOURCE T88CLNTOS0 ZPBS BW DATASOURCE REQU 3LXYvsaYUTUMCBOKEBSGMXSROD4 ZPBS BU DATASOURCE T88CLNTOS0 ZPBS BW DATASOURCE 06 REQU 3LXYX 8SPRZBZN OW2BF 2SHTO ZPBS BU DATASOURCE B T8 CLNTOSO 2 5 BW DATASOURCE BB REQU 3LYBOBOXRF38MXMS4OVKLCOZBS ZPBS BU DATASOURCE T898CLNTOS0 ZPBS BW DATASOURCE 06 REQU_3LYOICCEDILXG4XTVWJIAPWYLG ZPBS_BW_DATASOURCE_BA T88CLNTOS0 ZPBS_BW_DATASOURCE 06 REQU_3LYY4096 INUBNBVN TZH3MPKXO ZPBS BU DATASOQURCE TSGCLNTA9O 2 5 BW DATASOURCE B B REQU 3LYOC3SEPHFA4LKZGVTXG2CL5U ZPBS BU DATASOURCE T88CLNTOS0 ZPBS DATASOURCE REQU 3LZ61606FIGFZABOTXBIGTZPDO PBS BU INFO S URCE AB SSTEST PBS BU INFO SOURCE REQU 3N7672RNLBYPMLDFBK5N88 J65 TJ cn cn ao can aa go CO CO CD Diagram 11 Detail View of the PSA Analysis It is possible to perform a more flexible analysis of the PSA data using BW queries on the PBS InfoCube PBS ANA PSA More detailed information on this can be found in Chapter 6 PBS ca software PBS BW Database Analyzer Manual 25 3 3 Comparison Analysis To check the growth of InfoProviders or the success of archiving it is possible to compare two capacity runs This can be done using the report PBS ANA BW KAPAZITAET VGL transaction PBS ANA BW VGL
15. f a BW system can be very time consuming A runtime of several hours is possible which is why it is preferable to perform the analysis over night or at weekends In order to ensure that a specified timeframe is not exceeded it might be neces sary to split up the analysis into several steps In this case the capacity analysis should be performed first followed by the distribution analysis The advantage of this is that the results of the capacity analysis can be taken into account before the distribution analysis and the analysis can then be restricted to the most important InfoProviders The capacity analysis could also be split up into several runs that could be divided into areas for example 250 You should also consider if the capacity analysis can be carried out for InfoProvid ers that belong together in several runs for example 050 OMM As a time characteristic must be entered for the distribution analysis a complete distribution analysis of the BW system is only useful in rare cases A distribution should be made to single or a group of comparable InfoProviders if an appropriate and matching time characteristic has been selected previously The automatic time characteristic selection according to the default priority ranking order might not display the optimum result We recommend using manual selection in most cases PBSc software 36 PBS BW Database Analyzer Manual 6 PBS AnalysisC
16. gregates are listed sepa rately beneath their InfoProvider Display InfoProvider with size 0 Enables InfoProviders that do not contain any data to be displayed hidden Display size in nearline DB if available the nearline database IQ 082 was analyzed in addition to the primary database the size of an InfoProvider in the nearline memory can also be displayed Merge status ONLY Using a HANA DB the date of the last MERGE op eration can be displayed If an InfoProvider contains several tables e g fact and dimension tables the date of the table with the oldest MERGE run is displayed Screen AIS export Defines where the result should be output The data is written into an AIS file via the AIS export and in this way can be processed using external software PBSc software 15 PBS BW Database Analyzer Manual PBS BW Database Analyzer Manual 16 3 2 1 Selection of the size to be displayed The size of the analyzed InfoProviders can be displayed in two ways e he size on the database e The size in the data dictionary Please note that both values although they refer to the same table might differ significantly from one another Size on the database corresponds to the actual disk space taken up on the da tabase The evaluation algorithm depends significantly on the database system used and reflects the capacity utilization of the database Size in Data Dictionary corresponds to the si
17. he system issues a warning that this might result in extremely long runtimes As different time characteristics can be defined in an InfoProvider you must deter mine which characteristic should be relevant in the analysis The typical time char acteristics OCALDAY OCALMONTH OCALQUARTER OCALYEAR OFISCPER and OFISCYEAR are used in the standard setting in exactly this sequence OCALDAY is defined in the InfoProvider it is used in the analysis if this is not the case OCALMONTH is used Of course the user is free to adapt the priority of these time characteristics to the actual requirements Moreover it is possible to apply characteristics that are based on these time characteristics as for example ODOC DATE OPSTNG DATE Calendar day f OCALDAY Calendar year Month B DU CALMONTH Calendar year Quarter 3 OCALQUARTER Calendar year 4 OCALYEAR Fiscal year Period 5 FISCPER Fiscal year b OFISCYEAR uUserdefined 1 DATE zuser defined 2 HPSTNG DATE Diagram 16 Determination of user defined distribution characteristics If it is not possible to specify or determine priorities in general the InfoProviders should be analyzed separately or in groups InfoCubes DataStore If none of the defined time characteristics exists despite a determination you can automatically choose the first time characteristic of the InfoProvider or skip the In foProvider analysis For InfoCubes the first time characterist
18. ic corresponds to the first time characteris tic supported or the first characteristic based on a supported time characteristic in the sequence of dimensions and items compare transaction RSDCUBE For ODS DSO objects the first time characteristic corresponds to the first support ed time characteristic PBSc software PBS BW Database Analyzer Manual 32 4 2 Distribution Analysis Evaluation Program Edit Goto System Help BIH 08 53 53 casi 1 do Evaluation of distribution according to time characteristic Selections InfoProvider zM DS B5 Calendar vear 10 Period to Fiscal year variant to Time characteristic to Run number 18 Diagram 17 Evaluation of the InfoProvider ZMODS 05 The distribution analysis which was set up previously can be easily evaluated using the transaction PBS ANA BW T2 The evaluation takes into account the capacity analysis which was created previ ously From this evaluation the DB size of the fact tables is determined for In foCubes or active activation queue change log tables for DataStore objects the average data record size is calculated and taken into account in the evaluation PBS ca software PBS BW Database Analyzer anoo s Evaluation of distribution according to time characteristic BW Analyzer Distrib acc to time char Run 0010 Test Date Run date 115 598 27 120 28 137
19. lidity period or not All InfoProviders All InfoProviders available in the system InfoCubes DataStore objects and tables are analyzed InfoProvider with arch objects Only those InfoProviders are analyzed for which archiving objects have already been created This option can be used to help re duce the runtime of the analysis However it might be the case that not all InfoPro viders are examined Since there are currently no SAP archiving objects for PSA tables they cannot be analyzed PSA detailed analysis Enables a more exact division of the PSA by splitting up the quantity into corresponding requests analyze index tables Evaluates the index tables in addition to the data tables The size of the index is added to the size of the data and is not shown separately PBSc software PBS BW Database Analyzer Manual 11 nearline database RIQ If the CBW solution is being used in addition to the BW Analyzer the size of the InfoProviders can be determined on a connected nearline database SAP IQ DB2 WARNING Functions of the PBS RIQ inter face are used to determine the table size This means that only tables that can be addressed via the PBS RIQ connection can be analyzed The ABAP PBS ANA BW should always run in the background It is possible to check the progress in the system log entries of your own jobs 3 1 1 Comments on AS 400 database Before the database analysis in an AS 400 environment
20. ng the table analysis There fore it might be the case that an error occurred during a table analysis for exam ple because no statistical information was available for one table under Oracle BucOSD CB5 BSD CB5 Angebote Auftr ge 782 Diagram 5 Error during analysis Diagram 5 shows that an error occurred during the analysis of the fact table for In foCube OSD 05 The entry is marked red Please check whether the job log of the analysis run provides more detailed information concerning this error It is pos sible that transaction RSRV can help you 3 2 3 Navigation To navigate quickly between objects there are three buttons in the application tool bar which you can use to switch quickly to the required object type Infacubes ODS objects PSA tables Diagram 6 Quick navigation One click on the button and you immediately go to the page on which the output of the analysis results of the requested type starts 3 2 4 Special features of ORACLE As a result of the additional options that can be specified during creation of the analysis further possibilities are supported during the evaluation of the data In the area Display mode the option Tablespace is available The InfoProviders are displayed in separate groups according to the tablespace Since tables of an InfoProvider can exist in several tablespaces they are displayed more than once under some circumstances The line that is displayed in green shows the
21. on key F8 the corresponding transfer programs are generated and the InfoCubes are updated afterwards Usually it is not necessary to execute this as a background job Comments The InfoCubes PBS ANA and PBS ANA PSA that are supplied should be under stood as templates meaning that it is up to the user to freely split up the existing characteristics into as many more dimensions than those already defined It is also the responsibility of the user to define the queries On the one hand the user has the flexibility and the many possibilities open to him for defining queries as required However on the other hand the user should ensure that key figures of different classes DB Size DDic Reserved are not mixed inadvertently In contrast to transaction PBS ANA BW KAP the size specified here is not in kilobytes KB but in bytes Under some circumstances for example when defining or executing queries this can result in an error message that the fixed unit BYT is not defined This unit may also be displayed incorrectly In this case it should be checked whether the OSS note 400217 can be used to resolve the problem It may be possible that the execution of queries results in a system termination In this case it should be agreed with the Basis team whether the statistical infor mation is available or can be extended for the InfoCubes PBS ANA and PBS ANA_PSA This can be done for example in the administration of the data targets S
22. tabase system the report PBS ANA BW starts a corre sponding ABAP to construct the capacity analysis It is not possible to start directly the report for a specific database type for example PBS ANA BW ORA for Ora cle databases Attention The specified options are dependent to some extent on the database be ing used and may be displayed differently in the customer system Description Free text for the analysis run description can be entered Analysis run for Please select for which BW objects an analysis should be car ried out Fact and Dimension tables One fact table and several dimension tables are as signed to each BasisCube If you choose this option fact tables as well as all di mension tables of the InfoCube are analyzed ATTENTION As up to 16 dimen sions can be assigned to one InfoCube this option directly influences the runtime of the analysis program Fact table Depending on the InfoCube design the size of a dimension table can be very small compared to a fact table If you choose this option the dimension ta bles are not taken into account in the analysis Current versions only PSA tables are not deleted automatically for example af ter a structural change They still remain in the system although this might no long er be required If PSA tables which are no longer required are deleted you do not have to analyze them versions PSA tables are analyzed independent of whether they are in the va
23. ting Analyses 28 4 Distribution according to Time Characteristic 29 4 1 Distribution Analysis Setup 30 4 2 Distribution Analysis Evaluation 32 4 3 Deletion of Distribution Analysis 34 5 Procedure 35 6 PBS AnalysisCube 36 6 1 Comments 37 PBSc software 3 PBS BW Database Analyzer Manual 4 About This Manual The modular manuals of PBS Software GmbH for the PBS BW Database Analyzer are composed of the partial manuals Part A Installation in general Part B Manual PBS BW Database Analyzer This manual is part B describing the administrative tasks such as the layout of the analysis and evaluation Should you have questions or problems regarding the PBS archive add ons please call directly the Service Hotline of PBS Software GmbH Phone 49 6251 174 110 Fax 49 6251 174 174 Email hotline pbs software com Release Compatibility The PBS BW Database Analyzer discussed in this manual runs with BW release 3 x and 7 0 of SAP SE 69190 Walldorf Baden Germany At present the database systems HANA DB Sybase ASE Oracle Informix ADABAS DB2 DB400 and MS SQL Server 7 are supported PBS software PBS BW Database Analyzer 1 Introduction One main aspect which makes the usage of a Data Warehouse for a company so important is the transfer of reporting from OLTP systems to systems optimized for such purposes Such a system which enables a more efficient data analysis and at the same time
24. total size of the data capacity occupied by the InfoProviders The reserved size of a table can differ significantly from the size that is actually oc cupied In the area Size the user therefore has the possibility to choose between the two values PBS software PBS BW Database Analyzer Manual 18 In addition it is possible to analyze index areas of data tables This can however extend the runtime PBSc software 19 Manual PBS BW Database Analyzer InfoCubes 3 2 5 28080 50 147208 Ajdwa LOGOL GE emn Aydua pggagar ig rsrzama Aidua 20809 m r c Evaluation of the Analyzed InfoCubes ggz OL Salge 159 jusJ n3 E401 591984 759 OES 80 syoatqo 500 ul E30 5 28 40 5900 SEL 80 5910487 uorsueuitp i123el E10 saqgnzjolurm abe HOLSE 8A Yang A LUD SUOLYdO 754 uarsuaurp pue 1284 uarqda agqgngolu FEL OSL pazALeue Jo AyLoede d3dIAQ Hd dMI 3117 Gl FH 9329 BL 40 F00 OU Und Ajraedg HNIHH3H 16 20 Bui SJAPLACJJOLUI jo Aauednaao aJeds 1810 W3zATwNw mg S d sale YSd 800 Mg Ajyioedey SOUR PAG Arle 9 la Diagram 7 PBS software PBS BW Database Analyzer Manual 20 Object The archiving object assigned to the
25. ube The PBS BW Database Analyzer makes it possible for you to transfer analysis runs that have been performed into two InfoCubes that are supplied by PBS This ena bles you to make use of the many analysis options that are available These in clude for example e User defined access to relevant data using BW queries e Use of external tools for example MS Excel and MS Internet Explorer for easy evaluation and presentation of the data e Archiving of analysis runs that are no longer needed For this purpose PBS supplies the InfoCubes with the names PBS ANA and PBS ANA PSA which are always the target of the data transport These are found in the InfoArea PBS ANA AREA which was also created automatically during the import of the transport order of the PBS BW Database Analyzer Start the transaction PBS ANA BW CUBE and choose the analysis run that should be transferred into the InfoCube Please note that an analysis run can only exist once in the InfoCube BW Analyzer Transport Analyses to the PBS Analyzer InfoCt Information The results ofthe selected run will be written inta the Infacubes IPBSIAMA and PRSTANA Diagram 19 Transport of the Analysis Results PBS ca software PBS 6 1 BW Database Analyzer Manual The option of preventing the multiple transfer of identical PSA analysis results to the Analysis InfoCube also exists After selecting Start functi
26. untime When specifying the tablespaces it should be noted that the In foProvider tables can exist in several tablespaces An InfoCube would therefore only be analyzed if both the tablespace of the fact table and the dimension table are specified PBSc software PBS BW Database Analyzer Manual 13 As standard the actual occupancy of a table is analyzed only the reserved size standard view in SAP transaction 0802 is significant the option Detailed anal ysis should not be selected The analysis is then carried out slightly quicker The indices belonging to the tables can be evaluated using the option Analyze index tables As is the case with the other options within the area Analysis op tions you should however not underestimate the increase in runtime that this can result in The option size via DDIC additionally should only be used if DB statistics were not set up Using this function the table size is determined via the length of a data record as defined in the Data Dictionary and the number of data records SELECT COUNT The results represent rather a general overview of the sizes of the In foProviders and must on no account be compared with the results of the transac tion DBO2 This means with relation to the analysis results that the DDic analysis typically sometimes significantly returns higher values than the DB statistics anal ysis PBSc software PBS BW Database Analyzer 1 Manual 14
27. ze of all fields in one data record multiplied by the number of lines For the calculation the data size field length is used as it is defined in the Data Dictionary This option should be used for exam ple if statistical information is not up to date To determine the actual size select the size on the database Both values DB DDIC might differ from one another For example the fill level of Pages or the compression in the DDIC specification is not taken into consideration While the page header display serves to give a general overview on the analysis the display differs only slightly depending on the InfoProviders PBS BW ANALYZER Disk space occupancy of infoproviders Time 11 01 39 HEMMING Capacity run no 0047 of 27 10 2003 Date 03 12 2003 ANALYSE ALLE INFOPROVIDER Capacity of analyzed 156 734 InfoCube option Fact and dimension tables PSA options Only current version Page Infocubes analyzed Total fact dimension tables DB 135 108 ODS objects Total data in ODS objects DB 5 350 PSA tables Total current PSA tables 16 266 Diagram 4 Header Information of the Analysis The marker analyzed is displayed for all InfoProviders that were taken into con sideration during the analysis run As a consequence data of the corresponding In foProviders is available PBSc software PBS BW Database Analyzer Manual 17 3 2 2 Errors during the table analysis In each database system there are differences regardi
Download Pdf Manuals
Related Search