What is the purpose of @aggregate aware function?please
draw, how you use the @aggregate aware function
- 6 Answers
- 21861 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
Explain which versions are used in the bo dashboard work?
What three things do you consider to be the most important factors for a manager?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
how to prepare the documentation in business objects and where to get the requirement?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the difference between condition & filter?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how to create reports on screech?
Explain how we drill up week to month?
is it possible to export the webi reports to crystal reports?with out using businessview?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain the difference between detect alias and detect context?
