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.....

What specific features and functionality do I get with olap services?

885

---

At which levels you can set the vldb properties? Which level has the highest pecedence?

896

---

Difference between project merge and object manager in microstrategy?

940

---

What do you mean by static prompt report?

933

---

Explain rw document?

1023

---

Explain object variable error?

922

---

How does microstrategy object manager determine if two projects are related?

987

---

What leads to a cross-join or how does a cross-join occur?

894

---

Describe implicit attribute?

933

---

What are prompted filters? Have you ever used them? Where?

927

---

What do you mean by staging area?

892

---

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

879

---

What are the different modes to run i-server?

975

---

Explain heterogeneous mapping?

900

---

What are the different types of metrics available in microstrategy?

906

---