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
What is a conditional attribute in microstrategy?
What is adaptive metric?
What is report as filter in microstrategy?
How do users receive only information that they want?
how can you direct the sql generated to use a specifc table?
Difference between project merge and object manager?
What are vldb properties?
You have got the requirement from a client. Explain the technical approach you will take now.
What are the programs that we can do with the microstrategy architect?
What is a dw? Why do we need it?
Can reports be executed in off-peak periods?
Explain fact?
Explain 4gt switch. Does it have any drawback?
What is derived metric?
Explain transformations?