My gloal is to cast a fact column to double value. MyDate =. The syntax used in ApplySimple is incorrect for SQL Server 2012 database. User may have the requirement to limit the date range selection within a specified period based on a single date prompt. These triggers do not need to be defined in advance. By design, however, MicroStrategy SQL Generation Engine 8. 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. The current logic I've found is below. Microstrategy Dossiers With the release of MicroStrategy 10. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. Personally, I would use ApplySimple and let the database handle the work. In addition to the the pre-defined options for metric formatting, MicroStrategy supports custom formatting. The types of arguments determine how the parameter markers inside the pattern are replaced. Using a combination of filters and metric dimensionality, the same results can be achieved. 1. 62K. x. Depending on your MicroStrategy product and licensing. 08K. A split hierarchy is one - that at the lowest level - has more than one child. 2. JDBC is more performant than the ODBC. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. . This technical note provides an example of how to calculate the number of days between the current date and a date attribute. e. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Number of Views 4. Syntax. Something like: ApplySimple("'Y'", [your metric here]). To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. x pass-through function, in this case the ApplySimple function. x and 10. The 'Choose a Prompt Style' dialog box opens. : ApplySimple ("Decode (T1. 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. Syntax. microstrategy. 35K. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. KB484697: How to use the ApplyX function without the "Use FreeForm SQL Report" privilege. Expression: ApplySimple("FORMAT(#0,'yyyy-MM-dd')", [DAY_DATE]) Save the modification and update schema. It is suggested to use quotes to get exact phrase when there is a space between. Microstrategy Dossiers With the release of MicroStrategy 10. Users may need to list all objects (e. In the Database Logins dialog, enter your login credentials. Using these functions, SQLs generated by MicroStrategy will call UDF just like any other function provided by Db2. 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. 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. This allows you to use MicroStrategy's built-in functions in your qualification. . We are active contributors to solutions on the MicroStrategy Community site. 1 and 10. 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. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. MSTR has evolved dashboards to the point that they. This true in any case where an explicit datatype is required. Create a numeric value prompt and name it P1. g. 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. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. This is a single-value function. ApplySimple: ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. 94K. For example, ApplySimple("#0 * #1",[col1],[col2]). 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. x adn 10. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. x-10. x report for a specific attribute using an ApplySimple statement as one of its forms. 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. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . ) are used. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. The prompt may be used in the ApplySimple function, and will be substituted at runtime. nction Types. ) can be used. MicroStrategy will continue to investigate and post updates as soon as they are available. Click New. mstrc, please open a Notepad or Notepad++. Examples of this category are simple mathematical. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. It should work. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Dynamic date qualifications are not supported against MDX cube data sources, but the same results can be achieved by using custom MDX expressions. 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. Subscribed reports or documents for each. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Relate tables contain the ID columns of two or more attributes, which will define associations between them. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. 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. 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. A derived expression can only use single-value functions, and arguments that are used in the expression are columns. MicroStrategy Internal Reference number for this technical note is KB483717 and. arithmetic operators) are used. 1 and 10. Right-click the fact and select Edit. 2 release, the driver file is called odbc8. 이 작업은 ApplySimple() 와 ApplyAgg() 함수를 팩트와 메트릭 정의에 활요함으로서 이루어질 수 있습니다. Reports that contain B or C will ignore filters on the other. Microstrategy Dossiers With the release of MicroStrategy 10. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 1 and 10. The following steps can be used to concatenate two attribute forms. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Microstrategy Dossiers With the release of MicroStrategy 10. Let me know if you need additional information. 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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Sum is a group-value function. Microstrategy Dossiers With the release of MicroStrategy 10. Relate tables are often used to create relationships between attributes. Microstrategy Dossiers With the release of MicroStrategy 10. The database instance is created. 4. Select a prompt style and click on 'OK'. 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. string1 is the string that will be converted to a date. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. Example 1 Using. Set Data Engine Version setting to 12. 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'. Depending on your MicroStrategy product and licensing. For this example, assume we have a order_fact table has two dates, order_date and ship_date and an. These values are set by default when the "Hive 0. . 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. x, select 'Project Documentation' from the Tools menu to start the wizard. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. I can't remember if the strings have to be enclosed in single or quote quotes. percentage. 4. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. The database instance is created and can. 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, 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. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9 You have 2 options. EXAMPLES: Using the Populate method: Set objMDFilter = mobjObjSource. 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. If the first date argument is later than the second date argument, the result is a negative number. 2. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. Select the DSN. You can use the ApplyComparison function to define custom filters. Add the metric to a simple report and execute. [MSTR User]. Case can be used for categorizing data based on multiple conditions. From the MicroStrategy Developer File menu, point to New > Attribute. This is a single-value function. Change the DESC form expression to the following. Use the datetime format defined on warehouse database side in the ApplySimple statement. 1 and 10. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. 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. Phoenixier. 4. This means that an attribute. Web/Desktop requires making use of a Live Connect dataset (either Data Import - Pick Tables or from Existing Objects). Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. MSTR has evolved. 4. This document provides the steps to accomplish the same. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. , metrics or attributes) containing a particular function or operator (e. Using these functions, MicroStrategy generated SQL. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. . 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]. Number of Views 2. Open the project in which a new column is added. The syntax always follows the format Applyfunction ("#0. Number of Views 1. All articles. 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. 1 and 10. KB39990: How to use ApplySimple to create attribute form to support sorting configuration in the attribute editor in MicroStrategy Desktop and Web 9. Users wish to execute scripts in MicroStrategy Command Manager 9. Something like: ApplySimple("'Y'", [your metric here]). Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. Make two grids with different attributes and metrics in each 3. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. 1. 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. MSTR has evolved. ApplyRelative where OLAP (ranking, etc. 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. Right-click on an existing environment and choose Properties. This custom SQL can be used in the. Info. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. From the Database connection type drop-down, choose Snowflake. In other words, ApplySimple("(#0 - #1) / 7", ?, ?) will fail as shown in the example below. Within a project, a security filter may be specified for any user. Case. HyperIntelligence and its Architecture. 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. Click OK. In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. 0 and have to resort use applysimple to take advantage of DB's least function instead. These functions are supported by the Analytical Engine. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. SYMPTOM: In MicroStrategy 9. Another way to accomplish this using ApplySimple instead of ApplyComparison would be to drag the Hour attribute to. Impact: Capability. Number of Views 48. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. &[cbecker] The ApplySimple string can build this ID by using a placeholder where the user login should appear: This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. There's a reason we're at the top of the list. Contact MicroStrategy Technical Support for an update on the status of this request. 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. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. MicroStrategy - Dynamic Attribute with join. In this article we will discuss the ApplySimple function. In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. Step 4) When users execute the report, they will notice that the 'ApplySimple' is ignore resulting in just the Metric Alias. Keep the form expression unchanged. Using Prompts and ApplySimple Statements. The prompt "Choose from all elements of 'Category'" is also placed into the report. 4. Click New. These functions are not supported by the Analytical Engine, so they must be calculated by the database. The example given below relates to an Oracle data warehouse, but many other RDBMSs support similar functionality. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default. Case can be used for categorizing data based on multiple conditions. Sum <Distinct, FactID, UseLookupForAttributes>(Argument)Where: Argument is an attribute, fact, or metric representing a list of numbers. KB485687: The bulk insert is not working which caused performance issue when running multi-source reports. If the cube dimension's key data use the MicroStrategy login directly, the formula can be relatively simple. This is a group-value function. 1. The MicroStrategy SQL Engine will join database tables together based on the lowest level attributes that MicroStrategy Architect assigns to each table. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. For example, ApplySimple("#0 * #1",[col1],[col2])indicates that two items, col1 and col2, referenced as. ApplySimple (" 'Text goes. Case. x, with the Intelligence Server running on Linux,. nction Types. 3 – Enter the desired. In the Database Connections dialog, enter a database connection name. 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. x-10. 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. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. The ability to define object relationships and then allow MicroStrategy to generate all of the appropriate SQL as you manipulate and drill is the core of the product. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. view, MicroStrategy Logical View) - or not use an attribute form and use a metric instead (that's in relation to the varchar2 data type you mentioned below, since by default, MicroStrategy will pick the column datatype you are using in the applysimple) Now, if what you are saying that you need to apply that functionI tested using internal least function on metics in 7. The MicroStrategy Case statement should work fine. 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. MicroStrategy does not currently support element prompts inside of metric definitions. However, the user would like to search for the exact phrase. 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. Use ApplySimple in MicroStrategy. The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal. The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. The recommended VLDB optimizations for Hive 0. CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. HTCMS (Programmer) (OP) 19 Feb 04 20:41. x, with the Intelligence Server running on Linux, the image in the exported PDF. 4. To create a column alias for a fact. 2. 6. 2. In the right corner of the dashboard, change the. The new functions in Microstrategy are pretty smart and convert the generic function to the database specific function when it queries the database. Insert an HTML container (and not an image) and insert the script below. 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. MSTR has evolved. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Download and extract Snowflake ODBC driver from Snowflake console. Microstrategy Dossiers With the release of MicroStrategy 10. • Involved in understanding and transmitting the business requirements for the project and. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. CAUSE: This is currently working as designed. This is a single-value function. Save and assign a name to the file like “My_first_connection_file. However, the ApplySimple statement is running a database-specific function(s), and with this example, changing the data type from Datetime to Char. To create a MicroStrategy Environment connection file . Navigate to the Layout Tab. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. MicroStrategy Technical Support does not provide customized MDX queries. Creating a . STEPS TO REPRODUCE: 1 - In the MicroStrategy Tutorial project create a new attribute form in the Category attribute with the following expression:For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. When using OLAP Cube data sources, aggregation at multiple levels can be performed in two ways. ACTION: Contact MicroStrategy Technical support for an update of this. ApplySimple("SUBSTR(#0,1,3)", ) Apply. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. x using an Oracl… Number of Views 6. 1 and 10. Also, I have to move null handling to RDBMS via the function- NVL (Oracle), IsNull (SQL Server), and Coalesce (DB2) because conditions and calcs done in the database don't benefit from MSTR's. Thus directly using NULL in formula will fail. YTD transformation. This is a comparison function. I now want to find the % faulty from total, and have created. 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. 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. Create a file subscription in MicroStrategy Web. arithmetic operators) are used. The example below shows the basic structure of an ApplySimple statement to create metrics. 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. The ApplySimple function is used with simple operators and functions. For new columns to be available for attribute and fact creation in MicroStrategy Architect, the table structure must be updated. I have a problem and can't understand how create metrics. g. This is true whether the null checking is written into the metric formula using the MicroStrategy function NullToZero(My_Fact), or using a database pass-through function such as ApplySimple("NVL(#0, 0)", My_Fact) for Oracle. Select only Configuration Objects for documentation. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. The following of this note assumes the driver was downloaded to. Select the DSN. MSTR has evolved. This document describes the second approach. The schema looks like the following diagram. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. , metrics or attributes) containing a particular function or operator (e. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Note: The form expression in the above sample is for Access database only. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. Choose the Light Theme from the drop down menu and click the Apply button. if both conditions are met, then Red, else Green. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 1K. Examples of this category are simple mathematical. Create a metric with the ApplySimple statement below as its definition and name it "Case Metric": ApplySimple ("CASE WHEN #0 <= 2000 THEN #1. ApplyRelative: where. In the Database Connections dialog, enter a database connection name. mstrc file from an empty text file. The following example uses MicroStrategy Tutorial to explain the construction of a Year-To-Date metric. In the Database Logins dialog, enter your login credentials. Filter functions can only be Equal, And, Or and Not" displays on prompt screen when using ApplySimple on a cube report in MicroStrategy 9. Consolidations and custom groups are two special reporting features that enable user to surpass basic reporting functionality. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . MicroStrategy Web supports basic HTML tags on warehouse elements, including the tag for HTML hyperlinks. 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:Transformation expressions using ApplySimple cannot be optimized because MicroStrategy does not parse or analyze the operations performed in the pass-through SQL string in any way. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. 2. thread395-610882. ApplySimple: where simple operators (e. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. Follow the steps below. Concat is often used to combine related values, such as a first and last name. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. 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. I hope this helps. Presented by MicroStrategyBlog. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). With consolidations, user can group attribute elements to define "virtual" attributes that enable. 0. Use of M03 in Microsoft SQL Server 2000 would result in DATEADD (DD, (1 - DAY (GetDate ())), GetDate ()). You can use them in many different capacities, which include, creating or modifying both schema and user objects. Refer to the following MicroStrategy Knowledge Base technical note for how to create a dummy metric that will return a static string of data:. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. x, select 'Project Documentation' from the Tools menu to start the wizard. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. Click New.