Answer Posted / praveen

Data which is not there in datawarehouse and such data to be shown on the report as per the requirement.
for ex: Month attribute has jan,feb,mar......Dec.

But you want a consolidated elements we need to create an attribute in such a way without changing the metadata and warehouse defination.
This we achieve with consolidation.

so we group the attribute elements called derived elements.

summer=mar+apr+may

The consolidated attribute to be created to display values in a report.
Here in such case we use consolidation.

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

1109

---

you are required to disable webusers to use only one i-server. How would you do that?

953

---

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

1037

---

Can the administrator easily maintain and manage microstrategy intelligence server?

1070

---

Explain fact constellation schema?

1085

---

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?

1078

---

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

1019

---

What is embedded metric?

1050

---

what do you mean by security filter?

1061

---

How do users receive only information that they want?

1021

---

Difference between project merge and object manager?

1068

---

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

1021

---

differentiate between two-tier, three-tier and four-tier connections.

1042

---

What do you mean by derived metrics?

1027

---

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

988

---