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
- 24089 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
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What sort of existing documents should business analysts refer to when starting on a new project?
what is the difference b/w the refresh and buffered data?
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
can anybody tell me about complicated object you have created
How we drill up week to month?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
When to use local filter and when to use global filter?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
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 are the steps to be taken to schedule the report?
How would you format some text using css to be verdana and bold?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain what is the difference between slice and dice and cross tab report?
