Answer / sachin jain

Can follow two approaches.

1. Aggregate tables are built in the database, which contains the dimension fields(not foreign keys) along with the aggregated measures. In the universe they are present as standalone tables.Aggregate aware function is used to define both the dimensions and measures of such tables

2. No aggregate tables are built in the database level. They contain the normal fact table at different granularities. In the universe, aggregate aware is used only to define the measures and aggregate incompatibility is set accordingly

The first approach is better in terms of performance, since for the higher levels of aggregation, all the information is obtained for a single table. However, a large scale implementation of this approach in a dimensional schema is difficult. In most BI projects, the second approach is preferred

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

0 Answers  

---

Explain about Short cut join?

2 Answers   Wipro,

---

How do u get requirement from the client? in what format?

1 Answers   TCS, Wipro,

---

if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 Answers  

---

What is metrics?

2 Answers  

---

What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers   Wipro,

---

Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier

2 Answers  

---

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers   TCS,

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers  

---

How can we improve performance?

2 Answers  

---

where are objects are stored ?

6 Answers   Tech Mahindra,

---

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,

---