In this video I discuss when to use joint element lists in MicroStrategy and demonstrate how to create them. In the right side of the Security. x and newer: - It is required to have attributes for the recipients that contain at least the three following attribute forms. 2) Create Metric2 as the RunningSum of Metric1. This attribute join type is the default setting. Create a Report Services Document 2. It can be achieved quickly and intuitively, within the existing dashboards, on the fly and without relying on IT. Autostyles based on one document can be applied to another document in. If an environment does not already exist, an environment will need to be created first. After you have defined the attributes and their relationships, you are ready to define hierarchies, a way of grouping related. This issue occurs specifically when there are attributes on the document that contain joint-child parent-child relationships. Name the derived metric using the top most text field in the window. Finally, put in on the report. VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine. Configure Bulk Export. This is an update to previous article that did the same with "pure APIs" request. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. For Year, choose an answer, e. Put this Prompt inside a metric, as shown below: Create a report and put this metric in the Report objects window. But in reality, many of these dimensional relationships change over time. The simple key shows how you can identify a calling center with only its Call_Ctr_id. When a joint child attribute, which is an attribute that exists at the intersection of other indirectly related attributes, is added, this affects how the attribute elements and transformation values are displayed. From the left, click Document. x, select 'Project Documentation' from the Tools menu to start the wizard. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as. Specify a name and location for the new security filter and click Save. The attributes should belong to the same hierarchy, e. To apply the same tooltip to every item in the graph, select the Labels and Values category. The relationship filter functionality applies to the Filter Editor, the Report Editor and the Custom Group Editor. It is used to apply database (row-level) security to a MicroStrategy user. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. A blank visualization appears in the dossier. Select the Password protect zip file check box and type a password for the zip file. As you can imagine, the SQL Engine. Right-click on an existing environment and choose Properties. , the New York store is part of the Northeast Region. Select 'Configure Bulk Export': Specify any additional desired configuration options. x and in the New Grid window, select Report Builder and click 'OK', as shown below: On the next screen, select the attributes to include on the report. Populate and Evaluate: Fill report data required for display. While this code may apply to other releases directly, MicroStrategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. Typically, dimensional hierarchies are presented as independent of time, e. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 0, a VLDB property is available to control the join behavior between component metrics in a nested compound metric: "Nested Aggregation Outer Join," located under Joins in the. Browse to the filter you want to convert and click Open. Toggling selections in the parent selector does not populate the child selector correctly in MicroStrategy Web 9. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Add the 'Month to Date' transformation. Open the Workstation window. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. You link directly related attributes to each other by defining parent-child relationships, as explained in Attribute relationships. Click Advanced, then New to create a custom subtotal. Go to Project Configuration > Database Instances > Connection Mapping as seen below: Click on New to create a new Connection Map and fill in the Criteria for the USA users for their connection mapping, as shown below: Note: When creating a new connection map, the users can choose from the following two types of database instances. Insert an HTML container (and not an image) and insert the script below. x. under the "Insert" menu. 3. Create the report with 3 attributes and 1 metric. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER. Right-click the table and select Create Attribute. In MicroStrategy Web, open the document in Design or Editable Mode. 3. The connection process to Excel files involves the following steps: To connect to Excel file data, you must first prepare the Excel file as a valid data source and create a data source name for the Excel file. Enter a name for the form. This report shows the complete set of data. Expand the Series category. In the left side of the Security Filter Manager, in the Security Filters tab, browse to the security filter that you want to apply, and select that security filter. STEPS TO REPRODUCE: Create an Excel file with the following data. Groups may also be assigned permissions to objects. Basic Card. reg " file (this file will get created in the same folder where the executable resides) Stop and remove MicroStrategy services (if they exist)This video demonstrates how to create custom SQL filters in MicroStrategy. All transformations have the following components: •. Composite keys are constituted. You can only use objects of one type in an object prompt. What is a conditional attribute in MicroStrategy? A user may want to create an attribute with an alternating expression depending on a certain condition, a. The SQL is generated in this way because there is no explicit parent-child relationship between the attributes defined in the logical view. Add the “Component Object” attribute to the filter panel and filter on the metric that is of interest. The Calculated Member dialog opens. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. Right-click in the grid and select New to create a new connection mapping. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as joint child. 0 for databases that do not support Full Outer Joins. ApplySimple("str(#0) + #1", , ) Add the following expression if using Oracle. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. Close the Visualization Builder, and then re-open it. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. Check the box "Apply changes in permissions to all children objects" and "Recursively" to apply it to the. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. Once these Logical views are created, they are available to the report designer in a way similar to any other table. 1. Save the prompt as "Call Center Prompt". Choose Horizontal Bar: Side by Side. Create a file subscription in MicroStrategy Web. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. CA_FI_LEDGER will display finance document detail related to a purchase order. In this case, only one form exists for each, as shown below: A joint child is Microstrategy way of handling Composite Keys. 1 version. ) check box to. Level dialog box. From the Data menu, select Report Data Options. Insert an HTML container (and not an image) and insert the script below. In the Source drop-down list, select Google. In MicroStrategy Tutorial, create an Intelligent Cube with attributes: Year, Category, Subcategory, and a metric M01 with following expression. Create a blank dossier or open an existing one. Copy cleanup. Ø Local Transaction options. This will enable the option to use ApplyComparison’s in Filters. The red lines are used in System Hierarchy graphical view to represent joint child relationships. 3. Add the derived metric to the report and hide it by setting the column width to 0. 5. x, select 'Project Documentation' from the Tools menu to. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so that you get the correct data for reports that use the parent attribute in. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. To create an attribute filter. Create a FreeForm SQL Report and add this nested prompt into it. Follow the steps below: Right-click on the project and select 'Project Configuration. The default join behavior will be "Use minimum relation," regardless of what the setting is set to. reg " file (this file will get created in the same folder where the executable resides) Stop and remove MicroStrategy services (if they exist)In the Hierarchy View tab in MicroStrategy Architect 10. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. This means that two calling centers from different regions can share the same Call_Ctr_id. For example, in the Last Year transformation in the MicroStrategy Tutorial, the member attributes are Year, Quarter, Month, and Day. Add a Joint Element List Filter as: (Year, Subcategory) IN {(2014, Art & Architecture), (2015, TVs), (2016, Pop)}. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingMetric values are not sorted accordingly when two parent attributes of a child attribute and the child attribute are placed together on report, and sort hierarchically by total is enabled in MicroStrategy Developer 9. Similar to scenario 1, three passes are generated. From this script you can learn how to use all those various MicroStrategy REST APIs. Click the name of a report to execute it. In the Filter Editor, use the Object Browser to search for the attributes, metrics, filters, prompts, or reports you want to use in your filter. •. To handle this. 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. Navigate to the Layout Tab. To burst a file subscription across multiple files. Type the Name of the personal view. Select New Option. Copy cleanup. Choose the Light Theme from the drop down menu and click the Apply button. This video demonstrates how to create custom SQL filters in MicroStrategy. To do this: a. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table when the. it’s a very helpful tool for those working as Admin, project designer, project lead/manager (who handles entire BI-MicroStrategy components). . NOTE: Modifying the key form will trigger required updates when saving. Define the advance sort on the derived. The Create New Form Expression dialog box appears. Now, let’s take a look at how we can put this all together in a report using the MicroStrategy Tutorial Project. To change the layout of the walls, in the top menu bar, go to Graph > 3-D Settings: To change other properties, go to Graph > Graph Options: the Marker Shape and Size is on the General tab. Right-click the header of the attribute whose elements you want to use to. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. 4) Next, change the Theme back to None and click Apply. . When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. The following auto text codes allow you to add document variable information to your document. Custom groups; A custom group is a special filter that can be placed on a template and is. The document (PDF) provided by MicroStrategy is very clear to understand and very easy to create any work flow. For this class,. It permits users to create a set of elements from an attribute based on their relationship to another attribute. Its parent and child attributes are highlighted. There's a reason we're at the top of the list. Create a new table "photo_upload" in Tutorial warehouse database (the default location: C:Program FilesMicroStrategyTutorial ReportingTUTORIAL_DATA_7200. Target: The target is the attribute level at which the metric calculation groups. MicroStrategy's Report Builder steps you easily through the process of quick report creation, and lets you access a wide variety of report objects in your project to define your report. Save and close the metric. The first step of the cycle is to quantify the performance by measuring the time spent in each of the components that are part of a Document Execution Request, as described in the preceding sections. This is called heterogeneous column naming. Setting the metric formula join type for. Right-click on the Manager attribute in the page-by and add the Email attribute form. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. Create a joint element list qualification. Joint Element Lists are an advanced filtering qualification in MicroStrategy Developer / SQL Engine that can be used to filter on combinations of attribute element. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. The. 6. The report execution process is a three-step process: 1. select a13. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. x. In short, some attribute elements don't have a relationship with their parent/child attribute. When you create a new user, you need to provide some or all of the following information: Login information. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. This may make related application objects (reports, filters and. To add a derived element to a document, open the document in Editable Mode. Open the Workstation window. Calculate each attribute individual weight according to. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. Composite keys are constituted of two or more columns which together act as unique identifier. Include the prompt in a report and execute it. Source: MicroRooster. 2. From the Tools menu, select Document Properties. On the MicroStrategy Mobile Administrator page, click Mobile Configuration, on the left. You cannot create a relationship on a joint-child attribute, since it is view-only in the Hierarchy Editor. Once these Logical views are created, they are available to. Select any project that is in the project source that contains the users and groups and click Next. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. Step 1) In this step, Go to package (Here Modelling) and right click. This tutorial demonstrates how to create applications with MicroStrategy Mobile. Select only Configuration Objects for documentation. These attributes are then linked with a parent-child relationship. Composite keys are. Change the metric join type to 'Outer'. Both documents and RS dashboards provide the freedom to design a dashboard pixel-by-pixel in multiple editing and previewing modes. For example, a scheduled report executes which shows the Revenue by day for the past week. It will not indicate that the check box is enabled, but this step is mandatory. mstrc) Open Workstation. Method 2. Microstrategy online test with 15 practice questions & some sample questions. The property is named "document grids from multiple datasets" and defaults to enabled but can be set to disabled. Make two grids with different attributes and metrics in each 3. 3. Follow the steps below. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. To apply the same tooltip to every item in the graph, select the Labels and Values category. From the Insert menu, point to Widgets, and then select Microcharts. Right-click an element in the grid and select Calculated Member. 4. From the Select a Project drop-down list, select the project for which to assign the security role. Follow the steps below to reproduce this issue in MicroStrategy Tutorial: This example requires 6 attributes to effectively demonstrate the issue: -Region and Employee, where Region is the parent of Employee (one to many) 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. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. 3. For example, the joint child attribute Promotion is added to the previous report. Right-click the dossier you want to certify. x, select 'Project Documentation' from the Tools menu to start the wizard. In this Data in the Wild episode, we'll show a quick tutorial on how to use advanced filters in MicroStrategy Developer. In MicroStrategy Developer, log in to the project source that contains the MicroStrategy Tutorial project and then log in to MicroStrategy Tutorial. SecurityRegion table defines from which region a user is allowed to view data. _____in MicroStrategy allows you to create any desired view You answered: Both a and b Incorrect Correct answer: Logical view 4. The Grouping panel is displayed. Subtotals across level are displayed at the bottom of the of the grid report instead of distributed under each attribute element In certain reports, users may notice that subtotals defined across level are not broken by attribute element in a grid report in MicroStrategy Developer 9. This technical note explains how to create a joint element list filter in order to choose different criteria for two different attributes in MicroStrategy Developer 9. A user group (or "group" for short) is a collection of users and/or subgroups. NOTE: The aforementioned document and the example in this document use the logical view feature introduced in MicroStrategy 8. Open the dossier you want to modify. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. Joint element list. Groups provide a convenient way to manage a large number of users. Each video ranges from five to fifteen minutes in length,. For example, in the Last Year transformation in the MicroStrategy Tutorial, the member attributes are Year, Quarter, Month, and Day. All attributes used to group data in the report or document are shown in the Available Attributes list. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. From the Administration menu, point to Projects, and select Project Configuration. ; In the MDX Expression, enter arguments for the Apply Simple function. Select Joint Element List from the Option pull-down list. Click Browse. Describe joint child? It is a microstrategy way of conducting composite keys. TN11076 (TN5200-75x-0456): When drilling from a report to a template, the child report inherits the VLDB setting values of the parent report and ignores those set for the template in MicroStrategy 8. In this case, only one form exists for each, as shown below:Create the statistics database instance; Go the project configuration wizard of the project;. If an environment does not already exist, an environment will need to be created first. x with any number of attributes. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. The following steps describes how to create such derived metric. A joint child is Microstrategy way of handling Composite Keys. 4. A joint child is Microstrategy way of handling Composite Keys. The user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor. Choose attribute Call Center and use the Region Filter created in the previous step. You can also select an existing template (see How to Create a Report Based on an Existing Template ). Click Save and Close to save the metric and close. Case functions Microstrategy. In a BI platform, the logical data model is designed and built using current user requirements. You can connect MicroStrategy. ). The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Import the Data. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. In MicroStrategy projects, you explicitly define any direct relationships between attributes. A developer can build simple or compound metrics, apply to them many additional features like conditionality, level, transformation and also specify the formatting. Web Professional. 4. Explanation. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. Select Joint Element List from the Option pull-down list. In the Navigation pane, click Dossiers. - Composite key. Save the report as “Email Bursting”. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Slowly Changing Dimensions. A custom group is made up of an ordered collection of components called custom group elements. The steps to create a dashboard in Microstrategy are as follows: Click on Create on the left side of the Microstrategy web application. MicroStrategy offers an intuitive way to create and modify business. Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Select the chapter that contains the visualization to filter. Recommendation. A joint child is Microstrategy way of handling Composite Keys. Enter a name for the custom group in the Enter Custom Group Name Here field. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. Creating your chart. For example, there. mdb), as shown below: 2. Thanks to MicroStrategy Semantic Graph it is possible to analyze parent-child relations between objects. " Select "Use a filter to reduce the number of elements" and select the "QUARTER FILTER" created in the previous step. For example, the joint child attribute Promotion is added to the previous report. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 2, click Add External Data. Many classes have been developed as short instructional videos ranging from introductory topics such as Intro to Mobile to advanced topics such as Mobile Security. Source: MicroRooster. Composite keys are constituted of two or more columns which together act as unique identifier. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. The following is a procedure that will modify the default setting to create Outer Joins for metrics at the Project level: Procedure: Right-click on the Project name and select Project Configuration. From the Data menu, select Insert New Metric. Under Categories, expand Calculations, and then select MetricJoin Type. From the 'Edit' menu, choose 'Group'. Fact table levels: The context of your data. Step-1 – Click on the “Add Data” option under the “Datasets” tab. It is recommended that HTTP path should be used for reference image. Click Next. 6. Micro Strategy also supports mobile BI. 1, custom group selector does not have the custom group elements, while in 9. Answer: With OLAP services users can create a unique report views by removing or adding attributes and metrics contained within the intelligent cube. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. The elements of a metric level are described below: •. About custom groups. In MicroStrategy projects, you explicitly define any direct relationships between attributes. Examples include "Region = Northeast" or. Since the fact table is at the lowest level, the MicroStrategy Engine finds the join path through the lookup tables. The Select Bursting Criteria options are displayed. The idea here is to force MicroStrategy to use always the SQL code always the calendar lookup table:Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. A blank visualization appears in the dossier. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. Click on mstr to expand the list of CSS files used on the Welcome page. Create a new report in MicroStrategy Developer 10. How to build and manage Intelligent Cubes. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as joint child. In Name, enter a descriptive name for the attribute. exe to this machine. com Format: A MicroStrategy Online Training Video blog. This is a filter which contains a prompt on an attribute element list. The Report Data Options dialog box opens. Case This function evaluates multiple expressions until a condition is. 2. Click Insert Visualization . Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x, select 'Project Documentation' from the Tools menu to. _____ type of filtering raises the report filter to the level of the target. Create an auxiliary metric that uses the 'End on hand' fact but aggregates values one level higher than the one in the report, as shown below: Create a subtotal based on the auxiliary metric, as shown below: Add this new subtotal to the list of available subtotals for the 'End on Hand' metric. Step-1 – Click on “Add Data” option under “Datasets” tab. Form Type. In the right side of the Security. From the Visualizations panel, select Grid . MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so that you get the correct data for reports that use the parent attribute in a joint child attribute. Filter Editor. In the Datasets panel, click More next to the dataset name and choose Edit Dataset to add data to the dataset. The Custom Group Editor appears. xCreate a search object using MicroStrategy defined by the search criteria specified by the user, as shown below: Export the results from the search object to a text file, as shown below: Import the text file to Microsoft Excel, as shown below: Create the macros desired in Microsoft Excel. The Select a Function or Template dialog box opens. Ensure that the project schema for your new attribute is available for editing. Method 1 requires you to create a separate relationship table (in this case, Rel_Color_Item) and add both attribute IDs to the fact table as shown in the following diagram. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. This technical note explains how to create a joint element list filter in order to choose different criteria for two different attributes in MicroStrategy Developer 9. Create New Metric in a report or VI. If a user creates a report with two attributes, for example Country and Warehouse, the user may want to create a joint element list filter in order to choose different. Similarly with the Date attribute. Description: This video demonstrates how to create custom SQL filters in. Select Joint element list from the Option drop-down list. To quickly create a derived metric based on an attribute, right-click the attribute, point to Insert Metric, and select the function. Click on the "Validate" button to validate the formula. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. This video presents some of the new enhancements in MicroStrategy Desktop/Web 10. x, follow the steps below: Create a report with two metrics and at least one attribute, as shown below: Change the report to graph mode. However, in the third pass, when combining the results from the first two passes to generate data for Unit. To handle this case in MicroStrategy we make this set of columns, constituting composite keys, as joint child. Composite keys are constituted of two or more columns which together act as unique identifier. Define base formula? The base formula is used to provide the information of more complex metrics. You can only certify dossiers in the Dossiers area of the Navigation pane. Relationship tables in Microstrategy. x and 10. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Query Stage: Retrieve data from the warehouse. Create a Revenue metric at Category level as below and name it as "A": Sum(Revenue. Follow the steps below to reproduce this issue in MicroStrategy Tutorial: This example requires 6 attributes to effectively demonstrate the issue: -Region and Employee, where Region is the parent of Employee (one to many)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. You can also set the metric join type for a template. Revenue + Profit. Put that filter on the report. The parent-child relationships you create determine the system hierarchy within the project. 3. Select the filter or prompt to place on the metric using one of the following methods: Use the Object Browser to locate the object, then drag it into the Condition definition pane. Choose a project to contain your filter and click Select. Apply the security filter to a user or group. Relate tables contain the ID columns of two or more attributes, which will define associations between them. Steps to create a filter. The report execution is typically a 3 step process process of the below: Query Stage. 5. Users can use Microstrategy Desktop to create reports that access SAP data and join data across SAP BW Info Cubes and Query Cubes as. Microstrategy Document Editor Sections Important Notes: The Layout area is in the center of the Document Editor interface and provides the framework for precisely controlling where controls (such as text fields, grid and graph reports, images, and widgets) are displayed when the document is viewed in different display modes, printed,. How to create attributes in MicroStrategy? Create an Attribute. 06K. . Follow KB5490 to create a prompt-in-prompt using attribute Year and Month, so Year is the parent prompt and Month is the child prompt. Though the Region_id and Reg_id columns have different names, they store the same data: information about regions. The Python script below can be used for such an automation. This video also has a a brief discussion about how to create advanced filters as joint element lists.