7. 4. If you are editing the If function, use the values in step 7. Click on the word "Rank" to highlight and then right-click to show the "Rank" function's menu. Click Insert Visualization . Enter 0 in the Width field. x Users have the option of setting a certain percentage of a metric's values to be displayed by using the. x behavior), put ;-at the end of the level statement (inside the braces). Scorecards, dashboards, and reports can be. Save the metric. You can display the bottom 50% of metric values. It is a variant of MAPE in which the mean absolute percent errors is treated as a. In Microstrategy Tutorial 1. Enter a name for the custom group in the Enter Custom Group Name Here field. On the Template tab, click Change Template to use one of the five card templates. We can do it in three different ways. To calculate the Account Amount, create the following metric, called Actual. Go to the Data menu > Report Data Options > Display > Alias. The "Grouping" property has six possible settings, of which four specify non-aggregating behavior: Beginning (fact) Ending (fact)To Create a Custom Group. Is Null. This knowledge base article documents how to calculate Percentage to Total in a metric subtotal in MicroStrategy Developer 9. The result of this setting is reflected in the GROUP BY clause of the SQL command. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID) To use a special fixed comparison operator (for example, MYCOMPARISON) in a condition (WHERE clause) comparing the IDs of attribute1 and. In the Visualization Gallery, click Combo Chart to create a combination graph. Unless the defaults are changed, the function ranks the values in ascending order by the value of the metric, and the rank is an integer. RMC on Revenue and choose Insert -> Percent to Total -> Grand Total to create the Contribution (%) metric; Consider the following example from MicroStrategy Tutorial: Create a custom group called "Category" which has two group elements, 1 and 2. The Metric Editor opens. Every Command Manager command is represented in this module. How to calculate a metric based on the previous two values of another metric in MicroStrategy Developer 9. Alternatively, from the Data menu, select Show Totals. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. Enter the values to use as arguments. A limitation of the Percent to Total metric used with custom groups is that subtotals for each element of the custom group cannot be calculated properly. In the Datasets panel, click More to the right of the dataset in which you are creating a derived metric and choose Create Metric. The Card Editor appears. Expand the Series category. Insert a new Bar Chart visualization. Formula and dimensionality are the two important components in a metric. This article outlines how to create a value prompt for each row of a report that has a report filter based on 'Top n Rank' of a metric in MicroStrategy Developer This steps below describe method to create a value prompt for each row of a report that has n rows and these rows correspond to elements in the Top n Rank of a metric in MicroStrategy. or. 4. If the selected metric is a transformation shortcut metric, the Metric Editor opens. Step 1. x-10. To calculate a variance or a growth percentage such as last year's revenue versus this year's revenue, a transformation is convenient and flexible, although there are alternatives. Visualize your. To calculate the Account Amount, create the following metric, called Actual Amount, to. KB13828: How to create a grid report showing Pareto (percentage) or cumulative percentages in MicroStrategy Developer 9. In MicroStrategy, users can create an Average metric from an attribute description that. Transformation Metrics: Time-Based and Other Comparisons. Click Next. x-10. The report returns the following data when executed. In this video, you will learn how to create calculated Level Metrics in a dataset inside a Dossier. This data can be sorted by rank by going to Data > Advanced sorting and adding the metric to the sort properties. Now this setting is applied to derived metrics in MicroStrategy Web despite the checkbox not being available in the GUI. Use Workstation. Metrics are calculations performed on your data. Right-click the column (s) or row (s) to see displayed as percents of a total. In MicroStrategy Developer , create two object prompts "Metric_Prompt1" and "Metric_Prompt2" with same definition as shown below: Create a report with Month in rows and two prompts in columns as shown below: Run the report in dual axis line graph mode. To add it we double click on the metric or drag it from the left panel (Data Set Panel) to the right of our newly created percentage metric. The following code demonstrates how to accomplish this: Dynamic aggregation is the process by which metric results at the base level returned by the database are further aggregated in the Analytical Engine in OLAP. Options are: Over Rows: Displays values in each row of the report as percents of an attribute row total. Consider the following example from MicroStrategy Tutorial: Create a custom group called "Category" which has two group elements, 1 and 2. Metric calculations display information at simple as well as complex levels of. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. At this point, the grid should look like this: Create a new dossier. On the Datasets panel, right-click the metric to use to create the derived metric, and select New Metric. Profit Margin = (6-4)/4 which equals 0. In the MDX Cube compound metric editor, a formula enclosed in double quote marks will be treated as a passthrough formula, as illustrated below:In MicroStrategy Web, create a new document with the report as a dataset. This metric will serve as the denominator for the percent to total metric. Consider the following example where a threshold has been applied on values grater than 15% as shown belowIn the Layout category in the Preferences dialog box, select the Re-calculate legend size automatically when data changes check box, and then the Reposition chart frame and legend check box. When a custom group is used, a Percent to Total derived metric sometimes returns incorrect data. Next, right click anywhere under the data source tab and near any of the measure fields. You get all the attributes and metrics as usual. Using rank and percent-to-total metric analysis: You can create derived metrics that display the percent in relation to a selected total of each item affected by the metric or display a ranking. To select the metric (s) for which users can define their filters, on the Definition tab, choose one of the following options: Choose a metric: Browse to and select a specific metric to use. Edit the [% of case] metric, and then set the subtotal at. Create the derived metric as demonstrated below: 3. 2. Type the following for the name: "Total for the #P #0". You can display the top 10% of metric values with a green arrow. You can narrow the list of functions displayed in the pane by doing one of the following: A metric set qualification lets the manager restrict data based on a set of attributes, in this case certain products, based on a metric value, rank, or rank percentage, in this case, inventory count below a certain level. To open a document in Design Mode, from a folder, right-click the document and select Edit. x - 10. You can select any of the values, but you must select at least 2. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. This level must be higher than or equal to the level of aggregation for the metric itself. For example: Run the report as shown below: Percent value for Jan 2007 is 502,224 / 1,682,656=29. The derived metric's value is 12. Enable "Date Values" button on graph tool bar, increase the Categories number to be "12", as shown blow:In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. You have the following options: Break by None: No break by is used and the rank is calculated accounting for each separate item on a report. The New Prompt page opens. This metric will serve as the denominator for the percent to total metric. Click the Options icon . For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. Click Save and Close to save your changes and close the Metric Editor. ACTION: This setting can be controlled through the advanced symbols at the end of a conditional derived metric formula. The selected metric appears, by default, as the first metric. 2) Go to the Data menu > Edit Drill Map. A pop-up appears which shows the create metric option. x Enabling the 'Show Data Labels' and 'Show total' options on a vertical bar:stacked graph will display all of the metric values along with the totals in MicroStrategy Developer 9. Continue creating this derived metric by following the steps to create a summary metric in Using a function to create a subtotal: Creating summary metrics. This report shows the sum of sales for each month, for the previous row and the % change between them. From the Insert menu, select New Metric. Another important observation is not to forget to enable "Smart Metric”. , (comma) Thousands separator. 5. You can define metrics by using the available functions to analyze your data and determine business measures. Follow the next steps to give a metric a customized format: Open the Metric Editor, go to Tools menu, and select either Values or Headers, as illustrated below: Go to the Number tab and select 'Custom'. Open a new or existing dossier. Editing shortcut metrics. In the list of categories on the left, click Subtotals. Create four level metrics as shown below: Create a report with Year, Quarter and Month. In MicroStrategy Developer, choose File > New > Report. Create a derived metric and reserve it for future use in a visualization. 2987. Users may want to create a metric able to calculate the running product of a certain set of values, as shown in the table below:. Metrics are calculations performed on your data. Break byObject: A break by on Object is used to. Save and close the metric definition. Metric with an IF Function. Interactive, Express, etc. Alternatively, 4. Enter a name for the metric in the Metric Name field. Open a report in MicroStrategy Developer or Web. Metrics can be either simple or compound. For the steps below to achieve the requirement in Tutorial project: In MicroStrategy Developer, create a Subtotal object, and input the expression, as shown below: Sum ( ( x / Sum (x) {} )) {@} Save the. Right-click the column (s) or row (s) to see displayed as percents of a total. In the Datasets panel, double-click attributes and metrics to add them to the visualization. 4. A pie or ring chart requires at least one attribute and one metric. Double-click the object. When creating a consolidation, and calculating the percent to total derived metric, the sum of the percentage only adds up to 50%: CAUSE: This issue occurs due to a setting in the VLDB properties that causes the values of the percent contributions of the items in each consolidation to be summed up and then divided by two. Click Switch to Function Editor. All of the freeform SQL reports would have the following format. Create the “% Active Cohorts” metric (Users from a Cohort that have visits in a period) [Total Users]/[Total Users Cohort] 8. They are pretty similar to the formulas you see in spreadsheet software. In report data options change aliasing for new metric to blankThis is a compound metric that calculates the percentage change between the previous row and the current row. For an example of a transformation metric on a report, refer to the Metrics chapter in the Advanced Reporting Guide. Click the name of a report to execute it. the value that should be 1 is displaying 0. For example, the business unit costs are represented by the Account Amount fact, which is the actual amount of each recorded transaction. The report must be in either Grid view or Grid and Graph view. A blank visualization appears in the dossier. Metrics are calculations performed on your data. A simple metric can also contain non-group functions or. These privileges are part of OLAP Services. Project Metrics: It can be used to measure the efficiency of a project team or any testing tools being used by the team members. Search And Destory - WZ3 Waiting Room ----- Wanna Send a TIP!-->. If a metric cannot be created, you can double-click the metric to view a message describing why the metric creation failed. x, only one metric data label is displayed. The calculation can restart based on attributes identified in the parameter settings. To create a shortcut metric on a report,. Run the report. Rank. 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. Create a Report Services Document named Customer Profit and Revenue Document using the above report as a dataset. The fuel for business dashboards is data, so each one needs to have one or more data sources. In this video, you will learn how to create calculated Level Metrics in a dataset inside a Dossier. Click Toggle Totals on the Data toolbar. The Custom Group Editor appears. KB8813: How to create a Percent to Total metric without OLAP Services permissions in Microstrategy Developer. 6. A screen appears where users can choose to create a specific type of value. The percentile refers, thus, to the top part of the percentage in which the item is located. We can do it in three different ways. Summary Table (This is not aggregation of the fact table below) The following steps explain how to create the metrics for the report above: 1. To calculate an average while applying a weight to the values, see. In the Detail Header section, add a panel stack by clicking Insert 'Panel Stack. Click the Format icon . This report shows the sum of sales for each month, for the previous row and the % change between them. Create a second metric defined as Count(Quarter) with the level set to Quarter and grouping set to none. or. From the first drop-down list, select Series Values. If you want to create the metric by defining the metric's formula directly, see Metric Formula Editor. Select Insert Metric and point to Percent To Total. In the Datasets panel, right-click the metric to use to create a derived metric and choose Calculation. Metrics are MicroStrategy objects that represent business measures and key performance indicators. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. When specifying the percentage value using Rank<ByValue=False>, please specify a fraction value between 0 and 1 that corresponds to the percentage value. From a practical perspective, metrics are the calculations performed on data stored in your database, the results of which are displayed on a report. The steps below give a detailed explanation on how to. The metric definition is shown below: Create a metric named 'Rank times Max of 1'. This issue is documented in "KB16618 - Percent to total derived metrics in a report with a custom group in the page axis return lower percentages than expected in MicroStrategy Engine". In MicroStrategy Web 9. At the worst of the bear market (so far) MicroStrategy was down 50% on. To use "By Percent" option for the "Rank" function, perform the following steps: Open a new metric and use the "Rank" function in the metric formula. Derived metrics are not metric objects that can be re-used in other MicroStrategy reports and. ' (a period), as shown below: In Design View, go to the Grid menu > Options > Columns and Rows. 4. Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. From the MicroStrategy home page, click New Metric . Insert a Drop-down selector. The Select a Function. or. The metric condition can be either a filter or a prompt that returns a list of filters. The report automatically updates with the metric column you selected now hidden. Performance Implications of Large and Complex Dossiers. Place 2014 (from Year attribute) in the a report attribute. Set "Join Type" to "Outer Join" for metric "Revenue" in menu:. Click on the word "Rank" to highlight and then right-click to show the "Rank" function's menu. Prerequisite. The break by setting of a metric qualification allows you to choose the attribute level at which to restart counting rank or percent values for a metric. The metric is aggregated at the lowest level on the report, which is Store. This procedure assumes you are already working with a metric in the Metric Editor. Select the "OK" button to insert the new metric into the report. To start, build a report with the attributes Region and Year and the Units Sold metric. When changing the removing the profit derived metric from the data set notice the expected results are returned:If you want to qualify the values of a metric into more than two groups, create a derived metric using the Case function. In MicroStrategy Tutorial, create a new report. Some of the. For steps to create a transformation, see the Project Design Guide. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. x - 10. To select the metric (s) for which users can define their filters, on the Definition tab, choose one of the following options: Choose a metric: Browse to and select a specific metric to use. Note that a custom group, 'Age Groups' from the MicroStrategy Tutorial project, is used in the page-by axis. At this stage, all metrics are available in both S1 and S2, but the order is different. The default metric formatting for currency, displays the dollar sign ($) on the metric without being aligned (two spaces to the left of the first unit). To create the financial data metric In the Datasets panel, click More to the right of the dataset in which you are creating a derived metric and choose Create Metric. Create a new derived metric called MovingDifference with the formula below: MovingDifference<BreakBy = {Country}, SortBy = (Year)>(Revenue,2) It is recommended to build the derived metric using function wizard (the “fx” button in new metric editor) as show below: 2. Start by creating an element. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. To open a document in Design Mode, from a folder, right-click the document and select Edit. Ensure that the Tooltips check box is selected. When inserting a new Percent to Total metric in MicroStrategy Developer 9. The Metric Column Alias Options dialog box opens. Create a new Report R1 with the Subcategory and Item attributes and the Profit metric. - for the percentage columns (also known as compound metrics in MSTR), you can do the same as above and hide the subtotal. You will learn about a couple of Level Metric. Follow the next steps to give a metric a customized format: Open the Metric Editor, go to Tools menu, and select either Values or Headers, as illustrated below: Go to the Number tab and select 'Custom'. Steps are below to create a conditional metric. In MicroStrategy Tutorial, create a metric named Percentage Change in Revenue that calculates the percentage change in revenue as compared to last year's revenue as shown below: Click on Tools in the menu, select Formatting and then click on. Go to Graph Options -> Series, set Profit and Revenue to show as Line and check 'Show Data Labels'. Also practical examples are used in this document in order to illustrate the. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. 4. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab; Percent to Total; Total for each; Chose the level, here Year Metric MF can calculate percent revenue values for each row at its parent time level. The Insert Function dialog box opens. MicroStrategy Percent To Total Shortcut Metric#MicroStrategy #PercentToTotal #Shortcut Metric #SeekhoAsaniSay* * * SUBSCRIBE HERE! * * * ️ of the Report Level's presence on the metric's dimensionality, the MicroStrategy Structured Query Language (SQL) Generation Engine groups by all of the attribute IDs found on the template. To apply the same tooltip to every item in the graph, select the Labels and Values category. Since the YoY Percent Change is a real percentage we need to change the formatting to a percent. Select Add Condition. Direct Cubes over View Reports. See Modifying existing metrics for more detailed instructions. Number of Views 3. From the Position drop-down list, specify whether the legend is positioned to the Right, Left, or at the Bottom of the graph. From the Data menu, choose Advanced Thresholds Editor. The key points are: 1) create the Contribution (%) derived metric in the report instead of in the dashboard; 2) use filtering selector instead of slicing selector. Make sure that both the minimum and maximum number of answers are 1 and that the prompt is required. e. As you grow MOM and quarter over quarter, the power of compounding begins to take effect year over year. On a dual axis graph in Visual Insight, the scale on the axis of a percentage metric displays from 0 to 1 instead of 0% to 100% and cannot be formatted when using MicroStrategy Web 9. To Create a. Continue creating the metric (for example, adding levels or conditionality) . x? Knowledge Base: How to concatenate two. Log in to a project in MicroStrategy Developer. Use the Ctrl key to select multiple attributes and metrics. None, which excludes the attribute in. Metrics are completely reusable - they can be added to different reports or even other metrics. Select Insert Metric and point to Percent To Total. The following explains a workaround for creating a Pareto percentage chart with only one metric that will show the percent to total line and show the legend. KB18705: How to create a custom subtotal to display the grand total of a metric that uses the 'End on hand' metric in Micr… Number of Views 2. A typical case is to create a derived metric to perform calculations between columns of metric data. In addition, a colored badge appears with the percent of increase or decrease. For example, you might choose the. For example, in a report that shows. Step 1 Create a report with Category and sub-category as its two columns. A custom group is a set of special filters that can be placed on a template. This is an OLAP function. This technical note lists the steps to create a stack bar graph that only displays the Totals, in MicroStrategy Developer 9. The metrics are created in the location specified. Save the dashboard. Subtracting one metric from another then dividing it into another number to express a metric as a percentage. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. Enter the values to use as arguments. From the Data menu, choose Thresholds. Setting "ByValue" to False enables the. For example, you may want to see all the customers in a retail store that bring in over $1,000k in revenue per month, or a teach may want to only view data on students who scored over 2000 on their SATs. For the example scenario, select Type a value, and then type 500000. Conditional. 4. Case. (browse) to locate the metric. Create a new dossier, and add the report made in step 2 as a dataset. STEPS TO IMPLEMENT. 4. To define a Metric using a text based value prompt, directly type the prompt name. Add the metric from Step 2 to the report shown above. 4. How to create a column in Microstrategy that contains the sum of another column. 4. Create a report with at least one attribute and two metrics. The report is updated. Click OK to return to the Metric Editor. This technical note lists the steps to create a grid report showing Pareto (percentage) or cumulative percentages in MicroStrategy Developer 9. In this example we will be creating Level Metrics in orde. Once you get to the process of Data Collection, define the following: Choose Data Source that connects MicroStrategy and Metric Insights. To Create a Metric. A user creates a dual axis graph in a document, where one of the axes is used only for percent metrics. The steps below show you how to display and format titles for a graph. Microstrategy - creating a simple percentage column Ask Question. Name the derived metric using the top most text field in the window. Open 'Last Years Dollar Sales' in the metric editor and highlight the 'Transformation' definition as shown below: Drag and drop the transformation 'Last Year. To create a round-down function that produces the following sample results, use the following formula in Metric Editor in MicroStrategy Developer 9. 3) The Origin of the association of the Drill Map has to be set to the Local Template as shown in the image below. Save the cube, and run it to publish. To Display or Hide Existing Grand Totals and Subtotals on a Report. The results of these calculations appear on your dossier. 5. or you can create another metric at Year level and then a metric with does. Percent-to-total and rank shortcut metrics are derived metrics, so the Input Metric Formula dialog box is used to edit them. As to the Month-to-Date(MTD) calculation, creating a table-based transformation, and a transformation metric is a general way. Last updated: Apr 12, 2019. You can create new metrics, called derived metrics, based on attributes and metrics that have already been added to a dossier. Add DM. Create a simple metric. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric that you chose to edit. From the. 4. To Create a Percent-to-Total Shortcut Metric. . Identifies values that are null. The Metric Formula Editor opens. That is, the metric calculates at the level of the target, if possible. Run the report in graph view with Vertical bar >Clustered style. How to calculate the top percent value of a metric based on the Total versus the Row count in MicroStrategy Developer 9. If all conditions are false, a default value is returned. NOTE: If the above drop down list is disabled, the metric is not a compound metric and so smart totaling does not apply. Create a derived metric with formula (Revenue – Revenue) and add to columns 2. 20 (or 20%). Consider the following example from MicroStrategy Tutorial: Create a custom group called "Category" which has two group elements, 1 and 2. Create the metrics as follows: 2. Consolidations are used to specify the data that you want to view in your report. CREATE METRIC "<metric_name>". Click Exit. 4. Update Schema. Create a new Derived. ; In Web: Choose Data > Insert New Metric. This is for example the case when measuring temperatures. To create a Metric Qualification prompt. StatusRefer to following technical note for detailed instructions: KB6012 - How to create a metric that determines the number of business days between two dates in the MicroStrategy Developer 9. The Profit metric is a simple sum of the Profit fact. Click Create on any page, and select New Metric. From the Function drop-down, select the part of the metric that will be filtered on: Metric Value, Rank, or Percent. Modify the date to add 1 year (as to simulate the Last Year value). The Subtotals dialog box opens. Click on the "Validate" button to validate the formula. This metric will display the quotient of 'Max of 1' and 'Rank Revenue' metrics. Click Advanced. Select "Rank parameters". 96K KB17427: How to display the total for a grouping attribute on a graph in a MicroStrategy Developer 9. Clear the Totals check box to remove the standard subtotals. From a practical perspective, metrics are the calculations performed on data stored in your database, the results of which are displayed on a report. Right-click the column (s) or Select the portions of the report for which percent-to-total data is to be displayed. The following steps describes how to create such derived metric. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. If the New Metric dialog box is displayed, click the Empty Metric icon. Click the Options icon . Metrics are similar to formulas in spreadsheet software. x, as shown below:The following template contains metrics #1 and #2 above and the attributes 'Year' and 'Category'. ApplySimple("CONCAT(to_char(#0, 999999) , #1)", , ) Validate the expression. 4. Click Switch to Function Editor. Derived metrics are easy to create and can be made on-the-fly when you are viewing or creating a report, allowing you to create a metric while focusing on a given report. Refer to the following MicroStrategy Knowledge Base technical note for more information on transformation metrics: KB7238: Creating transformation, rank and percent to total metrics in MicroStrategy DeveloperThe formula of a compound metric is based on arithmetic operators and non-group functions. The concat() function can be found in the string functions. Only one filter or prompt can be associated with each metric, but that filter can contain multiple qualifications. Click Next. It can be created using a multitude of means, including: Counting the number of times something happens. Metrics are MicroStrategy objects that represent calculations performed on data. Click Save and Close to save the metric and close. The selected metric appears, by default, as the first metric in the calculation. Follow the next steps to create this type of metric. Create a user-defined subtotal. Step 2. 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. Create a third metric that is defined as a concatenation of the two previous metrics as seen below. For a description of level metrics, including examples, see Level Metrics: Applying the Metric Condition to the Metric Calculation. Define the expression to be used. A second numeric value appears. You can narrow the list of functions displayed in the pane by doing one of the following:In the metric editor, go to Tools > Formatting…. Click on the YoY Percent Change measure then on the Modeling ribbon click the % symbol in the formatting. Also notice the following:A transformation table is a type of relation table, normally used to create a transformation metric. Grouping in a metric level determines how the metric aggregates. Content In order to create a metric in MicroStrategy Visual Insight to filter on a specific attribute, a Case statement function can be used to get the designed results. Type a name for the metric in the Metric Name field. 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. In the Datasets panel, select the metrics you want to combine into a derived metric. The key points are: 1) create the Contribution (%) derived metric in the report instead of in the dashboard; 2) use filtering selector instead of slicing selector. In free-form layout, we provide an intuitive way to let you visually “group” containers together. How are metrics ordered in thresholds in MicroStrategy Developer.