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. 4. The script inside the " " always depends on the type of database used and can. 4 stars with 3896 reviews. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Notice that a joint child relationship can be one-to-many or many-to-many. Example 1. ApplyComparison. Overall, more than 87. MicroStrategy URL Parameters. Example: Customer City = Call Center Using ApplyComparison The steps below demonstrate how to create a filter that qualifies on months prior to the current month using a custom expression in an advanced qualification in MicroStrategy Developer 9. It can connect to data warehouses, relational systems, flat files, web. 2. Create an attribute element prompt for Month. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9 Open a project source in Object Manager. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. If you’re a Power BI user, you’ll be pretty much at home with MicroStrategy since both use similar analytics tools and share a common semantic layer. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. 00% Whether there are values or not. It allows users to customize data visualizations and build personalized real-time dashboards. 0. Intelligence Everywhere. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. Case can be used for categorizing data based on multiple conditions. Follow the simple steps below to create a datamart report: 1 In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. The Intelligence Server won't enforce the "Use Freeform SQL Editor" privilege for the end-users who are using ApplyX functions in these projects, and will enforce the privilege for all other projects. KB20000: How to create dynamic dates using MicroStrategy Developer 9. ApplyComparison. The Subtotals dialog box opens. ApplyComparison ("Upper (#0) like. 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. Project and schema locking prevent multiple users sessions. The next example uses ApplyComparison. Exercise 4. 4. Filter Reports using SQL with ApplyComparison and ApplySimple. 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. I've been all over Microstrategy community and have tried possible solutions/formatting etc. To make Apply functions, to must have the Use FreeForm SQL Publications privilege. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. The report execution process is a three-step process: 1. From the next drop-down menu, select the operator that describes how you want to filter data. How to implement attribute form expression using Apply Functions in MicroStrategy Developer Apply functions can be used in the attribute editor to provide access to functionality that is not standard in MicroStrategy, but available from the Relational Database Management System (RDBMS), such as the special functions or syntactic constructs. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Populate & Evaluate Stage. 9 billion. 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. Microstrategy Dossiers With the release of MicroStrategy 10. Once you have subscribed to MicroStrategy, you will be able to download the MicroStrategy virtual appliance. How to define an advanced qualification using a custom expression to filter on months in MicroStrategy Developer 9. Back to the Report. Visit the data visualization and data dashboard galleries for inspiration. Sometimes it’s easier to push the functions to the database level. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. You must use the ApplyComparison and when you create the filter use Advanced Qualification. . ,. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. There's a reason we're at the top of the list. . Select only Configuration Objects for documentation. 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. Visit the data visualization and data dashboard galleries for inspiration. 2. In this article, we raised two workarounds to help. Security filters enable you to control what warehouse data users can see when that data is accessed through MicroStrategy. To resolve this issue, follow the steps below: Log into the project source as a user with System Administrator privileges. 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). Syntax Common to Apply Functions. Create a FreeForm SQL Report and add this nested prompt into it. In MicroStrategy 2021 Update 5, in order to achieve better performance, for selected Gateways, the SQL Engine will push down the case function to calculate in the databases. Skip on content. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. They act as containers for non-standard SQL expressions that MicroStrategy does not support. x. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. To create a MicroStrategy Environment connection file . None. When used inside a string comparison statement they are a. MicroStrategy - Metric Comparison. CONTENTS 1. 2) Create Metric2 as the RunningSum of Metric1. ApplyLogic where logical operators (And, Or, etc. Starting in MicroStrategy 10. Instead of filtering on Region directly, its qualification may be written into an ApplyComparison expression, which uses a CASE statement to affect the condition's outcome. 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. Create another report R2 with Year, Month, Revenue and use R1 as filter. 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. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. Select any project that is in the project source that contains the users and groups and click Next. Save and assign a name to the file like “My_first_connection_file. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. From: sukumar123 via microstrategy-l [mailto:microstrategy-l@groups. Overall, more than 87. Select. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. If you can use an Oracle 'function' instead of a stored procedure, you could setup a filter containing the function inside a MicroStrategy ApplyComparison (). To use Apply functions, you should have the Use. 4. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. This document will use the MicroStrategy Tutorial project with a warehouse in SQL Server to demonstrate the concept: Create a numeric value prompt and name it P1. About Us. for each successive object passed. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. I generally use this trick if I need to set an ID equal to the results of a subselect, usually the result of a Max or a Join. Applycomparison advancd filter with a select state. Note: To avoid user permission conflicts, the following steps must be performed with highest privileges. The index. In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. Prior to MicroStrategy 9. Create a report with Region attribute in the row, and add the above filter. The next example uses ApplyComparison. In order to exclude the values, create another filter expression which will always be TRUE and. The next example uses ApplyComparison. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart t. The user should enter two double-quote marks in succession, as shown. The menu also provides features to connect to a server if required, view the data sets available, the visualization gallery, and data filtering options, etc. A icon appears in the upper left corner of the source visualization. The filtering options are: Standard filtering - allows the report filter to interact as usual in the metric calculation. Create an advanced filter qualification. Case. Right-click on an existing environment and choose Properties. How to create a dynamic custom group to display a set of date ranges in Microstrategy Developer. Instead, you can use an ApplyComparison function in a custom expression qualification filter to search for this symbol. 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. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. Using L’Hôpital’s rule, limx → ∞ lnx √x = limx → ∞ 2√x x = limx → ∞ 2 √x = 0. About Us. Level: Set grouping to "Beginning Fact" for your date attribute. Ragged Hierarchies in Microstrategy. System Manager workflow can execute on a schedule or after an event has been triggered. Right-click the project for which to activate the advanced qualification option and choose My Preferences. To Display a Filter's Definition. For more details, click the link corresponding to each function. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. Depending on the type of object you are filtering on, a different set of choices appears. Right click on your project and click “Project Configuration…”. Using Prompts and ApplySimple Statements. The 30+ free BI comparison graphs will give you instantly insight in the pros and cons. As a MicroStrategy developer, and a SQL. ) are used. microstrategy. mstrc) Open Workstation. Therefore, there are two ways around it; you need to create a view that pre-joins the two tables so the two columns are in the same table; or you can use a subquery to bring one column from one table into the other table. To create a custom expression filter, the Advanced Qualification Editor must be enabled in the user's project preferences in MicroStrategy Developer 9. Enter the values to use as arguments. Filename. 4. The option to Delete unused managed objects allows a MSTR Admin to force a search and delete of those managed objects which no longer are in use by the project (no longer have dependants). You will see that R2 still displays the first 6 months data. The ApplyComparison function is used with comparison operators such as >, Like, and In. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. Number of Views 3. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9Open a project source in Object Manager. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. Item = 3/4 * 10 = 7. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. Add the derived metric to the report and hide it by setting the column width to 0. The ApplySimple function is used with simple operators and functions. From the Tools menu, select View Filter. 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. 3. Since the limit is 0 and ∑ ∞ n = 1 1 n3 / 2 converges, we can conclude that ∑ ∞ n = 1lnn n2 converges. Number of consultants & teachers ___. Using MicroStrategy Object Manager to copy/move objects around is not recommended while other user sessions are making changes using MicroStrategy Agent, as it could lead to metadata inconsistency. ApplyComparison("{Current Month} > #0", Month@ID ) {Current Month}. 13 Locations. For instance, it could be possible to pass in parameters to MicroStrategy Web to dynamically effect what a user has access to at that timeWhen exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Select only Configuration Objects for documentation. (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. 4. 3. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. If an environment does not already exist, an environment will need to be created first. Use the MicroStrategy built-in apply (pass-through) functions; Freeform SQL; Apply (pass-through) functions. Object prompts can be created using. You must use the ApplyComparison and when you create the filter use Advanced Qualification. To determine how MicroStrategy hides null and zero metric values in the grid, on the General tab, select the Hide Null/Zero Toggle Behavior. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. There is no functional difference between the two symbols. We’re here to help you align the future of AI/BI technology with your company vision. The report execution is typically a 3 step process process of the below: Query Stage. From the Visualizations panel, select Grid . To support including attribute information in the metric expression, in the Definition area, type Max () to use the Max aggregation function. From the Project menu, select Compare Projects. The following procedure describes how to achieve this: Create the highest level filter. Follow the steps below. ) Add Customer State and Customer to the report. 2. Create a file subscription in MicroStrategy Web. 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. The metric will assign sequential numbers to the rows using the defined order. In Microstrategy I am trying to create a new fact that returns a specific name depending on the type of text contained in the field NAME. Now when both the prompts are answered,the above subquery is generated by the Microstrategy . To Access an Advanced Filter Qualification. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. 1 and 10. Save the report as “Email Bursting”. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. likes. For basic information and examples of the ApplySimple function, see the Functions Reference. The first qualification is to use a shortcut to the report just created above. Restricting access to data: Security filters. 2. This will enable the option to use ApplyComparison’s in Filters. Overall, more than 87. For filters, the ApplyComparison and ApplySimple functions are most useful, although you can also use Apply functions to create metrics and prompts. 0. Microstrategy Dossiers With the release of MicroStrategy 10. Why MicroStrategy Why MicroStrategy; Customer Stories ApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same type. An object is a basic building block in MicroStrategy. ) The above example used an Apply function, ApplySimple. 5% of users said that the platform is easy to use, with a user-friendly drag. Choose attribute Call Center and use the Region Filter created in the previous step. Therefore, users must use the ApplyComparison function to ignore the SQL parser as shown below: NOTE: KB5700-007-0107 describes the ApplyComparison function in detail as well as other functions that bypass the SQL parser in MicroStrategy Desktop. Right-click on an existing environment and choose Properties. b. Today, I’ll talk about ApplyComparison, which allows you to provide custom SQL in the WHERE clause of. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Tuning Suggestions on Db2 database. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. 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. However, when a LIKE operator is used in the metric definition, the query can be incorrectly generated leading the report to fail. 02K. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. ApplyComparison ("#0 between #1 and #2",? Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. . Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. . Open MicroStrategy Developer. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. Open the document in Design or Editable Mode. For details, see Comparison Operators. 2. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. Use the individual editors inside Developer to create and edit various model objects. The filter on this will be "where <> '-' " and there is no need to use. 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. About Us. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Example. Data DesignIn MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. 2 by default. 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. . Brand = 4/4 * 10 = 10 (note that the lowest level attribute always have a weight of 10 ) Similary for a the date hierarchy, the values are calculated as below. From the Tools menu, select View Filter. If all conditions are false, a default value is returned. The attribute form should use the same column as the ID attribute form, but it should only be sourced from the lookup table for the attribute. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. I asume you store the elements of the "security-" where clause in the fact table. ApplyComparison. 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. Logical operators: These operators provide basic comparisons and return TRUE or FALSE values based on the evaluation of the formula. As you can imagine, the SQL Engine. From the Tools menu, select Grouping. Unser Team; Careers: work as a business intelligence advisor; ServicesKB14562: How to use a relationship filter to control expensive subqueries in MicroStrategy SQL Generation Engine Number of Views 3. Syntax. See side-by-side comparisons of product capabilities, customer experience, pros and cons, and reviewer demographics to. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. 4. This will enable the option to use ApplyComparison’s in Filters. Click Filter Options. The Lead function can be used in the same way. In the MicroStrategy Developer File menu, point to New > Filter. For example, these functions can aid in the creation of attribute forms by combining. This type of operator includes And, Or, and Not. exe using the command line. Therefore, users must use the ApplyComparison function to ignore the SQL parser as shown below: NOTE: KB5700-007-0107 describes the ApplyComparison function in detail as well as other functions that bypass. To Access an Advanced Filter Qualification. The Select Bursting Criteria options are displayed. From the Tools menu, select Grouping. The Report SQL indicates that the filter has not been applied. Number of Views 2K. The example below shows the basic structure of an ApplySimple statement to create metrics. 2. In Microstrategy I am trying to create a new fact that returns a specific name depending on the type of text contained in the field NAME. We will also learn sapply (), lapply () and tapply (). Transformations allow you to apply an attribute-element based offset to compare metric data. The Filter Editor is displayed. Description. ProjectListType. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. The Grouping panel is displayed. Using Prompts and ApplySimple Statements. 13K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation EngineFunctions in MicroStrategy are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-selected calculations. Apply (Pass-Through) Functions. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. While each Apply function has its own syntax, the Apply functions share several syntactic features: The "#n" code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. 2) Creating a filter definition prompt with the Sum Metric, so that when the rpeort is prompted user cans elect Sum Metric value is >0 . If excutionMode is not provided in the URL, by default PDF will be used as executionMode. Hover over the visualization to use as the source and click More in the top right and choose Select Target. The apply collection can be viewed as a substitute to the loop. Review your choices at the summary screen and click Finish. Note: Filters can only be created out of metrics and schema attributes. Below is what I tried but it did not work. Below are the new features exclusive to. When they need to use an Apply function, MicroStrategy encourages you to submit an enhancement request for inclusion of of desired feature in one future product release. The number of partitions should typically be between the minimum and maximum, and closer to half the number of logical cores. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. In the layout tab, click "Allow multiple selections". 1 and 10. 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. From: danielmager via microstrategy-l To: devildreamss Sent: Wednesday, No vember 1, 2006 1:27:45 PM Subject: Re: [microstrategy-l] Microstrategy lo gged in user on report / parameter. From the Tools menu, select Report Options. Create another dynamic date filter 'OBJ2 - Last Month' Create a Metric 'OBJ3 - Max Day No Filter' that returns the day value in a metric for a given day. 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. Depending on your MicroStrategy product and licensing. g. But, DESC has repeating values. Use the limit comparison test to determine whether the series ∑ ∞ n = 1 5n 3n + 2 converges or diverges. x. Revenue: $500 million to $1 billion (USD) Computer Hardware Development. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. Overall, more than 87. For basic information and examples of the ApplySimple function, see the Functions Reference. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. EXAMPLE. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. com Para jpviva. x using an Oracl… Number of Views 6. In the bottom left corner, click on the button "Generate Connection File". When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. KB7294: How security filters work in. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. id where #1 and #2)", [Date]@Id,? [GTN],? [BTN]) Both the GTN amd BTN are optional prompts. key1 + '%')",Key2@ID) Published: Apr 12, 2017. . MSTR doesn't support attribute form expressions or fact expressions using columns from different logical tables. 3. In the MicroStrategy Developer File menu, point to New > Filter. Only project configured with those setting is applicable for the case in this article. Save the filter as "Region Filter". Below tuning suggestion is based on IBM Document on Performance Tuning. e. How to get the latest N days data that are available in database in MicroStrategy Developer 9. x: Open the Filter Editor to define a new filter. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. In this case, Promotion has a many-to-many relationship to both Item and Quarter. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Published on July 2022 | Categories: Documents | Downloads: 1 | Comments: 0 | Views: 62MicroStrategy Tutorial. The examples shown below were created in the MicroStrategy Tutorial project. It leverages data connectivity, machine learning and mobile access to offer. With the following objects:. 2. Example include ApplySimple, ApplyComparison, etc. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. Click Filter Options. The syntax always follows the format Applyfunction ("#0. Define the advance sort on the derived. You can achieve what you want if you build the metric with: A filter to ignore your specified "NULL-Date". Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. 6 stars with 694 reviews. In MicroStrategy Developer, it may be necessary to create a report that will calculate the year to date total of a metric. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Example 1 Using an attribute ApplySimple ("Datediff (YY, #0,getdate ())", [BIRTH_DATE]) Example 2 Using an attribute ApplySimple ("Months_between (sysdate,#0)",. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Apply functions: These functions provide access to functions and syntactic constructs that are not standard in MicroStrategy but are offered by various relational database. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. If I select name1 from the prompt, I do need to show all the occurances of. Clear the Totals check box to remove the standard subtotals. Accordingly, this section focuses on how to use transformations in metrics and reports, and provides only an overview of. SUBCAT_ID SUBCAT_ID,Examples of this category are Between, Like, Greater than(>), Less than (<), ApplyComparison, and so on. The Filter Editor is displayed. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. Examples of this category are Between, Like, Greater than(>), Less than (<), ApplyComparison, and so on. To create Attribute/Fact definition or simple passthrough expression - use ApplySimple. If you are editing the Case function, use the values in step 8. {&GROUPLABEL} Name of the graph. 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. 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. Tysons Corner, VA. (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 issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. In the bottom left corner, click on the button "Generate Connection File". Quick connections to any data source are combined with one-click sharing of any insight.