How can we use consolidations in microstrategy report
Answer Posted / krishna
Consolidations :
Consolidations are used to Specify the data you want to view in your report,and it allows you to group attribute elements in New ways without changing the metadata and warehouse definitions.
Use:
When the client want to view profit values as per season wise for a particular region, in this situation season attribute not available in data so we can create the season consolidation as SEASON = {(SUMMER = FEB+MAR+APR+MAY)+ (SPRINT = JUNE+JULY+AUGUST+SEPTEMBER) + (WINTER = OCTOBER+NOVEMBER+DECEMBER+JAN) };
The above consolidation we can insert into report then it will displays the season wise profit values.....
| Is This Answer Correct ? | 26 Yes | 1 No |
Post New Answer View All Answers
Explain access control?
What does microstrategy intelligence server allow users to do?
How is security handled?
How can the user determine the object id of an object?
Difference between project merge and object manager?
How do you ensure simultaneous releases across multiple operating systems?
hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com
How conflicts occur and what are the ways to resolve them?
What are logical views used for in microstrategy?
What is report as filter in microstrategy?
What are the different types of metrics available in microstrategy?
Name the various types of filters?
Write the different types of matrices in microstrategy?
what do you mean by custom groups?
Explain snowflake schema?