Q.What is an aggregate?
Ans.aggregates are mini cubes; they are used to improve the performance when doinf query; similar to indexes on a table; it is transport to the user
Q.How do you create/maintain aggregates?
Ans. AWB→ right click on infocube→ select maintain aggregate
Q.Can you create aggregate on ODS or multi provider?
Ans.No
Q.What are the options when defining aggregates?
Ans. a. * - groups according to characteristics values
b.H - hierarchy
c.F - fixed value; for example if you have a 0COUNTRY characteristics, if only country US is reported often, then you can create aggregate only for US
d. Blank= none
Q.What is “filling” of aggregate?
Ans. The data from infocube is summarized in to the aggregates
Q.Which table has the aggregate status and data?
Ans. RSDDAGGDIR
Q.What is change run?
Ans.Using a process chain or AWB→Tools → Apply Hierarchy attribute change
Q.which report can you use to monitor change run?
Ans. RSDDS_CHANGERUN_MONITOR
Q.What is the programme to maintain?
Ans.RSDDS_AGGREGATES_MAINTAIN
Q.What is “roll Up”?
Ans.Roll up is the process by which requests loaded in to the info cube are “rolled to “ the aggregates; till roll up is done you can not do a report on the request
Q. What is the optimal size of the aggregates?
Ans.
It should have around 10-20% of the size of the fact table; for example if your fact table contains 1 million rows, the aggregate should have less than 200,000 rows.
Q.what is propose from statistics for aggregates?
Ans.You can ask the system to get the optimal characteristics for aggregation by using the BW statistics data(like query run time etc)
Q.can you define aggregates on time dependent navigational attributes?
Ans.NO
Q.what are the naming conventions for aggregates created from statistics?
Ans.STAT 1 through STAT n
Q.what are naming conventions used for aggregates created from query?
Ans. MIN 1 through MIN n and MAX1 through MAX n.
Q.what are important aggregation usage indicators?
Ans.
a. Number of records
b.summarization ration(compression)
c.Last used date – remember if you don’r see any recent activity then this aggregates is not used
Q.Ho w does change run affect aggregate?
Ans.Newly loaded master data is not active until the change run has beeen applied to hierarchy
Ans.aggregates are mini cubes; they are used to improve the performance when doinf query; similar to indexes on a table; it is transport to the user
Q.How do you create/maintain aggregates?
Ans. AWB→ right click on infocube→ select maintain aggregate
Q.Can you create aggregate on ODS or multi provider?
Ans.No
Q.What are the options when defining aggregates?
Ans. a. * - groups according to characteristics values
b.H - hierarchy
c.F - fixed value; for example if you have a 0COUNTRY characteristics, if only country US is reported often, then you can create aggregate only for US
d. Blank= none
Q.What is “filling” of aggregate?
Ans. The data from infocube is summarized in to the aggregates
Q.Which table has the aggregate status and data?
Ans. RSDDAGGDIR
Q.What is change run?
Ans.Using a process chain or AWB→Tools → Apply Hierarchy attribute change
Q.which report can you use to monitor change run?
Ans. RSDDS_CHANGERUN_MONITOR
Q.What is the programme to maintain?
Ans.RSDDS_AGGREGATES_MAINTAIN
Q.What is “roll Up”?
Ans.Roll up is the process by which requests loaded in to the info cube are “rolled to “ the aggregates; till roll up is done you can not do a report on the request
Q. What is the optimal size of the aggregates?
Ans.
It should have around 10-20% of the size of the fact table; for example if your fact table contains 1 million rows, the aggregate should have less than 200,000 rows.
Q.what is propose from statistics for aggregates?
Ans.You can ask the system to get the optimal characteristics for aggregation by using the BW statistics data(like query run time etc)
Q.can you define aggregates on time dependent navigational attributes?
Ans.NO
Q.what are the naming conventions for aggregates created from statistics?
Ans.STAT 1 through STAT n
Q.what are naming conventions used for aggregates created from query?
Ans. MIN 1 through MIN n and MAX1 through MAX n.
Q.what are important aggregation usage indicators?
Ans.
a. Number of records
b.summarization ration(compression)
c.Last used date – remember if you don’r see any recent activity then this aggregates is not used
Q.Ho w does change run affect aggregate?
Ans.Newly loaded master data is not active until the change run has beeen applied to hierarchy
No comments:
Post a Comment