Answer Posted / sai

Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html

Can Bo generates the Report from the cubical data Explain?

2038

---

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1530

---

What is the profile and package?

2299

---

Explain what three things do you consider to be the most important factors for a manager?

1011

---

Explain about a tricky situation for which you found a very simple solution?

1007

---

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1047

---

What is the difference between absolute and relative div positioning?

1050

---

What task is 98% of the required work of a business analyst?

1052

---

is it possible to export the webi reports to crystal reports?with out using businessview?

2290

---

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2099

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10401

---

What is the difference between datawarehousing and businessintelligence?

1101

---

What is the difference in creating filters in designer and business objects?

1026

---

How to schedule the report in b.o?

1038

---

What three things do you consider to be the most important factors for a manager?

1090

---