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 transformation metric in microstrategy?

1020

---

Explain attribute role?

1099

---

What is fact degradation?

982

---

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

938

---

Explain heterogeneous mapping?

995

---

What are vldb properties in microstrategy?

1055

---

What is an object prompt?

1036

---

Can you explain surrogate key?

1058

---

How can users design dashboards quickly and without programming experience or training?

968

---

Explain oject manager?

1015

---

What is purpose of having conditionality in metrics in microstrategy?

988

---

Can you create an event based schedule in microstrategy? How?

1047

---

Explain four-tier connection?

944

---

Can I deploy a single bi application in multiple languages?

986

---

Explain object variable error?

1009

---