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.

Explain rw document?

1022

---

Explain snowflake schema?

966

---

What are the various ways of incorporating security in microstrategy?

906

---

What are configuration objects?

991

---

what do you mean by security filter?

902

---

Explain fact relation?

925

---

Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

961

---

Explain attribute?

871

---

how can we direct the sql generated to use a specifc table?

860

---

Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.

957

---

What is heterogeneous mapping?

962

---

What subtotaling features does microstrategy desktop contain?

924

---

what are passthrough functions?

886

---

Imagine this, you are required to reset the password for all users at a time. How would you do that?

901

---

Explain transformations?

948

---