Answer Posted / krishna

Consolidations :
Consolidations are used to Specify the data you want to view in your report,and it allows you to group attribute elements in New ways without changing the metadata and warehouse definitions.

Use:
When the client want to view profit values as per season wise for a particular region, in this situation season attribute not available in data so we can create the season consolidation as SEASON = {(SUMMER = FEB+MAR+APR+MAY)+ (SPRINT = JUNE+JULY+AUGUST+SEPTEMBER) + (WINTER = OCTOBER+NOVEMBER+DECEMBER+JAN) };

The above consolidation we can insert into report then it will displays the season wise profit values.....

Explain scan md?

770

---

Explain fact constellation schema?

765

---

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

740

---

What is the conflict resolution window?

781

---

What is metadata in microstrategy?

789

---

What are pass-through functions and why they are so called? Give some examples.

748

---

How would you increase the logical size of a table in microstrategy?

719

---

Explain oject manager?

737

---

Is olap services sold as a separate product?

678

---

what are passthrough functions?

689

---

What do you mean by consolidations?

736

---

How does microstrategy object manager determine if two objects in different projects are the same?

763

---

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

704

---

What is microstrategy intelligence server?

745

---

Explain microstrategy logical primary keys?

727

---