Interested to Buy Any Domain ? << Click Here >> for more details...
How can we use consolidations in microstrategy report
- 4 Answers
- 18271 Views
- IBM, Wells Fargo, I also Faced
- E-Mail Answers
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 are the different authentication modes available in microstrategy?
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?
What is a conditional attribute in microstrategy?
Explain star schema?
What are objects?
What is a security filter in microstrategy?
How does microstrategy object manager integrate with the microstrategy product suite security model?
How do we resolve attribute roles in microstrategy?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
Can a record be inserted and updated in database using microstartegy?
What is adaptive metric?
Explain access control?
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 do you optimize reports in microstartegy?
What olap capabilities do I have within a microstrategy report services document?
