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 level prompt?
Imagine this, you are required to reset the password for all users at a time. How would you do that?
How is the number of passes in a sql query significant in performance evaluation?
what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?
Explain attribute?
What is a conditional attribute in microstrategy?
what do you mean by kimball?
What is dynamic aggregation in microstrategy?
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?
Explain access control?
Explain star schema?
What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
How to optimize a report in microstrategy environment?
What does microstrategy intelligence server allow users to do?
Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?