Data files can be published as either an In-Memory Cube or a Live Connect Cube. The script inside the " " always depends on the type of database used and. Relationship tables in Microstrategy. For reference, refer to the Snowflake release notes. Change the DESC form expression to the following. In this table, the PARENT_ID column logically points to another row in the same table (ID column). Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 4. In addition to the the pre-defined options for metric formatting, MicroStrategy supports custom formatting. Click OK. Microstrategy Dossiers With the release of MicroStrategy 10. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced as #0. CAUSE: This is currently working as designed. X to be seen in MicroStrategy Web 9. 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. ApplyAgg: where aggregate functions (e. This feature is similar to what we see in. Download the following driver to the server hosting your Intelligence Server: TGZ for Linux. There's a reason we're at the top of the list. 4. ApplyComparison where. 1 and 10. ApplySimple This is the most common function, as you can use it in an Attribute definition. 4. 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. Create a Report Services Document 2. Using Prompts and ApplySimple Statements. In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. You can use the ApplyComparison function to define custom filters. You can use them in many different capacities, which include, creating or modifying both schema and user objects. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). The new functions in Microstrategy are pretty smart and convert the generic function to the database specific function when it queries the database. It is used to define compound metrics via. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. 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. -dinzana. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. MSTR has evolved. Example 3: ApplySimple ApplySimple ("Datediff (YY,#0,getdate ())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. Select the attribute form to be displayed with a link. x that require single quotes in the definition. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. MicroStrategy with Google Big Query. This function does not take input variables. x-10. Microstrategy Dossiers With the release of MicroStrategy 10. 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. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. This section describes the date and time functions. Follow the steps below. xApplySimple("year(date(#0) - 2 MONTHS)*100+month(date(#0) - 2 MONTHS)",CustomAttriubte@ID). Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. NewObject (DssTypeMDSecurityFilter) objMDFilter. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. 0. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Select the DSN. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. x, a passthrough function, such as ApplySimple, cannot be used on a prompt in a report based off of an Intelligent Cube. In the Database Connections dialog, enter a database connection name. x, with the Intelligence Server running on Linux,. Presented by MicroStrategyBlog. The Select Bursting Criteria options are displayed. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. x. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Depending on your MicroStrategy product and licensing, this function may not be available. Victoria is experiencing low interest rates too. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. ApplyRelative: where Online Analytical Processing (OLAP) functions (e. Personalizing file locations. 4. Keep the form expression unchanged. Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. 1. ApplySimple("Case when #0=1907 then 'Daily' else 'Weekly' END", ) After updating schema, the report works fine as shown below: Published: Jun 6, 2017; Last. Create a metric with the ApplySimple statement below as its definition and name it "Case Metric": ApplySimple ("CASE WHEN #0 <= 2000 THEN #1 WHEN #0 >= 2001 THEN #2 END", ? [P1], Revenue, Profit) Note: This example will prompt users for a value. 1 and 10. 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. Copy the code for the D3 visualization you are using. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Define the advance sort on the derived. Viewed 13k times. MSTR has evolved. Recommendation. Examples of this category are simple mathematical. ", Arg1, Arg2). 44K KB440320: How to create multiple metric comparison conditions to filter a report which allows to prompt for one value inpu…Custom formatting metric values of 1,100,000 into a 1. A human reader can see from the ApplySimple SQL string that the revenue value will be returned (meaning that the datatype should be Float). 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. Users may need to list all objects (e. g. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. 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. Select your custom visualization. I now want to find the % faulty from total, and have created. The steps below use objects from the MicroStrategy Tutorial project as an example. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. How to create fact that does not get rounded up when calculated with MicroStrategy Developer 9. In most cases, these values are not recognized as MicroStrategy objects. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. Fu. It should work. 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". Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. How to create a MicroStrategy connection file (. Dynamic date qualifications are not supported against MDX cube data sources, but the same results can be achieved by using custom MDX expressions. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. The steps below demonstrate how to create a filter that qualifies on months prior to the current month using a custom expression in an advanced qualification in MicroStrategy Developer 9. e. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. This allows you to use MicroStrategy's built-in functions in your qualification. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. I originally cut and pasted the syntax from SQL+ into the attribute statement and tweaked it. 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. This document describes the second approach. x . x. Phoenixier. 4 and later. Users may need to list all objects (e. The expression editor in MicroStrategy Developer provides an escape sequence to support double-quote marks in a string. 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. Ragged Hierarchies in Microstrategy. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x. &[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. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. Case can be used for categorizing data based on multiple conditions. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. x. But, it will calculate at the lowest Data level if that is your intention. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Whenever users submit an element browse request or a report. 2. 4. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. 1 and 10. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. In this article we will discuss the ApplySimple function. Use the ApplySimple pass-through expression to create the HTML tag expression. Microstrategy Dossiers With the release of MicroStrategy 10. Number of Views 3. Set Data Engine Version setting to 12. The Code Editor tab should be open. 4. Fu nction Types. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. the columns separated by commas at the end with an ending close Paren. x. g. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. 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. 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. g. MicroStrategy’s strongest feature is it’s SQL Engine. 35K. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. Recommended VLDB Properties for use of MicroStrategy 9 with Hive 0. : ApplySimple ("Decode (T1. CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. In the Database Connections dialog, enter a database connection name. . ", Arg1, Arg2). Case can be used for categorizing data based on multiple conditions. Create a Custom Group Element using the Relationship filter created in step 3: 5. 4. snowflakecomputing. This is a single-value function. If the first date argument is later than the second date argument, the result is a negative number. The following steps can be used to concatenate two attribute forms. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. MicroStrategy supports any UDF defined on Teradata through the use of pass-through functions, such as ApplySimple. Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports. Reports that contain B or C will ignore filters on the other. x-10. The prompt "Choose from all elements of 'Category'" is also placed into the report. 2. These triggers do not need to be defined in advance. mstrc file from an empty text file. ; Distinct is a TRUE/FALSE parameter that allows you to. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. 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. Save the prompt as "Call Center Prompt". 94K. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. , ApplySimple or ApplyAgg). 1 and 10. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Open up the same document in MicroStrategy Web 10. Syntax. The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. ApplyRelative where OLAP (ranking, etc. Number of Views 48. 1. 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. Microstrategy Dossiers With the release of MicroStrategy 10. Sum <Distinct, FactID, UseLookupForAttributes>(Argument)Where: Argument is an attribute, fact, or metric representing a list of numbers. Click New. 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. ACTION: Use Concat function instead. These functions are not supported by the Analytical Engine, so they must be calculated by the database. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. However, the ApplySimple statement is running a database-specific function(s), and with this example, changing the data type from Datetime to Char. 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. 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. Upgrade to MicroStrategy m2020 or later release. 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. 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. 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. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. This issue can be solved in two steps using a MicroStrategy 10. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 2. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Deploy the ojdbc8. From the Database connection type drop-down, choose Snowflake. x pass-through function, in this case the ApplySimple function. ApplyComparison: where comparison operators (e. g. The fractional part is removed without rounding the number up or down. ACTION: Contact MicroStrategy Technical support for an update of this. MSTR has evolved. comApplySimple functions are used for simple expressions that use arithmetic operators. 다음의 예시 화면은 MicroStrategy Tutorial 프로젝트 안에서, 단순히 ORDER_DETAIL 과 ORDER_FACT 테이블을 사용해서 만들어졌습니다. Users wish to execute scripts in MicroStrategy Command Manager 9. x using an Oracl… Number of Views 6. ITtoolbox. com Para jpviva. These functions are supported by the Analytical Engine. Trending Articles. "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. DATA ANALYSIS 102. Explanation. Right-click on an existing environment and choose Properties. Fu nction Types. KB39990: How to use ApplySimple to create attribute form to support sorting configuration in the attribute editor in MicroStrategy Desktop and Web 9. 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. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. These functions are not supported by the Analytical Engine, so they must be calculated by the database. Syntax. From the MicroStrategy Developer File menu, point to New > Attribute. x and higher. Unfortunately this is a "decode within a decode" and isn't. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. arithmetic operators) are used. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. 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. x mixed case columns names for a DB2 database by default have SQL generated with quote characters enclosing the name . Using Prompts and ApplySimple Statements. Database administrators can store HTML tag elements directly in the data warehouse, but MicroStrategy also has the ability to add HTML tagging to non HTML elements by using the ApplySimple database function. com) In the popup that opens, select ODBC. 4. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. , the report always contains a clause such as 'WHERE MONTH_ID = 200107', for the current month. 1 and 10. 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. A table containing data that points to another row within the same table is said to have a recursive reference or to conform a recursive hierarchy. When using OLAP Cube data sources, aggregation at multiple levels can be performed in two ways. thread395-610882. Personally, I would use ApplySimple and let the database handle the work. Examples of this category are simple mathematical. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. 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]. Follow the steps below. ')"; [Net Weight. In MicroStrategy Developer, create a dummy metric with the following definition. kumar says: September 5, 2008 at 8:48 am iam asking a. g. ApplySimple where simple (e. 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. Click New. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. 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. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. it looks like MicroStrategy doesn't support it, please advise. . Examples of this category are simple mathematical. Examples of this category are simple mathematical. 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. Number of Views 4. g. Right-click the fact and select Edit. The syntax used in ApplySimple is incorrect for SQL Server 2012 database. x. Could you please update the list…. If two users with different security filters run the same report, they may get different results. 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. The prompt may be used in the ApplySimple function, and will be substituted at runtime. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. 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. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. MicroStrategy Technical Support does not provide customized MDX queries. Using a combination of filters and metric dimensionality, the same results can be achieved. i need to. Microstrategy Dossiers With the release of MicroStrategy 10. 0. 4. xThe 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. Create a metric with M03 = MonthStartDate (CurrentDate). To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. You can use the MicroStrategy CASE function, available in MicroStrategy Developer (\\Schema Objects\Functions and Operators\Functions\Internal Functions), to retrieve desired result sets. 4. 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 This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it seems that the BBDD is ORACLE), and breaks it down by product. 4. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. Microstrategy Dossiers With the release of MicroStrategy 10. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Community & Support Search Discussions Open A Case View My CasesTo create the MDSecurity filter, users can either populate the new MDSecurity filter with the definition of an existing filter or define the BottomLevel, TopLevel and Expression properties. Create a numeric value prompt and name it P1. This section describes the date and time functions. 2 for a '(VARCHAR2 (4 BYTE)' column. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to. This is a single-value function. cc Assunto [microstrategy-l] ApplySimple function in MSTR 7. Case. microstrategy. ApplyAgg: where aggregate functions (e. Microstrategy Training Centers in Victoria, BC – List of Microstrategy certification training, classes, Institutes in Victoria, Know more about Microstrategy fees. A derived expression can only use single-value functions, and arguments that are used in the expression are columns. These functions can be used in a MicroStrategy expression as follows, take ApplySimple function for example, create a metric using expression below (Average and Avg are existing metrics): ApplySimple ("case when #0 >. The current year can be returned by putting: Year (CurrentDate ()) for your comparison. This means that an attribute. 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. Select only Configuration Objects for documentation. In MicroStrategy Web, edit or execute a report. Complex functions that use combinations of metrics, attribute forms and facts as arguments must use an ApplyAgg. Create New Metric in a report or VI. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. 4. But, it will calculate at the lowest Data level if that is your intention. x use the Day attribute to qualify on a particular date. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. To create a column alias for a fact. In short, some attribute elements don't have a relationship with their parent/child attribute. 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. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. Whatever the final sql is (1) take the final sql, (2) Wrap. The 'Choose a Prompt Style' dialog box opens. g. x, with the Intelligence Server running on Linux, the. 이 작업은 ApplySimple() 와 ApplyAgg() 함수를 팩트와 메트릭 정의에 활요함으로서 이루어질 수 있습니다. 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. ApplySimple() Accepts facts, attributes, and metrics as input. x, select 'Project Documentation' from the Tools menu to start the wizard. This is a single-value function. Create a Report Services Document 2. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. This means that every metric is evaluated in separate SQL passes. 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. My gloal is to cast a fact column to double value. 6. To ensure this prompt requires an answer, select the 'Prompt answer is required' check box. Close the Visualization Builder, and then re-open it. 4. This true in any case where an explicit datatype is required. Click New. The MicroStrategy SQL Engine 9. Split Hierarchy with M-M relationships: Explanation. Now your connection f. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result.