Answer Posted / prasanna

An aggregate table is summary table that dba build to execute
querys faster.@aggregate _aware is an function in bo which
takes advantage of aggregate table when ever possible else
it redirects to original fact table.

syntax:
@aggregate_aware(sum(smallest_table),sum(medium
table),sum(biggest_table));

here smallest table is aggregate table because data is
aggregated by various dimensions.and big table is fact table.

8. How much supervision have you typically received in your previous job?

2257

---

Can we create universe with no cache??

2515

---

Can anybody tell me what are the tuning problems?

2048

---

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3845

---

U r project in which stage in implementation?

2526

---

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1271

---

Which versions are used in the bo dashboard work?

1059

---

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

988

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2040

---

Explain the difference between union and group?

1111

---

Give some information on report bursting?

997

---

what is xcelsius architecture?

4597

---

can anybody tell me about complicated object you have created

3225

---

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1041

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2007

---