Micro Strategy Question:

Download Job Interview Questions and Answers PDF

How to use consolidations in microstrategy report?

Micro Strategy Interview Question
Micro Strategy Interview Question

Answer:

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.....

Download Micro Strategy Interview Questions And Answers PDF

Previous QuestionNext Question
How we can create the Intelligent cubes in Microstrategy?In document how to create metrics?