It is suggested to use quotes to get exact phrase when there is a space between. g. KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. For example, ApplySimple("#0 * #1",[col1],[col2]). It must then add these tables to its MicroStrategy project, and create the appropriate attributes so report users can analyze business data for their appropriate country. ApplySimple. Change the DESC form expression to the following. Microstrategy Caches Improving Response Time: Caching A cache is a result set that is stored on a system to improve response time in future requests. 1 and 10. Expression: ApplySimple("FORMAT(#0,'yyyy-MM-dd')", [DAY_DATE]) Save the modification and update schema. MSTR has evolved dashboards to the point that they. 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. Microstrategy - creating a simple percentage column. x-10. If I select name1 from the prompt, I do need to show all the occurances of. 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. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. A system external to Intelligence Server is responsible for determining whether the conditions for triggering an event are met. The index for referencing these objects begins with 0 and increases by for each successive object passed. If the metric formula includes other operations outside of the ApplySimple function, these operations could be evaluated by the Analytical Engine and the smart metric option would be expected to. In SQL Server, it would be as follows: Applysimple ("#0 + char (13) + #1 + char (13) + #2 + char (13) + #3" STREET, CITY, STATE, ZIP) where (13) is the ascii code for. Syntax. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. 4. 1 and 10. Select your custom visualization. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . In Microstrategy I am trying to create a new fact that returns a specific name depending on the type of text contained in the field NAME. Save the prompt as "Call Center Prompt". x fails to generate SQL for a metric based on a fact defined with an ApplySimple statement SYMPTOM: SQL for a metric based on a fact defined with an ApplySimple statement is missing in the report SQL at run time in MicroStrategy 9. Select a prompt style and click on 'OK'. 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. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. Microstrategy Dossiers With the release of MicroStrategy 10. If users attempt to apply a prompt. 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. Could you please update the list…. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). 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. Deploy the ojdbc8. Add the metric to a simple report and execute. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. To Define a Join Between the Columns of Two Tables. Victoria is experiencing low interest rates too. The ApplySimple function is used exactly as in SQL reports, with the passthrough syntax enclosed in double quote marks, followed by a list of MicroStrategy objects or expressions separated by commas, for example:. ApplySimple("SUBSTR(#0,1,3)", ) Apply. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. But, DESC has repeating values. Create a Report Services Document 2. ApplyAgg where aggregate functions (Sum, Max, etc. Microstrategy Caches Improving Response Time: Caching A cache is a result set that is stored on a system to improve response time in future requests. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1K. 4 and later. 00" format. For new columns to be available for attribute and fact creation in MicroStrategy Architect, the table structure must be updated. Users need to change the expression accordingly based on the. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. This is a comparison function. But since the length of the month ranges between 28-31 days it. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. MicroStrategy - Dynamic Attribute with join. Depending on your MicroStrategy product and licensing, this function may not be available. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. 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. MyDate =. This article describes a behavior observed when adding a new attribute form expression with Workstation, if the ApplySimple function is used. x and 10. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Select any project that is in the project source that contains the users and groups and click Next. ApplySimple may be used in one or both sides of a comparison expression. Upgrade to MicroStrategy m2020 or later release. x. 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. 4. If all conditions are false, a default value is returned. x. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. Examples of this category are simple mathematical. Define the advance sort on the derived. Change the DESC form expression to the following. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. x, with the Intelligence Server running on Linux,. 1 and 10. Step 2) Create a metric using the following syntax, Sum(ApplySimple("#0", <Attribute Name>, 1)){~}. How to create a MicroStrategy connection file (. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. MSTR has evolved. Using Prompts and ApplySimple Statements. The prompt may be used in the ApplySimple function, and will be substituted at runtime. 4. 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. Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. You can use the ApplyAgg function to define simple metrics or facts by using database-specific, group-value functions. I want to find out the number of Widgets that were faulty, so I created another metric with that. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. KB32365: How to use element list prompts in database passthrough functions In MicroStrategy SQL Generation Engine. 1 and 10. 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. The prompt may be used in the ApplySimple function, and will be substituted at runtime. For reference, refer to the Snowflake release notes. 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. 35K. Thanks. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. For example: • 1/ Attribute [Net Weight] = 0,5 (type of data is. 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. 0. My gloal is to cast a fact column to double value. Make two grids with different attributes and metrics in each 3. 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. 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. Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. ) are used. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. x-10. Select the DSN. x-10. From the Database connection type drop-down, choose Snowflake. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. You can use CASE, which will apply the changes in the analytical engine or you can use ApplySimple to pass your Case statement down to the database. This function does not take input variables. g. Use the datetime format defined on warehouse database side in the ApplySimple statement. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default. This technical note outlines the differences between Consolidations and Custom Groups in MicroStrategy 9. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. x, with the Intelligence Server running on Linux, the. The user should enter two double-quote marks in succession, as shown. . SyntaxCurrentDate. The same logical should apply for other databases, but the syntax will need to be changed. 4. I have a problem and can't understand how create metrics. 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. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. 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. For the example above, the Count metric should use Null for the ELSE statement so not to count anything when #0 meets the condition. MicroStrategy Web supports basic HTML tags on warehouse elements, including the tag for HTML hyperlinks. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. 0. But, it will calculate at the lowest Data level if that is your intention. The database instance is created. 62K. The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)In some scenarios, it is necessary to use a database passthrough function (ApplySimple, ApplyComparison, ApplyAgg) to achieve specific query syntax that is not natively generated by the MicroStrategy SQL Generation Engine. Below is what I tried but it did not work. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". In this table, the PARENT_ID column logically points to another row in the same table (ID column). 2. 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. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Create a report with Category, Subcategory and Revenue. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. The MicroStrategy Case statement should work fine. 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. Close the Visualization Builder, and then re-open it. This true in any case where an explicit datatype is required. If you are looking to learn. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. In MicroStrategy Desktop, double-click on the attribute to be modified. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. to_char (case when Date_DESC is null then to_date (`31-DEC. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. The MicroStrategy SQL Engine 9. Fu nction Types. Open the project in which a new column is added. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. Right-click on an existing environment and choose Properties. 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. Creating a . Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. Open up the same document in MicroStrategy Web 10. "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. Case can be used for categorizing data based on multiple conditions. double quotes around it, substitute the column names with #0 . 1 and 10. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. Hi All, Can anyone tell me how to use Applysimple in Microstrategy=2E=2E=2Ei= need to do something like ApplySimple (""Monthly Recon '. 2 Can anyone tell me how to create a Filter using Applysimple in Microstrategy 7. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. HyperIntelligence and its Architecture. CAUSE: This is expected behavior. ApplyAgg: where aggregate functions (e. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. Add the derived metric to the report and hide it by setting the column width to 0. Trending Articles. Relate tables contain the ID columns of two or more attributes, which will define associations between them. 1 and 10. December 07, 2018. x. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Metric Join Type: VLDB Setting at Database Instance Level Report. The following steps demonstrate how to use the comparison operator prompt. 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. Returns the difference in days between two given dates as an integer value. To create a prompt that places the maximum date value from a warehouse table as the. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. 4. In this article we will discuss the ApplySimple function. Select Filter definition prompt -> Choose from an attribute element list as shown below. Keep the form expression unchanged. It should work. Click New. The Dynamic Dates in MicroStrategy SQL Generation Engine 9. RE: YTD. . Syntax. Thanks a lot for the 101 Microstrategy Question…. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. MSTR has evolved. This true in any case where an explicit datatype is required. These triggers do not need to be defined in advance. This is a group-value function. x use the Day attribute to qualify on a particular date. This is a single-value function. Use ApplySimple in the form expression and change the date format to yyyy-mm-dd. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. Now your connection f. This week I bring a very useful functionality in MicroStrategy: Pass-through functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query. Personally, I would use ApplySimple and let the database handle the work. Within a project, a security filter may be specified for any user. 1 and 10. Create a metric using either definition: ApplySimple("Sum(#0)", ?Year) Or ApplySimple("Sum(#E0)", ?Year) 3. x-10. x, select 'Project Documentation' from the Tools menu to start the wizard. The Select Bursting Criteria options are displayed. MSTR has evolved. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY) as the Source table. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). ApplySimple. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. 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. This is a single-value function. The following example uses MicroStrategy Tutorial to explain the construction of a Year-To-Date metric. Syntax. 4. So far we have only found ways to change the. The current logic I've found is below. DATA ANALYSIS 102. MicroStrategy with Google Big Query. 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. Save and assign a name to the file like “My_first_connection_file. MicroStrategy does not currently support element prompts inside of metric definitions. You can use them in many different capacities, which include, creating or modifying both schema and user objects. For more details on enabling the setting, see Change Data Engine Version. Number of Views 3. There's a reason we're at the top of the list. Sum <Distinct, FactID, UseLookupForAttributes>(Argument)Where: Argument is an attribute, fact, or metric representing a list of numbers. I can't remember if the strings have to be enclosed in single or quote quotes. In most cases, these values are not recognized as MicroStrategy objects. 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine ApplyComparison. Examples of this category are simple mathematical. 1 and 10. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. In the layout tab, click "Allow multiple selections". 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. From the File menu, click Open. Splitting the fraction: Numerator: Sum (VOL) {~} Denominator: Max ( ApplySimple ("replace (#0, ',', '. These functions are not supported by the Analytical Engine, so they must be calculated by the database. i need to. 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. ", Arg1, Arg2). An example of this behavior is as follows: Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. If all conditions are false, a default value is returned. Data files can be published as either an In-Memory Cube or a Live Connect Cube. Apply the filter Year=2002 to your report. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced as #0. the columns separated by commas at the end with an ending close Paren. The ApplyComparison function is used with comparison operators such as >, Like, and In. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. A split hierarchy is one - that at the lowest level - has more than one child. 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. Save the filter as "Region Filter". 1 and 10. Concat is often used to combine related values, such as a first and last name. MicroStrategy will continue to investigate and post updates as soon as they are available. x. 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. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. x use the Day attribute to qualify on a particular date. xApplySimple("year(date(#0) - 2 MONTHS)*100+month(date(#0) - 2 MONTHS)",CustomAttriubte@ID). 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. The ApplySimple statements given above are ORACLE Specific. MSTR has evolved. 4. Click OK. Concat is often used to combine related values, such as a first and last name. To ensure this prompt requires an answer, select the 'Prompt answer is required' check box. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Using a combination of filters and metric dimensionality, the same results can be achieved. 4. However, the user would like to search for the exact phrase. The ApplySimple function is used with simple operators and functions. This means that every metric is evaluated in separate SQL passes. The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal. MyDate,sysdate,#0,#1)",Fact1,Fact2) OR. The calculation of the difference is based on the number of day boundaries crossed, not the number of twenty-four hours periods elapsed. x. Viewed 13k times. In addition to the the pre-defined options for metric formatting, MicroStrategy supports custom formatting. For example, if you specify the File Location as. ApplySimple() Accepts facts, attributes, and metrics as input. 2. For. ApplyRelative: where Online Analytical Processing (OLAP) functions (e. mstrc, please open a Notepad or Notepad++. 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 three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. SYMPTOM: In MicroStrategy 9. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. The recommended VLDB optimizations for Hive 0. 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. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. 08K. 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. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. solutions Forum; YTD transformation. 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. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 3 environment, we have a star schema that has multiple date dimensions. 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. Right-click the fact and select Edit. Number of Views 4. A ragged hierarchy is the one in which the parent or child attribute element of one or more attribute elements are not present in the level immediately above or below the attribute. By default, all of the columns used in an expression must originate from the same table. The ApplyComparison function is used with comparison operators such as >, Like, and In. ApplySimple ("_PARTITIONTIME", [AnyColumnName]) Note: This will work in MicroStrategy Developer for IT and in MicroStrategy Web/Desktop for Business Users. 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. Concat is often used to combine related values, such as a first and last name. 7x are listed below. 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. All attributes used to group data in the report or document are shown in the Available Attributes list. Click New. ApplyAgg where aggregate functions (Sum, Max, etc. 3 – Enter the desired. 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. x. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". C:Reports {&RecipientName}, all subscriptions using that file device are delivered to subfolders of C:Reports. microstrategy. Our solutions work to guide towards best practices and provide guidance to the user community. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. This document provides the steps to accomplish the same. 4. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. x using an Oracl… Number of Views 6. mdb and TUTORIAL_METADATA_7200. 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. The result does not. It should work. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;.