Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of @aggregate aware function?please
draw, how you use the @aggregate aware function
- 6 Answers
- 23673 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
What is the difference in creating filters in designer and business objects?
What are the data types present in bo? What happens if we implement view in the designer and report?
How can you first report in Business Objects by using broadcast agent?
How to execute the plsql procedure from the report by clicking with mouse?
Explain what is the difference between business requirement document and use case document.
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What are the join problems comes appart from loop,chasm & fan Traps
how get the grand total in master-detail report?
What is the difference between condition & filter?
Explain what is the difference between slice and dice and cross tab report?
What sort of existing documents should business analysts refer to when starting on a new project?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is package in BO
