Answer Posted / sunil

Well both answers are right( from tiru and nadia) same thing just differ in approach.

EX: if there is any table with such feilds

say
day_id, Qtr_id, Qtr_desc, Month_id, Month_desc.

2nd table sales
001 ...090 has same sales ..say 100

now if you are calculating sales over day
it will return you wrong data, by doing 90 days *100 sales values (this is termed as multiple counting problem)

so here we developer are facilitate by this logical table object. we create a new table with proper qtr_id and qtr_desc with sales to get the accurate data every time.
Which will thus be called as aggregated sales data.

This is not recommended until and unless you dont find any other way since performance is your high priority.

What is a joint child?

989

---

If your client wanted to customize the null value, how would you do that?

1069

---

According to you, what are the most important tables in a dw? Why?

1030

---

What do you mean by trimming sql in microstrategy?

1101

---

What is the difference between microstrategy and cognos reporting tool?

1047

---

What are configuration objects?

1102

---

What is the effect of dls on microstrategy?

1057

---

What are logical views used for in microstrategy?

1015

---

What is a dw? Why do we need it?

1026

---

Explain the Roles in mstr?

1027

---

Define different types of attributes in microstrategy desktop?

1285

---

How are microstrategy reports performance tuned?

1033

---

What are prompted filters?

990

---

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

1019

---

what do you mean by kimball?

1043

---