Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. This can be achieved in multiple ways, but this Tech Note will focus on creating a Year to Date metric using a Month or Quarter attribute without using a transformation table. The My Preferences dialog box opens. x-10. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. ) The above example used an Apply function, ApplySimple. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. 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. Quick connections to any data source are combined with one-click sharing of any insight. '. If I select name1 from the prompt, I do need to show all the occurances of. EXAMPLE: Create a filter using the ApplyComparison expression with "like" function embedded. The Filter Editor is displayed. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. To begin, the architecture for dashboard execution is. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. Number of Views 2K. can you guide me as to > where I should use the Applycomparison syntax, > Previusly I was using the Applysimple with. To create metrics to use additional attribute forms as inputs for predictive metrics. ) Add Customer State and Customer to the report. This article describes how to use the applycomparison function to use like with text prompts in MicroStrategy(The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. Since the limit is 0 and ∑ ∞ n = 1 1 n3 / 2 converges, we can conclude that ∑ ∞ n = 1lnn n2 converges. Using this function and given the format in which the column is stored in the MicroStrategy Tutorial (Vmall) warehouse (integer, YYYYMM), the formula will extract the year from the date prompt, multiply it by 100 and add the day number to it, giving it the desired format. Select the source and destination projects. The report execution process is a three-step process: 1. x-10. If an environment does not already exist, an environment will need to be created first. They may be compared in either 2-tier or 3-tier. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. The index. ) are used. Follow the simple steps below to create a datamart report: 1. After installation of this application only thing you have to do is to follow step listed below: Type here text you want to find and press next. com Para jpviva. Next, navigate to the Theme tab. Number of consultants & teachers ___. com] Sent: Friday, July 18, 2008 10:26 AM To: Karan, Divya Subject: RE:[microstrategy-l] How to create a case sensitive value prompted filter in MSTR Posted by sukumar123 on 07/18/2008 11:29:00 AM I am using DB2. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. EXAMPLE. You can only certify dossiers in the Dossiers area of the Navigation pane. With advanced qualifications enabled, double-clicking on the last line in the filter editor or report filter panel reveals the radio button to add an advanced qualification to the filter. The next example uses ApplyComparison. Create a FreeForm SQL Report and add this nested prompt into it. Skip on content. 4 stars with 3896 reviews. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. Hi, if this doesn't work fo r any reason, there is a workaround. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. We will also learn sapply (), lapply () and tapply (). This report shows the sum of sales for each month, for the previous row and the % change between them. The MicroStrategy ONE platform provides access to AI-powered workflows, unlimited data sources, cloud-native technologies, and unparalleled performance to speed up time from data to action. To Create a Combination Graph. Right-click on the project name and select My Preferences. 1. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Starting in MicroStrategy 10. Query Stage: Retrieve data from the warehouse. There's a reason we're at the top of the list. ) are used. 4. IsNotNull(Argument) Argument is a fact or metric. 2. Article Reference Number: KB39231. 4. for each successive object passed. A ragged hierarchy is the one in which the parent or child attribute element of one or more attribute elements are not present in the level immediately above or below the attribute. Select Show advanced qualification. x and newer Loading × Sorry to interruptIn some scenarios, it is necessary to use a database passthrough function (ApplySimple, ApplyComparison, ApplyAgg) to achieve specific query syntax that is not natively generated by the MicroStrategy SQL Generation Engine. Filter Reports using SQL with ApplyComparison and ApplySimple. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. The next example uses ApplyComparison. Select only Configuration Objects for documentation. Go to My Preferences > Editors > Filter Options and. 5. ITtoolbox. Syntax. The following procedure describes how to achieve this: Create the highest level filter. A product bundle (including Web, Intelligence, Analytics, and Distribution) designed to meet the specific needs of power users who create, design, analyze, share, and save MicroStrategy Dossiers, reports, and documents. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. This is a comparison function. ApplyComparison is a 'pass-through' function that builds a SQL comparison expression based on the input string of database-specific SQL syntax. 2. The issue is reproduced in MicroStrategy Tutorial project with the steps below: Create a metric based on the freight fact which is extended to Item attribute with fact extension. Item = 3/4 * 10 = 7. To extend this flexibility to you, MicroStrategy offers 5 functions which allow you to directly supply the SQL you want for a specific piece of the Query: ApplySimple, ApplyAgg, ApplyComparison, ApplyOLAP and ApplyLogical. Patent Nos. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. Click the Editors tab. 1 In some scenarios, users would like to query the latest N days data that are available the database. In the right corner of the dashboard, change the. The next example uses ApplyComparison. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. Save the filter as "Region Filter". Use the MicroStrategy built-in apply (pass-through) functions; Freeform SQL; Apply (pass-through) functions. In earlier versions of the product metrics with different conditions such as the expression 'ApplyComparison("#0 in (select year_id from lu_year where year_id = 2015)",Year@ID)' could not be combined into a single pass of SQL per the SQL Global Optimization. The apply collection can be viewed as a substitute to the loop. In the User Manager, grant the 'User report filter editor' privilege to the user facing this issue. 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. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. This should work (replace regex w something meaningful, do you want this case insensitive etc etc): ApplySimple ("case when #0 ~ 'As Is' then 'As Is' when #0 ~. Example 1 Using an attributeWildcards are special characters which when used in a string comparison such as "like" change its behavior. The definition of the shortcut filter (East Coast) is displayed. Adding an existing D3 Visualization;. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Users may want to create a metric that displays 'NEW' when the display date is later or equal to the selected date and 'OLD' when the display date is earlier than the selected date in MicroStrategy Developer 9. ApplySimple: ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. . If you are looking to learn. 2. Syntax Common to Apply. In MicroStrategy Developer, it may be necessary to create a report that will calculate the year to date total of a metric. Once you have subscribed to MicroStrategy, you will be able to download the MicroStrategy virtual appliance. If all conditions are false, a default value is returned. This custom SQL can be used. To use # as a character rather than a placeholder, use four # characters in a row. I asume you store the elements of the "security-" where clause in the fact table. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. 4. 4 and later. Open “Database instances” in the Categories menu, and click on “SQL Data warehouses”. If I understand right, create a report using the above SQL to generate a single value (it does). This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it seems that the BBDD is ORACLE), and breaks it down by product. Cross-tab stage. Select any project that is in the project source that contains the users and groups and click Next. But, DESC has repeating values. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID)You can use the ApplyComparison function to define custom filters. The next example uses ApplyComparison. Then use this report in a filter along with the advanced qualification which says'ApplyComparison ("#0 in (select distinct fiscal_mo_nbr from days where day_dt=trunc(sysdate-1))", [Fisc Mth Nbr]@ID)'. One common way to do this is to compare the date information you have stored to the current date. Connect to a database instance and drags tables into the canvas. Using system prompts, users can use. ApplyComparison is used to define a filter by populating the WHERE clause in the SQL passed to your RDBMS, and can take facts, attributes, and metrics as input. A user tries to create a custom filter expression in MicroStrategy Desktop 8. 1 and 10. Click Add Condition in the View Filter section to add your filter. MicroStrategy helps business people make faster, better business decisions, empowering them with self-service tools to explore data and share insights in minutes. 3. 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. 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. How to define an advanced qualification using a custom expression to filter on months in MicroStrategy Developer 9. A list of security roles in the project source opens in the main Developer pane. Example: Customer City = Call Center Using ApplyComparisonTo use Apply functions, you must have the Use FreeForm SQL Editor privilege. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Go to the Editors section and select Filter. Labels: #Recursive hierarchies microstrategy #Recursive Hierarchy. Populate and Evaluate: Fill report data required for display. Choose folders where you want to find the text and press next. Cards can be consumed in a web browser via the MicroStrategy HyperIntelligence Chrome extension and on iOS devices via the MicroStrategy. A blank visualization appears in the dossier. ApplyComparison() Accepts facts, attributes, and metrics as input. 0. Details of Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. Case. 1 and 10. If SQL is required for another database platform, users need to contact their database administrator to do so. 1. Create a tie-breaker / unique-ranking metric using the [running count] analytical function: Right-click on the RunningCount function name and choose 'parameters': Set the sorting order to be [UNIT PRICE] and [UNIT COST]. I've been all over Microstrategy community and have tried possible solutions/formatting etc. The template looks like the following: In this sample workflow, you want to return the newly created filter and its. 11 a new optimization is available for metrics with complex custom logic SQL filters using applycomparison. If you can use an Oracle 'function' instead of a stored procedure, you could setup a filter containing the function inside a MicroStrategy ApplyComparison (). But, DESC has repeating values. You will see that R2 still displays the first 6 months data. 3. They act as containers for non-standard SQL expressions that MicroStrategy does not support. 5. Execute the report and add a Subtotal (Average). ittoolbox. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. There are three types of objects: schema objects, application objects, and configuration objects. Right-click on an existing environment and choose Properties. Right click and "Run as Administrator" to. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. If I select name1 from the prompt, I do need to show all the occurances of. A icon appears in the upper left corner of the source visualization. In this article we will discuss the ApplySimple function. Dashboard performance troubleshooting in MicroStrategy 10. 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. ApplyComparisonStep 3. x using the ApplyLogic function, as illustrated below. Returns TRUE if value is not NULL; otherwise returns FALSE. In this case, enter 'Date@ID'. Select only Configuration Objects for documentation. Instead, you can use an ApplyComparison function in a custom expression qualification filter to search for this symbol. To solve this problem, the ApplyComparison. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. Open MicroStrategy Developer. 3. x. An example of a business case in which this could be useful is using a filter-based slider selector to target a grid/graph object in Web in order to filter it down to a user's. Overall, more than 87. ApplyComparison is commonly used to create custom filters. Create a report with Region attribute in the row, and add the above filter. Plus, it connects business apps while integrating data. Select Filter definition prompt -> Choose from an attribute element list as shown below. If you are looking to learn. Example: Customer City = Call Center Using ApplyComparisonSet the qualification type to 'Custom'. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. Now, if I create an attribute on the DESC itself, I do get a unique list of values to be shown in the prompt , but, the report results get messed up. Number of years active 18. Syntax Common to Apply Functions. 1. 1) Adding a view filter to the report where Sum Metric != 0 which will bring only non zero values. 1. 00% Whether there are values or not. . MicroStrategy Developer allows expressions to be created where an element list prompts is one of the arguments to a passthrough function; however. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. From the Tools menu, select Document Properties. With MicroStrategy, you can deploy data on-premise, in the cloud, or with the hybrid of both. A dataset is a standard MicroStrategy report. Powering. From the first drop-down menu, select the form you want to filter data based on. How to get the latest N days data that are available in database in MicroStrategy Developer 9. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. In SQL View look at where the cross join appears, and between which tables the cross join appears. The filter on this will be "where <> '-' " and there is no need to use. To enable a visualization to filter or highlight the data in another visualization. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 11K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL. 2. x using an Oracl… Number of Views 6. 2. No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a report based on the results of a SQL query. Based on verified reviews from real users in the Analytics and Business Intelligence Platforms market. If you want to use a data range in your filter, select Between. Click OK. The report execution is typically a 3 step process process of the below: Query Stage. Example: Customer City = Call Center Using ApplyComparison To use Apply functions, you must have the Use FreeForm SQL Editor privilege. Click Save and Update Schema. Visit the data visualization and data dashboard galleries for inspiration. To create a custom expression filter, the Advanced Qualification Editor must be enabled in the user's project preferences in MicroStrategy Developer 9. Continue creating the metric (for example, adding levels or conditionality) . Click Certify. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a. Double click on your Report Filter and you’ll now have the option to add an Advanced Qualification: You can then provide the code for the ApplyComparison. Choose one of the following: Save the metric. To Access an Advanced Filter Qualification. From the Tools menu, select Report Options. Now, if I create an attribute on the DESC itself, I do get a unique list of values to be shown in the prompt , but, the report results get messed up. For example, while the Lag function can. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. This type of operator includes And, Or, and Not. Apply (Pass-Through) Functions. MicroStrategy - Metric Comparison. 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. MSTR has evolved dashboards to the point that. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. The Document Properties dialog box opens. 0. For filters, the ApplyComparison and ApplySimple functions are most useful, although you can also use Apply functions to create metrics and prompts. Number of offices 3. Save the report as “Email Bursting”. September 06, 2018. Follow the steps below. The “SQL” portion of your code always come. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. Create an attribute element prompt for Month. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. Object prompts can be created using. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. Some key things to understand when making these formulas. How to create a dynamic custom group to display a set of date ranges in Microstrategy Developer. Set up the VLDB settings for metric join type and SQL GO. Transformations allow you to apply an attribute-element based offset to compare metric data. The elements of a metric level are described below: •. 62K. In the last field, type the value (s) or click the calendar to select a. Filter Reports using SQL with ApplyComparison and ApplySimple. For the Time hierarchy, the offset can. mstrc”. ApplyComparison. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. Continue with the previous Steps 2 and 3 above. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. MicroStrategy use TLS v1. Open the dossier you want to modify. 2) Create Metric2 as the RunningSum of Metric1. 4. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom expressions using a. ApplySimple() Accepts facts, attributes, and metrics as input. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. This week I bring a very useful functionality in MicroStrategy: Pass-through functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query. In the MicroStrategy Developer File menu, point to New > Filter. Starting in MicroStrategy 10. ApplyComparison. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to. Apply functions: These functions provide access to functions and syntactic constructs that are not standard in MicroStrategy but are offered by various relational database. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. . CONTENTS 1. Hover over the visualization to use as the source and click More in the top right and choose Select Target. If you are looking to learn. 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. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. This article describes how to use the applycomparison function to use like with text prompts in MicroStrategy (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. Using the "Month" attribute as an example, follow the steps below to create a dynamic filter in the Microstrategy Tutorial project: Create a filter from Developer and select "Add an advanced qualification", as shown below: Select "Custom expression" under "option" drop-down list, as shown below:Filter Reports using SQL with ApplyComparison and ApplySimple. There is no functional difference between the two symbols. Microstrategy Dossiers With the release of MicroStrategy 10. ApplyComparison ("#0 in (SELECT MAX(WK_IDNT)FROM TIME_DAY_DM WHERE. In Teradata, the Extract function returns the month, day or year from a date field. Note: To avoid user permission conflicts, the following steps must be performed with highest privileges. 5% of users said that the platform is easy to use, with a user-friendly drag. x. Example 1 Using an attribute ApplySimple ("Datediff (YY, #0,getdate ())", [BIRTH_DATE]) Example 2 Using an attribute ApplySimple ("Months_between (sysdate,#0)",. 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. 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. The fuel for business dashboards is data, so each one needs to have one or more data sources. A user tries to create a custom filter expression in MicroStrategy Desktop 8. See this difference in Joins Across Datasets and Document/dashboard best practice. It can connect to data warehouses, relational systems, flat files, web. Back to the Report. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. How to create a MicroStrategy connection file (. Example: Customer City = Call Center Using ApplyComparisonYou can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. 1 comment. x . Using Prompts and ApplySimple Statements. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. MicroStrategy. --- mahuamitra via microstrategy-l wrote: > > Thanks for the quick reply. 1001 to 5000 Employees. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Check out real reviews verified by Gartner to see how MicroStrategy compares to its competitors and find the best software or service for. likes. The Security Role Editor opens. Click OK. Apply Comparison – Techniques _ Microstrategy Blog. For more details, click the link corresponding to each function. For example, today is 10/15, the user would like to get the latest 2 days data while there is only data between 10/1~10/10 available in the. For details, see Comparison Operators. The examples shown below were created in the MicroStrategy Tutorial project. Create a new attribute form for the attribute that the qualification will be based on. ApplyAgg. . Simple drag-and-drop tools are paired with intuitive visualizations. 11 where metrics with complex custom SQL logic filters can be combined into a single pass of SQL through global optimization when a feature flag is enabled. Open a new or existing dossier. This feature is only implemented for element list prompts. all to no avail. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. x. e. Creating metrics on-the-fly: derived metrics, Defining attribute elements on-the-fly: derived elements, Filtering data on the fly: view filters and metric filters, Importing data as an. One or more of the following patents may apply to the product sold herein: U. The next example uses ApplyComparison. Click Insert Visualization . AMPERE blog on Microstrategy development and issues faced during development, deployment and maintenance. A simple application of this technique is to use a constant value prompt in your project as a multiplier of metric data: ApplySimple (" ( [Measures]. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. g. 1 and 10. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy (turning it into a traditional snowflake schema). ApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same. It allows users to customize data visualizations and build personalized real-time dashboards. Target: The target is the attribute level at which the metric calculation groups. A blank visualization appears in the dossier. In the Subscription Editor, click Burst…. Every request to a MicroStrategy Web product corresponds to a. the Administration menu -> Projects in MicroStrategy Developer as shown. This is a single-value function. 2 by default. Data can be connected through an API, flat file, or database. This is usually ID. You must use the ApplyComparison and when you create the filter use Advanced Qualification. Overall, more than 87. To Access an Advanced Filter Qualification. Case can be used for categorizing data based on multiple conditions. A bubble chart (aka bubble plot) is an extension of the scatter plot used to look at relationships between three numeric variables. In MicroStrategy Web, open the document in Design or Editable Mode. Create an advanced filter qualification. Cheers. 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. Select the attributes and facts from that table. ) The above example used an Apply function, ApplySimple. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. Intelligence Everywhere. ApplyComparison ("Upper (#0) like. To create a MicroStrategy Environment connection file . For example, a transformation metric can help a user compare last month's revenue to this month's revenue. 4. When evaluating different solutions, potential buyers compare competencies in categories such as evaluation and contracting, integration and deployment, service and support, and specific product capabilities. 3. Level metrics allows the users to choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. The next example uses ApplyComparison. Is Null.