4.what is aggregate awareness ? how do we use ? where do we
use ?
Answers were Sorted based on User's Feedback
Answer / mrs.narmatha
Aggregate awareness: is the ability of a universe to make
use of aggregate the tables in a database. These tables
have precalculated data
USE:
you can use a function @aggregate_Aware in the select
statement for an object that directs a query to be run
against aggegate tables
This function can be used to speedup the exceution of the
query and to improve the performace of sql transaction
| Is This Answer Correct ? | 33 Yes | 3 No |
Answer / nmr
redirect the query to desired table,
or
improve the performance,
while useing summeriaed table
retrive results with very fast compare then the demension
table
| Is This Answer Correct ? | 0 Yes | 2 No |
How to import BIAR file in bo?
disadvantages of boxi
What is the difference b/w the simple Universe and Complex Universe?
which is the best way to resolve loop context r alias why?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
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!!!
how to create reports on screech?
what are the debuggings in the business objects?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
What is domain? How many are there in a basic setup? What are they?
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
What services the broadcast agent offers on the server side?