VLDB Properties. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. In MicroStrategy, attributes are identified by the column headers of reports. Form groups in Microstrategy - Form groups in Microstrategy courses with reference manuals and examples pdf. Compound Metrics. Replace. x?; Knowledge Base: How to concatenate two. This allows developers to model attributes and facts whose. If you are leveraging Web ASP, see KB484127 to use this feature. x? Number of Views 6. Subqueries (or correlated subqueries) are used infrequently but significantly in the MicroStrategy SQL Generation Engine. 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. You can re-use the same formula in multiple metric definitions. Using the description tables and Ids, the attribute information is stored. This is the essence of a joint child relationship. To Create an Attribute-To-Attribute Qualification Filter. This knowledge base article documents the process of creating compound keys for attributes in MicroStrategy Developer 9. Enter a Form name and Description. WORKAROUND: There are a couple of options to workaround this limitation. Dataset DS2 with attribute 'Year' and metrics 'Revenue', 'Profit', 'Profit Margin' (this is a compound smart metric calculated from metrics Revenue and Profit). There's a reason we're at the top of the list. Compound attributes. 1/10. 3. If you know of better/faster ways, please share. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. It is used with database-specific OLAP functions such as Rank(). For example, in the image below the document level global lookup table uses two-key (or two-ID) sorting, while the lookup tables use a single key (ID) sorting. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. All the forms for the selected attribute will be displayed. Drag the prompt onto the Definition pane at the bottom right, as shown in the image. Create Dossier and Chapter Filters. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms. In SQL, the formula commonly becomes part of the SELECT clause of the SQL command. Apply Filter Changes. Attributes provide a. This attribute join type is the default setting. See Column data descriptions and identifiers. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. 1, users can map attributes during Data Import to existing attributes. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. The MicroStrategy SQL Engine does not require a pure dimensional model and has built-in support for many constructs that are typical in Entity-Relationship (ER) schemas such as compound keys, many-to-many relationships, fact. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. 4 Basic Functions are supported by the MicroStrategy Analytical Engine: First. This join type lets you display only those attribute elements that are common to the lookup tables and the fact tables in your data warehouse. We recommend the latest version. MicroStrategy Object Manager makes a list of all object dependencies before copying an object to prevent metadata inconsistency. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. Metrics: Component Objects. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the formatting will not show correctly when viewed. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. For large metadata and complex schemas, gathering all the dependencies may take a long time. All articles. If the Object Browser is not displayed, from the View menu select Object Browser. Click OK. Split Hierarchy with M-M relationships: Explanation. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. A compound attribute is an attribute with multiple columns specified as the ID column. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. Generally, you build a compound attribute when your logical data model reflects that a. 13. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. This article describes why an attribute with a compound ID may fail the execution of a dossier if the compound ID has locale sorting that is inconsistent with the order by the. Click here to view help for the latest version of this product or search MicroStrategy Community. Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. Heterogeneous mapping allows the engine to perform joins on unlike column names. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. , Attributes, Facts, Hierarchies, partition mappings, Tables or Transformation). 8K views 4 years ago n this brief video tutorial, Stephen Goodson, a senior instructor. (Optional) Use the Up and Down. Attribute_ID1 = “,A1,” AND a11. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. DATE and DIM_DATE. Ensure that the project schema for your new attribute is available for editing. In the pane, begin typing the metric formula. This implies that more than one ID column is needed to uniquely identify the elements of that attribute (see Attributes with multiple ID columns: Compound attributes). The ApplyOLAP function is used to define compound metrics. 1 and 10. In MicroStrategy, create an attribute that can return all the location data for each entry. Consider the sales figures of your company. Unique identifiers denote the key that maps an attribute to its source data in the source system, when applicable. Answer / nadia sheikh. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Each of these compound metric types is described with examples below. J2EE environment:A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). Creating Compound Attributes MicroStrategy Community 3. Example for this can be a database of airports around the world. A compound attribute is an attribute that consists of more than one atomic attribute through an object join or member terminals that use dot notation. For the Time hierarchy, the offset can. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. x, the Report Objects window shows the same attribute form multiple times, as shown: In the above example, the 'Store ID' form shows up twice. A compound attribute is an attribute that consists of more than one atomic attribute through an object join or member terminals that use dot notation. Click the Add icon to the right of the Element list. SUMMARY: This technote describes a current defect in MicroStrategy Web 9. An attribute-to-attribute qualification can compare the City form of both attributes to display only the Call Centers and Customer Cities that are in the same city. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. Right-click a derived metric and choose Edit. compound attributes. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. Attribute ID form expressions will always appear in the group by clause, because this is necessary to define the aggregation level for the query. Option A 1. Click Insert Visualization . The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. For this reason, a metric qualification in a filter is a type of set qualification. Relate tables are often used to create relationships between. MicroStrategy builds the rules that MicroStrategy SQL Engine uses to generate SQL when a report request is made. The prompt displays the related attribute elements for users to select their filter criteria from. In MicroStrategy Workstation, architects can create and edit attribute objects. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. A compound attribute is an attribute with multiple columns specified as the ID column. SYMPTOM: In Visual Insight in. 1 : In the Project Creation Assistant, click Create attributes. x and 10. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the. During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. In the Actions column, select the Edit icon for the user to modify. To create a compound key (composite key), users must create multiple attribute forms, group them together, and set the form group as the key for the attribute. The attribute level follows a consecutive order from. This technote describes a current defect in MicroStrategy Distribution Services 9. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Mode. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. The multiple columns are joined with other. 939 views 3 years ago. In the Editor panel, click Add Column Set to create another column set. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Whenever the attributes in Report Objects are not the same as the attributes on the grid, dynamic aggregation has occurred. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. These attributes require a compound primary key in the data warehouse to uniquely identify their elements. 09%) is another ROIC powerhouse with rock-solid demand stability and a balance sheet that supports continued dividend growth. To ensure consistency between the metadata and the object cache, remember to update the schema after schema object modifications (i. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. ) In the metric formula, the desired output dimensionality is given. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. HyperIntelligence allows you to add various, or alternate, forms of the keyword attribute for matching. The derived metric aggregates at the level of the attributes on the visualization by default. 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. Therefore, if a base metric appears in the template, Metric. xml, contains the information used to map ESRI geo attributes to the corresponding attributes in the MicroStrategy metadata. 2, the selector will not work if using the Include option for the selector. For example:By adding simple dummy attributes you are able to arrange the columns in a much more tidy form without even touching the original data. However it. HistogramMedian. Depending on your MicroStrategy product and licensing, this function may not be available. DATE@ID) My. 4. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Select a Form category, Display type and Default sort from the lists. DATE ie. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. All placeholders must begin with #0 and increase in increments of 1. Edit the evaluation order for the report: set Total to 1, metric. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. 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. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. Sometimes you don’t have all the columns that are necessary for creating your visualizations. Learn how to switch to a compound grid, add column sets in this new visualization. xattributes (list or None, optional): ID numbers of attributes to be included in the filter. To uniquely identify a distribution center, one must know two details about the. This is a compound metric that calculates the percentage change between the previous row and the current row. Micro Strategy also supports mobile BI. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. 2. Starting in MicroStrategy 11. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and. In MicroStrategy 2020, the metric guide is supported and will guide the Engine to retrieve the metric from the correct table. The metric formula defines the data to be used and the calculations to be performed on the data. From the Insert menu, select New Metric. You cannot change the join types of. Create a new attribute where the boolean datatype is used as an id form. MicroStrategy's default technique is to write description form expressions into the SQL Max() function. Steps to Create Smart Attributes. Formula: Is a mathematical expression using one or more functions, applied to the data to be used in the calculation (facts, attributes, constants, or metrics). Sorin is a MicroStrategy specialist, experienced in Retail. Only two leading objects are defined in the query language. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. It's. Follow the steps below to create a metric that counts the unique combination of two different attributes: 1. MicroStrategy can help you with that, with the creation of derived attributes and metrics. Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold) 8) Mention what types of testing can be carried out over the Microstrategy reports? Microstrategy can carry out test like • Naming convention tests • Total calculations test • SQL query validations • Attribute and metric. desired view using MicroStrategy, without DBA involvement. This information can help define primary keys in the physical warehouse schema (see Uniquely identifying data in tables. 4. 4. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Knowledge Base: Working with Compound Grids in MicroStrategy 2020;. Use the Object Browser on the left to locate the prompt to add to the metric's definition. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. This article notes a limitation of mapping MDX attributes to schema mapped attributesFor example: Simple or Compound Metrics . 11 hours ago · 2. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. A derived metric is a calculation based on metric data included in the report definition. It is used to apply database (row-level) security to a MicroStrategy user. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. Select a Form category, Display type and Default sort from the lists. Types of filters in Microstrategy Below are the types of filters: 1. Attribute_ID2= “,B1,”)”). Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Steps to Reproduce on a Compound Grid. Create a new dataset DS1:In MicroStrategy Web 9. A calculated expression is a metric that is calculated dynamically when the document is executed, directly from metrics on a document dataset. Attributes give users context for reporting on and analyzing data. 71K subscribers Subscribe 2. 0. This URL executes a report with one prompt. 0: Profit/Revenue. microstrategy attribute selector values wtd mtd qtd ytd An alternative approach, which meets the time period requirement and reduces the time to market of the analytical application is creating a Custom Group with the time periods, then using a selector on the Report Services Document to filter the data by the time periods. A compound key attribute is an attribute that has two or more IDs. Any of the lookup table columns can be set as the attribute key by using 'Set as key' feature, but only the forms that are actual primary keys in the lookup tables should be used. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. This join type lets you display only those attribute elements that are common to the lookup tables and the fact tables in your data warehouse. Each attribute form must have at least one expression. Create a. Featured on Meta Update: New Colors Launched. The Metric Editor opens. or. Attribute having more than one ID from category. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. However, on editing the attribute, this form appears only once as. Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold) 8) Mention what types of testing can be carried out over the Microstrategy reports? Microstrategy can carry out test like • Naming convention tests • Total calculations test • SQL query validations • Attribute and metric. Example A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Add data to the report and leverage formatting capabilities. Creating attributes with multiple ID columns: Compound attributes • Modifying how to use attributes to browse and report on data • Specifying attribute roles: Attributes that use the same lookup • Supporting data internationalization for attribute elements Modifying attributes with the Properties pane A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. This name change is visible in. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. Metrics: Component Objects. Recommendation. These units are part of an attribute, for example, Customer. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. This article notes a limitation of mapping MDX attributes to schema mapped attributes For example: Simple or Compound Metrics . Follow the steps below. MicroStrategy recommends to have only one child at the lowest level. Attribute_ID1 = “,A1,” AND a11. 10) Define different types of attributes in Microstrategy desktop? Answer: Compound Key Attribute Implicit Attributes Derived Attributes Simple Attribute. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. I have a metric A = Avg(0. A compound attribute is defined as an attribute with more than one column specified as the ID column. In the relational database. In this case, Promotion has a many-to-many relationship to both Item and Quarter. The attributes and metrics appear as filters. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. The Grid Settings section allows you to select the Fit to page option, which fits the grid's width onto one PDF page width, or you can select the Allow horizontal pagination option, which breaks a wide grid onto numerous pages. 176. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. Most attributes have at least two forms, ID and description (Desc). In MicroStrategy, users can create compound metrics belonging to MDX Cubes imported from multidimensional data sources such as SAP BW, Microsoft Analysis Services, or Hyperion Essbase. ". Due to how the editor works it is not possible to force this restriction upon creation. In Desktop 2020 you can only use attributes in rows. This article notes a limitation of MDX data sources for filters on different levelsStarting in MicroStrategy 10. Grid Settings You can choose how to export wide grids. The resulting SQL will contain just the Metric Alias. These commands can be compiled into script files and run from a graphical interface or from the command line. Following examples uses MicroStrategy Tutorial project to demonstrate the problem and solution. Create an Attribute Open the Workstation. a compound key is a primary key consisting of more than one=. Click OK. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. Select the check box for any smart attribute that needs to be created. leading_object{. Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. This article describes an issue in MicroStrategy where SQL will not be generated correctly when using an attribute with a compound ID in a metric without specifying a form. The Year - Define a new member attribute. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. x-10. Attribute_ID2= “,B1,”)”). MicroStrategy download site to. The Results Preview dialog box opens. Make two grids with different attributes and metrics in each 3. This article does contain a solution. An additional modeling convention is to add unique identifiers for each attribute and fact. Custom number formatting symbols. It is now possible to format column groups differently, freely alternate the placement of metrics and attributes in the column headers for each group of columns, or choose which columns of the Grid should show the subtotal value or all values. In the relational database. For example, in the MicroStrategy Tutorial project, the Time hierarchy includes relationships between the attributes Year, Quarter, Month of Year, Month, and Day. Enter a Form name and Description. This section focuses on the VLDB properties that are set at the metric and report level. What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. Create your metric's formula. A compound attribute is an attribute with multiple columns specified as the ID column. If you include Customer on a report with both Last Name and Address. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. 10869 views | September 04, 2020 01:10. A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). This design may look strange, but in most cases there are. 4. A compound key attribute is an attribute that has two or more IDs. In MicroStrategy Workstation, architects can create and edit attribute objects. The Category attribute of the MicroStrategy Tutorial project shown below is used as an example of how you can modify and view attributes using Architect. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. Dynamic aggregation occurs when you move an attribute from the report grid to the Report Objects pane. Four types of direct relationships can exist between related attributes, and these relationships are defined by the attribute elements that exist in the related attributes. 4. On the Attribute Forms editor, click the Current Attribute drop-down and select an attribute. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. The purpose of filtering these tables is to obtain datasets that have a common attribute, but different values for it to ensure no overlap. This design may look strange, but in most cases there are sound. Configuration Objects:. The following steps demonstrate how to design this kind of report in MicroStrategy Tutorial project as shown below:The Cognos reporting can be considerably slow in performance than the microstrategy reporting. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. Metrics used to define the calculated metric can come from different datasets. Creating attributes with multiple ID columns: Compound attributes. In the right corner of the dashboard, change the. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. Metrics can be calculated to any attribute level in Report Objects regardless of whether that attribute is on the report template. If list is empty, no attributes will be selected and metric data will be aggregated. You can use derived metrics to. In this case, the partition is defined by YEAR_ID and REGION_ID:. 1. This URL executes a report with one prompt. In the list of categories on the left, click Subtotals. There's a reason we're at the top of the list. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. : ToString("Coal") Then add this attribute to the compound grid Columns group:A compound attribute is defined as an attribute with more than one column specified as the ID column. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to. This attribute join type is the default setting. In MicroStrategy Developer, go to File > New > Metric. The Promotion attribute is related to a particular Item-Quarter pair, as opposed to it being related to Item and Quarter separately. Attribute description forms can be rendered into SQL in two ways. The following procedure describes how to achieve this: Create the highest level filter. Today, we are covering how to create derived attributes and metrics in MicroStrategy. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. Under 'Source tables', select a table and click 'Set as Lookup'. Mapping is required only if you want to display areas on your map on a local server. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Report R contains attribute T. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. The corresponding attributes and metrics in this local schema only. Drag attributes or metrics from the Datasets panel to the Filter panel. x-10. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. If the base metrics are selected to return to the end user in the same pass that calculates the compound metric, since the temporary tables containing data for base metrics are full outer joined, as long as an element has value for either of the base metrics, the row appears in the final grid view. Learn how to switch to a compound grid, add column sets in this new visualization. it seems like a small gap to breach to finalize this API endpoint. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Scenario: Attribute1 is a compound key attribute with a. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. x. In Desktop 2020 you can only use attributes in rows. For example, the attribute name (original object name) is called, Category. Metrics made up of metrics: Compound metrics. A compound key attribute is an attribute that has two or more IDs. And leverage the Page-By function to focus your analysis on one element. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. The MicroStrategy SQL Engine does not require a pure dimensional model and has built-in support for many constructs that are typical in Entity-Relationship (ER) schemas such as compound keys, many-to-many relationships, fact. Press and hold the Ctrl key to select multiple attributes or metrics. In this case, enter 'Date@ID'. VLDB properties allow you to customize the SQL that MicroStrategy generates. Problem. 4. e. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges to create derived metrics. A title bar allows MicroStrategy Web users to minimize and maximize the Grid/Graph, and it provides an identifier for the Grid/Graph in all views.