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
What are the different types of metrics available in microstrategy?
Explain star schema?
Write the components microstrategy metadata?
What is level prompt?
What olap capabilities do I have within a microstrategy report services document?
Explain attribute?
What according to you are the roles and responsibilities of a microstrategy developer?.
explain html document?
What are the different formatting types?
Explain security role?
What is the order of precedence of vldb properties?
What are configuration objects?
What specific features and functionality do I get with olap services?
what is smart metrics in microstrategy?
Explain scan md?