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

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

What is the Difference b/w Server based Ranking and normal Ranking?

1 Answers  

---

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Answers  

---

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers  

---

What is casual dimension?

4 Answers  

---

Can we link the oracle and excel universess?

1 Answers  

---

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

---

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

---

what is crosstab reporting,slice and dise and drill mode??

3 Answers  

---

What is the pragma?

2 Answers  

---

how to connect the hyperlink in webi reports?

7 Answers   TCS,

---

What is the use of linling the universes?Thanks in advance

2 Answers  

---

What are the Users and User groups?

2 Answers   Wipro,

---