The best design for a hierarchy is to organize or group attributes into logical business areas. For example, you can place related attributes into hierarchies by their level.
The example below demonstrates the Location and Customer hierarchies. Within the Location hierarchy, State, City, andStore are organized according to their relationships. The Customer hierarchy also groups together the attributes Company, Contact, and Customer.
Before MicroStrategy 7.0, hierarchies had to be separate and distinct from one another, follow the dimensional structure in the logical data modeling, and include at least one attribute. Beginning with MicroStrategy 7.0, however, they do not follow these rules. Hierarchies provide convenient navigation paths through the data.
The system hierarchy is a structure based on relationships you define between attributes. A user hierarchy allows you to logically define and order groups of attributes. Both the system and user hierarchies allow you to navigate and organize attributes in your project.
When you group attributes together into hierarchies, you are developing a working design of the display and browse functions of the attributes. In the example below, there aretwo instances of the Region hierarchy. One hierarchy demonstrates Region having multiple States and the States having multiple Stores.
This hierarchy allows you to create drilling and browsing options to the lower levels to view Region, State, and Store on a report. But if you only include Store in the Regionhierarchy, as in the second example, then the only options for drilling or browsing are the Region and Store levels.
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.