Hint. This is a single-value function. 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. There's a reason we're at the top of the list. The index. This report shows the sum of sales for each month, for the previous row and the % change between them. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. ApplyComparison. 4. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. With all form sort orders set to none there is no saved sort order, MicroStrategy defaults to sort ascending by ID. About Us. Go to File > New >. This type of operator includes And, Or, and Not. From the Project menu, select Compare Projects. 4. Create a new filter using a custom expression with POST /api/model/filters. 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. Follow the simple steps below to create a datamart report: 1 In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. By default, 'Custom Expression' is the option selected for a new Advanced Qualification. 62K. After installation of this application only thing you have to do is to follow step listed below: Type here text you want to find and press next. However, when a LIKE operator is used in the metric definition, the query can be incorrectly generated leading the report to fail. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. Then use this report in a filter along with the advanced qualification which says'ApplyComparison ("#0 in (select distinct fiscal_mo_nbr from days where day_dt=trunc(sysdate-1))", [Fisc Mth Nbr]@ID)'. mstrc”. Select the source and destination projects. microstrategy. The My Preferences dialog box opens. x SQL Engine is ignoring the conditionality at the report level because a metric in the report also contains a related conditionality which has been set to "remove related report filter elements" or "ignore" the filtering criteria at. Create an advanced filter qualification. This method exists as attribute only outer joins will not be generated on their own by the MicroStrategy SQL engine. But, DESC has repeating values. . CASE 2. Now your connection f. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. ApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same. For the Time hierarchy, the offset can. 2. 0. I have a filter and in it is the ApplyComparison function doing a simple query. Example: Customer City = Call Center Using ApplyComparison 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. Number of Views 16. The filtering setting for a level metric governs the relationship between the report filter and the calculation of the metric. See this difference in Joins Across Datasets and Document/dashboard best practice. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. This prompt is used in a filter. In the Functions pane, hover over the If or Case function and click Edit. xThe steps below describe a method of double-filtering a grid/graph object in Web 9. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. There's a reason we're at the top of the list. Based on verified reviews from real users in the Analytics and Business Intelligence Platforms market. ApplyComparison ("#0 in (select max (date) from user e join cycle c on e. You can allow joins across datasets based on unrelated common attributes in a single Dossier or for all of the documents. 2. The ID is distinct. They act as containers for non-standard SQL expressions that MicroStrategy does not support. Filter Reports using SQL with ApplyComparison and ApplySimple. ittoolbox. Follow the steps below: Right-click on the project and select 'Project Configuration. Continue creating the metric (for example, adding levels or conditionality) . The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. Click Certify. Case. For client configuration of MicroStrategy as Db2 client, you can refer to MicroStrategy Support Document for Db2. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. MSTR has evolved dashboards to the point that. 6,154,76 6, 6,173,310, 6,260,050,. Level: Set grouping to "Beginning Fact" for your date attribute. A report requires to show the bottom 10 unit prices per item. x SQL Engine is ignoring the conditionality at the report level because a metric in the report also contains a related conditionality which has been set to "remove related report filter elements" or "ignore" the filtering criteria at. 5% of users said that the platform is easy to use, with a user-friendly drag. Number of consultants & teachers ___. 4. A MicroStrategy Report Services document displays data coming from multiple reports, with the data laid out and designed in presentation-quality format. Use the steps in Custom Expressions along with the custom expression below, to create the filter you need: ApplyComparison ("#0 like '*'", Store@DESC) Each piece of the custom expression is explained below: This article explains how the applycomparison function works in MicroStrategy This video focuses on what types of functions you users can create and how to correctly write them. Type: Company - Public (MSTR) Founded in 1989. This feature is only implemented for element list prompts. Go to the Editors section and select Filter. To create a rolling month transformation filter, which will allow a user to select a month and will then filter values based on the the inputted number of months before it, do the following: 1. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. MicroStrategy introduced HyperCards, a new object that is built, managed, and deployed using MicroStrategy Workstation(Not by using Developer or Desktop as far as I know). Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. How to define an advanced qualification using a custom expression to filter on months in MicroStrategy Developer 9. Considerations for the use of star schemas with MicroStrategy SQL Generation. The user should enter two double-quote marks in succession, as shown. Example: Customer City = Call Center Using ApplyComparison You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. A sales team might use a business dashboard to connect. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 0. 2) Create Metric2 as the RunningSum of Metric1. mstrc, please open something similar to Notepad. Open MicroStrategy Developer. 2. If DHTML is disabled, click the Go icon . All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. Once data flows into the interface, the dashboard will come to life. This article explains how to use the applycomparison function in MicroStrategy INTRODUCTION Pass-through expressions, also called Apply functions, provide access. x using the ApplyLogic function, as illustrated below. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. IsNotNull(Argument) Argument is a fact or metric. If an environment does not already exist, an environment will need to be created first. ApplyComparisonStep 3. The next example uses ApplyComparison. General hardware recommendations. It allows users to customize data visualizations and build personalized real-time dashboards. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. Visit the data visualization and data dashboard galleries for inspiration. x using a filter selector combined with a case statement derived metric and view filter. Save and assign a name to the file like “My_first_connection_file. Enable users to interact with personalized chat for further product discovery. Create another report R2 with Year, Month, Revenue and use R1 as filter. Select Filter definition prompt -> Choose from an attribute element list as shown below. Choose the Light Theme from the drop down menu and click the Apply button. The next example uses ApplyComparison. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. Using OLAP Services, create a metric that is the SUM of a fact. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a. ApplyComparison(UPPER(#0) like 'Z####%', Country@DESC) The SQL used the. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. Click Filter Options. 2. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. likes. For details, see Comparison Operators. Double click on your Report Filter and you’ll now have the option to add an Advanced Qualification: You can then provide the code for the ApplyComparison. Populate & Evaluate Stage: Fill report data for display. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. While string functions can be used to create metrics, a more common use case for these functions is in the creation of attribute forms. x-10. 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. Powering. Select only Configuration Objects for documentation. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID)You can use the ApplyComparison function to define custom filters. Syntax. ) The above example used an Apply function, ApplySimple. xApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same type. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. 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. Go to My Preferences > Editors > Filter Options. Ap plySimple (microstrategy. To create metrics to use additional attribute forms as inputs for predictive metrics. In this article, we raised two workarounds to help. x. Form Type. Syntax Common to Apply Functions. When MicroStrategy trains a decision tree model, the decision tree algorithm splits the training data into two sets; one set is used to develop the tree and the other set is used to validate it. This is a comparison function. Select the source and destination projects. If I understand right, create a report using the above SQL to generate a single value (it does). No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a. Right-click a project in that project source and select 'Compare projects' or select Project. Here is my test-version of the metric, "Ttime" is the date-attribute. 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. Right click and "Run as Administrator" to. mstrc) Open Workstation. Case. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. all to no avail. The following examples illustrate the URL parameter reportviewmode and the corresponding view of the report that will display: When reportviewmode is set to 1, the report is displayed in grid mode: When. MicroStrategy Developer allows expressions to be created where an element list prompts is one of the arguments to a passthrough function; however. Salesforce (Tableau) has a rating of 4. 3. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. Adding an existing D3 Visualization;. , in search results, to enrich docs, and more. Competitors: Oracle, SAP, IBM Create Comparison. In earlier versions of the product metrics with different conditions such as the expression 'ApplyComparison("#0 in (select year_id from lu_year where year_id = 2015)",Year@ID)' could not be combined into a single pass of SQL per the SQL Global Optimization. --- mahuamitra via microstrategy-l wrote: > > Thanks for the quick reply. Create a report with Region attribute. Click Save and Update Schema. In MicroStrategy 2021 Update 5, in order to achieve better performance, for selected Gateways, the SQL Engine will push down the case function to calculate in the databases. {&GROUPLABEL} Name of the graph. x . for each successive object passed. 4) Next, change the Theme back to None and click Apply. x. ApplySimple – Uses simple arithmetic operators. ) Add Customer State and Customer to the report. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. For details, see Comparison Operators. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. String functions perform various actions that modify the characters returned for a string of characters. Labels: #Recursive hierarchies microstrategy #Recursive Hierarchy. MicroStrategy can generally generate this type of SQL, but I find using this method usually comes out with more efficient SQL, especially compared to using a Set Qualification Filter. 4. Select the attributes and facts from that table. To create a custom expression filter, the Advanced Qualification Editor must be enabled in the user's project preferences in MicroStrategy Developer 9. The Delete unused managed objects option is found under. x: Open the Filter Editor to define a new filter. Select Show advanced qualification. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. '. It can connect to data warehouses, relational systems, flat files, web. A blank visualization appears in the dossier. Menu. com) KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. The next example uses ApplyComparison. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. 1. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. The attribute form should use the same column as the ID attribute form, but it should only be sourced from the lookup table for the attribute. If an environment does not already exist, an environment will need to be created first. Syntax Common to Apply. When used inside a string comparison statement they are a. Enter the following expression: ApplyComparison("{Current Month function} > #0", Month@ID )A prompt is a question the system presents to a user when a report is executed. Select any project that is in the project source that contains the users and groups and click Next. Wherever you can define an expression, you can use a function. The ApplyComparison function is used with comparison operators such as >, Like, and In. From the Select a Project drop-down list, select the project for which to assign the security role. mstrc file created before and click Continue. The fuel for business dashboards is data, so each one needs to have one or more data sources. Workaround / Solution. 3. Accept the other default values. Therefore, users must use the ApplyComparison function to ignore the SQL parser as shown below: NOTE: KB5700-007-0107 describes the ApplyComparison function in detail as well as other functions that bypass the SQL parser in MicroStrategy Desktop. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. ) The above example used an Apply function, ApplySimple. The Filter Editor is displayed. 4. As a MicroStrategy developer, and a SQL. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. The Lead function can be used in the same way. For example, edit the attributes. Overall, more than 87. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. The following procedure describes how to achieve this: Create the highest level filter. ) are used. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). x and newer Loading × Sorry to interruptIn 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. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. 1 comment. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. ApplyComparison where comparison operators (>=, <, Like, etc. Level Metrics. Copy cleanup. x-10. This will enable the option to use ApplyComparison’s in Filters. …To change the order of the transformations, select a transformation and use the directional arrows to re-position it. Our Team; Careers: work as a economic news consultant; Our. 5. => ApplyComparison ("#0= (SELECT WEEK FROM WEEK_DATA WHERE CURRENT_WEEK = 'Y')", WEEK@ID) My problem is whenever I view the report through the Web or look at the print preview, the value of that particular filter is not being displayed. To configure:-. To begin, the architecture for dashboard execution is. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. For more details, click the link corresponding to each function. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The Grouping panel is displayed. I asume you store the elements of the "security-" where clause in the fact table. We’re here to help you align the future of AI/BI technology with your company vision. the Administration menu -> Projects in MicroStrategy Developer as shown. If SQL is required for another database platform, users need to contact their database administrator to do so. Click OK. 3. Open the dossier you want to modify. Unser Team; Careers: work as a business intelligence advisor; ServicesKB14562: How to use a relationship filter to control expensive subqueries in MicroStrategy SQL Generation Engine Number of Views 3. The easiest is probably to create an attribute of only the first character using the substring function. The definition of the shortcut filter (East Coast) is displayed. Takeaways: Power BI vs. Patent Information This product is patented. Microstrategy Dossiers With the release of MicroStrategy 10. ApplyComparison is a 'pass-through' function that builds a SQL comparison expression based on the input string of database-specific SQL syntax. Set up the Enterprise Manager. Maybe the Names (DESC) can be repeated but the ID should be distinct. This document provides the steps to accomplish the same. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. The maximum number of partitions is dictated by the number of cores on the box. Apart from using the VLDB properties to create the left outer join, article describes how to use the Logical View to specify an outer join between two attribute lookup tables when only attributes are on a report. From: sukumar123 via microstrategy-l [mailto:microstrategy-l@groups. Select types of files you want to be considered and press next. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. KB20000: How to create dynamic dates using MicroStrategy Developer 9. Go to My Preferences > Editors > Filter Options and. The Apply functions are not meant to take. Check out real reviews verified by Gartner to see how MicroStrategy compares to its competitors and find the best software or service for. Back to the Report. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Select only Configuration Objects for documentation. 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. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. ,. Actually, it can be used anywhere where. Save the prompt as "Call Center Prompt". This should work (replace regex w something meaningful, do you want this case insensitive etc etc): ApplySimple ("case when #0 ~ 'As Is' then 'As Is' when #0 ~. ) The above example used an Apply function, ApplySimple. Number of Views 16. As a MicroStrategy developer, and a SQL programmer, I pick and choose my battles, and as much as it’s recommended in MicroStrategy to make complex metrics with “Last” or different Level Dimensionality, there’s also situations where you want to make the database do the work…such is the Case with the ApplyComparison filter. 2. If you want to use a data range in your filter, select Between. Use the limit comparison test to determine whether the series ∑ ∞ n = 1 5n 3n + 2 converges or diverges. 4. System Manager workflow can execute on a schedule or after an event has been triggered. EXAMPLE. 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. This will change the diagrams, depending on the value selected. Create an empty MD shell in Microsoft Access. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. S. 2) Creating a filter definition prompt with the Sum Metric, so that when the rpeort is prompted user cans elect Sum Metric value is >0 . If you are looking to learn. September 06, 2018. 1. Filename. Clear the Totals check box to remove the standard subtotals. 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. A user tries to create a custom filter expression in MicroStrategy Desktop 8. 2. Data DesignIn MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. ApplyComparison ("upper(#0)=upper(#1)", Customer@, ?Customer) Note: The SQL query mentioned in this document is specific for Oracle Warehouse and provided as simply an example. The following report sample displays all of the options, including the view filter, in the report details. If you are looking to learn. 6 stars with 694 reviews. There is no functional difference between the two symbols. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. Min (Ttime) {~+, <|Ttime+} < [date filter]; @2; ->. You can only certify dossiers in the Dossiers area of the Navigation pane. In Step 1, choose a Project Source from the drop down list, and enter a Login and a Passwordthat have administrative privileges to the metadata. KB7294: How security filters work in. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. The filter on this will be "where <> '-' " and there is no need to use. The number of partitions should typically be between the minimum and maximum, and closer to half the number of logical cores. Instead of filtering on Region directly, its qualification may be written into an ApplyComparison expression, which uses a CASE statement to affect the condition's outcome. The apply collection can be viewed as a substitute to the loop. Applycomparison advancd filter with a select state. One of the MicroStrategy-provided transformations answers our needs for the following example. With MicroStrategy, you can deploy data on-premise, in the cloud, or with the hybrid of both. Object prompts can be created using. Is Null. From the Tools menu, select Grouping. CAUSE: One scenario is that the MicroStrategy 10. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. While each Apply function has its own syntax, the Apply functions share several syntactic features: The "#n" code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. 02K. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. Click OK. Create 2 attribute filters in the report. The My Preferences dialog box opens. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. ApplyComparison is used to define a filter by populating the WHERE clause in the SQL passed to your RDBMS, and can take facts, attributes, and. 1. Note: Filters can only be created out of metrics and schema attributes. Open the Desktop Window with the Navigation pane in Smart Mode. The Filter Editor is displayed. A bubble chart (aka bubble plot) is an extension of the scatter plot used to look at relationships between three numeric variables. Select the 'Advanced' tab, as shown below: Change the setting for 'Attribute element browsing' (circled in red above) to the limit that is desired for the project. Follow the steps below for an example of how to do this. 1. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. key1 + '%')",Key2@ID) Published: Apr 12, 2017. The menu also provides features to connect to a server if required, view the data sets available, the visualization gallery, and data filtering options, etc. Bitcoin rose Friday, topping $38,000 to extend a strong year for the cryptocurrency. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. The Filter Options dialog box opens. Data can be connected through an API, flat file, or database. ApplyComparison ("#0 between #1 and #2",? Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart t. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. Cross-tab stage. Populate and Evaluate: Fill report data required for display. Here are the detailed steps on how to install MicroStrategy using the MicroStrategy virtual appliance: Go to the MicroStrategy website and create a MicroStrategy account. ) The above example used an Apply function, ApplySimple. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. 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.