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


Please Help Members By Posting Answers For Below Questions

How would you configure wh authentication? Explain.

599


Explain fact constellation schema?

649


Write different kinds of objects in microstrategy?

666


Explain adhoc reports?

609


Explain confirmed dimensions. When are they used?

630






1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2239


What do you mean by bulk export report?

628


What do you mean by derived metrics?

670


Explain the difference between holap and molap?

620


What is level prompt?

619


What are the supported languages for microstrategy intelligence server?

686


What is rank metrics in microstrategy?

662


Can you create an event based schedule in microstrategy? How?

694


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

651


What is an object prompt?

678