MicroStrategy Object Manager 9. Watch on. Select create option. Enable logging on Client Services > Sources Manipulator. Use Object Manager when you have only a few objects that need to be copied. SYMPTOM: When importing a package into a project in MicroStrategy. If in doubt, check out the "MicroStrategy System Administration Guide" product manual, which covers all you need to know on command manager. OM object types are a way of grouping similar data. If installing over previous versions of the product, the folder remains the. When you migrate an object to another project, by default any. Place intelligence server close to the both the data warehouse and the metadata repository. Choose both import and create undo package. Implemented MicroStrategy Schema Objects and Application Objects like Attributes, Hierarchies, Filters, and Metrics using MicroStrategy Desktop to create new and rebuild the reports. x. MicroStrategy Enterprise Manager를 사용하려면 MicroStrategy Command Manager가 설치에 포함되어야 합니다. Experience in Upgrading MSTR 8. Platform Analytics and Enterprise Manager are both monitoring tools that capture data about MicroStrategy. CREATE METRIC "Count Customer City" IN FOLDER "Public ObjectsMetricsCount Metrics" EXPRESSION "Count(Customer City) {Country} "<>" ON PROJECT "Duplicated MicroStrategy Tutorial"; CAUSE: Attribute names that contain spaces cannot simply be used in parameters such with the parametere EXPRESSION. The following table lists folders and files of interest that are included in the default directory structure after an installation of Object Manager. Before importing the package to the target project, an undo package is generated. Using "Create configuration package" /"Create. The metadata is a central repository, which stores all the objects used by it. Create a configuration package with user and/or user group objects and set their Action to Replace. Change the action item of all. Users' profile folders are project specific, unlike users, which are system wide objects. One possible cause of this issue is a physical table object (DBTable) has become a managed object, therefore, when searching dependencies in the MicroStrategy Obejct Manager, the managed objects are missing from the result set. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. In this example, a MicroStrategy Tutorial project is used where a shortcut for "Business Roles" is created inside. . x - 10. Here, create a configuration package and add the user with all of the dependents. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. ACTION: Install MicroStrategy Developer in the machine where Object Manager is running to enable the search functionalityThis technical note describes a way to launch MicroStrategy Developer and log into a project using the Microsoft Windows Command prompt. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. In the original XML file used for creation, modify the options for the main chosen destination object and set AddDependents to No as shown below. Dossier’s intuitive, drag-and-drop interface enables you to display and explore your data in seconds. 3. To incorporate the results of a Command Manager statement into a procedure, use the ExecuteCapture command. In MicroStrategy Enterprise Manager, create a new report. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. 1. <Connections> <SourceConnection> <Location>DSN=Analytics_Metadata. Default object answer: A prompted report can have two possible default answer, a default. Video Tutorials. A solution/code fix is not available in current release, but is being reviewed for a future MicroStrategy. exe. x-10. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. x and 10. Open a project source in MicroStrategy Object Manager. What this option does is that it migrates the object even if it exists identically in the source project. x even 'Show System Objects' option is selected, as shown below: NOTE: Run the report, and check SQL View. From the search results the Administrator can rename or delete the objects. " Change this to any folder location and destination and click OK. 4. Yes, schema objects may be copied across initiatives the use of MicroStrategy Object Manager. Enterprise Manager、MicroStrategy Object Manager、MicroStrategy Reporting Suite、MicroStrategy Power User、MicroStrategy Analyst、MicroStrategy Consumer、MicroStrategy Email Delivery、MicroStrategy BI Author、MicroStrategy BI Modeler、MicroStrategy In MicroStrategy Object Manager 9. Create a user that belongs to both groups (Test1) Log in Developer as the Test1 user and notice that the user can only see the MicroStrategy Tutorial as expected. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. <Connections> <SourceConnection> <Location>DSN=Analytics_Metadata. 0 oder höher ist erforderlich, um MicroStrategy-Produkte auf Windows-Plattformen zu installieren. Object Manager 31 Integrity Manager 31. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution,. MicroStrategy - Object Manager - Online Training Video by MicroRooster. Right-click a project in that project source and select 'Compare projects' or select Project. Configuration objects include objects such as users, database instances, database login IDs, and schedules. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. MicroStrategy released the ability of Read-Only Mode in MicroStrategy ( KB34610 ). This is not the same as creating visual insight dashboards; this is equivalent to creating dashboards the the developer desktop. Choosing the 'Replace' option will only migrate an object is the version IDs are different. - Take note that in both cases, they seem to be correctly applied to only the MicroStrategy Tutorial project. Use Existing: The destination object remains the same. mmp) file. This set of users could then be narrowed down further by looking at which of these users has the proper privileges and permissions to modify the object. x: To do this, go to Programs > Microstrategy > Integrity Manager. ). Number of Views 1. x, create a fact (e. Object Manager can copy application, schema, and configuration objects. KB17418: ‘The schema is being modified by Administrator’ message appears when attempting to edit a schema object in MicroStrategy Developer9. Reviewing and Managing Properties of MicroStrategy Objects may be a task for Developers and Architects when building and. To understand how MicroStrategy Object Manager handles tables, one must first. 6. x. 1. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. 2. Visit the data visualization and data dashboard galleries for inspiration. This search will return the list of all the prompt answer objects that belong to the specified user. x - 10. Select the 'Import Selected Objects' option and select a report which has dependencies. If they are the same, the migration fails. It is designed to help developers build data-driven client applications quickly and easily. Windows Installer 3. 5. MicroStrategy Developer temporarily locks the schema of a project when User 1 opens an editor or wizard that affects schema objects (attribute editor, fact editor, schema update, warehouse catalog, etc). Add the report and add all used dependencies. Then click OK. Create an object manager package and add the report. exe file is stored. 0 Defects and Enhancements a new privilege was added to the Object Manager Section. 1 provides new reports that can provide MicroStrategy Command Manager scripts to delete unused objects in the project. A token is a word, a list of words enclosed in quotation marks, or a symbol. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. This statement can only be executed in a Windows. MicroStrategy Administrator - Object Manager is built with the assumption that two projects are related. Replacing the . Certain MicroStrategy object editors don't display after disconnecting an external display which hosted the editors in MicroStrategy Developer 9. It covers BI project in MicroStrategy Platform with Examples. …In this video I will show you how I handle migrating objects from development to production using Object Manager in MicroStrategy. MicroStrategy Object Manager. Selenium is a popular open-source web-based automation tool. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. This technical note describes an issue when trying to import a package in MicroStrategy Object Manager. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). The user is listed on the Service Startup tab, in the Login field. Step 3: Import the package into a multi-node cluster a non-primary node using Command Manager. The Web Objects API is a granular level API used by many of the MicroStrategy Web products' Web Beans and other Web Components to access MicroStrategy Intelligence. LU_. 0, Developer 2000, oracle databases. This short video show users how to use Microsoft tools such as Excel with MicroStrategy. g. Published: Jun 7, 2017. By running the following script in the Command Manager:. Any prompts with personal answers saved for the login using Integrity Manager can be resolved using those personal answers. ” Select “Add” and add any object to the package. Open up the 'MicroStrategy Tutorial Project' and navigate to Schema Object->Attributes->Customer as shown below. API samples illustrate how REST API calls work with ReactJS, and the ability to create reports on the fly, with ad-hoc object fetching and. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. 1. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. MicroStrategy - Passthrough Filters - Online Training Video by. Designer: A design interface used to create DataStage applications OR jobs. CAUSE: The steps that lead to this state are unknown at this time. Dedicate a machine for the metadata repository. The options are: Exclude all parent. If two objects have the same GUID, they refer to the same object. The log entries are written by the client MicroStrategy Object Manager 9. KB47203: A Folder cannot be added to "Selected objects" page in package creation in MicroStrategy Object Manager 9. In the Configuration Package window, click "Search for Configuration Objects". Import the newly saved package. 1 Hotfix 2. . Object Manager and Project Merge both copy multiple objects between projects. This hotfix should be applied on top of MicroStrategy 9. MicroStrategy Usher, Usher Badge, Usher Secu rity, Usher Security Server, Usher Mobile , Usher Analytics, Usher Network Manager, MicroStrategy Trela for Retail (Alert backwards / used for demonstrations, MicroStrategy Services, MicroStrategy Professional Services, MicroStrategy Consulting, MicroStrategy Customer Services, MicroStrategy. The object's editor or wizard opens. These reports are. It specifies the data source, required. If the count of unused managed objects is in the order of 100s of thousands, it is an indicator that they are many unused objects in the metadata and that the these should be cleaned up. 4. The following article knowledge base will explain how to hide shortcut objects from appearing in the results of the search within the "All Objects" panel in design mode:How to update the Object Exist Status indicator in MicroStrategy Enterprise Manager 9. Begin creating a configuration package by navigating to ToolsCreate Configuration Package. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. Die Schritte für die Installation von MicroStrategy Object Manager finden Sie im Kapitel Installing MicroStrategy on Windows (Installieren von MicroStrategy unter Windows). WORKAROUND Use object manager package to migrate the user instead of drag and drop. This same component also performs object manipulations through MicroStrategy Object Manager 10. Objects in MicroStrategy get referenced by their GUID (Globally Unique Identified). NOTE: The Dependent objects deletion functionality only applies to application objects (reports, metrics, filters, etc. A security role is a collection of project-level privileges that are assigned to users and groups. 3. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). MicroStrategy - Architecture. In environments where many shortcut objects exist, it may be advantageous to only show the original objects and hide the shortcut objects when searching for an object. ACTION: Open the project where you wish to import the Object Manager package and select "Import Package" from the Tools menu. . User Manager. The following procedure describes how to migrate MicroStrategy Tutorial Project's metadata from Access to SQL Server 2005 in MicroStrategy 9. Go to each of the attributes and facts returned by the dependency search. The goal of an object migration is to have two objects (source and destination) of the same definition. Where <Path> is the directory where the setup. Post a Discussion; Log a Case; Speak to an Expert; Product. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. BUSINESS USER VIDEOS & TUTORIALS. OR. Best Practices for Copying Objects. Save the report as prompted. All articles. x-10. Published: Jun 7, 2017. In MicroStrategy Object Manager, when creating a configuration package for a user group, the users and security roles do not get brought into that package. For example, a report shows revenue data for all geographical regions of. Mindmajix’s MicroStrategy Admin certification training course enables you to master the concepts and techniques of MicroStrategy Administration. 0 Object Manager called "Use Object Manager Read-only"This is a known issue in MicroStrategy object manager 10. For example, you might have two types of users with different functionality needs: the Executive Users who need to run, sort, and print reports, and the Business Analysts who need additional capabilities to drill and change. ACTION: Grant permission to read database views to the user account specified to be used for the MicroStrategy Enterprise Manager project's. まだ何もありません。 このフィードに投稿するには、ログインしてください。An object is a basic building block in MicroStrategy. x, have dependencies on objects in the configuration that were not present or had different definitions in previous versions, such as MicroStrategy 9. They can also interact with the reporting objects. 300. This new privilege will allow the user to create Object Manager Packages which can be. Upon clicking Edit, the user can choose to modify the definition rules, update schema options, ACL options for the package. MicroStrategy Administrator - Object Manager is the component in the MicroStrategy Product Suite that allows system administrators to conduct project life-cycle. The following objects can be used on a MicroStrategy Enterprise Manager report to display the first report execution time; it can be modified to apply to documents as well by replacing the Report attribute with the Document attribute. Implemented drill functionality on the reports using Drill Maps. 2. . As shown below, the Data Source Name (DSN) is ended with semicolon. x machine. The command prompt is displayed. x-10. Secondly, we would assign a name of “. Object Manager cannot undo the copying and replacing of objects. compound metric. Upgrade to this version to take advantage of this fix. Statements consist of one or more tokens. x. Set Freeform SQL and MDX objects default security. To create an XML file to use to import the package and create the undo package the Object Manager GUI must be used but this is only for creation of the XML file. For the first-time user, see Getting Started with Documents for a brief overview of documents. In the Object Manager log in a Project Source 2. In the Owner tab select "Only this owner" and choose the user to manage. a lookup table. Access MDUpdateUtil. Community & Support Search Discussions Open A Case View My CasesMicroStrategy Tools (Object Manager, Command Manager, Enterprise Manager, Integrity Manager, System Manager). The command prompt is displayed. Example: User creates a package from MicroStrategy Version 10. Select the search object from the folder browsing. A tool used to migrate objects and their dependencies from one environment to another. 1. Delete unused managed objects, which can be found in MicroStrategy Developer, under Administration menu > Projects. This video covers includes: Hierarchy, Attribute, Value, Object, and Level Prompts. Save as Unused Fact. 1) Use SQL statement: select COUNTRY_ID. As a result, a security filter can limit the data a user sees on a report, even if the report is designed to display a broader set of data. MicroStrategy Object Manager provides complete life cycle management capabilities for MicroStrategy environments. They may be compared in either 2-tier or 3-tier. 6Object Manager supports migration of objects between "related" projects, where one of the projects was created as a duplicate of the other. IS_REP_FACT: Fact table for report job executions. On the Create Package editor, click on the add button and in the Add objects editor, select 'Import selected objects'. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. DLL file should allow Object Manager to function correctly. Create a configuration package for the user group 'Managers' and select the option 'Objects used-by dependencies' In Object Manager, when importing a package, the user has the option to edit the package. It does not work with schema or configuration objects. 0/6. Select session task as type of task. Specify the port number where the SMTP server receives incoming e-mail. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. The User Editor opens. MicroStrategy Narrowcast Server uses several ports to communicate between the Narrowcast components: Distribution Manager. Visualizations in MicroStrategy Dossier, Part 1: Understanding a Dataset. x, Certified (Supported for Linux, MacOS) Chrome 27. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Execute the search. Click "Add" button and select "Import Folder and Children recursively" option in the 2nd window, then, select "Subject Areas" folder as shown below: 4. x-10. Retrieving information from ResultSet objects. This is the object hierarchy used in property management. Configure a new system by selecting the menu item "Configure New System…"The MicroStrategy ONE platform provides access to AI-powered workflows, unlimited data sources, cloud-native technologies, and unparalleled performance to speed up time from data to action. 3. 2. Grant Object Manager privileges for the Object Manager group. In the MicroStrategy system, every object has an ID (or GUID) and a version. 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). Object Manager cannot undo the copying and replacing of objects. Step 2: Create an object manager package containing just a view report in MicroStrategy Object Manager from a lower environment. Simply view the contents of the package. MicroStrategy Object manager. In the Tools menu click on Create a Package 4. This hotfix should be applied on top of MicroStrategy 9. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. A. In part one of this video tutorial series, Kevin Thompson from our Customer Education team describes the types of dataset objects you'll encounter on a MicroStrategy Dossier and what each object type represents. Manager: It is the main interface of the Repository of ETL DataStage. MicroStrategy Object Manager: A lifecycle management tool designed for MicroStrategy environments, and helps you to copy various objects inside a project or across different related projects. ACTION: This issue has been addressed in MicroStrategy 9. This article explains why when a Folder is selected in the “Add Objects” screen, the arrow to add objects to the “Selected objects” is not activated This video demonstrates how to create pixel perfect dashboards using the web client. 008) Stop any of the MicroStrategy Servers running on. Using Object Manager, you can copy objects within a project or. 4. In MicroStrategy Object Manager 9. Select the desired Project Source (Data Source) and click on Next, as shown below: Upon clicking Next, the following window shows the. Copy the . This is not the same as creating visual insight dashboards; this is equivalent to creating dashboards the the developer desktop. x: To do this, go to Programs > Microstrategy > Integrity Manager. KB31819 - Where is the log file that contains information on creating and importing MicroStrategy Object Manager packages in 9. 28K. The Access Control List objects is a list of users and groups and the permissions of each for the particular object. ACTION: Close the project source in MicroStrategy Object Manager to the MicroStrategy Tutorial metadata and then the user has the option of performing the duplication by clicking on Project -> Duplicate Project from the Object Manager menu as shown in the image below instead of MicroStrategy Developer if desired:Security filters in MicroStrategy restrict a user's ability to access or view certain objects within a given MicroStrategy project. x data load takes place, its new definition will be updated in the Enterprise Manager Warehouse. 4. This article explains why when a Folder is selected in the “Add Objects” screen, the arrow to add objects to the “Selected objects” is not activatedThis video demonstrates how to create pixel perfect dashboards using the web client. xIt is possible to create a report in MicroStrategy Enterprise Manager 9. Through DataStage manager, one can view and edit the contents of the Repository. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. 4. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicrostrategy Power Users & Analysts use the Developer tool to execute reports and dashboards created by the Microstrategy Development Team. REL_. Compatible with both structured and unstructured data, use AI chat to ask questions about. They typically consist of descriptions of dimensions. The object's editor or wizard opens. 3. Drag and drop objects from the Object Browser into the Create Package dialog box. The objects stored in the metadata are reusable. 0, System Objects can be migrated with Object Manager, by dragging and dropping the object from the source to the destination project. All dependent objects of all objects currently listed in the package. KB40276: Logical tables are dependent on column objects even though the reference to the columns cannot be found in MicroStrategy Developer 9. Post a Discussion;. 158. Open the project with a locked schema in MicroStrategy Object Manager, and then close object manager. A prompt allows a user to provide an answer to restrict or filter data during report execution. MicroStrategy i About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Published: Jun 7, 2017. Then, nagivete into Public Folders, then, select Tools > Create Package. Managing changes within a business intelligence environment can be an overwhelming task for any IT department, large or. Resolve Conflicts when Copying Objects. Select the desired Project Source (Data Source) and click on Next, as shown below: Upon clicking Next, the following window shows the. Using this tool, users can easily transform big data into instinctive dashboards and reports for greater. All new Download site is now available! How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; How to increase the Java Heap size in Tomcat Application ServerThe database account used for the MicroStrategy Enterprise Manager project’s warehouse data source name (DSN) does not have the necessary database permissions to read views. 3. MicroStrategy Analytics 10 replaces its older Visual Insight version with its new Analytics (both Desktop and Enterprise). A similar result may be achieved with Command Manager, making it possible to obtain this information for multiple metrics simultaneously. The import is successful. It supports an interactive dashboard, highly detailed reports, ad-hoc queries, automated report disputes, and Microsoft Office integration. KB46488: Object translations are changed from the default language to another language when migrating objects which have a blank default translation in MicroStrategy Object Manager 9. Each row in the ResultSet object contains information about one item. Teradata ODBC Driver. There are two methods of determining a Project's version: Using the MDUpdateUtil tool. Remove any objects if they are not to be migrated. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. In MicroStrategy 9. Locate the MSVBVM60. ACTION: Before enabling the visualization of the System Objects folder, close MicroStrategy Desktop and any instance of the MSTRDesk. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Methods to create and manage language objects, interface languages, and language settings. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. ACTION: Before enabling the visualization of the System Objects folder, close MicroStrategy Desktop and any instance of the MSTRDesk. 3. For example, if you want to copy the Cost fact from the MicroStrategy Tutorial project to the Human Resources Analysis Module project, you can create a package with the Cost fact and all of its dependents, and then. Lists all attributes from a given location path within a project. The following lists certification updates for 9. The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, GET, and DELETE. The log entries are written by the client MicroStrategy Object Manager 9. In the backend, there is a different component responsible for recalculating table logical sizes, table keys and fact entry levels. The package. At the bottom of this window, the user will see the "Default output folder for Object Manager. This KB addresses an issue seen when Object translations are changed from the default language to another language when migrating. Here, create a configuration package and add the user with all of the dependents. MicroStrategy Object Manager 9. 4. By right-clicking on the project in Object Manager and going to 'Properties'. Click Enter. Follow the steps below for an example of how to do this. MicroStrategy - Prompts (Hierarchy, Object, Level & Value) - Online Training Video by MicroRooster. Select the search object from the folder browsing. Import the package in another project to Object Manger. MicroStrategy Object Manager allows you to easily migrate objects from one environment to another using drag-and-drop, copy/paste, and so on. Lists all attributes from a given location path within a project. When a user performs a Project Comparison and views the objects 'Only in source' in the Project Comparison Result Set window, the ability to select objects is no longer available in MicroStrategy Administrator - Object Manager. • The user does not need access to the source project. 3. MicroStrategy objects appear in the system layer and are usable across multiple projects. Web XML API log. Configuration object 'CASTOR_SERVER_CONFIGURATION' with ID 'XXXX' cannot be modified because it is locked by 'USER' on 'MACHINE' since mm/dd/yyyy h:mm:ss. 0. For example, you can copy over the existing. Published: Jun 7, 2017. , managed objects depending on other managed objects. 3. The MicroStrategy Repository is an embedded PostgreSQL repository that supports the storage of Collaboration Server, Platform Analytics, and the Storage Service. After creating and importing MicroStrategy Object Manager packages, the log file generated to capture the details of the action is configured using MicroStrategy Diagnostics and Performance Logging. MicroStrategy - Object Manager - Online Training Video by MicroRooster. Object Manager helps you to resolve the conflict. 6. Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create filters, prompts and metrics. Related. In MicroStrategy Developer 9. MicroStrategy Driver Manager Files. 2. Pakete: Object Manager können eigenständige MicroStrategy-Metadatenobjekte erstellen und die Paketdateien verwenden, um diese Objekte in andere MicroStrategy-Projekte zu importieren. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. 4. exe --ResponseFile="C:\response. A dialog box opens. To add the dependents of all objects to the package, click Add all dependents. This allows object definitions to be maintained in AI results. •Command Manager - Performs various administrative and application development tasks by using text commands that can be save as script. 3% of resumes. Statements consist of one or more tokens. Update Schema. Depending on the options you set in the Object Manager Preferences, you can exclude certain types of dependent objects from this migration. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. Consider an example where 2 datasets are contained in a dossier, and a visualization in the dossier contains objects from both datasets. Before customization: After customization: Follow these steps to achieve this customization:Click Modify to open the Properties dialog box: Security tab. Create a derived element on Quarter (this option is only available in MicroStrategy Web, after executing the report).