Click New. x, select 'Project Documentation' from the Tools menu to start the wizard. Insert an HTML container (and not an image) and insert the script below. Hi all, I was wondering if anyone knew of a way to change the display value of a NULL attribute (usually comes up blank) to display something like "UNKNOWN" or "NULL". Presented during MicroStrategy World 2021, hear best practices and tools and tips for connecting to Snowflake. string1 is the string that will be converted to a date. Select any project that is in the project source that contains the users and groups and click Next. ApplySimple where simple (e. When using OLAP Cube data sources, aggregation at multiple levels can be performed in two ways. MicroStrategy Internal Reference number for this technical note is KB483717 and. The ApplyComparison function is used with comparison operators such as >, Like, and In. EXAMPLES: Using the Populate method: Set objMDFilter = mobjObjSource. Using a combination of filters and metric dimensionality, the same results can be achieved. 6. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Fu nction Types. Number of Views 49. But, DESC has repeating values. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. An example of such a need occurs when a modification had been made to the Relational Database Management System (RDBMS) so that the ApplySimple syntax should be changed to reflect the new. MSTR has evolved. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. thread395-610882. x, with the Intelligence Server running on Linux,. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). arithmetic operators) are used. Select your custom visualization. CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. To Define a Join Between the Columns of Two Tables. The expression editor in MicroStrategy Developer provides an escape sequence to support double-quote marks in a string. The MicroStrategy Tutorial project is used to explain how users can customize numbers from "1,000,000" to a "1. The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal. 1 and 10. For new columns to be available for attribute and fact creation in MicroStrategy Architect, the table structure must be updated. 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 shown in the screenshot. Concat is often used to combine related values, such as a first and last name. The same logical should apply for other databases, but the syntax will need to be changed. Concat is often used to combine related values, such as a first and last name. Create a Report Services Document 2. Use ApplySimple in the form expression and change the date format to yyyy-mm-dd. region. Select a prompt style and click on 'OK'. For example, if you specify the File Location as. Syntax. 1. e. 1 and 10. jar. Loading × Sorry to interruptKB42225: How to create a distinct count subtotal from base report in MicroStrategy Web Number of Views 6. x. Thanks. 2. 3. g. Create a FreeForm SQL Report and add this nested prompt into it. Personally, I would use ApplySimple and let the database handle the work. ApplyAgg: where aggregate functions (e. 4. Thus, if a Dynamic Date is created based on today's date, in order to get 'Last Month' a specific number of days can be subtracted from the date. 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. 4. This is the format that will be used to convert string1 to a date. 3K. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Create a Custom Group Element using the Relationship filter created in step 3: 5. While MicroStrategy Developer 9. For example, concatenating the two strings "Micro" and "Strategy" would result in the single string "MicroStrategy". The CASE function permits multiple comparisons. 98K. BC OnLine Partnership Office E161, 4000 Seymour Place PO Box 9412, Stn Prov Govt Victoria, BC V8W 9V1A simple application of this technique is to use a constant value prompt in your project as a multiplier of metric data: ApplySimple (" ( [Measures]. 4. 4. 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. For more information on creating an applysimple, refer to MicroStrategy Knowledge Base document, KB5700-007-0113 - How to implement attribute form expression using Apply Functions in MicroStrategy Desktop. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. ApplySimple("Case When #0 ='abc' Then #1 Case #2='xyz' Then #3 End",Attribute_A@ID,[Metric 1],Attribute_B@ID ,[Metric 2]). x fails to generate SQL for a metric based on a fact defined with an ApplySimple statement SYMPTOM: SQL for a metric based on a fact defined with an ApplySimple statement is missing in the report SQL at run time in MicroStrategy 9. 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 document provides the steps to accomplish the same. All attributes used to group data in the report or document are shown in the Available Attributes list. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. In addition to the the pre-defined options for metric formatting, MicroStrategy supports custom formatting. This allows you to use MicroStrategy's built-in functions in your qualification. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 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 MaxApply functions provide access to functionality that is not standard in MicroStrategy, but is available in the relational database. Specify the desired delivery options including recipient address, subscription name. 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. {Select a Month} and ApplySimple("DateAdd('m',-11,#0)",{Select a Month})) Relate by System Default. Number of Views 1. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. HyperIntelligence and its Architecture. 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. Apply the filter Year=2002 to your report. In ApplyComparison, the custom SQL syntax enclosed in quotation marks represents the entire condition; thus there is no need to compare the result of ApplyComparison to anything. Use the datetime format defined on warehouse database side in the ApplySimple statement. DaysBetween. Open the project in which a new column is added. Phoenixier. 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. 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. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. arithmetic operators) can be used. 2. Users may need to list all objects (e. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Explanation. Sum . Open your Snowflake console ( account. ApplySimple( "convert. 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. ITtoolbox. arithmetic operators) are used. Depending on your MicroStrategy product and licensing, this function may not be available. Syntax. x. By default, all of the columns used in an expression must originate from the same table. It is used to define compound metrics via. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. 1M type format. 35K. I want to find out the number of Widgets that were faulty, so I created another metric with that. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. x that require single quotes in the definition. MSTR has evolved. Users need to change the expression accordingly based on the. png"). Our solutions work to guide towards best practices and provide guidance to the user community. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Define the advance sort on the derived. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. You can use various techniques and interfaces to create and modify attributes for a project: • The Attribute Creation Wizard allows you to:Use the datetime format defined on warehouse database side in the ApplySimple statement. CAUSE: This is currently working as designed. 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. Expression: ApplySimple("FORMAT(#0,'yyyy-MM-dd')", [DAY_DATE]) Save the modification and update schema. Personally, I would use ApplySimple and let the database handle the work. Upgrade to MicroStrategy m2020 or later release. Thus directly using NULL in formula will fail. If an attribute is the lowest level attribute in a hierarchy, then the MicroStrategy SQL Engine will place a key beside this attribute in its logical table view. Depending on your MicroStrategy product and licensing. 1K. The MicroStrategy Case statement should work fine. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). I can't remember if the strings have to be enclosed in single or quote quotes. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). The syntax for that is ApplySimple(“<Insert database SQL>”, [Column #0])ToDateTime (Convert String or Number to a Date or Timestamp) The ToDateTime function converts a string of characters or a number into a date or timestam p. Filter functions can only be Equal, And, Or and Not" displays on prompt screen when using ApplySimple on a cube report in MicroStrategy 9. Create a metric using either definition: ApplySimple("Sum(#0)", ?Year) Or ApplySimple("Sum(#E0)", ?Year) 3. HTCMS (Programmer) (OP) 19 Feb 04 20:41. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. To create a prompt that places the maximum date value from a warehouse table as the. 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. By default usually MicroStrategy treats all column names as upper case only, however in DB2 (and potentially other databases) mixed case columns are possible in a case sensitive database collation. format_mask is optional. 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. 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 nction Types. 4. 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. It is possible to prompt the user for the concluding element by using ApplySimple:Returns the date of the first day of the month in which date or timestamp occurs. 2. You can use the ApplyComparison function to define custom filters. Create a metric like the example below: e. 1 and 10. Subscriptions and tasks that are based on event-triggered schedules execute when a MicroStrategy event is triggered. i'm trying to use the ApplySimple function in order to define a Metric in MicroStratey. This is a single-value function. 4. Whatever the final sql is (1) take the final sql, (2) Wrap. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. 4. HTCMS (Programmer) (OP) 19 Feb 04 20:41. MSTR has evolved. Step 2) Create a metric using the following syntax, Sum(ApplySimple("#0", <Attribute Name>, 1)){~}. x If a user needs to display blocks of 12 months as years by specifying the end month at run time there is a way of doing it by following the steps below: 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. 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. ApplySimple. A human reader can see from the ApplySimple SQL string that the revenue value will be returned (meaning that the datatype should be Float). x, a passthrough function, such as ApplySimple, cannot be used on a prompt in a report based off of an Intelligent Cube. The prompt "Choose from all elements of 'Category'" is also placed into the report. Step 4) When users execute the report, they will notice that the 'ApplySimple' is ignore resulting in just the Metric Alias. Right-click on an existing environment and choose Properties. From the Database connection type drop-down, choose Snowflake. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Make two grids with different attributes and metrics in each 3. percentage. I hope this helps. g. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. Plano, Texas, United States. x and higher. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. You can use the MicroStrategy CASE function, available in MicroStrategy Developer (Schema ObjectsFunctions and OperatorsFunctionsInternal Functions), to retrieve desired result sets. x pass-through function, in this case the ApplySimple function. NOTE: An enhancement request has been made to allow users to create a graph for rolling 12 months comparing current and prior year metrics without having to modify attributes by implementing ApplySimple statements. Since there are 7 days in each week and 52 weeks in each year, this calculation will always match each day of the week to the. If you are looking to learn. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. , metrics or attributes) containing a particular function or operator (e. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. The ID is distinct. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. ApplySimple ("_PARTITIONTIME", [AnyColumnName]) Note: This will work in MicroStrategy Developer for IT and in MicroStrategy Web/Desktop for Business Users. MyDate,sysdate,#0,#1)",Fact1,Fact2) OR. ApplyRelative: where. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. My current metric definition is: ApplySimple("TO_DOUBLE(. Microstrategy Dossiers With the release of MicroStrategy 10. This technical note outlines the differences between Consolidations and Custom Groups in MicroStrategy 9. it looks like MicroStrategy doesn't support it, please advise. Syntax. Dynamic date qualifications are not supported against MDX cube data sources, but the same results can be achieved by using custom MDX expressions. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. ApplySimple ("Case When T1. ApplyOLAP is the MicroStrategy Apply function tool used for OLAP functionality when you wish to use the native capabilities of your RDBMS. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. The syntax always follows the format Applyfunction ("#0. , ApplySimple or ApplyAgg). 1 and 10. Microstrategy - creating a simple percentage column. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. ApplySimple This is the most common function, as you can use it in an Attribute definition. 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. 1 and 10. In the layout tab, click "Allow multiple selections". g. From MicroStrategy 9. ApplySimple: Simple single-value functions, including arithmetic operators such as + and -, date and string manipulation functions, and so on ApplyAgg: Group-value (otherwise. The ApplyAgg function is used with Basic functions such as Sum and Max. 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. To create an attribute form that allows the attribute to display a name in the format of 'Last_Name, First_Name' in MicroStrategy 10. If an environment does not already exist, an environment will need to be created first. ApplySimple. For example, ApplySimple("#0 * #1",[col1],[col2]). In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. This is a single-value function. microstrategy. x and add a derived attribute, right clicking an. g. If instead a “. This is a single-value function. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. g. RE: YTD. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. 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. The prompt may be used in the ApplySimple function, and will be substituted at runtime. 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. Count(ApplySimple("Case when #0 <> 0 then #1 else Null end", Column2, Column1)) {~ } Note: Notice that the ELSE statement is using 0 or Null based on the metric functions, such as Sum or Count. From the File menu, click Open. Click New. Create a numeric value prompt and name it P1. . A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. x adn 10. Choose attribute Call Center and use the Region Filter created in the previous step. This filter must be applied in the final pass to find the correct store-region relationship, even though the final pass is a normal join instead of a downward join. The recommended VLDB optimizations for Hive 0. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . Change the DESC form expression to the following. How to embed horizontal bar graphs into a column of a grid in Report Service Document in MicroStrategy Developer 9. Microstrategy Dossiers With the release of MicroStrategy 10. 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. The apply functions act as containers for non-standard SQL expressions being passed to the database. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. It should work. ApplySimple("#0", MaxProfit). The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. mstrc file from an empty text file. 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. 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. Relationship tables in Microstrategy. These values are set by default when the "Hive 0. Case can be used for categorizing data based on multiple conditions. It must then add these tables to its MicroStrategy project, and create the appropriate attributes so report users can analyze business data for their appropriate country. 4. MicroStrategy Web supports basic HTML tags on warehouse elements, including the tag for HTML hyperlinks. Select 'Schema' > 'Warehouse Catalog'. MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. 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. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. Syntax. If two users with different security filters run the same report, they may get different results. This article explains how to model recursive hierarchies in MicroStrategy. Sum, Max, etc) can be used. In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. YTD transformation. ; Distinct is a TRUE/FALSE parameter that allows you to. KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. These functions are not supported by the Analytical Engine, so they must be calculated by the database. These functions are supported by the Analytical Engine. Reports that contain B or C will ignore filters on the other. To convert a CHAR to an INTEGER in MicroStrategy for SQL Server, change the definition of the attribute as follows: ApplySimple ("cast (#0 as INT)", SKU_IN_CHAR) DateDiff (Day@ID, CurrentDate (), "d") For each element of the Day attribute, the metric displays the number of days between that date and the current date when running the report or dossier. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Returns the current date as provided by the database timer. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. The MicroStrategy SQL Engine 9. For instance, if the datetime format is defined as yyyy-mm-dd on warehouse database side, the form expression needs to be modified as follows:Instead of using the MicroStrategy Week() function, database-based functions can be directly used through an ApplySimple() statement. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. For more details on how to use ApplySimple() statements, refer to the following MicroStrategy Knowledge Base technical note:When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Look the SQL code generated for the report, take the alias. Using these functions, MicroStrategy generated SQL. How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. KB32365: How to use element list prompts in database passthrough functions In MicroStrategy SQL Generation Engine. In most cases, these values are not recognized as MicroStrategy objects. ApplySimple ("cast (#1 as varchar (3)) + ': "" ' + #0 + ' "" ' ", , ) The purpose of this expression (for SQL Server) is to display items with both the ID and description in the same string, quoting the description: When SQL is generated, wherever two double-quotes appear in. This document describes the second approach. 4. x, select 'Project Documentation' from the Tools menu to start the wizard. The schema looks like the following diagram. Keep the form expression unchanged. NOTE: For additional information regarding pass-through expression ApplySimple and Attribute form data type, refer to the MicroStrategy technical notes: KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation EngineThis article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. 18K KB8426: How to create a metric with an ApplySimple statement which will choose different metrics for calculation based on. . Thanks a lot for the 101 Microstrategy Question…. MyDate =. MicroStrategy will continue to investigate and post updates as soon as they are available. This feature is similar to what we see in. . Follow the steps below. 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. com) In the popup that opens, select ODBC. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. Users want to create a filter that always filters on this month, i. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. For reference, refer to the Snowflake release notes. g. MSTR has evolved dashboards to the point that they. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE. The example given below relates to an Oracle data warehouse, but many other RDBMSs support similar functionality. The steps below use objects from the MicroStrategy Tutorial project as an example. Case. Create a file subscription in MicroStrategy Web. 7x. 1 and 10. All articles. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. MicroStrategy parser doesnt recognize NULL as a key word for null value. This is a single-value function. When the ApplySimple Date attribute is defined, the MicroStrategy Engine automatically defines the Form Format of the attribute as "Datetime" because the raw data is being pulled from a Data column. 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. Viewed 13k times. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. The current year can be returned by putting: Year (CurrentDate ()) for your comparison. NewObject (DssTypeMDSecurityFilter) objMDFilter. An example of such a need occurs when a modification had been made to the Relational Database Management System (RDBMS) so that the ApplySimple syntax should be changed to reflect the new database requirements. 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. The steps below give a detailed explanation on how to create a report that contains a metric based on another metric that will return a static string of data from the warehouse. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. In MicroStrategy Developer, create a dummy metric with the following definition.