Interested to Buy Any Domain ? << Click Here >> for more details...
main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
- 2 Answers
- 8395 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sai
Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Explain in detail about type 1?
How would you format some text using css to be verdana and bold?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
what is universe null
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Did you face any problems while creating reports? Name? Solutions?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
how many reports have u created ? explain a few.
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What we need to discuss with designer before starting the universe designing.
Which versions are used in the bo dashboard work?
how get the grand total in master-detail report?
Explain when to use local filter and when to use global filter?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
In banking domain how many Fact tables,Dimension table are present?
