Create a report with the custom group and. EXAMPLES: Using the Populate method: Set objMDFilter = mobjObjSource. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. Syntax. MSTR has evolved. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. The apply functions act as containers for non-standard SQL expressions being passed to the database. Info. Users may wish to use ORACLE's DECODE function instead of the more generic CASE statement incorporation with the 'ApplySimple' function during the report design for MicroStrategy 9. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". 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. 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. An inner join is created and a line representing the join appears in the Query Builder pane, running. For the example above, the Count metric should use Null for the ELSE statement so not to count anything when #0 meets the condition. , the report always contains a clause such as 'WHERE MONTH_ID = 200107', for the current month. Download the following driver to the server hosting your Intelligence Server: TGZ for Linux. 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. If all conditions are false, a default value is returned. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The Select Bursting Criteria options are displayed. It is used to define compound metrics via. The fractional part is removed without rounding the number up or down. 4. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). 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. Click New. 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. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. cc Assunto [microstrategy-l] ApplySimple function in MSTR 7. Create a report with Category, Subcategory and Revenue. Accept the other default values. 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. RE: YTD. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. ApplyComparison where. Filter functions can only be Equal, And, Or and Not" displays on prompt screen when using ApplySimple on a cube report in MicroStrategy 9. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. png"). Examples of this category are simple mathematical. Microstrategy Dossiers With the release of MicroStrategy 10. In this table, the PARENT_ID column logically points to another row in the same table (ID column). Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. The result does not. of distributed under each attribute element. I hope this helps. Complex functions that use combinations of metrics, attribute forms and facts as arguments must use an ApplyAgg. The ApplyAgg function is used with Basic functions such as Sum and Max. This is a single-value function. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. Microstrategy - creating a simple percentage column. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Open the project in which a new column is added. If two users with different security filters run the same report, they may get different results. 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. x adn 10. ApplySimple (“Case when [Field Header Name]='CONDITION1’ then 'condition1 example' end”,String1) What I've found online is a little misleading and wondering if anyone can assist. Create New Metric in a report or VI. 4. x. Please follow this product guide toKB6669: How to create dynamic date filters on time attributes other than Date using custom SQL transformations in MicroStrategy SQL Generation Engine . 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. MicroStrategy is a commercial off-the-shelve tool that automates the generation of Snowflake SQL queries through a semantic layer in datasets design. Save the filter as "Region Filter". thread395-610882. xApplySimple("year(date(#0) - 2 MONTHS)*100+month(date(#0) - 2 MONTHS)",CustomAttriubte@ID). Make two grids with different attributes and metrics in each 3. x. If the precision is needed to be displayed on a report, a workaround is possible by casting the DATETIME data type to a VARCHAR data type. 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. g. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. The database instance is created and can. for each successive object passed. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Create a Report Services Document 2. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. MicroStrategy OAuth 2. The script inside the " " always depends on the type of database used and can vary from one database. 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 ("Decode (T1. 4 and later. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. 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. , ApplySimple or ApplyAgg). ApplySimple This is the most common function, as you can use it in an Attribute definition. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. Select only Configuration Objects for documentation. In this article we will discuss the ApplySimple function. CurrentDateTime () For more information on the syntax used in your specific database, refer to the appropriate section in the Functions Reference. x. Below is what I tried but it did not work. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. This function does not take input variables. ApplyOLAP is the MicroStrategy Apply function tool used for OLAP functionality when you wish to use the native capabilities of your RDBMS. Microstrategy Dossiers With the release of MicroStrategy 10. Note: The form expression in the above sample is for Access database only. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. You can use the ApplyAgg function to define simple metrics or facts by using database-specific, group-value functions. To create a prompt that places the maximum date value from a warehouse table as the. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Create a numeric value prompt and name it P1. In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. The ApplyComparison function is used with comparison operators such as >, Like, and In. 4. Users may need to list all objects (e. 4. The MicroStrategy SQL Engine will join database tables together based on the lowest level attributes that MicroStrategy Architect assigns to each table. Number of Views 49. Syntax. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. In the example above, the ApplySimple statement for the attribute ID form should contain placeholders for column name as follows: ApplySimple("substring(#0, 1, 10)",) After changing the ApplySimple syntax for the attribute form CustCol 3, when the report SQL is viewed, the report will group by the attribute form CustCol 3 as shown below:Qualify on the attribute form that you want to compare (presumably the Year ID), and then in the Operator section, change the dropdown from its default 'Value' to 'Custom'. Microstrategy Dossiers With the release of MicroStrategy 10. snowflakecomputing. If the cube dimension's key data use the MicroStrategy login directly, the formula can be relatively simple. As shown below, for a specific report, the 'Group By ID Attribute' VLDB property is set to 'Group by column' instead of 'Group by expression' to avoid using an ApplySimple. 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. g. x-10. MicroStrategy will continue to investigate and post updates as soon as they are available. In a cube containing data from the MicroStrategy Tutorial project, the following metric ranks over the lowest level attribute in the Product hierarchy used on the report. 18K KB8426: How to create a metric with an ApplySimple statement which will choose different metrics for calculation based on. A MicroStrategy Report Services document displays data coming from multiple reports, with the data laid out and designed in presentation-quality format. Something like: ApplySimple("'Y'", [your metric here]). NTTA (North Texas Toll Authority) Nov 2021 - Mar 20231 year 5 months. x . Trending Articles. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. 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. 1 and 10. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. x . When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Microstrategy Dossiers With the release of MicroStrategy 10. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9 You have 2 options. Case. 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. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. 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. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. g. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . In SQL Server, the CAST () function is used to convert data into a different data type and the ApplySimple () function in MicroStrategy can be used to incorporate the CAST () function. 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. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. 3. . Users want to create a filter that always filters on this month, i. For more information on using the ApplyAgg() function, refer to the following MicroStrategy Knowledge Base documents: KB4202: How to. 1 and 10. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Close the Visualization Builder, and then re-open it. Copy the code for the D3 visualization you are using. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. ) are used. 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. arithmetic operators) are used. x-10. Presented during MicroStrategy World 2021, hear best practices and tools and tips for connecting to Snowflake. 4. This document describes the second approach. ApplySimple ("Case When T1. 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 contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. 1 and 10. The ApplySimple statements given above are ORACLE Specific. MicroStrategy Technical Support does not provide customized MDX queries. Try to create the metric this way: Sum (PaidAmt * Attribute Sales Year). ApplySimple: where simple operators (e. Max (1) The metric definition is shown in the image below: Create a second metric with an apply simple statement and using the dummy metric on its definition, as shown below. For more details on enabling the setting, see Change Data Engine Version. Open up the same document in MicroStrategy Web 10. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. Sum <Distinct, FactID, UseLookupForAttributes>(Argument)Where: Argument is an attribute, fact, or metric representing a list of numbers. The recommended VLDB optimizations for Hive 0. 2. 21K. Subscriptions and tasks that are based on event-triggered schedules execute when a MicroStrategy event is triggered. Look the SQL code generated for the report, take the alias. 2. For example, concatenating the two strings "Micro" and "Strategy" would result in the single string "MicroStrategy". 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. com) In the popup that opens, select ODBC. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. 4. 1. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. For. 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. The example below shows the basic structure of an ApplySimple statement to create metrics. arithmetic operators) are used. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. If all conditions are false, a default value is returned. g. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. Click OK in all three dialogs (Login, Connection, and Database Instance). This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. You can use the ApplyComparison function to define custom filters. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. I just verified taking the SQL generated by MSTR back into SQL+ -- the SQL+ results work as they should; however, the report results are different. From the MicroStrategy Developer File menu, point to New > Attribute. x. Plano, Texas, United States. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. Microstrategy Dossiers With the release of MicroStrategy 10. g. mdb) and C:Program Files (x86)MicroStrategyTutorial. 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. Depending on your MicroStrategy product and licensing. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. format_mask is optional. 1 and 10. This article explains how to model recursive hierarchies in MicroStrategy. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. The ID is distinct. AddDays. 1 and 10. Used Enterprise manager to create reports on the project usage and report usages. 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. Microstrategy Dossiers With the release of MicroStrategy 10. arithmetic operators) can be used. 4. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. Creating a . Using these functions, MicroStrategy generated SQL. nction Types. To Define a Join Between the Columns of Two Tables. Save and assign a name to the file like “My_first_connection_file. Click OK. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE. These functions are not supported by the Analytical Engine, so they must be calculated by the database. 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. If you are looking to learn. I originally cut and pasted the syntax from SQL+ into the attribute statement and tweaked it. MyDate,sysdate,#0,#1)",Fact1,Fact2) OR. 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. 3K. The MicroStrategy Case statement should work fine. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. Number of Views 48. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). e. For example, ApplySimple("#0 * #1",[col1],[col2])indicates that two items, col1 and col2, referenced as. 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. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. 이 작업은 ApplySimple() 와 ApplyAgg() 함수를 팩트와 메트릭 정의에 활요함으로서 이루어질 수 있습니다. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. HTCMS (Programmer) (OP) 19 Feb 04 20:41. Keep the form expression unchanged. x-10. Custom groups; A custom group is a special filter that can be placed on a template and is. x-10. 00" format. Nick. Sum, Max, etc) can be used. Relate tables contain the ID columns of two or more attributes, which will define associations between them. 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. 1 and 10. When a user types in keywords to tries to find element names in an element prompt, the search returns all objects containing the keywords in MicroStrategy Developer 9. Select your custom visualization. {Select a Month} and ApplySimple("DateAdd('m',-11,#0)",{Select a Month})) Relate by System Default. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. 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. 1 and 10. From the Database connection type drop-down, choose Snowflake. Syntax. Add the derived metric to the report and hide it by setting the column width to 0. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine ApplyComparison. DaysBetween. Number of Views 2. The index for referencing these objects begins with 0 and increases by for each successive object passed. Microstrategy Dossiers With the release of MicroStrategy 10. The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. Microstrategy Dossiers With the release of MicroStrategy 10. Let me know if you need additional information. ", Arg1, Arg2). Case. 0. YTD transformation. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. The script inside the " " always depends on the type of database used and. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Select Filter definition prompt -> Choose from an attribute element list as shown below. In the layout tab, click "Allow multiple selections". MicroStrategy parser doesnt recognize NULL as a key word for null value. 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:To burst a file subscription across multiple subfolders. If your database does not include SQL syntax support for a date and time function, the function cannot be. Syntax. 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. 4. In addition, MicroStrategy also allows a business user to design custom ANSI SQL queries with a live connection to leverage any database push-down optimization such as query. I just verified taking the SQL generated by MSTR back into SQL+ -- the SQL+ results work as they should; however, the report results are different. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. e. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. But, it will calculate at the lowest Data level if that is your intention. MSTR has evolved. ITtoolbox. In MicroStrategy Developer, log in to the project source that contains the fact to create a new column alias for. 1. MicroStrategy Web supports basic HTML tags on warehouse elements, including the tag for HTML hyperlinks. [MSTR User]. MicroStrategy recommends to have only one child at the lowest level. You could use applysimple on the attribute definition to display 'NULL; Example:This article describes features that are not supported when using Dynamic Sourcing. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . This section describes the date and time functions. Select any project that is in the project source that contains the users and groups and click Next. , ApplySimple or ApplyAgg). When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Phoenixier. x does not have the inherent functionality to truncate numbers like this, it is possible to do it using the 'ApplySimple' function. "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. mstrc” file needs to be created for an environment connection prior submission, please follow these steps. The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal. Visit the data visualization and data dashboard galleries for inspiration. mdb and TUTORIAL_METADATA_7200. Save the prompt as "Call Center Prompt". User may have the requirement to limit the date range selection within a specified period based on a single date prompt. 98K. If users attempt to apply a prompt. Example 1 Using an attribute The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. 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. g. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Fact Editor in edit mode so that. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . ACTION: Use Concat function instead. Metric Join Type: VLDB Setting at Database Instance Level Report. Unfortunately this is a "decode within a decode" and isn't. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). microstrategy. The calculation of the difference is based on the number of day boundaries crossed, not the number of twenty-four hours periods elapsed. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. C:Reports {&RecipientName}, all subscriptions using that file device are delivered to subfolders of C:Reports. You can get to exactly the same result using "regular" MicroStrategy Objects _and_ this is a lot easier to tune (and sometimes, the MicroStrategy SQL engine will do some good optimization in the way the SQL is. 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". ) functions are used. 4. Loading × Sorry to interruptKB42225: How to create a distinct count subtotal from base report in MicroStrategy Web Number of Views 6. 2. Web/Desktop requires making use of a Live Connect dataset (either Data Import - Pick Tables or from Existing Objects). solutions Forum; YTD transformation. g. Number of Views 4. Syntax. Our solutions work to guide towards best practices and provide guidance to the user community. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. However, the ApplySimple statement is running a database-specific function(s), and with this example, changing the data type from Datetime to Char. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced as #0. 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. Create a metric with M03 = MonthStartDate (CurrentDate). 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. Concat("Images/demo/s", [BARANG_ID_INT], ". Follow the steps below. The Dynamic Dates in MicroStrategy SQL Generation Engine 9. 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. 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. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. In a cube containing data from the MicroStrategy Tutorial project, the following metric ranks over the lowest level attribute in the Product hierarchy used on the report. XSTEPS TO IMPLEMENT.