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 ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

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

1 Answers  

---

what is the diff between etl tool and olap tool

2 Answers  

---

what is diff between Decode and case ? Give some Example?

2 Answers  

---

IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?

4 Answers   TCS,

---

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

---

How can we use multiple data providers in a single report in business objects?

2 Answers  

---

what is a Micro cube?

5 Answers   TCS,

---

Hi any done business objects certification.i am expecting some help from them.

6 Answers  

---

when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers   BMC, TCS,

---

WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?

2 Answers  

---

How to execute the MACRO through Infoview?

1 Answers  

---