Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / learner
Aggregate awreness is the function in BO, which helps in
improving the performance of reporting. For ex. if we have
data at different levels of aggregation in different tables
of a single universe, then this function helps the bo to
select the table(detail table or light aggregated table or
highly aggregated table)(ex year, month,daily revenues in 3
tables) for running the query while creating the report
based on the grain level of reporting requirement.(for
example if we ask year wise revenue then it will directly
go to that year table instead of calculating it from the
daily table).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is surrogate key? Explain with examples.
What are Aggregate tables?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is meant by metadata in context of a data warehouse and how it is important?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are aggregate transformation?
What is the difference between ods and oltp?
What is the difference between olap and oltp?
What is normalization, first normal form, second normal form, third normal form?
Explain what are the possible data marts in retail sales?
How do you create surrogate key using ab initio?
What are the different problems that ?Data mining? can solve?
Explain how to generate iqd file from framework manager?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain why should you put your data warehouse on a different system than your oltp system?
