For example, ApplySimple("#0 * #1",[col1],[col2])indicates that two items, col1 and col2, referenced as. The MicroStrategy Case statement should work fine. . MSTR has evolved. . Examples of this category are simple mathematical. If all conditions are false, a default value is returned. For example, ApplySimple("#0 * #1",[col1],[col2]). The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. : ApplySimple ("Decode (T1. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Explanation. Click New. If the cube dimension's key data use the MicroStrategy login directly, the formula can be relatively simple. Example 1 Using. ApplyRelative: where. Create a numeric value prompt and name it P1. MSTR has evolved. CAUSE: This is currently working as designed. x, with the Intelligence Server running on Linux,. For reference, refer to the Snowflake release notes. The steps below use objects from the MicroStrategy Tutorial project as an example. 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. Below is what I tried but it did not work. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Change the DESC form expression to the following. 1 and 10. In addition to the the pre-defined options for metric formatting, MicroStrategy supports custom formatting. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. 1 and 10. Something like: ApplySimple("'Y'", [your metric here]). KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. x-10. 2. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. g. Make two grids with different attributes and metrics in each 3. The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)In 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. 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. Accept the other default values. The Apply function types are listed below, along with examples of the MicroStrategy functions that they can replace: ApplySimple: Simple single-value functions, including arithmetic operators such as + and -, date and string manipulation functions, and so on; ApplyAgg: Group-value (otherwise known as aggregate) functions such as Sum and Max Apply functions provide access to functionality that is not standard in MicroStrategy, but is available in the relational database. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Creating a . Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. Example 1 Using an attribute The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. The month names do not originally reside in the warehouse tables and the user does not want to manually input the values into the warehouse. If two users with different security filters run the same report, they may get different results. XSTEPS TO IMPLEMENT. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. This is a single-value function. png"). This is a single-value function. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. com) In the popup that opens, select ODBC. Teradata supports user-defined functions (UDFs), which allow you to extend the SQL language by writing your own functions or installing UDF packages from third-parties. This custom SQL can be used in the. In threshold, use the condition as "Region_Test where DESC Exactly EMPTY", then threshold will be applied to those elements whose DESC is a space. 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation EngineApplyComparison. You can use the ApplyComparison function to define custom filters. An example of this behavior is as follows:Try using some of the date functions that are now available in 8. x using an Oracl… Number of Views 6. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. Depending on your MicroStrategy product and licensing. How to create fact that does not get rounded up when calculated with MicroStrategy Developer 9. Microstrategy Dossiers With the release of MicroStrategy 10. x-10. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. NewObject (DssTypeMDSecurityFilter) objMDFilter. ApplySimple where simple (e. Once the administrator sets it up, the end user has to just log in with their Okta or Azure AD email credentials to start using MicroStrategy with Snowflake. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. How to create a MicroStrategy connection file (. 3 environment, we have a star schema that has multiple date dimensions. 4. As a workaround users can use ApplySimple function as below: ApplySimple(“Case when #0>0 then #1 else NULL end”, [BACK_END_DENIAL_COUNT],[TEST_ID]) Also, you can use "NulltoZero" function as. Environment: Microstrategy. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. 3. ApplyOLAP is the MicroStrategy Apply function tool used for OLAP functionality when you wish to use the native capabilities of your RDBMS. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. MSTR has evolved dashboards to the point that they. The syntax always follows the format Applyfunction ("#0. This is a single-value function. x and an Oracle Warehouse using the ApplySimple function. x . 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. MSTR has evolved. Returns the current date as provided by the database timer. This function does not take input variables. Create a Fact using two expressions with ApplySimple() definitions as follows:KB14356: When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrate… Number of Views 1. x use the Day attribute to qualify on a particular date. Create a metric with M03 = MonthStartDate (CurrentDate). this column in ApplySimple statement. Microstrategy Dossiers With the release of MicroStrategy 10. Keep the form expression unchanged. Steps to create such a prompt in MicroStrategy Tutorial is given as follows. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. ApplySimple: where simple operators (e. , ApplySimple or ApplyAgg). However, MicroStrategy does have a method for providing database specific SQL to be passed directly to the database; this is accomplished with the ApplySimple statement. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. ApplySimple may be used in one or both sides of a comparison expression. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer Number of Views 1. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Web/Desktop requires making use of a Live Connect dataset (either Data Import - Pick Tables or from Existing Objects). nction Types. 2 for a '(VARCHAR2 (4 BYTE)' column. Ragged Hierarchies in Microstrategy. ApplySimple. Syntax. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. MicroStrategy parser doesnt recognize NULL as a key word for null value. In a MicroStrategy environment with IBM DB2 as the Warehouse Database, a date attribute is created and defined using an ApplySimple statement containing the function 'CHAR' having 'LOCAL' as argument (which is a DB2 native syntaxWe use MicroStrategy Tutorial objects in the following steps. CREATE SECURITY FILTER "SecFilter3" DESCRIPTION "region@id=1" IN PROJECT "MicroStrategy Tutorial" EXPRESSION "Region@ID=?Contributors"; will receive the following error: CAUSE: This is a known limitation in MicroStrategy Command Manager 9. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. x, with the Intelligence Server running on Linux, the. 1 and 10. 0 database: Create a date value prompt named "End Date" Create a metric "metric1" with the following definition: ApplySimple("Extract(EPOCH FROM DATE #0)", ?) Create a metric "metric2" with the following definition: Min() Fu. . AddDays. Close the Visualization Builder, and then re-open it. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 1 and 10. g. The apply functions act as containers for non-standard SQL expressions being passed to the database. These functions are not supported by the Analytical Engine, so they must be calculated by the database. Personally, I would use ApplySimple and let the database handle the work. Database administrators can store HTML tag elements directly in the data warehouse, but MicroStrategy also has the ability to add HTML tagging to non HTML elements by using the ApplySimple database function. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Specify the desired delivery options including recipient address, subscription name. These functions are supported by the Analytical Engine. If your database does not include SQL syntax support for a date and time function, the function cannot be. ; Distinct is a TRUE/FALSE parameter that allows you to. Use the ApplySimple pass-through expression to create the HTML tag expression. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. x-10. A metric to show the per-year average of quarterly totals must first aggregate the basic fact data at the level of quarter, then calculate the average at year level over that intermediate result. The following example uses MicroStrategy Tutorial to explain the construction of a Year-To-Date metric. x. MicroStrategy Apply functions provide access to functions or syntactic constructs that are not standard in MicroStrategy but are provided by various Relational Database Management System (RDBMS) platforms. When adding a prompted metric using an ApplySimple() function that includes a Max, the prompt name will not be displayed for prompt ordering on a MicroStrategy Report Services Document as shown in the image below: The metric in the report contains a formula similar to the following examplemstrgrl (TechnicalUser) (OP) 2 Dec 03 15:36. MicroStrategy OAuth 2. The Code Editor tab should be open. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. If you are looking to learn. I originally cut and pasted the syntax from SQL+ into the attribute statement and tweaked it. You can use CASE, which will apply the changes in the analytical engine or you can use ApplySimple to pass your Case statement down to the database. 1 and 10. 1 and 10. In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. 4. g. x. It should work. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. e. It should work. KB32365: How to use element list prompts in database passthrough functions In MicroStrategy SQL Generation Engine. The datatype used to define columns in temporary tables for objects defined with multiple inputs such as an applysimple statement are determined by the datatype of the first object listed in the object definition in MicroStrategy. However, MicroStrategy does have a method for providing database specific SQL to be passed directly to the database; this is accomplished with the ApplySimple statement. In this brief video tutorial, Doug Terbush from our Customer Education team describes the use of the Case function, along with examples of using this functio. This function relies on the Analytical Engine for processing, rather than the database. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. g. In MicroStrategy Developer, log in to the project source that contains the fact to create a new column alias for. Most data on a document is from one or more underlying datasets. x adn 10. Number of Views 3. 4. 4. 1. This technical note provides an example of how to calculate the number of days between the current date and a date attribute. g. mstrc file from an empty text file. Select the DSN. Apply the filter Year=2002 to your report. Presented by MicroStrategyBlog. For more information on using the ApplyAgg() function, refer to the following MicroStrategy Knowledge Base documents: KB4202: How to. Microstrategy Dossiers With the release of MicroStrategy 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. arithmetic operators) can be used. The ID is distinct. CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. x and higher. KB484697: How to use the ApplyX function without the "Use FreeForm SQL Report" privilege. The ApplyComparison function is used with comparison operators such as >, Like, and In. ", Arg1, Arg2). Microstrategy Dossiers With the release of MicroStrategy 10. Recommended VLDB Properties for use of MicroStrategy 9 with Hive 0. Pass-through expressions, also called Apply functions, provide access to special functions or syntactic constructs that are not standard in MicroStrategy, but can be obtained. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. 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. You can use the MicroStrategy CASE function, available in MicroStrategy Developer (Schema ObjectsFunctions and OperatorsFunctionsInternal Functions), to retrieve desired result sets. Create a metric using either definition: ApplySimple("Sum(#0)", ?Year) Or ApplySimple("Sum(#E0)", ?Year) 3. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. 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. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. In MicroStrategy Developer, create a dummy metric with the following definition. MSTR has evolved. By design, however, MicroStrategy SQL Generation Engine 8. The MicroStrategy Analytical Engine does not calculate date and time functions. 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. To create a column alias for a fact. The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. Right-click on an existing environment and choose Properties. 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. In MicroStrategy SQL Generation Engine, it is not possible to use element list prompts in database passthrough functions, using the default syntax, such as ApplySimple, ApplyComparison and ApplyAgg. This allows you to use MicroStrategy's built-in functions in your qualification. jar file to i-server machine. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Hadoop Gateway operation modes MicroStrategy Hadoop Gateway is a native connector which was built based on Spark 1. In the Database Connections dialog, enter a database connection name. solutions Forum; YTD transformation. that is used to table that contains column MyDate and force. The ApplySimple function is used exactly as in SQL reports, with the passthrough syntax enclosed in double quote marks, followed by a list of MicroStrategy objects or expressions separated by commas, for example:. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Number of Views 1. 1. These values are set by default when the "Hive 0. KB485687: The bulk insert is not working which caused performance issue when running multi-source reports. , the report always contains a clause such as 'WHERE MONTH_ID = 200107', for the current month. Create a Report Services Document 2. We are active contributors to solutions on the MicroStrategy Community site. With a few additional applysimple statements this can also be used to create QTD and MTD. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. In the Database Logins dialog, enter your login credentials. In Teradata, the Extract function returns the month, day or year from a date field. • Involved in understanding and transmitting the business requirements for the project and. For the example above, the Count metric should use Null for the ELSE statement so not to count anything when #0 meets the condition. CONTENTS 1. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). Nick. Impact: Capability. 1 and 10. Use of M03 in Microsoft SQL Server 2000 would result in DATEADD (DD, (1 - DAY (GetDate ())), GetDate ()). kumar says: September 5, 2008 at 8:48 am iam asking a. Plano, Texas, United States. Create a Report Services Document 2. Article outlines why the 'Allow Smart Metric' setting does not persist in OLAP Cube compound metrics using ApplySimple in MicroStrategy DesktopReplace is a metric, fact, column, or string representing the text strings that are used to replace any instances of the string from Find that are included in the strings returned by Argument. MicroStrategy, Inc. Complex functions that use combinations of metrics, attribute forms and facts as arguments must use an ApplyAgg. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. Click OK. -dinzana. Split Hierarchy with M-M relationships: Explanation. . ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). All attributes used to group data in the report or document are shown in the Available Attributes list. 1 and 10. x. If I select name1 from the prompt, I do need to show all the occurances of. Problem. Something like: ApplySimple("'Y'", [your metric here]). But, DESC has repeating values. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Microstrategy Dossiers With the release of MicroStrategy 10. In the Database Logins dialog, enter your login credentials. The syntax always follows the format Applyfunction ("#0. An example of this behavior is as follows: Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. g. 2. Number of Views 2. But since the length of the month ranges between 28-31 days it. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. In our MicroStrategy 9. To Define a Join Between the Columns of Two Tables. Create a report with the custom group and. The function removes the fractional part of a real number so that only the integer part remains. Users may want to create a report with a metric that has the current date of execution as a column on a report in MicroStrategy Developer 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. You can use the ApplyAgg function to define simple metrics or facts by using database-specific, group-value functions. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. ) are used. . 1 and 10. To create a prompt that places the maximum date value from a warehouse table as the. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Create a report with Category, Subcategory and Revenue. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. 1 and 10. The index for referencing these objects begins with 0 and increases by. Depending on your MicroStrategy product and licensing. This is the format that will be used to convert string1 to a date. Follow the steps below. This article describes a behavior observed when adding a new attribute form expression with Workstation, if the ApplySimple function is used. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. The following steps can be used to concatenate two attribute forms. The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. The metric is the key component that makes the formula work because the MicroStrategy Analytical Engine was designed to make computations against objects and the subtraction of two dynamic (prompts) values divided by a physical constant (7) is not valid. Sum, Max, etc) can be used. The following example will walk through how to setup an attribute form that converts a default datetime value in Microsoft SQL Server 2000 into a NULL value. Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports. MicroStrategy - Dynamic Attribute with join. How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9. There's a reason we're at the top of the list. if both conditions are met, then Red, else Green. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Using Prompts and ApplySimple Statements. Community & Support Search Discussions Open A Case View My CasesTo create the MDSecurity filter, users can either populate the new MDSecurity filter with the definition of an existing filter or define the BottomLevel, TopLevel and Expression properties. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. KB39990: How to use ApplySimple to create attribute form to support sorting configuration in the attribute editor in MicroStrategy Desktop and Web 9. Examples of this category are simple mathematical. The schema looks like the following diagram. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. Save the prompt as "Call Center Prompt". Syntax. Depending on your MicroStrategy product and licensing. Change the DESC form expression to the following. Choose attribute Call Center and use the Region Filter created in the previous step. Subscribed reports or documents for each. for each successive object passed. ApplyAgg where aggregate functions (Sum, Max, etc. ApplySimple ("Case When T1. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Try to create the metric this way: Sum (PaidAmt * Attribute Sales Year). With consolidations, user can group attribute elements to define "virtual" attributes that enable. YTD transformation. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. 4. region. 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. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Fu nction Types. 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. 2. ApplyComparison The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. x that require single quotes in the definition. Details: With the Data Import functionality, MicroStrategy imports data from Snowflake into our fast in-memory cubes and can constantly send queries to the data in the memory saving on compute costs. Click on 'Finish' and save the prompt. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Examples of this category are simple mathematical. Microstrategy Dossiers With the release of MicroStrategy 10. g. The ApplyAgg function is used with Basic functions such as Sum and Max. Within a project, a security filter may be specified for any user. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Download and extract Snowflake ODBC driver from Snowflake console. Microstrategy - creating a simple percentage column. Trunc (Truncate) Returns the integer component of a given number. This is a single-value function. 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. MSTR has evolved. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Select the attribute form to be displayed with a link. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine ApplyComparison. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. For more information on using these functions in the MicroStrategy's architecture, refer to the MicroStrategy Product documentation and the following Microstrategy Knowledge Base document: TN3905 (TN5200-7X0-0019): How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine 8. Concat is often used to combine related values, such as a first and last name. In threshold, use the condition as "Region_Test where DESC Exactly EMPTY", then threshold will be applied to those elements whose DESC is a space. Whenever users submit an element browse request or a report. ApplySimple may be used in one or both sides of a comparison expression. Syntax. Note: The form expression in the above sample is for Access database only. When using a warehouse that has a table storing month values only as a number, users wish to also display the corresponding month names in MicroStrategy Developer 10. Recommendation. This section describes the date and time functions. Microstrategy Dossiers With the release of MicroStrategy 10. There is an enhancement request to support. Fu nction Types. ApplySimple ("_PARTITIONTIME", [AnyColumnName]) Note: This will work in MicroStrategy Developer for IT and in MicroStrategy Web/Desktop for Business Users. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default. the columns separated by commas at the end with an ending close Paren.