How can we use consolidations in microstrategy report
Answer Posted / praveen kumar sivvam
Consolidations are used to grouping of attribute
elements.Performence wise these are very useful.
EX: I have month attribute in my project but customer need
season wise report for this i will create consolidation by
combing some of months as a one element.
Summer(feb+march+april+may)
Winter(Oct+Nov+Dec+jan)
Rainy(june+july+Aug+sep).
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is an object prompt?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
How can the user determine the object id of an object?
Write different kinds of objects in microstrategy?
What are consolidations?
What is a conditional attribute in microstrategy?
How we can decided drilling options for an attribute?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
Name the types of transformation?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
what do you mean by kimball?
Explain the Roles in mstr?
What is embedded metric?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
What are report filters and view filters?