Extensively used filters, prompts, consolidations and custom groups to. All of these objects can be built and manipulated in MicroStrategy Desktop. To delete a hierarchy from the list, select the hierarchy and click Remove. There are three types of objects: schema objects, application objects, and configuration objects. To apply a filter to an attribute in a hierarchy. From the File menu, select New, and then Hierarchy. Scan MD. From the Schema menu, select Architect. On the next screen, select the DSI you want, then click the Generate Geospatial Service key button. •. 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. Explanation: A hierarchy in MicroStrategy is a set of related attributes arranged in a tree-like structure. Read Only: Read only mode allows you to view the schema objects without locking the schema from other users. Three categories of Microstrategy. These objects are developed in MicroStrategy Architect, which can be accessed from MicroStrategy Developer. This chapter. Click on the Schema Objects | Hierarchies folder. NET Framework 4. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. It is the primary contact layer between. The Object hierarchy and fact tables track all key schema (tables, facts, attributes, etc) and application objects (reports, dashboard, cubes, etc) stored in the MicroStrategy Metadata (s) being monitored by Platform Analytics. Yes, schema objects can be copied across projects using MicroStrategy Object Manager. 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. ) and public objects (metrics, filters, templates, reports, dashboards, etc. Hierarchy - Logical objects that group attributes to reflect their relationships or provide convenient browsing and drilling paths in the MicroStrategy reporting. x, select 'Project Documentation' from the Tools menu to start the wizard. Click the icon and enter the new name. Creating application objects and Schema to serve the user communities of both Web and MicroStrategy Desktop. Schema objects include attributes, facts, hierarchies, transformations, functions, partition mappings, columns, and tables. Drag the attribute from the left pane and drop it on the target attribute in the view. Once the target hierarchy is opened, you can start editing it. Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies. The object is named as "User. Schema objects are directly mapped to a column or columns in the database. x SQL Engine is ignoring the conditionality at the report level because a metric in the report also contains a related conditionality which has been set to "remove related report filter elements" or "ignore" the filtering criteria at. 0. LU_. It supports scorecards, interactive dashboards, ad hoc query, high formatted reports. In the Schema Update dialog box, select or clear the following check boxes: Update schema logical information: Use this option if you added, modified, or deleted a schema object. Objects of this type that can be used in MicroStrategy Web are: Attributes Hierarchies Facts PUBLIC OBJECTS Public objects in the Public Objects folder are created and managed by the Reporting Support team. 4. DSS_OBJECT_TYPE: The type of the report, such as "Graph Report". An object is a basic building block in MicroStrategy. Business Intelligence with MicroStrategy Cookbook. Open up the same document in MicroStrategy Web 10. Microstrategy Dossiers With the release of MicroStrategy 10. For steps to access this dialog box, see Accessing the Architect options. Option A 1. KB45087: "[DFCSCHEMA] Population Exception: The object shown in the following hierarchy no longer exists in schema: -Dimension/Hierarchy-Attribute Form. You can sort, filter, search by name and ID, and change security access for schema objects, including attributes, metrics, filters, prompts, hierarchies, and more. MicroStrategy recommends you choose Automatic if you are unsure what tables contain the column used in the expression. • Good understanding and knowledge of Star/ Snowflake/ Dimensional. The system hierarchy is automatically created when you create a project and is maintained. These report objects are discussed in detail in the Advanced Reporting Help. Maintain MicroStrategy schema objects and public objects. Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web Server. UserHierarchy ( connection : Connection , id : Optional [ str ] = None , name : Optional [ str ] = None ) ¶Schema objects represent different components of the logical data model and are directly mapped to a column or columns in the database. A ragged hierarchy is the one in which the parent or child attribute element of one or more attribute elements are not present in the level immediately above or below the attribute. By learning about objects and different object types, you will develop a strong understanding of the MicroStrategy Schema and Public Objects. •. If the issue persists, please contact MicroStrategy Technical Support for further assistance. Cards can be consumed in a web browser via the MicroStrategy HyperIntelligence Chrome extension and on iOS devices via the MicroStrategy. 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. Click User Defined Hierarchy at the top of the Hierarchy Editor and choose the target hierarchy. Users can now use Workstation to create projects, connect to data sources, and create schema objects, including attributes, facts, metrics, prompts, and derived elements. facts, attributes, hierarchies, aggregation, and portal integration. MicroStrategy platform capabilities exposed in a RESTful web service. 83K KB39551: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableThe object definition is. x/9. Your building blocks – Schema Objects; The Source – Tables; Business raw measures – Facts; Business context – Attributes; Grouping business context – Hierarchies;This update is required when you make any changes to schema objects such as facts, attributes, or hierarchies. From the Select a Project drop-down list, select the project for which to assign the security role. x, select 'Project Documentation' from the Tools menu to. It includes things like attributes, facts, hierarchies, transformations, etc. V. For steps to access this dialog box, see Accessing the Architect options. The auto-generated numeric ID for. 8 and up?. In MicroStrategy Developer, log in to the project source that contains the MicroStrategy Tutorial project and then log in to MicroStrategy Tutorial. Data-Type. x and add a derived attribute, right clicking an. Reports that contain B or C will ignore filters on the other. Locate the Request Geospatial key button above the products session and click on Mapbox Key : Each key is DSI specific. These types of hierarchies include the system hierarchy and the user hierarchy. The two types of hierarchies that exist in MicroStrategy include: System hierarchy: The system hierarchy is created according to the relationships defined between the. These objects are developed in MicroStrategy Architect, which can be accessed from MicroStrategy Developer. In the Folder List, navigate to and open the Schema Objects folder. The options you can define determine how Architect displays data, automatically creates and maps schema objects, loads the Warehouse Catalog, and updates the project's schema. System Hierarchy. Connect to a database instance and drag tables onto the canvas. Edit an Existing User-Defined Hierarchy. Browse Library. "System Prompt" is a system object that was introduced back in version 8. The table is added to the project and included in the Project Tables View of Architect. Recursive hierarchies are not supported by MicroStrategy. User-Defined Hierarchy. Add or remove hierarchies, then click OK to return to the Prompt Generation Wizard. The Report SQL indicates that the filter has not been applied. Prompts APIAn object is a basic building block in MicroStrategy. Schema objects directly reflect the warehouse structure and include attributes, facts, functions, hierarchies, operators, partition. Schema objects include attributes, facts, hierarchies, transformations, functions, partition mappings, columns, and tables. The Project Design Help is devoted to explaining schema objects. Make a shortcut to the Test Hierarchy in the Schema Objects > Hierarchies folder. Finally, you will learn about the administration, security, and monitoring of your BI solution. Edit an Existing User-Defined Hierarchy. Column. KB39551: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableThe object definition is incomplete or inconsistent" error message. Default is true. "System Prompt" is a system object that was introduced back in version 8. 4. It contains all objects related to an anlaytics solution: schema objects, reports, documents, cubes, etc. • Designing and developing BI solutions based on MicroStrategy platform. Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web Server. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the following screen shot: In the "Languages" screen,. The Hierarchy Editor opens. 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. 2. 1 to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model. To manually update the schema. ) and public objects (metrics, filters, templates, reports, dashboards, etc. 4. Open the Workstation window with the Navigation pane in smart mode. The. These are MicroStrategy specific objects eg : Metrics, FIlter, Reports etc 3. 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. Multiple threads Number of worker threads that the Metadata Manager Agent uses to extract metadata asynchronously. 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. A. Published: May 16, 2017;. 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. On the left, under Layout Properties, select Advanced. One way to achieve a balance of the various trade-offs in your schema design is to use a variety of schema types in your physical warehouse schema. Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: Population Exception: The object shown in the following hierarchy no longer exists in schema: -TableObject is not found in DFCSchema during DFC conversion. Error(s) occurred while loading schema: DSSSQLEngine: Schema loading error: Population Exception: The object shown in the following hierarchy no longer exists in schema: -Link-TableObject is not found in DFCSchema during DFC conversion. 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. However, to make a user hierarchy available for browsing in the Data Explorer you must place it in the Data Explorer folder—a subfolder of the Hierarchies folder, which is located in the Schema Objects folder. They typically consist of descriptions of dimensions. "System Prompt" is a system object that was introduced back in version 8. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. If an existing schema object is in the production project, select 'Replace' in the Conflict Resolution Dialog. For steps to access this dialog box, see Accessing the Architect options. MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. RE: Recursive Hierarchy. and build complex hierarchies to organize data and better reflect relationships. "System Prompt" is a system object that was introduced back in version 8. Some of these options are available in the MicroStrategy Architect Settings dialog box. Hierarchy Reporting with Ragged Hierarchies; Filtering for a Level Metric;. ) that can be reused across projects, reports, dashboards, and applications. 2. 0. In this table, the PARENT_ID column logically points to another row in the same table (ID column). schema. There are three types of objects: schema objects, application objects, and configuration objects. but the attribute relationship in the MicroStrategy schema is defined incorrectly with a one-to-many relationship. 3. 0. A project also represents the intersection of a data source, metadata repository, and user community. Create New Project displays the Project Creation Assistant dialog box, which guides you, step by step, through the selection of tables and the creation of facts and attributes for a new project. The object shown in the following hierarchy no longer exists in schema: Use Table Alias. • Schema objects design: Attributes, Facts, Hierarchies, Transformations, etc. MicroStrategy Workstation allows you to browse and search for schema objects. You can get the ID by navigating to the cube or report within MicroStrategy Web, right-clicking on the desired cube, and selecting Properties. That is to say, it will be easiest to model your objects in the tool with the schema designed in this manner. 0. You must have the System Administrator role to view schema. Packages API The Packages API family allows you to create and import migration packages. Creating schema objects is the primary task in MicroStrategy Architect. To manually update the schema. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Open the Hierarchies folder, and then the Data Explorer folder. The Component Object hierarchy is used to track the relationship between an object and all of its direct child components. 0, Administrator, Architect, Desktop, Narrowcast. Business Intelligence with MicroStrategy Cookbook. To ensure consistency between the metadata and the object cache, remember to update the schema after schema object modifications (i. A project is where you build and store all schema objects and information you need to create application objects such as reports in the MicroStrategy environment, which together provide a flexible reporting environment. ) as well as MicroStrategy application objects (Metrics, Filters, Templates, etc. Firstly populate the metadata with project definition and schema objects. Hierarchies represent the relationship between. The system hierarchy is the default hierarchy that MicroStrategy sets up for you each time you create a project. This KB article discusses an issue that may occur when updating Schema in MicroStrategy Developer 9. • Maintenance of MicroStrategy projects. You can even use different schema types within the same hierarchy. In the example above, the two airport attributes do not have a common. To view and edit the parents and children of an attribute. The logical table from the development project will be copied to the production project as a dependent. In this level, new tables are created (schema tables) using “FactInfo” and “AttributeInfo. 3. 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. This technical note outlines an issue that occurs when updating a project schema in MicroStrategy Developer 9. Browse Library Advanced Search Sign. The next hierarchy is the “Schema” level. Hover over the user-defined hierarchy you want to rename. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. MicroStrategy Architect is a project design tool, which allows you to define all the required components of your project from a centralized interface. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Controlling access to the database: Connection mappings Connection mappings allow you to assign a user or group in the MicroStrategy system to a login ID on the data warehouse RDBMS. Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies. 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. This is a filter which contains a prompt on an attribute element list. Definition. Population Exception: The object shown in the following hierarchy no longer exists in schema: - Population Exception: DBMS-DBMSThe object definition is incomplete or inconsistent. In the MicroStrategy 2020 Update 2 release, users can create and manage standalone filters using the Filter Editor accessed from the main Workstation window. ( 1 ). Recursive hierarchies are not supported by MicroStrategy. Rather, the project schema refers to an. As the name suggests, these objects are used by the users and analysts (Public), and the. You can save user hierarchies in any folder. -Attribute:The object definition is incomplete or inconsistent. Certain MicroStrategy features automatically create new schema objects, referred to as managed objects, which are not directly related to the project schema. Functions and Operators −. KB429013: "The object shown in the following hierarchy no longer exists in schema: -Relation-TableObject is not found in D… Number of Views 1. The option to Delete unused managed objects allows a MSTR Admin to force a search and delete of those managed objects which no longer are in use by the project (no longer have dependants). Dynamic Dashboard, Report development, and Project design: Facts, Attributes, Hierarchies, Aggregation Deliver required documentation for build, and support responsibilities, including. SCHEMA OBJECTS Schema objects are created and managed by the project architect(s) and map to objects in the database. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Object BaseAttributeForm has already been deleted or is in an invalid state. LOGICAL_SIZE]) #. Developed Complex business reports in desktop using multiple Prompts, Filters and Compound metrics. MicroStrategy projects contain schemas and related schema objects, including attributes, tables, hierarchies, and so on. Schema Objects are the logical view of the structure of the data warehouse. Recursive Hierarchies. Drilling is a function in MicroStrategy reports that allows. . Map schema objects to new tables automatically: Select to map schema objects automatically to new tables. 0. Specify to skip importing creation data, modification date, and author for schema objects. Traditionally, hierarchies within the MicroStrategy platform are modeled with fixed tables, categories and levels, which can often be limiting due to dynamic real-world. When the user hierarchies are viewed, the background color is determined by the computer's settings. Print Project Schema opens the Print Project Schema dialog box, on which you can request printing of schema connections, warehouse tables, fact and attribute definitions, physical or logical table-catalog views. MONTH_ID. The MicroStrategy Schema Objects are going to be the foundation of any project. Error(s) occurred while loading schema: 9. Select the Enable Incremental Fetch check box. Facts, attributes, hierarchies, and other schema objects are the building blocks for application objects such as reports and documents. User-Defined Hierarchy. The object hierarchy does not record data related to configuration objects (subscriptions, schedules, users, user. Hierarchies Logical objects that enable you to group attributes to reflect their relationships or provide convenient browsing and drilling paths in the MicroStrategy reporting environment. The schema objects can then be seen in Desktop in the users Profile folder or in Public Objects. 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). The definition of application objects such as reports, documents, filters, templates, custom groups, metrics, and prompts are derived from schema objects. MicroStrategy Course Overview. This chapter. To view your newly created time hierarchy, open the System Hierarchy Editor. You can sort, filter, search by name and ID, and change security access for schema objects,. Ragged Hierarchies. User. 0. When a new attribute is added to a hierarchy, the attribute by default will not show up in the MicroStrategy Developer Data Explorer side bar. These are the objects which are decided during the creation of a MicroStrategy project. Click User Defined Hierarchy at the top of the Hierarchy Editor and choose the target hierarchy. All schema objects are created and maintained by the MicroStrategy architect. When the user hierarchies are viewed, the background color is determined by the computer's settings. When User 2 with a schema modification privilege opens any schema object on the same project, User 2 be prompted with the. Change names and security access of schema objects and application objects. This video covers how the MicroStrategy Architect can be used to map physical objects in the data source to the logical objects in the MicroStrategy metadata. One hierarchy can be highly normalized while another can be highly denormalized. The Object Management API family exposes the ability to programmatically manage objects in the MicroStrategy metadata. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). • 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. 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. In MicroStrategy Desktop 9. Used MicroStrategy Desktop 9. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. If you open a schema editor in read only mode, the entire project is enabled to use read only mode. Create Relationships in System Hierarchies MicroStrategy Hierarchies are Schema Objects made of Attributes, which serve two main purposes: Browse Library. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Ability to build and maintain MicroStrategy schema objects (attributes, facts, hierarchies, tables, views, etc. Some of these options are available in the MicroStrategy Architect Settings dialog box. MicroStrategy Projects; Your building blocks – Schema Objects; The Source – Tables; Business raw measures – Facts; Business context – Attributes; Grouping business context – Hierarchies; Comparing data across time – Transformations;The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. "System Prompt" is a system object that was introduced back in version 8. Lets look at how mstr calculates the LTS, but before that we need to see the hierarchy. REL_. The object is named as "User Login" and is implemented as a prompt object. 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). The Document Properties dialog box opens. A system hierarchy is maintained by the relationships that exist among the project’s schema objects. CAUSE: One scenario is that the MicroStrategy 10. An object is a basic building block in MicroStrategy. When you migrate objects (dossiers, reports, cubes) that are using time. This file is created using MicroStrategy Object Manager. MicroStrategy Workstation allows you to browse and search for schema objects. Creating Dashboards and Reports to provide a broader range of analytical functionality and to facilitate reports deployment. In MicroStrategy Developer, log into the project source that contains your project and open the project. Update Project Schema. A search for dependent objects shows only logical table and system hierarchies that should not prevent an attribute to be deleted. Generally speaking, Schema Objects are mapped to database structures such as tables or columns with a few exceptions in which other Schema Objects are used as part of their. MicroStrategy Hierarchies are Schema Objects made of Attributes, which serve two main purposes:. Controlling access to data at the database (RDBMS) level. These objects are using during the creation of the Microstrategy project. Make a shortcut to the Test Hierarchy in the Schema Objects > Hierarchies folder. "Object Required" error message appears when trying to run script on hierarchy object in MicroStrategy Command Manager 9. These attributes and facts are part of the report definition that the MicroStrategy Engine refers to when a report. However, to make a user hierarchy available for browsing in the Data Explorer you must place it in the Data Explorer folder—a subfolder of the Hierarchies folder, which is located in the Schema Objects folder. Hierarchies − They represent the relationship between various attribute values. This platform supports various types of scorecards, interactive dashboards, and automated reports. M icroStrategy is one of the leading software vendors in enterprise business intelligence (BI) today. What is the MicroStrategy schema? This is the backbone of the platform. In MicroStrategy Web, edit or execute a report. Certain MicroStrategy features automatically create new schema objects, referred to as managed objects, which are not directly related to the project schema. . 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. MONTH_DESC. Navigate to File > New or right-click > New, all the objects are missing from the menu. Physical tables in a data warehouse consist of columns, and logical tables in the MicroStrategy schema relate this column data to attributes and facts. Linking database users and MicroStrategy users: Passthrough execution. Schema objects:. "System Prompt" is a system object that was introduced back in version 8. Open the Workstation window with the Navigation pane in smart. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. Browse and Search for Schema Objects. M icroStrategy is one of the leading software vendors in enterprise business intelligence (BI) today. . 2, 9. This is called heterogeneous column naming. Update schema. If you have selected to automatically create attributes, attribute forms, and facts based on schema. 0; Installing SQL Server 2012 Command Line Utilities; Setting up the AdventureWorks DW sample database; Installing the . "Object Required" error message appears when trying to run script on hierarchy object in MicroStrategy Command Manager 9. They help in carrying out drill-up and drill-down. Application object: Reports, filters, documents, templates, metrics, prompts, custom groups are. MicroStrategy object definitions and data warehouse connection information. 0. In the right corner of the dashboard, change the data source to none. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. 3584: System Hierarchy. This prompt is used in a filter. Facts, attributes, and hierarchies are three essential pieces to any business intelligence application. Update schema. •. The Grouping Properties dialog box opens. What are the Various Objects in MicroStrategy? The objects MicroStrategy allows you to create are divided into three categories: Schema Objects: These are the objects usually created by a project designer. This technical note documents a metadata inconsistency that is exposed through MicroStrategy Developer when updating the schema. Transformations Schema objects you can create using attributes in your projectare one of the many MicroStrategy techniques used to perform time- series. facts, attributes, hierarchies, aggregation, and portal integration. Creating Project Tables, Facts, Attributes and its relationships and hierarchies; Overview of MicroStrategy Architect and Schema Objects MicroStrategy Architect provides a set of tools that are used to create new projects and modify the structure of existing projects. Business Objects, S. A system hierarchy is maintained by the relationships that exist among the project’s schema objects. 0. However, the levels within a dimension in an MDX cube source are mapped to hierarchies and attributes in MicroStrategy. For steps to access this dialog box, see Accessing the Architect options. An object is a basic building block in MicroStrategy. 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. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. Ragged Hierarchies Chapter 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. In the Folder List, navigate to and open the Schema Objects folder. Browse Library Advanced Search Sign. Drilling using hierarchies. To create a new user hierarchy. The system administrator should use MicroStrategy Administrator - Object Manager to copy the schema object. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. 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. MicroStrategy does not recommend or support this type of schema. ) and public objects (metrics, filters, templates, reports, dashboards, etc.