What is the purpose of @aggregate aware function?please
draw, how you use the @aggregate aware function
- 6 Answers
- 21829 Views
- Cap Gemini, Deloitte, I also Faced
- E-Mail Answers
Answer Posted / prasanna
An aggregate table is summary table that dba build to execute
querys faster.@aggregate _aware is an function in bo which
takes advantage of aggregate table when ever possible else
it redirects to original fact table.
syntax:
@aggregate_aware(sum(smallest_table),sum(medium
table),sum(biggest_table));
here smallest table is aggregate table because data is
aggregated by various dimensions.and big table is fact table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Post New Answer View All Answers
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?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What would you consider as your biggest achievement and why?
What is the dense rank?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what three things do you consider to be the most important factors for a manager?
how to prepare the documentation in business objects and where to get the requirement?
What is report template in b.o?
Explain the difference between union and group?
in sap bi we have wad, then why we go for sap bo
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What Is Snow Flake Schema?
U r project in which stage in implementation?
What is object stores?
How were the reports scheduled and how to resolve unexecuted documents?
