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 we can resolve the loops by using the Aggrigate Awareness?
Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
can i link two Universes having with different connection
Explain what are the steps to be taken to schedule the report?
why less number of records in loop? why more number of records in traps?
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?
. User wants to modify a report and wants to add additional data. How will you approach.
1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
how can i add two different reports in the same document?
Difference between Object varification and validation