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 pragma?

2 Answers  

---

How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

1 Answers   IBM,

---

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

2 Answers   TCS,

---

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  

---

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

---

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,

---

Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 Answers  

---

Explain the difference between compatible and incompatible objects?

0 Answers  

---

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

---

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

---

What are @FUNCTION?

4 Answers  

---

Why do we need metrics and sets?

1 Answers  

---