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 about compound key?

1146

---

To save time, can many reports be run at the same time?

1088

---

What are the different formatting types?

1104

---

Explain adhoc reports?

977

---

Write the different types of matrices in microstrategy?

1093

---

what is microstrategy narrowcast server?

1170

---

What are the vldb properties? Which level of vldb configurations have the highest precedence?

989

---

Explain four-tier connection?

980

---

What do you mean by static prompt report?

1033

---

What is the difference between absolute filtering and standard filtering in microstrategy?

1035

---

What is a logical size of a table and what does it depend on?

1013

---

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.

1077

---

Explain standard filters?

1050

---

If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

1124

---

Is microstrategy desktop available in other languages?

1052

---