sap tbw10 6 converted

8/17/2019 SAP TBW10 6 Converted

1/77

TBW10 Lesson: Chains of processes

114-10-2008 © 2008 SAP AG. All rights reserved.

Task 3: (Optional) Add a step of compression toits chain of processesYou may want to compress your InfoCubo after the data load. Add therefore avariant of step of compression to its InfoCubo.

1. Additionally you may want to compress your InfoCubo after the data load.Therefore need a step of additional process from the Management folder data destination for compression of the InfoCubo. Call it GR##_COMP andenter the description Compression GR## . As parameters of the optionSelect the object class InfoCubo and searchIts InfoCubo GR##HUB1.

2. The system automatically suggests the process steps delete index,Generate Index, rollup of fill of aggregates. In our simple scenario we do

not need these steps. Delete them so that it is just the compression step.Link the data transfer process with step compression.

3. Record and enable its chain of processes.


2/77

Chapter 7: Managing Data Destinations TBW10

2 © 2008 SAP AG. All rights reserved. 14-10-2008

→

→

Solution 18: (Optional): the creation of a

chain of processes simple to uploadyour InfoCubo

Task 1 - Definition of a chain of simple processesto load data in its InfoCuboFirst you must define each of the steps, called variants of process, its chain.

1. Create a new string of processes. Go to the update of the chain of processesusing the transaction RSPC and select the icon to create new chain of processes . Enter as the name T_GR##_PC01 and as descriptivetext GR## chain of processes 01 .

a) To create a chain of new processes use the transactionRSPC or the following path SAP Easy Access Modeling Workbench:Modeling Icon: Chains of processes .

b) Create A new chain of processes and enter asthe name T_GR##_PC01 and as descriptive text GR## chainof processes 01 .

c) Confirm .

2. Insert a startup process. Name the GR##_START01 and type in thedescription GR## Home01 . Modify the selections to

start immediately .a) Create a new boot process . Name the GR##_START01 and type

in the description GR## Home01 . Then press Confirm .

b) Press the push button Modify selections and select Immediate andstart time. Record your selection entries , thenrecord the variant of process , back Andconfirm their . You will now find the boot process in the canvas.

3. To add more steps to its chain of processes, go to the summary of typesof process.

In the area loading process and subsequent treatment will find the processRun InfoPaquete . Simply drag and drop it on the canvas. To inserta InfoPaquete for the implementation select the appropriate InfoPaquetethrough the Help F4.

Select the previously defined InfoPaquete GR## flat files ofvariable data and conclude the insertion.

Continued on next page

→


3/77



→

→

How many types of processes have been inserted?

A) Go to Summary of types of process. In the folder loading process and subsequent treatment select the type of process runInfoPaquete and drag and drop it on the canvas. Select theInfoPaquete GR## file data plane variables throughthe Help F4 and confirm .

At this point you should see the steps of the process load data andadditionally the step of process process of data transfer in the canvas.

4. Before loading new data you want to make sure that the PSA tables areempty. Therefore plan an additional step to clear the PSA regularly. Youwill find the PSA erase in the folder other processes BW . Create avariant GR##_PSA_of with the gr Description## ClearPSA and select the object class table PSA . You will find the exact tableLooking for your data source costc##_td_flatfile.

a) Go to Summary of types of process. In the folder other processes BW select the type of process clear requests of thePSA and drag and drop it on the canvas. Press , enter the name GR##_PSA_DEL AND DESCRIPTION GR## ClearPSA . .

b) Select the object class table PSA and locate your data sourceCostc##_td_flatfile . Record , back And .

5. Finally we must connect each one of the steps to install the chain of processes. Connect the boot process with the step clear request for PSA.Do so by selecting Connect with from the context menu of its startup process.

Then connect the step delete orders of PSA with step Load data in the same way.

Finally connect the step load data with the step Data Transfer Process.

Both steps should be undertaken only if the previous step has beensuccessfully implemented.

a) In the shortcut menu of the startup process, select Connect with clear

PSA request .→

b) On the shortcut menu to delete request PSA select Connect With Load Data. In the next window select Action for With success .

c) In the shortcut menu of the step Data Transfer ProcessSelect Connect to Compress. In the next windowSelect Action for successfully .



4/77



→ →

→

Task 2: Implementation and monitoring of its chain of processes

Before you run the chain of processes, you must verify and activate it.

1. Check your chain of processes and activate it.

a) Check And select the .

2. Start the string and check the display of the Protocol. Run the process withstandard priority. You should refresh the screen from time to time until allthe steps are executed correctly.

a) Start the chain of processes .

b) In the next screen assign standard Priority.

c) Go to the display of the protocol , select the list of executions fromthe current date. Simply press the Refresh button several times untilthe process finishes.

3. Verify your InfoCubo. Have you found a new request on this?

a) Switch to your InfoCubo through SAP Easy Access Modeling Workbench: Modeling InfoSitio. In the context menu on your InfoCubo select Manage. Check the label request .

Task 3: (Optional)Add a step of compression to its chain

of processesYou may want to compress your InfoCubo after the data load. Add therefore avariant of step of compression to its InfoCubo.

1. Additionally you may want to compress your InfoCubo after the data load.Therefore need a step of additional process from the Management folder data destination for compression of the InfoCubo. Call it GR##_COMP andenter the description Compression GR## . As parameters of the optionSelect the object class and locate your InfoCubo InfoCubo GR##HUB1.

a) Go to Summary of types of process. In the Folder Management of destinations of data select the type of compression of theInfoCubo process and drag and drop it on the canvas.Press , enter the name GR##_COMP ANDDESCRIPTION COMPRESSION GR## . .

b) Select the object class and locate your InfoCubo InfoCuboGR##HUB1. Record , back And .



5/77



2. The system automatically suggests the process steps delete index,Generate Index, rollup of fill of aggregates. In our simple scenario we do

not need these steps. Delete them so that it is just the compression step.Link the data transfer process with step compression.

a) Delete these steps of process by selecting Delete process from theshortcut menu for each one of the steps.

b) Select Connect with from the context menu of the process of transfer of data. Bind it to step to hide.

3. Record and enable its chain of processes.

a) Record and activate again its chain of processes.


6/77



Summary of the lesson

You should now be able to:• Describe the use of the process chains• Describe what that provide different views of the process chains• Create and run a chain of processes simple

More information

The complete details on strings of processes are available in the course SAPBW350.


7/77


TBW10 Resumen del capítulo

Chapter SummaryYou should now be able to:• Describe daily and periodic tasks necessary to update the Data

Warehouse• List the tools available for the management of the store• Explain where it fits the file in the job of an administrator • Describe how to use the tag Manage InfoCubo• Define compression and describe their use• Define the erasing and reconstruction of requests and explain when the

used• Define the selective deletion and explain when to use this feature

• Describe the features available in the tag manage to an object DataStore• Identify the function of manual activation on the label to manage for the

DataStore object• Identify features of clearing and reconstruction for standard DataStore

objects• List the options for the reconstruction of data destinations, as InfoCubos

or other objects DataStore• Describe the use of the process chains• Describe what that provide different views of the process chains• Create and run a chain of processes simple


8/77


Resumen del capítulo TBW10


9/77


TBW10 Examine sus conocimientos

Examine their knowledge489

1. What are some typical management tasks?Select the answer(s) correct(s).A RemodeledB Requests FileC Indexing documentsD System Options

2. The applications are an advantage because:

3. The applications are an inconvenience because:

4. The Clears the data from the active tableof an object DataStore, but not from the log of modification. Fill in the blanks to complete the sentences.

5. The deletion based on applications, which of the following problems solved?Select the answer(s) correct(s).

A Clearing the last upload of data incorrectB Erasure of Data for a specific combination of society and

Division

C Clearing the Log request modifications and of the tableActive if the request was already enabled but not in the nextdestination

D Clearing the log data led to modifications

6. The aspect of integration of a chain of processes that allows it to be a goodmonitor is called view of . Fill in the blanks to complete the sentences.


10/77

Examine sus conocimientos TBW10

540 © 2008 SAP AG. Reservados todos los derechos. 14-10-2008

7. What expressions on strings of processes are true?Select the answer(s) correct(s).

A Process chains have a GUI for graphic design.B The chains of process have views of log, verification and

Planning.C The chains of process have many kinds of processes for

Check your project BI.D The manifold processes include AND, OR and EXOR.


11/77

TBW10 Examine sus conocimientos

54114-10-2008 © 2008 SAP AG. Reservados todos los derechos.

Answers491

1. What are some typical management tasks?

Answer: A, B, C, D

All the above and many more.

2. The applications are an advantage because:

Answer: allow the simple deletion of records in error.

3. The applications are an inconvenience because:

Answer: occupy space and resources.

4. The Selective deletion clears the data from the active table of anobject DataStore, but not from the log of modification.

Answer: Selective deletion

Clearing the log of changes is usually a periodic job done with a string of process.

5. The deletion based on applications, which of the following problems solved?

Answer: A, C

The log of changes is cleared in a chain of process.

6. The aspect of integration of a chain of processes that allows it to be a goodmonitor is called Log view.

Response: LOG

7. What expressions on strings of processes are true?

Answer: A, B, C, D

All of the above are true.


12/77


Capítulo 7: Administración de destinos de datos TBW10


13/77


Chapter 8 493 Introduction to the optimization of

Performance of a query

Chapter SummaryIn addition to the dynamic aggregation with the processor OLAP, BI also offersthe option to physically store added to the database, as well as other moreadvanced options that allow the user to increase the speed of access to the data.

This unit presents several techniques and tools that can be used to improve the performance, from the assessment of the users in your organization.

Objectives of the Chapter At the end of this chapter you will be able to:

• List some factors that affect the performance of a query• Explain why the performance tuning BI is not considered to be primarily a

function of basic equipment• Identify techniques and basic tools for optimizing a query

• Define aggregates and enumerate some of the benefits of its use• Use update functions of aggregates• Explain the rollup of aggregates and the location of the read pointer • Explain why the modification executions of aggregates are

important• Creating and completing an aggregate for a InfoCubo• Define accelerators BI• Explain the use of accelerators BI and its high-level architecture


14/77

Capítulo 8: Introducción a la optimización de rendimiento de una query TBW10


• Explain the advantages of accelerators BI compared with other tools of performance improvement BI

• Identify the Business Content of statistics of BI• Raise the use of BI Administration Cockpit

Content of the Chapter Lesson: Introduction to optimizing the performance of a query in the BI.................................................................................................................................. 545

Demo: RSRT demo ........................................................................................548Lesson: Aggregates BI .........................................................................................552

Procedure: Creation of an aggregate and data padding ......................570Exercise 19: Creation and fill of a added for a InfoCubo . 571 Exercise

20: Loading a InfoCubo and transfer of a added 577 Lesson: BI Accelerator ............................................................................................................. 583Demo: Demo the speed of queries ............................................................589

Lesson: Summary Statistics ................................................................................592Demo: Show the Business Content for InfoArea: Business InformationWarehouse (0BW) >>> BI Statistics (0BWTCT_STA) . . . 596


15/77

TBW10 Lección: Introducción a la optimización del rendimiento de una query en BI


Lesson:

495

Introduction to optimizing the performance of a query in

the BIDuration of the lesson: 20 Minutes

Summary of the lessonAlthough the BI system is optimized for a quick reporting, the definition of "fast" is different for each user. In this lesson you will learn some of the manyaspects that could affect the performance of a query.

Lesson ObjectivesAt the end of this lesson you will be able to:

• List some factors that affect the performance of a query• Explain why the performance tuning BI is not considered to be primarily a


This overview is really and advertisement for BW360. Although we go into somedetail on aggregates, we do not address many of the other areas in detail.

Business CaseYour project has set a minimum run time acceptable for queries. Some queriesviolate this threshold. Your job is to improve these queries of slowimplementation and want to learn how to meet this objective.

Performance factors of queriesThere are many issues that affect the performance of queries, but one in which weare not accustomed to thinking is the perception of the user. Users should beaware that a complex analysis would entail some time. It and the functions of the

company must be according to destinations performance of query reasonable, andthe enterprise must understand the costs involved with a performance of querygrowing.

Prior to the installation of a BI system should take into account the size of theresources and performance objectives. The base team uses the entry of the activityand other data, combined with a tool called Quick Sizer, to determine the initialsize and configuration of servers BI and the system of management of the disk support. However, many system options and decisions of the BI application affectthe final goal of a query fast.


16/77



If they ask, the path for the quicksizer

is Http://Service.sap.com/quicksizer But it is not to be covered in this class,

see BW360 for more information.

Chart 199: Query and Web performance factors

To be able to discuss one sentence on each of these topics, please review theBW360 materials and the BW330 materials.

http://service.sap.com/quicksizerhttp://service.sap.com/quicksizer


17/77



Tools and techniques to improve the performance of queriesAs a support to a deployment BI, the Expert user (authors of queries andfunctional representative) is the first contact with a query of under performance.They may go first, but will contact you shortly after. The basic steps of highlevel for solving issues of performance of queries are:

Note: This is conceived as a high-level summary

, the details are found in BW360.

1. Examine BI Statistics for information about the execution time of systemload for the query in question.

Council: BI Statistics maintains detailed data on treatment times.

2. With BI information statistics, review the design of query in search of violations of best practices.

3. Consider the preliminary estimate / dissemination of information (usefulin many reports aimed at end users).

4. With BI information statistics, consider using the BI Accelerator, if it has been installed on your system.

5. With statistical information B, consider the creation of aggregates,taking into account that BI Accelerator is not an option.

6. With information from BI Statistics and other information on table sizes(RSRV) and access times SQL (ST01), consider the remodeling of the star schema or the addition of indexes to operational data stores to improve thedesign.

7. Work with the team of basis for evaluating cache options, the system loadand other parameterizations of the system that could be affecting the performance.

There are many tools that you can use to determine the root cause of performance problems, including the query monitor (transaction RSRT). The monitor of queryis a simple way to run and debug a query in the backend. Through the executionof a query with this tool removes many other subjects, such as the Web pagelayout and the customizing of the book of Job, from the center of the performanceof a query.


18/77



Chart 200: RSRT: The monitor of query

Demo: RSRT demo

Objective

Show one option in RSRT

System Data

System: Principal:User ID: Key of access:Parameterizations of the system:

1. Open RSRT, enter "T_06to00/T_BW3104" as the query. Then pressexecute and debug, check the options to "Do not use cache and DisplayStatistics Data" (under the others section)then the execute the query withthe green check.

2. Specify a key date of 10.10.2010 (ask the class as a reminder what the heck is key date? The answer it should be hat the key date selects the appropriatetime dependant attribute records that are valid for a specific date. Continueto execute the report and obtain the output.


19/77



3. Select the "UP arrow" to continue to the statistics information. The first tabshows the times for all the substeps of the query. About halfway down,

there is an event text called data manager, this is the time data base, itshould be less than one second RPF this query. Note it will not appear if you forgetTo set the option to not use cache.

4. Select the data manager tab to show the number of records selected and thenumber of records transferred (over on the right side of the of the screen.The numbers should be about 300 and 100 respectively.


20/77



Discussion with moderator Understanding responsibilities for improving query performance?

Questions for discussionUse the following questions to the course participants take part in the discussion.You can also use your own questions.

Who's job is it to improve the performance of queries?


21/77




You should now be able to:• List some factors that affect the performance of a query• Explain why the performance tuning BI is not considered to be primarily a


More information

For more information on the performance of queries and loads, see the courseSAP BW360.


22/77



Lesson:

500

Added BIDuration of the lesson: 90 Minutes

Summary of the lessonThis lesson summarizes the aggregates BI. Is their use, creation and features.


• Define aggregates and enumerate some of the benefits of its use• Use update functions of aggregates

• Explain the rollup of aggregates and the location of the read pointer • Explain why the modification executions of aggregates are

important• Creating and completing an aggregate for a InfoCubo

This exercise discusses the design and use of the BI aggregates. It covers muchof the aggregate building and design, but does not address aggregates build ontime dependant master data, or some technical aspects of aggregates.Aggregates are also discussed in the BW360 Performance and Tuning, and theBW330 Data Modeling classes.

Business CaseCreate aggregates for the accounting InfoCubo cost centers will improve the performance of queries that use data from this InfoCubo. Your project team BIneeds to define aggregates for this InfoCubo because the performance of thequery does not reach to be acceptable. The team also want to compare the benefits of optimizing the performance of the system to the end user before thedisadvantages and costs associated.

Aggregation in a BI system and its benefits

An aggregate is a summary view of the data in a InfoCubo. In an aggregate, theset of data from a InfoCubo is stored redundantly and persistentIn its own InfoCubo as structure in the database. An aggregate in a InfoCubo issimilar to the indexes in a database table. Although technically are verydifferent, both improve the performance of the system without the need for user intervention. The only way that a user hasTo know that an aggregate is built for a InfoCubo that I was consulting is torealize that the query is running more quickly. The aggregates


23/77


TBW10 Lección: Agregados BI

They can be created only for InfoCubos (not virtual cubes or DataStore objects).The aggregates can be formed in InfoCubos by selecting specific objects

connected to the InfoCubo, as for example:

• Features in dimension tables• Associated with the InfoCubo hierarchies• Navigation attributes associated with the InfoCubo

Although the data is already stored in a structure of star schema summary, theInfoCubo must contain the detail level (granularity) necessary to withstand eventhe more detailed user requirements. For example, if 1 per cent of queries musthave the level of detail day, but the remaining 99% need only month, your timedimension and the fact table connected must be designed to withstand the level of

detail day. This will cause many more records are stored in its InfoCubo thanwould be required to support the requirement month. The end result would be thata 99% of queries would be implemented more slowly than they might not be so,which would have as a result that the query does not fulfill his response time goals.

Use aggregates reduces the volume of data to be accessed for each query becausethe data is stored in a separate aggregate InfoCubo that contains a limited set of features in the InfoCubo connected. In this example, day would not be included inour InfoCubo added. This would improve the read performance of queries thathave details that supports a added. Within the aggregate,The data are summarized automatically by selecting a limited number of featuresand their attributes of navigation or hierarchies available.

Chart 201: aggregates in BI


24/77



In the example above, say that the main InfoCubo contains (inside dimensions) 40different characteristics that include the InfoObjeto day. One of the aggregates

(with structure similar to a InfoCubo) contains six important features, and another contains six different. None of the aggregates contains the InfoObjeto day, since itis not used in many queries or need it many users. As shown in the previousimage, the user does nothing to address the added. If the navigation of a query issupported by an aggregate, the OLAP processor will use. If more than one meetsthe requirement, the OLAP processor selects the most efficient.

The aggregates are especially useful in the following cases:

• Run and navigate data from query delays to the groups of queries:aggregates can be designed to improve the speed of a group of queries.

• You want to speed up the implementation and the navigation of uns queryspecific. This is not as desirable as the reason above, unless the query willuse very often.

• Frequently used attributes of navigation in queries: the attributes of navigation are intrinsically slow, since they are in a table away from thefact table and therefore require a link of additional table to retrieve theattribute values of navigation. The execution time of queries with attributesof navigation dramatically improves when they are in an aggregate.

• You want to speed up the reporting of hierarchies of features by addingspecific hierarchy levels: a InfoCubo that has wages for 100,000 employees,for example, you could have an aggregate using the structure of thecompany until you reach the responsible for the object, with many fewer records.

Added: ExampleAn aggregate can be constructed on the basis of the characteristics, attributes of navigation and a InfoCubo hierarchies. Both the attributes of navigation time-dependent as time-dependent hierarchies can be used in aggregates, as well as theindependent of time. The use of dependent objects of time complicates the abilityof queries to use the aggregates.

Note: The complication that added the master data time-dependent to

the aggregates can be an important reason to avoid them. This approachis quite advanced and it is in BW330.


25/77



The aggregates are defined as follows:

• '*' - including; the feature is used in the compression• ' ' - excluded; a feature is not used in the compression• 'F' - included with a fixed value; the feature is compact with a specific

fixed value• 'H' - hierarchical level; the feature is compact for a specific hierarchical

level

Chart 202: simplified display of aggregate options

In general, adding features, hierarchies and attributes of navigation to your added, defines the granularity of the data and what are the requirements of reporting that must meet the aggregate. When it comes to characteristics of time(sometimes also other) if their basic requirements allow the inclusion of thefeature "X," should include all the characteristics that derive from "X.". For example, if you define an aggregate for the week, should also include themonth and year in the aggregate. This enlargement does not increase thenumber of records, but allows the added support more queries.

You can combine several features in an aggregate. Combinations are also possible in the restrictions, as fixed values or hierarchical levels. For example,you can have a added "Country=Germany and all customers and materials".


26/77



→

If the InfoCubo uses a ratio for that has been defined an aggregation of exception,this feature should be included in an aggregate and defined as '*'. The restrictions

are not allowed in this case (for example, fixed value 'F').Note: An aggregation of exception means that the ratio behavesdifferently when analyzing before different characteristics. ByExample, the balance of inventory can be added to the customers, but notthe time. When the time is reflected in the report, the value of the resultof the inventory is the value of the balance sheet of the last day. Shouldnot join the inventory of each day to get the full inventory. If you havethree classes of ratios in its InfoCubo, should have the feature of exception included in the design added; in this case, day must have "*"set in the aggregate.

GUI design, data loading and measurement for aggregatesSAP provides a GUI simple but efficient to build, load data and measure the useof aggregates. You can access the GUI by selecting Menu In a InfoCubo shortcut Update aggregates.

The aggregates have technical properties, properties of content and properties of status. This information is stored in the tableRSDDAGGRDIR and will be displayed in the GUI.

Chart 203: GUI added


27/77



When you build the aggregate, will only come to define a description, so thatshould be significant. The system automatically assigns a unique internal

identification of 25 characters when added (Table RSDDAGGRDIR,field AGGRUID). This identifier is used to connect the InfoCubo added with theappropriate InfoCubos from which were built. You will never see this name in theGUI. The system also provides a technical name for added to the InfoCubo added.It consists of six integers and is specified in a range of numbers that begins with100000. In this way, the first added that build will have the technical name1000001.

Before they can be used in reporting, aggregates should be enabled and completedwith data. If you are prevented from using one or more aggregates, has threeoptions:

• Disable the added. The aggregate is still full of data, but the OLAP processor do not use it. Still must transfer new data.

• Disable the added. The aggregated data are deleted, but the definition of theaggregate remains.

• Clear the added. The aggregate data and the definition of the aggregatewill be erased.

A InfoCubo can contain more than one added, but can normally only be used anaggregate in each step of the query. If you create multiple aggregates for aInfoCubo, the OLAP Processor verifies all when you run a query. During thischeck, the OLAP processor reads all aggregates of InfoCubo and selects theadded which conform to the definition of the query.

Note: In situations in which you create more than one SQL statement, it is possible that the OLAP processor select data from more than oneInfoCubo. An example of this occurs with queries based on multisite.Another Situation in which this occurs is when you have 2 ratios restricted, for example a "sales for Germany" and the other "Sales for the year = 2006".

The information on the status, the use and value of the aggregates is also providedin the GUI. The latest information used, number of times you have used and anassessment (valuation of utility) are some important fields. SAP also providesinformation on the number of records in the aggregate fact table (this number should be low, compared with the InfoCubo). Finally, it provides a measure thatrefers to the number of average records for each feature removed from theInfoCubo.

Contains a feature called the aggregated tree. It is designed to facilitate theefficient charging and, at the time of execution of the query, contribute to theselection of the aggregates available. This feature arranges the aggregates in ahierarchical relationship father-son. For example, the father of an aggregate of customer would be the addition of client and material. In turn, the aggregate of customer and material is the son of the aggregate of customer and material andsales organization.


28/77


29/77



If they are included in the aggregate 14 features or less, the BI system does notcreate real dimensions; instead it creates a dimension of individual item. In the

event of a dimension of individual item, the dimension table is deleted and thecharacteristic InfoObjetos SID is written in its place directly in the fact table.When this happens, the aggregates are called aggregates plans .

Note: The characteristics of the data packets and time are the exceptionsto this rule. Each one of these characteristics is stored in a dimension asthey were in the original InfoCubo.

Chart 205: Added drawings

If 15 or more features are included in an aggregate, the BI system can proceed intwo ways:

• If two or more features come from a dimension of InfoCubo, the dim theInfoCubo ID is stored as a key in the fact table.

• If only one feature comes from a dimension of InfoCubo ID, the master datais stored as a key in the fact table. Here is used a dimension of individualitem.

Tip: The system applies a complex logic to build tables in the fund. Makesure when you construct aggregates that does everything possible toLimit each one to the 14 components or less. For example, a client andmaterial and country of added only uses 3. Everything works best withthese aggregates planes of smaller size.

The following figure shows a simplified view of the connection between a anda InfoCubo InfoCubo added.


30/77



Chart 206: simplified table schema for an aggregate

Selection of addedThe aggregates should be created on the basis of queries that are defined by eachInfoCubo. However, the added created should also be useful and relevant. Note thefollowing considerations before you create an assembly:

• Does the aggregate is larger than necessary to support the majority of their queries? What should be added a fixed value to further define thedestination?

• Does it improve the speed enough to make it worth?• Does it really need? For example, does this added fixes an issue of user

performance?• Do aggregates can be combined without the user note a slower response

time?• Do the aggregates are in use?

Time-dependent aggregates

The aggregates that use master data time-dependent are called time-dependentaggregates . Previously, it has been recommended not to automatically enable theunit of time to master data (attributes and hierarchies) unless it is absolutelynecessary. This is because this important feature can have unintendedconsequences and confuseThe user. Enable the unit of time also greatly complicates the updating of aggregates. Given that the attributes of master data can change based on a specifickey, the aggregates of date is also created for a key date.


31/77



Demo the first exercise where they build the aggregate at this point in the lesson.

Aggregates of rollupFill is the term used for loading data from the original form in an aggregate.A rollup is the term assigned to the process of loading new data from theInfoCubo to aggregates of InfoCubo. A rollup takes place when the request for theInfoCubo is loaded on the aggregates. A rollup may consist of one or moreapplications and the request ID controls the request. The request ID is stored in the

size of the package of InfoCubo.

Chart 207: Rollup added

As can be seen in the image above, the first request (number 4611) has beentransferred to the added 100043. In the table RSDDAGGRDIR, a pointer for reading is set for the application in the field RNSID 4611_TO. This read pointer indicates the OLAP processor which request is available in the added andtherefore can be read in a query. In the second step, an additional request(number 4612) is written in the InfoCubo. Has not yet taken place a rollup. For this reason, the data for this request are not available for reporting. Note that thelocation of the read pointer is still set to the request 4611. On the Administration screen of the InfoCubo, the new request is also marked as not yet available for reporting. In the third step, after having made the rollup, the request 4612 isindicated as available for reporting and the location of the read pointer of thetable RSDDAGGRDIR now points the request 4612.


32/77



Chart 208: Rollup of added and read pointer

Steps in the rollup:

1. You write a new application in the InfoCubo (a new RNSID in the facttable).

2. New applications are transferred to the aggregate.3. During the rollup, the location of the read pointer moves to a new request.

The application is now available for reporting, as well as during the rollup.4. It is possible to compress a request (see section Compress added ).

Note: Although the new data have been loaded in the InfoCubo BI, thedata are not yet available in any query until you haveMoved (transferred) to all aggregates. This ensures a consistent answer (although above) if a query uses a InfoCubo or one of its aggregates.

Optimization of aggregatesUsing data from BI Statistics (mostly times of execution of queries) SAP provides an easy way to optimize its aggregates. The system can automatically propose new aggregates by analysing their queries slow.


33/77



Changes in the aggregates and the master dataIf modifications are made to attributes or hierarchies of features used inaggregates, the aggregates structure must also be modified. Since themodification of these data would invalidate the aggregated, not can directlyactivate the hierarchies or attributes of navigation, you can only mark it for activation. This means that the attributes and hierarchies of navigation are twoversions: An active version and a modified version. The modifications are madeduring an execution of modification for hierarchies or attributes. While thechanges are being made and the execution of modification is active, use the olddata for reporting until you have rebuilt the aggregates.

Tip: This concept is very important. It means, for example, that if

you modify the sales representative for a client, and there are addedto the sales representative, then no REPORTIncludes this updated information of the representative of sales until theexecution of the modification has fixed all aggregates that involve thesales representative.

Chart 209: Example: when is it required an execution of attributemodification

In the case of the aggregate of the customer displayed above, no modification isrequired because the amendments of the group of customers do not affect thisaggregate in particular. In the case of the aggregate of client / customer group,there is a need for execution of modification. Otherwise, the aggregate would provide incorrect results and inconsistent because the new allocation of customer D to the customer group and is not taken into account. Since the group of


34/77


35/77



→ →

Note the following points in relation to the modification executions:

• The time required for an execution of modification depends on thenumber of attributes of navigation and hierarchy and the frequency withwhich the data are modified teachers for each one of the characteristicInfoObjetos.

• During the execution of the modification, can only make reports on older versions of the attributes and attribute hierarchies. The active versions of theamendments are available only after the end of the execution of modification. This also applies to the reporting using InfoCubos that are notaffected by the implementation of modification, but that use the hierarchiesand the changed attributes.

• Use the monitor function ( RSA1 Management button Execution of modification) to check what objects are affected by theimplementation of modification. This will show you what features andhierarchies are enabled and what additions and InfoCubos are affected. If the execution of modification is active, the monitor will show you if themodifications are enabled for each aggregate.

Chart 211: Modification of a hierarchy: Effects on the aggregates


36/77



To hierarchies are the following applies:

• If you modify the structure, will fit all the aggregates of InfoCubo affected by modifications in the hierarchies and attributes. This class of execution of modification can take considerable time to complete.

• Once the hierarchies are marked as active, modified hierarchies areimmediately available for reporting, provided that they are not used in theaggregates. If used in aggregates, the can use in reporting if you delete or disable the aggregates. Otherwise, the modifications made in suchhierarchies will only be displayed after the end of the execution of modification.

Council: a modification execution typically runs after the master data is

loaded by means of a chain of processes.

Graphic 212: Implementation of attribute modification

If an aggregate is only affected by a few modifications, does not need to be rebuiltcompletely; the aggregate can be adjusted using in its place+/- records. During the execution of modification, the records of old data isrecorded with a negative value and the new are recorded with positive values.From a certain point, depending on theAmount of modifications, this method is more complicated than completelyrebuild the added. Since the threshold value for the maximum number of


37/77



→

→ → →

→

Modifications you can try also depends on the parameterizations of Your system, you can modify it. Select Administration Parameterizations

Customizing SAP Reference IMG Business Information WarehouseGeneral parameterizations Parameters for aggregates.

Compress addedThe aggregates can be compressed automatically during the rollup. Theapplication(s) is writes(n) in the fact table E of InfoCubo added. As has beenmentioned previously, this eliminates the Request ID, which means that acompression can be applied to all applications. Adds the data records with thesame value of feature. If a request has to be clear after the compression, you mustfirst disable all aggregates. This process can take a long time. If not compressingthe aggregates until you have compressed the InfoCubo, it does not take long toclear a request that has already been transferred but has not yet beencompressed. The option to compressThe added automatically after the rollup option is available through the ManageShortcut Menu > Transfer label for a InfoCubo. Should only be used when itis very unusual to need to delete requests from the InfoCubo. In most cases thisis true.

Chains of processes and aggregatesA chain of processes is a sequence of planned processes in the background andwaiting for the trigger a specific event. Some of these processes trigger an

event own, which in turn triggers other processes. In an operating system BI,there are several processes that are executed regularly in addition to the dataload process.

As a quick review, remember process chains were the tool we used to load our DataStore object in a previous lesson.

If you use strings of process, you can:

• Use treatment controlled by events to automate complex processes inthe BI system• Use graphics of network for visualize the processes• Control and monitor the processes of centrally

In this lesson, so far we have spoken of 3 areas that could be used chains of processes. In most cases, it is not necessary to use a chain of processes tocomplete an initial added, but there are two other tasks for which you needchains of processes. First,

→


38/77



The chains of processes are almost always used to perform the execution of modification of attributes. This step is performed to adjust aggregates based on

master data when the data is modified teachers.If the attributes of navigation time-dependent and/or time-dependent hierarchiesare used in an aggregate, must be another kind of process, "the aggregates of setting time-dependent", in a chain of processes.

Chart 213: String of simplified processes for loads of master data


39/77



The second use for chains of process that involve aggregates is the rollup. Thefollowing steps to load data variables that imply an aggregate show where comes

into play the rollup:

1. Start the chain.2. Deleting Indices of InfoCubo.3. Load the data from the source system to PSA through a InfoPaquete.4. Load data from the PSA to the DataStore object through a process

of data transfer (DWP).5. Activate data in the object DataStore.6. Loading data from the object DataStore to the InfoCubo through a DWP.7. Create indexes for the InfoCubo after loading.8. Create database statistics.9. Transfer data to the aggregate.10. Use the BI Information Broadcasting to distribute the reports previously

calculated.

As can be seen, the chains of the process are indispensable tools in BI.Without them, could not coordinate efficiently all the tasks required by theData Warehouse.


40/77



Creation of an aggregate and data padding517

1. Access the shortcut menu of a basic InfoCubo and select Updateaggregates.

2. The left side of the screen displays the dimensions, characteristics andattributes of navigation InfoCubo selected in a tree structure as selectionoptions for aggregates. Select one or more objects to copy them to your added.

Define the granularity required for the data in the aggregate. Add all thecharacteristics that are derived from these features.

Note: For example, if you define an aggregate for the month, shouldalso include the quarter and the year in the aggregate.

3. Enter a brief description and an explanatory description when the dialogwindow will be required.

4. Modify the structure of the aggregate by adding additional components or deleting an existing.

Insert components in an aggregate. Select one or more objects in selectionoptions for aggregates and transfer them to the assembly you want tomodify in the right side of the screen. Where necessary, modify theselection class by selecting the appropriate entry on the shortcut menu.

Your options for the class of selection are: All values of feature, hierarchylevel , or Fixed Value.

5. To check the definition of aggregates for inconsistencies, selectCheck Definition .

6. Record the added new or modified.

Result

You can activate the added new or modified and filling it with data. Then isavailable for reporting


41/77



519 Exercise 19: Creation and fill of a

added for a InfoCuboDuration of the exercise: 20 Minutes

Objectives of the ExercisesAt the end of this exercise, you will be able to:• Create and update added for a InfoCubo

Business CaseYour company you want to compact InfoCubo data of accounting for cost centersto improve the performance of a query. With this objective, the project team BIwant to create aggregates for the InfoCubo.

System Data

System: Assigned systemPrincipal: 800User ID: Assigned user IDKey of access: Assigned passwordParameterizations of the system: None required

Task - Create an aggregate and fill it outUse the feature COSTC## to create an aggregate for your InfoCubo GR##HUB1.

1. In the Workbench, open the directory of the InfoSitio and create anassembly for its InfoCubo GR##HUB1. Open the shortcut menu andselect Update aggregates.

2. Create your own added instead of using one proposed by the system.

3. In the model to define the aggregate, drag the Feature COSTC## for your added outside the window on the left and drop it in the right window.Assign your added the short description GR## AG1COSTC and descriptive text GR## added 1 Cost Center . Confirm your entries.

4. Verify that the definition of the aggregate is correct according to thereport of the log of aggregate.

5. Record the aggregate and then fill it with data. Select the icon Activate/Fill , start the job immediately and check the result.



42/77



6. Note the data records for the aggregate and then return to the screen toupdate the aggregates.

7. Clear the aggregate and then activate it again. Remember that when youdisable the aggregate prevents the use BEx, but you still must be updated.

8. Use the InfoCubo GR##HUB1 and the feature COSTC## to create a secondadded with the brief description GR## AG2 COSTC and descriptivetext GR## added 2 Cost Center 4100 . This time, use the Cost Center 4100- Technical Service and Maintenance (1) in the aggregation configuring itas a fixed value. Record entries. Activate your new added and fill it withdata. When the aggregation is successfully completed, compare the number of records added to the number of records that were originally available for this cost center In the InfoCubo.


43/77



→ →

→ → →

→ →

Solution 19: Creation and fill of a added

for a InfoCuboTask - Create an aggregate and fill it outUse the feature COSTC## to create an aggregate for your InfoCubo GR##HUB1.

1. In the Workbench, open the directory of the InfoSitio and create anassembly for its InfoCubo GR##HUB1. Open the shortcut menu andselect Update aggregates.

a) Select Menu SAP Easy Access Modeling Data Warehousing: Modeling InfoSitio Customer training InfoÁrea BW

BW310 Warehouse Management Group## GR##HUB1. In the

Shortcut menu of InfoCubo GR##HUB1, select Update aggregates.2. Create your own added instead of using one proposed by the system.

a) Since there is not yet available for your InfoCubo aggregates, thesystem displays a dialog box in which you must select whether or not you would like the system to propose aggregates. Select Createby myself .

3. In the model to define the aggregate, drag the Feature COSTC## for your added outside the window on the left and drop it in the right window.Assign your added the short description GR## AG1COSTC and descriptive text GR## added 1 Cost Center . Confirm your

entries.a) Select COSTC## and drop it into the window on the right.

In the window enter description added , perform the followingentries:

Field Name Input Value

Brief description GR## AG1 COSTC Descriptive text GR## added 1 Cost

Center



44/77



4. Verify that the definition of the aggregate is correct according to thereport of the log of aggregate.

a) In the bottom right of the screen, check the log added to determine if the aggregate is correctly defined: If Everything is correct, the following message appears: Theaggregate "GR## added 1 Cost Center" isset correctly .

5. Record the aggregate and then fill it with data. Select the icon Activate/Fill , start the job immediately and check the result.

a) Select Record .

b) Select the aggregate and fill it with data.

c) In the window run time of aggregation, select Immediately. Thelight turns green when the aggregation has successfully completed.

Tip: It may be necessary to refresh the screen to see theupdated status.

6. Note the data records for the aggregate and then return to the screen toupdate the aggregates.

a) To view the aggregated data, select .

b) Select the pad selecting fields to exit and then select at least onefield using the selection box (Do not select a SID field).Select Run Two times. Displays the records of aggregated data.

c) Return to the update of the aggregate by selecting Back Twotimes.

7. Clear the aggregate and then activate it again. Remember that when youdisable the aggregate prevents the use BEx, but you still must be updated.

a) Clear the added by selecting . In place of the green lights, shows agray diamond in the column filled/Off .

b) Select again the added by selecting .

8. Use the InfoCubo GR##HUB1 and the feature COSTC## to create a secondadded with the brief description GR## AG2 COSTC and descriptivetext GR## added 2 Cost Center 4100 . This time, use the Cost Center 4100- Technical Service and Maintenance (1) in the aggregation configuring itas a fixed value. Record entries. Activate your new added and fill it withdata. When the aggregation is finished



45/77



With success, compare the number of records added to the number of records that were originally available for this cost center in the InfoCubo.

a) Select COSTC## in the left area and drop it in the right window. b) In the window enter description added , perform the following

entries:

Field Name Input Value

Brief description GR## AG2 COSTC Descriptive text GR## added 2 Cost

Center 4100

c) Confirm your entries.d) Select the new aggregate in the right window and deployment the tree

until it is visible the feature COSTC##. On the shortcut menu for theInfoCubo COSTC##, select Fixed Value.

e) In the list of cost centers, select the cost center T900000004100 -Technical Service and Maintenance (1). Select Record .

f) Select Enable And fill in the aggregate with data.

g) In the window run time of aggregation, select Immediately. The lightturns green if the aggregation ended with success. Compare thenumbers of the columns summary records and entries.

h) Return to the Workbench by selecting Back .


46/77




47/77



525 Exercise 20: Loading a InfoCubo and

transfer of a addedDuration of the exercise: 15 Minutes

Objectives of the ExercisesAt the end of this exercise, you will be able to:• New data transfer from your InfoCubo to added

Business CaseEach day is loaded more data to your InfoCubo. To make these data available for reporting, you need to transfer them to their aggregates.

System Data

System: Assigned systemPrincipal: 800User ID: Assigned user IDKey of access: Assigned passwordParameterizations of the system: (only if the filter in DTP is notworking) We use the Filter functionality in the DTP to select the appropriatedata. In case that the filter for any reasons is not working, please consider thefollowing remarks:

1. Attention: If the Filter Functionality in the DTP is not working properlyand results in short dumps: the instructor you have to delete the PSA andstart an InfoPackage upfront to load data into PSA: SelectionSettings : Fiscal Year Period = 001.2005 / CO_AREA =6000 .

Then the participants do not need to use the Filter Functionality in the DTP.

2. It is important to coordinate with other instructors on the same box. Theyneed to be done running exercise 17 before you delete the PSA and reload itwith this data above.

Task 1: Loading data additional variablesYou want to examine the rollup of aggregates for the InfoCubo GR##HUB1.Before doing so, you must load an additional request in the InfoCubo.

1. In the Workbench, select the tag InfoSitio. Locate your InfoCuboGR##HUB1 and create a data transfer process to do so.



48/77



In the dialog window that appears, enter variable data GR## CA 6000 asthe description for the data transfer process.

The source for the data transfer process is the data source0CO_OM_CEC_1 of source system T90CLNT090.

In the rest of the tags, perform the following parameterizations. In

the page of label removal :

Field Name Value

Pull mode Delta Filter

Society CO = 6000

In the Label Update:

Field Name Value

Error Handling Without update, without reporting

In the Label Run:

Field Name Value

Processing Mode Removal and paralleltreatment

Start the transfer of data in the label Run.

Use the monitor to verify that the data has been loaded with success in theInfoCubo.

Task 2: Perform rollup of addedSince its InfoCubo contains aggregates, you must transfer the new data so that it isincluded in the aggregates. The system includes the latest data in reporting onlyafter the end of the rollup for all aggregates.

1. In the Label Requests, check the ID number of your request GR## CA 6000variable data OLTP. The symbols of the rollup Status columns (in theInfoCubo and aggregates) and Application available for reporting willindicate which requests have been updated already in the aggregates.



49/77



2. In the Label field Rollup , Rollup for Order ID, enter the ID of the requestof its last request GR## CA 6000 variable data OLTP and select Run. Is

performed in rollup of your request in the aggregates.3. Open the label again requests and check the Status column of rollup.

Select Refresh.


50/77



Solution 20: Loading a InfoCubo and

transfer of a addedTask 1: Loading data additional variablesYou want to examine the rollup of aggregates for the InfoCubo GR##HUB1.Before doing so, you must load an additional request in the InfoCubo.

1. In the Workbench, select the tag InfoSitio. Locate your InfoCuboGR##HUB1 and create a data transfer process to do so.

In the dialog window that appears, enter variable data GR## CA 6000 asthe description for the data transfer process.The source for the data transfer process is the data source0CO_OM_CEC_1 of source system T90CLNT090.In the rest of the tags, perform the following parameterizations. In

the page of label removal :

Field Name Value

Pull mode Delta Filter

Society CO = 6000

In the Label Update:

Field Name Value

Error Handling Without update, without reporting

In the Label Run:

Field Name Value

Processing Mode Removal and paralleltreatment

Start the transfer of data in the label Run.



51/77



→ →

→ → →

→

Use the monitor to verify that the data has been loaded with success in theInfoCubo.

a) Select SAP Easy Access Modeling Workbench: Modeling InfoSitio Training BW Customer Training BW BW310

Data Warehousing Group## .

From the shortcut menu of your InfoCubo, select Create DataTransfer process.

b) Update the data transfer process with the options that are offeredabove.

c) Select Run .

Task 2: Perform rollup of addedSince its InfoCubo contains aggregates, you must transfer the new data so that it isincluded in the aggregates. The system includes the latest data in reporting onlyafter the end of the rollup for all aggregates.

1. In the Label Requests, check the ID number of your request GR## CA 6000variable data OLTP. The symbols of the rollup Status columns (in theInfoCubo and aggregates) and Application available for reporting will indicate which requests have been updated already in theaggregates.

a) Access the function to manage its InfoCubo using the shortcut

menu. In the Label Requests, evaluate the status columns for thelast request. There are no entries in the columns Status of rollup or request available for reporting .

2. In the Label field Rollup , Rollup for Order ID, enter the ID of the requestof its last request GR## CA 6000 variable data OLTP and select Run. Is performed in rollup of your request in the aggregates.

a) Select the label Rollup.

b) In the Rollup field for request ID, enter the ID of the request to therequest GR## CA 6000 variable data OLTP.

c) Select Run .

3. Open the label again requests and check the Status column of rollup.Select Refresh.

a) In the Label requests, select Refresh .

In the Status column of rollup (in the InfoCubo and aggregates)and Application available for reporting , the corresponding symbolsshow you that the data has been updated on the aggregates and areavailable for use in queries.

→


52/77




You should now be able to:• Define aggregates and enumerate some of the benefits of its use• Use update functions of aggregates• Explain the rollup of aggregates and the location of the read pointer • Explain why the modification executions of aggregates are

important• Creating and completing an aggregate for a InfoCubo

More information

Additional information can be obtained in the course SAP BW360 or in the

SAP Help Portal: Http://help.sap.com.

http://help.sap.com/http://help.sap.com/


53/77


TBW10 Lección: BI Accelerator

Lesson:

530

BI Accelerator Duration of the lesson: 20 Minutes

Summary of the lessonAs an alternative or complement to aggregates, accelerators BI represent a new paradigm of data access for large sets of data. The lesson provides anintroduction to this technology and what it means for your BI system.


• Define accelerators BI• Explain the use of accelerators BI and its high-level architecture• Explain the advantages of accelerators BI compared with other

tools of performance improvement BI

This is a brand new 7.0 feature. It is a great tool, but you have specific hardwarerequirements. There also are a few limitations to it's use. For example it does notyet work for noncumulative key figures, or providers other than cubes. This class just gives the student an overview. BW360, the performance an tuning class goesinto the details.

Business CaseAs an administrator, is responsible for finding ways to improve the performance of queries. Already using aggregates to enhance performance, but you want to improve the speed yet more. You should investigate theaccelerators BI because they allow a quick access to any data withlittle effortAdministrative. It has also heard that accelerators BI are especially useful for sophisticated scenarios with classes of query unpredictable, a large volume of dataand a high frequency of queries.

BI Accelerators: Definition, positioning and BenefitsIt managers must balance the demands of the user for advanced BI tools that canhandle more data in less time with the reality of cost control. The current tools tryto keep up to date, contributing to


54/77



It get these competing objectives. The technologies that include the previouscalculation of data from query and/or the output (Web or Microsoft Excel) are an

option.Other options include the use of the global cache BI and aggregates BI.

Note: BW360 focuses on the setting of performance; the aggregates BI arean important part of this process of improvement.

Chart 214: techniques to improve the performance of queries

All these tools are a help in terms of performance, but involve many managementresources and have costs associated with the time of treatment. In addition, mayimply a redundant data storage.

The solution is the BI Accelerator. The BI Accelerator, a "complement"hardware and an "application" software that will solve many performance issues.This package with the latest hardware and software, is a joint effort of SAP andIntel, a technological partner of SAP. Allows enterprises to overload the AnalysisServices and applications by combining high performance software for SAP

NetWeaver with advanced hardware design of Intel that gives a boost to the performance of the analysis. It also cuts the time of TI performing a dataaggregation dynamics and eliminating many of the needs of the adjustment of queries. Shortens significantly the load times by eliminating the settings(modification executions) to data aggregates.


55/77



Chart 215: The BI Accelerator

Tip: Just to make sure that it is understood our "humor in his country,"thedinosaur in English, is a Tyrannosaurus Rex = TREX

Grouped by packages as a "team" (hardware and software together), your IT

department simply connects the BI Accelerator to the existing BI infrastructurefor SAP NetWeaver (7.0 or higher) and determines that the InfoCubos BI are"supercharged." The BI Accelerator indexes InfoCubo information to create astructure very compressed that can be loaded into memory when a user requestsdata. The accelerator is queries completely in memory using efficient aggregationtechniques , and then delivers the results to the analytic engine BI in SAP NetWeaver to give out until the user.


56/77



Chart 216: architecture of BI Accelerator

Software and hardware added BITo reduce the needs of training and setup, SAP has grouped by packages and previously configured the BI Accelerator with the hardware you need to run.Currently this hardware based on Intel technology must be purchased to IBM or HP.

Chart 217: BI Accelerator: Hardware and Software


57/77



The advantages of accelerators BI

Chart 218: Advantages of BI Accelerator

In comparison with the technologies and OLAP tools, the BI Accelerator presentsimportant advantages. In the following image, BI (without the accelerator) isshown as a tool ROLAP (relational database for OLAP). In the ROLAP, tablesare linked form r elacional to constitute the schemaOf reporting (as our star extended). BI also supports summary tables (added).Another technology is MOLAP (multidimensional database for OLAP). Thistechnology uses structures based on arrays in a patented design that accelerates theanalysis, but at the expense of greater data latency.


58/77



Chart 219: The BI Accelerator is a new technique of technical OLAP

Note: For your information, this kind of diagram so effective is available inthe BEx Web Application Designer.

The BI Accelerator is also well positioned in relation to the other tools of performance improvement mentioned at the beginning of this lesson.

Chart 220: Comparison of tools of performance scalability BI


59/77



As can be seen in the image above, the only reason that it could not adopt thisavant-garde technology could be the costs, as it presents many advantages and

very few or no inconvenience.

Demo: Demo the speed of queries

ObjectiveTo demo the speed queries

System Data

System: Principal:User ID: Key of access:Parameterizations of the system:

1. To demo on the BI Accelerator is not yet available.

IF you wanted to have fun with the student' you could make a big deal onhow fast the reports can be with Accelerators , then just open a workbook (that you saved with data in it) tell them the cube had 50 million records,yet see how fast the work book opened. Then you can tell the truth, that itwas a Completed Workbook. Tell them that although TREX is fast,nothing is faster than a precalculated web page or workbook accomplishedthrough the reporting agent, and the fact of the matter is that for 90% of your users this is the way to go!


60/77



Discussion with moderator

Questions for discussion

Use the following questions to the course participants take part in the discussion.You can also use your own questions.


61/77




You should now be able to:• Define accelerators BI• Explain the use of accelerators BI and its high-level architecture• Explain the advantages of accelerators BI compared with other

tools of performance improvement BI

More information

• The course SAP BW360 contains detailed information on the preparationand installation for the BI Accelerator.


62/77



Lesson:

538

Summary statisticsDuration of the lesson: 15 Minutes

Summary of the lessonIn this lesson you will learn about the statistics of BI. This powerful combinationof objects of Business Content provides a framework to monitor its BI system andresolve issues related to the performance.


• Identify the Business Content of statistics of BI• Raise the use of BI Administration Cockpit

This unit describes the technical structure and motivation of BI Statistics, the onlyInfoArea as a part of InfoAreal Business Information Warehouse (0BW) . It usesseveral examples to illustrate the ways in which it can be used.

Business CaseThe performance is a metric that you will use to measure the success of your project BI. You want to investigate different tools to help you monitor the performance of the load and a query and perform proactive improvements in theData Warehouse.

BI statistics: Motivation and useThe statistics of BI are a tool for the analysis and optimization of a BI system.The BI system is constantly growing in data and number of structures (cubes,DataStore and InfoObjetos objects, for example). The steady increase of objectsand data volume comes not only of the work of the Administrators BI and thoseresponsible for the data modeling, but also the users experts and the finalconsumers of the information. Those users who constantly run and create new

queries or modify existing ones.The adjustment of queries is a constant challenge, as is the need to monitor theload times and the use of the disk. The objective of the statistics of BI is offer the administrator BI tools to analyze and optimize BI.

In this class you provided a cost center with a InfoCubo to enable them to analyzewhere the money is spent in the company and who spends it. Arrive to createqueries and relevant characteristics of court and rotation to contribute to analyzethe data and to improve the business process. In a perfect analogy, we provide theadministrator BI a set of InfoCubos, queries and Web pages


63/77


TBW10 Lección: Resumen de estadísticas

For the performance load of BI. Administrators no longer need to use tablescryptic to reconstruct the causes of performance problems. In many cases, a good

administrator of BI should know the weaknesses in performance before the user realizes that exist. We provide the tools to be proactive not reactive.

BI statistics: Technical DesignThe statistics of BI allow you to get a summary of the processes of loading andanalysis BI (queries, etc.). It does so through objects and tools BI standard. Itincludes a complex network of Business Content.

The following objects are provided as part of the set of tools of the statistics of BÌ :

• The role of SAP NetWeaver BI Administrator (SAP_BWC_BI_ADMIN- ISTRATOR)

• And VirtualProviders InfoCubos• Multisite• Process chains• ETL (processes for transferring data and transforms)• Sources• InfoObjetos• Web pages• Portal package (BI Administration Cockpit)

The first seven objects are required to withstand the BI Administration Cockpit based on portals.


64/77



Chart 221: BI Administration Cockpit: Summary

The purpose of the lesson is to have the participants to look briefly at the cockpit.Details are provided in BW360.

Note: The BI Administration Cockpit can be configured to obtaininformation of Computing Center Management System (CCMS) of SAP,But its primary function is to organize and display statistical data BI.

The cockpit provides all the information needed to monitor the BI system. Youcan monitor the performance of load and the performance of a query from aWeb-based GUI easy of use and configurable that integrates in a SAP EnterprisePortal.

Although the end result is this simple cockpit, objects and functions required inthe fund are much more complex.


65/77



→

Chart 222: Statistics of BI and its flow in the BI Administration Cockpit

As shown in the image above, many InfoCubos, VirtualProviders, multisite andare used to determine the data that support the BI Administration Cockpit.

Several statistics providers BI and their uses

The BI Administration Cockpit is based on new InfoSitios that are delivered withBusiness Content of SAP NetWeaver 7.0 on the InfoÁrea Business InformationWarehouse (0BW) BI Statistics (0BWTCT_STA). Essentially, theyRepresent an expansion of the existing technical content, with one exception:statistics of time of execution of a query are updated in other detailed tables, withwhat they offer a more accurate assessment. As a result, the InfoCubos0BWTC_C02 and 0BWTC_C03 for statistics are obsolete from SAP NetWeaver 7.0.

Note: The statistics created before the upgrade can still be assessed withthese InfoCubos, while the InfoSitios are only available for statistics of

time of execution of queries generated after Go to SAP NetWeaver 7.0. It is not possible to migrate old InfoCubosstatistics in new.


66/77



The new InfoSitios are:

• For statistics of time of execution of queries very added: 0TCT_C01,0TCT_VC01 and 0TCT_MC01. They substitute the InfoCubo0BWTC_C02.

• For run-time statistics of more detailed queries: 0TCT_C02,0TCT_VC02 and 0TCT_MC02. They substitute the InfoCubo0BWTC_C02.

• For statistics data manager: 0TCT_C03, 0TCT_VC03 and0TCT_MC03. They substitute the InfoCubo 0BWTC_C03.

• For statistics data load chains of processes and processes: 0TCT_C21,0TCT_VC21 and 0TCT_MC21.

• For statistics data load processes for transferring data: 0TCT_C22,

0TCT_VC22 and 0TCT_MC22.• For statistics data load InfoPaquetes: 0TCT_C23, 0TCT_VC23 and

0TCT_MC23. They delivered essentially the same information that theInfoCubo 0BWTC_C05, but use the new InfoObjetos.

• For the status of current data load chains of processes and processes:0TCT_VC11 and 0TCT_MC11.

Use of BI Administration CockpitAlthough you might design queries, Web models and views of the portal user specific to monitor the performance, you can instead use the portal and the

Business Content delivered to:• Get a summary of the use of objects of analysis• Display the system performance and improve it using queries

delivered as "long-term trends in times of execution" or "deviations inexecution times of InfoSitios"

• Improve the selection and use of aggregates and, at the same time, reducethe effort that involves its update.

Demo: Show the Business Content for InfoArea: Business Information Warehouse (0BW) >>>BI Statistics (0BWTCT_STA)

Objective

Show BI Statistics delivered content cubes and if you want to show the admincockpit on the portal


67/77



System Data

System: Same as ClassPrincipal: Same as ClassUser ID: Tdcadmin (!!! Required for logon to the Portal !!!)Key of access: NimdaParameterizations of the system:

1. Open the Meta Data Repository via transaction RSA1, navigate to BusinessContent objects, then select object the Info Area icon and navigate to BIStatistics under Business Information Warehouse. Show some of the objectslisted above.

2. Access the Admin Workbench via RSA1 >>> Administration Tab >>> BIAdministration Cockpit. (check it to see if there is good information beforeyou demo it)

3. You need a specific user for logon at the portal. You could use user:tdcadmin and password: nimda.


68/77



Discussion with moderator

Questions for discussion

Use the following questions to the course participants take part in the discussion.You can also use your own questions.


69/77




You should now be able to:• Identify the Business Content of statistics of BI• Raise the use of BI Administration Cockpit

More information

You can find additional information in the SAP HelpPortal: Http://help.sap.cOm/saphelp_NW2004s/help-data/IN/43/15C54048035To39E10000000To422035/content.htm.

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/15c54048035a39e10000000a422035/content.htmhttp://help.sap.com/saphelp_nw2004s/helpdata/en/43/15c54048035a39e10000000a422035/content.htm


70/77

Resumen del capítulo TBW10


Chapter SummaryYou should now be able to:• List some factors that affect the performance of a query• Explain why the performance tuning BI is not considered to be primarily a

function of basic equipment• Identify techniques and basic tools for optimizing a query• Define aggregates and enumerate some of the benefits of its use• Use update functions of aggregates• Explain the rollup of aggregates and the location of the read pointer • Explain why the modification executions of aggregates are

important

• Creating and completing an aggregate for a InfoCubo• Define accelerators BI• Explain the use of accelerators BI and its high-level architecture•

sap tbw10 6 converted

Documents