Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
59 Cards in this Set
- Front
- Back
9 Performance Tuning
|
9 Performance Tuning
|
|
9.1 Intro to QPO
|
9.1 Intro to QPO
|
|
what must be considered prior to installation of BI system?
|
1) resource sizing 2) performance goals
|
|
who is the frst contact for poor performance?
|
power user - query authors and functional representatives
|
|
what is Query monitor? How do you access it?
|
tool to determine root cause of performance problems 2) RSRT
|
|
9.2 BI Aggregates
|
9.2 BI Aggregates
|
|
what is an Aggregate?
|
summarized view of data in InfoCube
|
|
how is data stored in aggregate?
|
redundantly and persistently in its own Info cube like structure on database
|
|
what is the similarity and difference between Infocube aggregate and database index?
|
"a) similarity – both improve system performance b) difference– technically different"
|
|
how does users know aggregate is built?
|
queries will run faster
|
|
for what types of objects, can aggregates be created?
|
"a) Infocubes b) not virtualcubes; DSO"
|
|
How are aggregates formed on Infocubes?
|
"by selecting specific objects connected to Infocubes a) characteristics in dimension tables b) hierarchies associated with Info cubes c) Navigational attributes associated with Info cubes"
|
|
how does using aggregates reduce the volume of data accessed for each query?
|
"because data is stored in separate Infocube this contains limited set of chars from the connected Infocube"
|
|
what is the role of OLAP processor in navigation of query?
|
"a) OLAP processor picks the most efficient aggregate if the navigation of the query is supported by the aggregate b) user does not target the aggregate"
|
|
where are aggregates particularly useful?
|
"a) improves the speed of group of queries b) speed up execution and navigation of a highly used specific query c) improves run time of queries with navigational attributes d) to speed up reporting on characteristic hierarchies by aggregatingspecific hierarchy levels:"
|
|
where from in Infocube can attributes be built from?
|
"InfoCubes a) characteristics b) navigational attributes c) hierarchies"
|
|
what type of navigational attributes and hierarchies can be used in aggregates?
|
"a) time dependent b) time independent"
|
|
what type of objects complicates the ability to utilize the aggregate by query?
|
time dependent objects
|
|
how are aggregates defined?
|
"a) '*' inclusive b) ' ' exclusive c) 'F' inclusive with a fixed value d) 'H' hierarchy level;"
|
|
a) '*' inclusive;
|
the characteristic is used in the summarization
|
|
b) ' ' exclusive;
|
a characteristic is not used in the summarization
|
|
c) 'F' inclusive with a fixed value;
|
the characteristic is summarized with a specific fixed value
|
|
'H' hierarchy level;
|
the characteristic is summarized for a specific hierarchy level
|
|
how do you define the granularity of the data and what reporting requirementsthe aggregate will fulfill?
|
by adding characteristics, hierarchies, and navigational attributes to youraggregate,
|
|
what does exception aggregation mean?
|
Exception aggregation means that the key figure behaves differentlywhen analyzed against different characteristics.
|
|
1) what are the different types of properties that aggregates have?
|
a) technical b) status c) content |
|
2) where are they stored?
|
2) stored in table RSDDAGGRDIR
|
|
3) where are they displayed
|
3) displayed on GUI
|
|
what are the options when you are prevented from using an aggregate?
|
a) Switch off aggregate b) Deactivate the aggregate c) delete the aggregate"
|
|
what does each aggregate consist of?
|
"a) two fact tables E and F b) at least two dimension tables – package and customer defined c) unit dimension is not mandatory"
|
|
what are time dependent aggregates?
|
aggregates using time dependent master data
|
|
what is filling of aggregate?
|
initial loading of data into aggregate
|
|
what is a rollup?
|
loading of new data from Infocube into Infocube's aggregates
|
|
how does rollup take place?
|
a) when Infocube request is loaded into aggregates b) rollup consists of one or more requests c) request id controls the request d) request ID is stored in the package dimension of Infocube
|
|
how can you optimize aggregates?
|
a) system automatically proposed new aggregates b) by analyzing slow queries c) using BI statistics data of query run times
|
|
when do you need to change the structure of attributes?
|
when changes are made to attributes or hierarchies from characteristics used in aggregates
|
|
why do you need to be careful when creating navigation attribute?
|
a) costly to maintain b) change in attribute value causes adjustment or rebuilt of all aggregates
|
|
what does time needed for change run depends on?
|
"a) number of navigational attributes and hierarchies b) how frequently master data is changed for for each char infoobjects"
|
|
what versions of attributes and hierarchies are used during change run?
|
old versions of attributes and hieracrhies
|
|
what is the monitoring function used to check which objects are affected by change runs?
|
RSA1–>Administration–>Change run
|
|
when is a change run usually executed?
|
after master data is loaded via a process chain
|
|
what happens when aggregated are automatically compressed during rollup?
|
"a) requests written to E fact table of aggregate IC b) removes request Id – compression can be applied across all requests. c) data records with same char value are aggregated"
|
|
what are two main uses of process chains for aggregates?
|
"a) to execute attribute change run b) rollup c) not used to initial filling of attributes"
|
|
9.3 BI Accelerator
|
9.3 BI Accelerator
|
|
what is BIA
|
a “snap-in” hardware and software “appliance” that will solve many performance issues.
|
|
how does BIA proces the information in InfoCubes
|
indexes the info in InfoCubes to create compressed structure that can be loaded into memory as needed.
|
|
advantages of BIA
|
a) fast query response b) user satisfaction c) stable query response d) scalability e) reduced TCO f) low maintenance.
|
|
why is BIA highly reusable
|
very few can be used to accelerate many different queries.
|
|
reason for not adopting BIA?
|
cost.
|
|
what is the unique advantage of BIA?
|
provides highest reusability with fast performance
|
|
9.4 Statistics Overview
|
9.4 Statistics Overview
|
|
one metric you will use to measure the success of your BI project?
|
Performance
|
|
what is BI Statistics?
|
tool for analysis and optimization of BI system.
|
|
what does BI Statistics enable? How?
|
a) to get overview of BI Load and analysis processes-queries etc b) throught standard objects and tools
|
|
what does BI Admin cockpit do?
|
primary job is to organize and display BI statistics data b) can be configured to obtain data from SAP CCMS
|
|
what are used to source data in support of BI Admin cockpit?
|
Infocubes- Virtual providers-Multiproviders
|
|
how do you monitor performance?
|
a) by designing custom queries, web templates and portal views b) utilize delivered portal and BI content
|
|
what is BI statistics-BI content?
|
a) SAP NW BI Admin role b) IC c) VP d) MP e) Process chains f) ETL g) sources h) info objects i) web pages j) portal package
|
|
Why are change runs needed?
|
Change runs repair aggregates that are built on changing master data.
|