How to use consolidations in microstrategy report?
Submitted by: AdministratorConsolidations :
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.....
Submitted by: Administrator
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.....
Submitted by: Administrator
Read Online Micro Strategy Job Interview Questions And Answers
Top Micro Strategy Questions
☺ | what is the difference between documents and dashboards in mstr? |
☺ | How to use consolidations in microstrategy report? |
☺ | What are the roles & responsibilities of microstrategy developer? |
☺ | Is it possible to see the data in dataset? |
☺ | Difference between standard, absolute and ignore condition in metrics? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |