In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. 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. 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. 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. In the Database Logins dialog, enter your login credentials. x adn 10. Users may need to list all objects (e. 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. EXAMPLES: Using the Populate method: Set objMDFilter = mobjObjSource. The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. Select only Configuration Objects for documentation. 6. 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. If the first date argument is later than the second date argument, the result is a negative number. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. You can use the ApplyAgg function to define simple metrics or facts by using database-specific, group-value functions. Define the advance sort on the derived. JDBC is more performant than the ODBC. MyDate =. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. kumar says: September 5, 2008 at 8:48 am iam asking a. The syntax always follows the format Applyfunction ("#0. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. If the precision is needed to be displayed on a report, a workaround is possible by casting the DATETIME data type to a VARCHAR data type. For. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Thus, if a Dynamic Date is created based on today's date, in order to get 'Last Month' a specific number of days can be subtracted from the date. If all conditions are false, a default value is returned. You can use various techniques and interfaces to create and modify attributes for a project: • The Attribute Creation Wizard allows you to:Use the datetime format defined on warehouse database side in the ApplySimple statement. 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. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. ApplyComparison The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. NOTE: For additional information regarding pass-through expression ApplySimple and Attribute form data type, refer to the MicroStrategy technical notes: KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation EngineThis article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. MicroStrategy is a commercial off-the-shelve tool that automates the generation of Snowflake SQL queries through a semantic layer in datasets design. Create a Custom Group Element using the Relationship filter created in step 3: 5. The function removes the fractional part of a real number so that only the integer part remains. x and 10. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). 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. Relate tables contain the ID columns of two or more attributes, which will define associations between them. x. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. 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. 3K. x. . 1 and 10. 0 workflow with Okta can be seen here. 2. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. CONTENTS 1. Impact: Capability. x. ApplySimple("#0", MaxProfit). In threshold, use the condition as "Region_Test where DESC Exactly EMPTY", then threshold will be applied to those elements whose DESC is a space. Refer to the following MicroStrategy Knowledge Base technical note for how to create a dummy metric that will return a static string of data:. 4. This issue can be solved in two steps using a MicroStrategy 10. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Number of Views 49. The user should enter two double-quote marks in succession, as shown. For example, if you specify the File Location as. mdb) and C:Program Files (x86)MicroStrategyTutorial. A derived expression can only use single-value functions, and arguments that are used in the expression are columns. Unfortunately this is a "decode within a decode" and isn't. RE: YTD. The CASE function permits multiple comparisons. 0 and have to resort use applysimple to take advantage of DB's least function instead. Examples of this category are simple mathematical. ) functions are used. Relationship tables in Microstrategy. 2. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. Create a Fact using two expressions with ApplySimple() definitions as follows:KB14356: When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrate… Number of Views 1. ApplySimple ("cast (#1 as varchar (3)) + ': "" ' + #0 + ' "" ' ", , ) The purpose of this expression (for SQL Server) is to display items with both the ID and description in the same string, quoting the description: When SQL is generated, wherever two double-quotes appear in. 1 and 10. ApplySimple where simple (e. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . Using this function and given the format in which the column is stored in the MicroStrategy Tutorial (Vmall) warehouse (integer, YYYYMM), the formula will extract the year from the date prompt, multiply it by 100 and add the day number to it, giving it the desired format. 2 Can anyone tell me how to create a Filter using Applysimple in Microstrategy 7. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. X to be seen in MicroStrategy Web 9. KB32365: How to use element list prompts in database passthrough functions In MicroStrategy SQL Generation Engine. ApplySimple This is the most common function, as you can use it in an Attribute definition. Thanks a lot for the 101 Microstrategy Question…. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Enter a title and a description for the prompt. Within a project, a security filter may be specified for any user. Number of Views 1. x. format_mask is optional. 4. 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. x does not have the inherent functionality to truncate numbers like this, it is possible to do it using the 'ApplySimple' function. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. It is possible to prompt the user for the concluding element by using ApplySimple:Returns the date of the first day of the month in which date or timestamp occurs. g. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. From the Database connection type drop-down, choose Snowflake. Sum is a group-value function. Insert an HTML container (and not an image) and insert the script below. 1 and 10. In MicroStrategy 2021, MicroStrategy ships Snowflake JDBC out of the box. microstrategy. Returns the difference in days between two given dates as an integer value. Select a prompt style and click on 'OK'. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. This filter must be applied in the final pass to find the correct store-region relationship, even though the final pass is a normal join instead of a downward join. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Sum, Max, etc) can be used. Involved in Microstrategy Intelligence Server performance monitoring and managing cache expiry times. 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. Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports. Navigate to the Layout Tab. ApplySimple("CONVERT(VARCHAR(23), #0, 121)",[Column1] )symbol. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. 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. 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:. Complex functions that use combinations of metrics, attribute forms and facts as arguments must use an ApplyAgg. Drag the column from the first table onto the column from the second table. By default, all of the columns used in an expression must originate from the same table. xDateDiff (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 dashboard. For reference, refer to the Snowflake release notes. x with any number of attributes. Victoria is experiencing low interest rates too. x. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. 4. You could use applysimple on the attribute definition to display 'NULL; Example:This article describes features that are not supported when using Dynamic Sourcing. This is a comparison function. If two users with different security filters run the same report, they may get different results. i need to. 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. g. Microstrategy Dossiers With the release of MicroStrategy 10. This true in any case where an explicit datatype is required. Relate tables are often used to create relationships between attributes. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. From MicroStrategy 9. Problem. The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. ) are used. x-10. 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. 2. This is a single-value function. You can choose one or more data files from Hadoop HDFS and load them into MicroStrategy Intelligence Server. x, with the Intelligence Server running on Linux, the image in the exported PDF. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. 4. Use of M03 in Microsoft SQL Server 2000 would result in DATEADD (DD, (1 - DAY (GetDate ())), GetDate ()). It is suggested to use quotes to get exact phrase when there is a space between. ApplySimple ("Case When T1. Presented by MicroStrategyBlog. 94K. For example, ApplySimple("#0 * #1",[col1],[col2])indicates that two items, col1 and col2, referenced as. These functions are not supported by the Analytical Engine, so they must be calculated by the database. For basic information and examples of the ApplySimple function, see the Functions Reference. 1 and 10. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. mstrc”. 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. ) are used. e. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. . Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. to_char (case when Date_DESC is null then to_date (`31-DEC. In SQL Server, the CAST () function is used to convert data into a different data type and the ApplySimple () function in MicroStrategy can be used to incorporate the CAST () function. If all conditions are false, a default value is returned. The MicroStrategy Analytical Engine does not calculate date and time functions. This means that every metric is evaluated in separate SQL passes. These triggers do not need to be defined in advance. KB4275: How to retrieve attribute form expressions using MicroStrategy Intelligence Server SDK. Copy the code for the D3 visualization you are using. g. region. Click New. 2. x and higher. Fu nction Types. "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. I want to find out the number of Widgets that were faulty, so I created another metric with that. The 'Group By ID Attribute' VLDB property is not applied in a MicroStrategy Desktop 8. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. With a few additional applysimple statements this can also be used to create QTD and MTD. This online help builds on a basic understanding of information provided in the Basic Reporting Help. g. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. The schema looks like the following diagram. ApplySimple: where simple operators (e. This function is commonly used in metrics and subtotals. 18K KB8426: How to create a metric with an ApplySimple statement which will choose different metrics for calculation based on. 4. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. The project level setting Data Engine Version can only be enabled through Workstation. The ID is distinct. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Download the following driver to the server hosting your Intelligence Server: TGZ for Linux. x. ApplyOLAP is the MicroStrategy Apply function tool used for OLAP functionality when you wish to use the native capabilities of your RDBMS. string1 is the string that will be converted to a date. 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. 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. 4. For more information on using the ApplyAgg() function, refer to the following MicroStrategy Knowledge Base documents: KB4202: How to. 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. Thus directly using NULL in formula will fail. Examples of this category are simple mathematical. ApplyAgg where aggregate functions (Sum, Max, etc. 3. Click OK in all three dialogs (Login, Connection, and Database Instance). KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. SYMPTOM: In MicroStrategy 9. This is a group-value function. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. The Select Bursting Criteria options are displayed. it looks like MicroStrategy doesn't support it, please advise. Environment: Microstrategy. 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. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. ACTION: Use Concat function instead. Create a metric with M03 = MonthStartDate (CurrentDate). x. Returns the sum of all numbers in a list of values. This custom SQL can be used in the. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. ApplyComparison: where comparison operators (e. MicroStrategy OAuth 2. 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. 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. Returns the current date as provided by the database timer. Select the attribute form to be displayed with a link. 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. 26K KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. 1 and 10. The MicroStrategy SQL Engine 9. mstrc file from an empty text file. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default. x and 10. Step 4) When users execute the report, they will notice that the 'ApplySimple' is ignore resulting in just the Metric Alias. 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. I now want to find the % faulty from total, and have created. 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. x-10. This function relies on the Analytical Engine for processing, rather than the database. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". 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. CONTENTS 1. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Our solutions work to guide towards best practices and provide guidance to the user community. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE. The prompt may be used in the ApplySimple function, and will be substituted at runtime. x does not parse the contents of the SQL string and it cannot anticipate differences in database implementations of standard (or. There's a reason we're at the top of the list. The recommended VLDB optimizations for Hive 0. Follow the steps below. It is used to define compound metrics via. mstrc) Open Workstation. x. x. Examples of this category are simple mathematical. 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. Contact MicroStrategy Technical Support for an update on the status of this request. 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. This is a single-value function. Number of Views 48. In this article we will discuss the ApplySimple function. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. Loading × Sorry to interruptKB42225: How to create a distinct count subtotal from base report in MicroStrategy Web Number of Views 6. Insert an HTML container (and not an image) and insert the script below. MicroStrategy - Dynamic Attribute with join. MicroStrategy will continue to investigate and post updates as soon as they are available. Let me know if you need additional information. x mixed case columns names for a DB2 database by default have SQL generated with quote characters enclosing the name . Select the DSN. The same logical should apply for other databases, but the syntax will need to be changed. x-10. 1 million 1. 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. Select the DSN. 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. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. Follow the next steps to create this type of metric. The fractional part is removed without rounding the number up or down. Count(ApplySimple("Case when #0 <> 0 then #1 else Null end", Column2, Column1)) {~ } Note: Notice that the ELSE statement is using 0 or Null based on the metric functions, such as Sum or Count. Applysimple), a user will be unable to select or use columns that come from different tables. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). Fu. In certain reports, users may notice that subtotals defined across level are not broken by attribute element in a grid report in MicroStrategy Developer 9. The ApplyComparison function is used with comparison operators such as >, Like, and In. x, with the Intelligence Server running on Linux,. 98K. There is an enhancement request to support. 4. x . The ApplySimple statements given above are ORACLE Specific. Examples of this category are simple mathematical. Sum <Distinct, FactID, UseLookupForAttributes>(Argument)Where: Argument is an attribute, fact, or metric representing a list of numbers. If an environment does not already exist, an environment will need to be created first. Explanation. arithmetic operators) are used. C:Reports {&RecipientName}, all subscriptions using that file device are delivered to subfolders of C:Reports. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. Use the datetime format defined on warehouse database side in the ApplySimple statement. 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. Fu nction Types. x-10. 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. x and an Oracle Warehouse using the ApplySimple function. 4. that is used to table that contains column MyDate and force. Thanks. Always be aware of the latest driver version. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Open your Snowflake console ( account. This section describes the date and time functions. 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. 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 apply in that case. 4. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 4. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Microstrategy Training Centers in Victoria, BC – List of Microstrategy certification training, classes, Institutes in Victoria, Know more about Microstrategy fees. 4. Contact MicroStrategy Technical Support for an update on the status of this request. KB485687: The bulk insert is not working which caused performance issue when running multi-source reports. The result does not. Case. ApplySimple may be used in one or both sides of a comparison expression. com Para jpviva. percentage. The script inside the " " always depends on the type of database used and. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. The same logical should apply for other databases, but the syntax will need to be changed. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. In the Database Connections dialog, enter a database connection name. Change the DESC form expression to the following. • Involved in understanding and transmitting the business requirements for the project and. 45K. In the Subscription Editor, click Burst…. Once the administrator sets it up, the end user has to just log in with their Okta or Azure AD email credentials to start using MicroStrategy with Snowflake. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. The current logic I've found is below. x using an Oracl… Number of Views 6. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). This technical note provides an example of how to calculate the number of days between the current date and a date attribute. 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. Step 2) Create a metric using the following syntax, Sum(ApplySimple("#0", <Attribute Name>, 1)){~}. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. x. ApplyRelative where OLAP (ranking, etc. 62K. User may have the requirement to limit the date range selection within a specified period based on a single date prompt. Microstrategy Dossiers With the release of MicroStrategy 10. I just verified taking the SQL generated by MSTR back into SQL+ -- the SQL+ results work as they should; however, the report results are different. , >, =, Like, In, etc) can be used. Steps to create such a prompt in MicroStrategy Tutorial is given as follows. If you are looking to learn. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9. Custom groups; A custom group is a special filter that can be placed on a template and is. By design, however, MicroStrategy SQL Generation Engine 8.