How can we use consolidations in microstrategy report
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can microstrategy desktop access operational data systems?
What are vldb properties?
Explain the various types of filters available.
What is a compound attribute in microstrategy?
Explain transformations?
What is heterogeneous mapping?
Why does microstrategy object manager search for object dependencies?
What do you mean by mstr?
What is the difference in the way microstrategy handles custom group and consolidations?
Explain fact relation?
Explain the Roles in mstr?
What do you mean by mstr? What are the different types of mstr objects?
What are logical views used for in microstrategy?
what specific features and functionality do you get with olap services?
What are objects?