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
hi,can you please share with me about,what is reportlimit,report order and how can create and use
Explain fact relation?
Explain fact?
Explain about compound key?
you are required to disable webusers to use only one i-server. How would you do that?
Explain object variable error?
What information is shared by the application across microstrategy web nodes?
how can we direct the sql generated to use a specifc table?
What are attribute roles?
Explain oject manager?
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?
Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?
Explain access control?
Explain absolute filter?
Explain microstrategy logical primary keys?