x, navigate to the Schema Objects > Hierarchies folder. Creating schema objects is the primary task in MicroStrategy Architect. Error(s) occurred while loading schema: 0This tutorial is the second part of the complete overview of the preparation of the MicroStrategy 9 environment, from setting up the Intelligence Server to go live on Web. User. x, navigate to the Schema Objects > Hierarchies folder. Schema objects. Error(s) occured while loading schema:1. In MicroStrategy Developer, from the Schema menu, select Update Schema. Logical tables are MicroStrategy objects that form the foundation of a schema. Specifies whether to extract hierarchies from Microstrategy. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. In Developer, Workstation or Web interfaces you can for example check what metrics are built on top of a fact (dependents) or what metrics has been used in report definition (components). MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. Hierarchy Reporting with Ragged Hierarchies; Filtering for a Level Metric;. 2. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . a lookup table. The object is named as "User Login" and is implemented as a prompt object. Hierarchy opens the Hierarchy Viewer that allows you to view hierarchies, both the user-defined hierarchies and the system hierarchy. The object is named as "User Login" and is implemented as a prompt object. User-defined hierarchies do not need to follow the logical data model and can be modified to include additional attributes or limit user access to them. 1, 9. Hierarchy Reporting with Ragged Hierarchies; Filtering for a Level Metric;. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. By learning about objects and different object types, you will develop a strong understanding of the MicroStrategy Schema and Public Objects. Click the icon and enter the new name. In MicroStrategy Developer, you create user hierarchies using the Hierarchy Editor or Architect. SUMMARY. Drilling using hierarchies. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. Schema objects: Schema objects directed to warehouse database structures and the essential aspects of business intelligence application such as facts, attributes, and hierarchies are stored in schema objects. 3584: System Hierarchy. Remove any table object with the type of +. In MicroStrategy Developer, log into the project source that contains your project and open the project. A database table used to uniquely identify attribute elements. The Hierarchy Viewer allows users to view both the user-defined hierarchies and the system hierarchy in MicroStrategy Developer 9. Update schema. • Teradata SQL queries development for MicroStrategy. 0. You can save user hierarchies in any folder. You can sort, filter, search by name and ID, and change security access for schema objects, including attributes, metrics, filters, prompts, hierarchies, and more. x-10. MicroStrategy project. The Grouping panel is displayed. Controlling access to data at the database (RDBMS) level. Click User Defined Hierarchy at the top of the Hierarchy Editor and choose the target hierarchy. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy (turning it into a traditional snowflake schema). For steps to access this dialog box, see Accessing the Architect options. Once the target hierarchy is opened, you can start editing it. MicroStrategy Schema Modeling With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize data and better reflect relationships. Transformation - Logical objects used to compare values at different times. the project schema refers to an internal map that MicroStrategy uses to keep track of attribute relationships, fact levels, table sizes, and so on within the project. It contains all objects related to an anlaytics solution: schema objects, reports, documents, cubes, etc. Add or remove hierarchies, then click OK to return to the Prompt Generation Wizard. In The Logical Data Model, you learned how to use hierarchies to group related attributes in practical. "System Prompt" is a system object that was introduced back in version 8. Published: May 16, 2017;. but the attribute relationship in the MicroStrategy schema is defined. Started with generating MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop. Schema Objects are like building block objects and are used. Managed objects are used to map data to attributes, metrics, hierarchies and other schema objects for Freeform SQL, Query Builder, and MDX cube reports. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. It includes things like attributes, facts, hierarchies, transformations, etc. This platform supports various types of scorecards, interactive dashboards, and automated reports. Create a filter on the attribute "Year. #Recursive hierarchies. 5. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. 4. The Security Role Editor opens. x-10. An object is a basic building block in MicroStrategy. 3. Launch Search editor and locate all table objects. 4. However, the levels within a dimension in an MDX cube source are mapped to hierarchies and attributes in MicroStrategy. Watch video to learn how MicroStrategy schema modeling works. Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies. The Modeling service is a microservice that enables MicroStrategy users to create and manage application and schema objects through Workstation. 0. Endpoints can be used to certify or de-certify a report or dossier, delete objects, and update object info for any object type. Error(s) occurred while loading Schema DSSSQLEngine: Schema loading error: Population Exceptions: The object shown in the following hierarchy no longer exists in schema: Relation-Table The object definition is incomplete or inconsistent. This is because they are only necessary with ragged/unbalanced hierarchies which are not supported as null attribute IDs are not. The business data your user community wants to report on is represented by schema objects in MicroStrategy. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. From the File menu, select New, and then Hierarchy. This is a filter which contains a prompt on an attribute element list. Then first click on the Schema object option. M icroStrategy is one of the leading software vendors in enterprise business intelligence (BI) today. 0. To change the order that the objects are displayed in the prompt, select a hierarchy and click the Up and Down arrows to move. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. Create Parent/Child relationships and set up dynamic attributes. User-defined hierarchies do not need to follow the logical data model and can be modified to include additional attributes or limit user access to them. The object is named as "User Login" and is implemented as a prompt object. Recommendation. ) that can be reused across projects, reports, dashboards, and applications. View Schema Information. Rather, the project schema refers to an. There are three types of objects: schema objects, application objects, and configuration objects. Schema objects : Schema. Ans: Microstrategy OLAP Services is an extension to Microstrategy Intelligence Server that allows Microstrategy Web and Desktop users to manipulate Intelligent Cubes™. Configuration objects : Used across all project. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. In every MicroStrategy project, there is a default system hierarchy that is built automatically based on the information we set into the Parent/Children tabs of. Hierarchies Logical objects that enable you to group attributes to reflect their related or provide convenient browsing both drilling paths in the MicroStrategy reporting environment. -Attribute:The object definition is incomplete or inconsistent. Therefore, unlike the Schema Objects, it is not necessary to perform an update schema after any Public. Error(s) occurred while loading schema: 9. Architect Interface in MicroStrategy Developer. The Hierarchy Viewer allows users to view both the user-defined hierarchies and the system hierarchy in MicroStrategy Developer 9. Updating your MicroStrategy project schema. reload(update_types=[SchemaUpdateType. It supports scorecards, interactive dashboards, ad hoc query, high formatted reports. So, if Universe is designed effectively with proper analysis/design, then we are done in. Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports. Hierarchies − They represent the relationship between various attribute values. RE: Recursive Hierarchy. 0. KB429013: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableObject is not found in D… Number of Views 1. Drilling is a function in MicroStrategy reports that allows. MicroStrategy Course Overview. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. For example, if you want to link the available attribute Phone Plan to Employee, drag Phone Plan. Open the Hierarchies folder, and then the Data Explorer folder. x, MICROSTRATEGY Desktop (Developer), Web, Administration, Intelligence server,. In the Folder List, navigate to and open the Schema Objects folder. To add additional attributes to the hierarchy, right-click within the Hierarchy View and select Add/Remove Attributes to Hierarchy. 3. NOTE: The 'Refresh' option assists in frequent updates to the interface for end user objects such as metrics, filters, prompts, etc. An object used to provide analysis of and insight into relevant data. While, Public objects are used to create other. in the schema: -Dimension/Hierarchy-Attribute:Object is no…Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. a relationship table. Scan MD. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. Physical tables in a data warehouse consist of columns, and logical tables in the MicroStrategy schema relate this column data to attributes and facts. This setting has four values:They can import the tables or define the query to pull the data into the schema, define the attributes and facts that will be the basis for other objects, and establish relationships and cardinality between attributes by creating hierarchies. Hierarchy Reporting with Ragged Hierarchies; Filtering for a Level Metric;. Create the relationships and hierarchies. The Modeling service is deployed. In MicroStrategy Developer, from the Schema menu, select Update Schema. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The Project Design Help is devoted to explaining schema objects. The objects you can create in MicroStrategy Developer fall into one of three groups: schema objects, application objects, and reports and documents. User-defined hierarchies do not need to follow the logical data model and can be modified to include additional attributes or limit user access to them. Therefore, it is necessary to set up schema objects before reports can be created. The user hierarchy is a hierarchy which you create specifically for your report designers. ACTION: This issue has been addressed in MicroStrategy 10. Created and maintained the schema objects ie the attributes, the facts, and the hierarchy as well as the metrics. These are the objects which are decided during the creation of a MicroStrategy project. Cards can be consumed in a web browser via the MicroStrategy HyperIntelligence Chrome extension and on iOS devices via the MicroStrategy. Data-Type. This hierarchy is specifically created for report designers. MicroStrategy recommends to have only one child at the lowest level. "System Prompt" is a system object that was introduced back in version 8. 3. In MicroStrategy Workstation, architects can create and edit attribute objects. Users can also filter and sort hierarchies. Open the Workstation window with the Navigation pane in smart mode. Objects in the schema automatically map. LU_. These schema objects are often created and managed by a MicroStrategy architect:The logical data model is composed of data abstraction objects (attributes, dimensions, etc. A solution is offered. The Modeling service is a microservice that enables MicroStrategy users to create and manage application and schema objects through Workstation. You can sort, filter, search by name and ID, and change security access for schema objects, including attributes, metrics, filters, prompts, hierarchies, and more. You need to use the system hierarchy, since this hierarchy build on true parent child relationship defined for the project. The Component Object hierarchy is used to track the relationship between an object and all of its direct child components. then the user must have the. #Ragged Hierarchies Microstrategy; #Ragged Hierarchy; #raggedmstr #raggedmicrostratgey;. Default is true. A system hierarchy is maintained by the relationships that exist among the project’s schema objects. Finally, you will learn about the administration, security, and monitoring of your BI solution. You can. Advanced Search. 83K KB12159: “[DFCSCHEMA] Population Exception: The object shown in the following hierarchy no longer exists in the schema: -R…These types of hierarchies include the system hierarchy and the user hierarchy. CONTENTS 1. Facts, attributes, and hierarchies are three essential pieces to any business intelligence application. Browse Library Advanced Search Sign. Schema objects include facts, hierarchies, and custom groups; project objects include reports, documents, and metrics; and configuration objects include project sources, database instances, and users. Create Relationships in System HierarchiesAn object is a basic building block in MicroStrategy. Select only Configuration Objects for documentation. Including hierarchies directly on MDX cube reports: Report designers can include MicroStrategy hierarchies directly on MDX cube reports. This platform supports various types of scorecards, interactive dashboards, and automated reports. . In every MicroStrategy project, there is a default system hierarchy that is built automatically based on the information we set into the Parent/Children tabs of. ) and public objects (metrics, filters, templates, reports, dashboards, etc. 4. Modify or Remove System Hierarchy Relationships Right-click a relationship. ) and public objects (metrics, filters, templates, reports, dashboards, etc. Edit an Existing User-Defined Hierarchy. Hierarchies; Comparing data across time – Transformations;. Application Objects : Which are built using schema objects. User-Defined Hierarchy. Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: Population Exception: The object shown in the following hierarchy no longer exists in schema: -RoleObject is not found in DFCSchema during DFC conversion. • MicroStrategy Mobile solutions. Any business intelligence application has three essential aspects: facts, attributes, and hierarchies; all these aspects are stored inside schema objects. Developer window menu options: Schema. The Document Properties dialog box opens. Finally, you will learn about the administration, security, and monitoring of your BI solution. NOTE: The 'Refresh' option assists in frequent updates to the interface for end user objects such as metrics, filters, prompts, etc. However, you cannot make any changes to the schema object. Traditionally, hierarchies within the MicroStrategy platform are modeled with fixed tables, categories and levels, which can often be limiting. To view and edit the parents and children of an attribute. Execute the following in MicroStrategy Tutorial: Create a user who's ACL is set to "View" for Tables folder under Schema Objects folder, and all privilege under Desktop Designer and Desktop Analyst. Ability to build and maintain MicroStrategy schema objects (attributes, facts, hierarchies, tables, views, etc. Select only Configuration Objects for documentation. Definition. This means that every schema editor automatically opens in read only mode. If you open a schema editor in read only mode, the entire project is enabled to use read only mode. If you want to see the schema objects, then login to Microstrategy developer as administrator. When the user hierarchies are viewed, the background color is determined by the computer's settings. User. A table containing data that points to another row within the same table is said to have a recursive reference or to conform a recursive hierarchy. Hover over the user-defined hierarchy you want to rename. Reports and documents can also be created. Your building blocks – Schema Objects; The Source – Tables; Business raw measures – Facts; Business context – Attributes; Grouping business context – Hierarchies;However, there are MDX cube source objects that can be manipulated in ways that affect how their related MicroStrategy objects are defined: Dimensions in MDX cube sources are not directly mapped to MicroStrategy objects. Edit an Existing User-Defined Hierarchy. You can also check that by using REST API or mstrio Python. Connect to your environment (s). 0. Once the target hierarchy is opened, you can start editing it. It allows users to drill down into more detailed data and analyze data at different levels of granularity. Returned as an integer:. Designing Schema objects such as Facts, attributes and hierarchies using Architect design toolBuild and maintain MicroStrategy schema objects (Attributes, Facts, Hierarchies, Tables, Views, etc. In MicroStrategy Developer, log into the project source that contains your project and open the project. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . MSTR Transformation Metric with no aggreagation; MSTR Defining sets of privileges: Security roles; MSTR VLDB SQL optimization tipsA list of security roles in the project source opens in the main Developer pane. The object hierarchy does not record data related to configuration objects (subscriptions, schedules, users, user. MicroStrategy REST. 8 and up?. These types of hierarchies include the system hierarchy and the user hierarchy. A solution is offered. When the lock is turned on under the Schema menu, no one, including the administrator, can perform changes on the schema objects. Drop Files. A user group (or "group" for short) is a collection of users and/or subgroups. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. • Experience in creating Microstrategy Schema and application objects such as Logical tables, attributes, facts, Hierarchies, metrics, prompts, filters, consolidations and custom groups • Experience in Report Services, Dynamic Dashboard, Report development and dossiers. This. Save and update the schema, then close MicroStrategy Architect. Schema objects include facts, attributes, hierarchies, and other objects which are stored in the Schema Objects folder in MicroStrategy Developer's folder list. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. Column. V. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. "System Prompt" is a system object that was introduced back in version 8. It enables to perform the following tasks: Initially populate. All of the schema objects—facts, attributes, hierarchies, transformations, and so on—in your project come together to form your project’s schema. 0. About MicroStrategy User Groups. x. By learning about objects and different object types, you will develop a strong understanding of the MicroStrategy Schema and Public Objects. Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: Population Exception: The object shown in the following hierarchy no longer exists in the schema: -Dimension/Hierarchy-Attribute:Object is not found in DFCSchema during DFC conversion Error(s) occurred while loading schema: 0. When the user hierarchies are viewed, the background color is determined by the computer's settings. KB429013: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableObject is not found in D… Number of Views 1. Stored Procedures Stored procedures in SAP HANA are objects that constitute of blocks of reusable code, they can be written either in R, L (sap usage only), or SQLScript in a repository (. The object is named as "User Login" and is implemented as a prompt object. From the File menu, select New, and then Hierarchy. Business Objects, S. Explanation: A hierarchy in MicroStrategy is a set of related attributes arranged in a tree-like structure. For example, facts are used to create metrics, which are in turn used to design reports. The. Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer. These attributes and facts are part of the report definition that the MicroStrategy Engine refers to when a report. This technical note documents a metadata inconsistency that is exposed through MicroStrategy Developer when updating the schema. Open up the same document in MicroStrategy Web 10. "Object Required" error message appears when trying to run script on hierarchy object in MicroStrategy Command Manager 9. Dynamic Dashboard, Report development, and Project design: Facts, Attributes, Hierarchies, Aggregation Deliver required documentation for build, and support responsibilities, including. 9. The objects you can create in MicroStrategy Developer fall into one of three groups: schema objects, application objects, and reports and documents. On the left, under Layout Properties, select Advanced. Select only Configuration Objects for documentation. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Describe how user hierarchies are used in a MicroStrategy project create user from TI 1 at Centro Universitário SENAC - SENACSPThe goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode. Overview of MicroStrategy Architect and Schema objects Number of Views 593 KB30585: "[DFCSCHEMA] Population Exception: The object shown . Duplicate Project opens the Project Duplication wizard, which allows you to duplicate a MicroStrategy project. Ragged HierarchiesChapter 5: Leveraging advanced data warehouse schema design Chapter 6: Using logical views to map schema objects to SQL queries Chapter 7: Resolving many-to-many attribute relationships Chapter 8: Specifying attribute roles Chapter 9: Implementing hierarchies with data modeling techniques Chapter 10: Managing slowly changing dimensions. This means that every schema editor automatically opens in read only mode. The project schema refers to an internal map that MicroStrategy uses to keep track of attribute relationships, fact levels, table sizes, and so on within a project. MicroStrategy Schema Modeling With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. MONTH_DESC. A system hierarchy is maintained by the relationships that exist among the project’s schema objects. From the Choose a Permission Level drop-down list, select the predefined set of permissions, or select Custom to define a custom set of permissions. and changes to the schema objects. In the Folder List, navigate to and open the Schema Objects folder. The basic schema objects are shown down; Although to can create other species are schema objects in MicroStrategy Architect that you use with more advanced. In MicroStrategy Desktop 9. 4. ) Ability to effectively interface with clients and other stakeholders to gather and define functional requirementsGrouping business context – Hierarchies MicroStrategy Hierarchies are Schema Objects made of Attributes, which serve two main purposes: Help to visualize and understand the relationships between the Attributes Define paths for users to drill (drill maps and drill paths) The following is a quick reference table for this MicroStrategy Object:5 years of experience in MicroStrategy Developing; 5 years of experience designing and building MicroStrategy Schema layer Objects (Attributes, Facts, Hierarchies, Transformations and Logical tables);Schema objects represent different components of the logical data model and are directly mapped to a column or columns in the database. Certain MicroStrategy features automatically create new schema objects, referred to as managed objects, which are not directly related to the project schema. Your building blocks – Schema Objects; The Source – Tables; Business raw measures – Facts; Business context – Attributes; Grouping business context – Hierarchies;Schema Objects are the MicroStrategy Objects which are logical representation of the structures of a data warehouse. Tables, Facts, Attributes, and Hierarchies. Create Relationships in System Hierarchies Considerations for the use of star schemas with MicroStrategy SQL Generation. User-defined hierarchies do not need to follow the logical data model and can be modified to include additional attributes or limit user access to them. MicroStrategy Workstation allows you to browse and search for schema objects. Therefore, unlike the Schema Objects, it is not necessary to perform an update schema after any Public. Right-click a table, and then select Add Table to Project. In MicroStrategy Developer, open a hierarchy using either the Hierarchy Editor or Architect, as described below: Locate a hierarchy in the Folder List, right-click the hierarchy, and select Edit. In the Folder List, navigate to and open the Schema Objects folder. x and 10. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Facts, attributes, and hierarchies are three essential pieces to any business intelligence application. However, the levels within a dimension in an MDX cube source are mapped to hierarchies and attributes in MicroStrategy. This technical note outlines an issue that occurs when updating a project schema in MicroStrategy Developer 9. 4. Make a shortcut to the Test Hierarchy in the Schema Objects > Hierarchies folder. User-Defined Hierarchy. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. 54K. Facts - Son los valores numéricos, que se. Click the icon and enter the new name. Se abre la siguiente pantalla mostrando los distintos objetos de esquema. The table is added to the project and included in the Project Tables View of Architect. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. User. Reports that contain B or C will ignore filters on the other. The modeling tool allows architects to transform a complex enterprise data environment into a unified. Update your schema to view the changes. To overcome, the proposed method presents a new strategy to automate the multidimensional design of Data Warehouses; this algorithm uses an enterprise schema of an operational database as a starting point to design data warehouse schema. Consider one example, before executing Schema Collection Verification test which ensures all schema objects are in the Schema collection, the ScanMD will execute Table Verification test and eliminate table objects with invalid. 4. Population Exception: The object shown in the following hierarchy no longer exists in schema: - Population Exception: DBMS-DBMSThe object definition is incomplete or inconsistent. Open the Hierarchies folder, and then the Data Explorer folder. Select the Members tab. A database table used to uniquely identify attribute elements. The system hierarchy is automatically created when you create a project and is maintained by the relationships that exist among the project's schema objects. Make a shortcut to the Test Hierarchy in the Schema Objects > Hierarchies folder. 0. Create a Report Services Document. In MicroStrategy Developer, a user can right-click on the object name and choose the option to allow users to search for components of that object. There is a good explanation on how to overcome those issues. This is the area found when navigating to Schema Objects - Hierarchies - Data Explorer folder and navigating the various created hierarchies. Hover over the user-defined hierarchy you want to rename. DSSSQLENGINE: Schema conversion error: :The object shown in the following hierarchy no longer exists in the schema: erroneous or obsolete schema CAUSE: This behavior has been reported in MicroStrategy 9. Browse Library. Hierarchies are groupings of attributes that can be displayed, either ordered or unordered, to reflect the relationships that exist between the attributes in a project. Hierarchies, Prompts, Filters etc. Login to the project as the user and open one of the table object --> This will allow the user to view table in read-only without giving any option. Number of Views 2. 2. Hierarchy Reporting: Get the correct value for metrics defined with scope scripts using a new MDX pattern. In MicroStrategy Web 9. The following procedure describes how to achieve this: Create the highest level filter. Configuration objects include objects that are used by all projects in a project source, such as users and user groups, database instances and logins, security roles, and Distribution Services devices, transmitters, and. The default mapping method for the first expression in a form is Automatic. Auto assign connections Metadata Manager configures. . Creating Dashboards and Reports to provide a broader range of analytical functionality and to facilitate reports deployment. 4. But this behavior can be changed by using the 'From Clause Order' VLDB property under the 'Joins' folder. They are the bridge between MicroStrategy reporting environment and data warehouse. As a result, the user has to choose the candidate schema which meets the system requirements. To add new users or groups to the object's access control list (ACL): Click Choose Users/Groups. In The Logical Data Model, you learned how to use hierarchies to group related attributes in practical business areas. The following screen opens up showing the various schema objects.