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 |
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
What is aggregate table and aggregate fact table ... Any examples of both?
What is meant by ZABO and FC(full-client)?
Can i use personal database connection to the Webintellegence reports?
Explain is there any other repository domains rather than universe, security, document?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
what is difference between Rich client web intelligence and Boxir2 web intelligence
please anyone explain me the derived table with the problem tables.
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.