Last updated: Jun 30, 2022. The New Grid dialog box opens. If you created a new dossier, you must save the dossier before adding an existing dataset. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. Start building with MicroStrategy to deliver exceptional product experiences Request a demo Administration Support 2/6 videos | 20M 16S total runtime This tutorial. For information on training metrics and creating predictive. You can also display dashboards on an iPad with MicroStrategy Mobile. The display format for dates does not change even after changing the SQL Date format and Date Pattern settings under VLDB properties of the project in MicroStrategy Developer. 4. The Fact Editor opens, with the Create New Fact Expression dialog box displayed on top of it. If the New Metric dialog box is displayed, click the Empty Metric icon. To view the rank of a metric in MicroStrategy Developer 9. 4. Follow the steps below in order to create a new report template that can be used when creating new reports in MicroStrategy Developer or Web: 1) In MicroStrategy. The reason for the case statement is that the value for. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. Choose File > New > Intelligent Cube. How to Programmatically Create a New Report with Data and Set its Graph Type Using the MicroStrategy Web SDK 9. A window, as displayed below, appears: Assign a Cost Range for reports by either using the horizontal scroll bars or the text boxes. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. The following solution allows users to create a report giving them data for the current month and pevious months without creating transformations. In a document, right-click a grid/graph displayed as a grid, and select Edit Grid. Using M0 create a second metric which will give us the dense rank and can be placed on the report. For a document, edit the document in Design Mode or Editable Mode. x and 10. How do users create a simple metric? Double-click on any fact from the Object Browser to define a new metric. `. In the Source area, select the database instance for your Excel file. Add Object and Component Object attributes to the grid to see all dossiers and their dependent datasets Example 2: How to create a dossier that shows all objects that use a certain metric 1. Creation Guide. In the Password field, enter the password that is paired with the user ID entered in Step 2. x: Create a metric called A with expression "Min(1){~}" as shown below. You can narrow the list of functions displayed in the. Create a Value Prompt->"Date and Time"-> Finish. Create a graph report. Administrators no longer need to install Narrowcast Server on the machine where. ; On the Freeform Sources tab, select Create Query Builder report. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. In MicroStrategy Web, on the reports page, under the name of the report/document that you want to create a subscription for, click the Subscriptions icon . Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. Click the MicroStrategy icon and select Create Report. Make sure the Category attribute has the Image form as a Display form. ) Obtain the Gotham Medium font file (in . Edit the Blank Report template from MicroStrategy Tutorial project in MicroStrategy Developer; Add an attribute to rows and another to page-by section; then save and close. To create a customized autostyle, follow the steps below: Open a template or report editor and define a base template. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Select a prompt answer and click Apply. Just make sure the ssl_verify parameter is set to True when creating the Connection object in mstrio-py (it is True by default): conn = Connection(base_url, mstr_username, mstr_password, project_id=project_id, ssl_verify=True) The second way is to pass the certificate_path parameter to your connection object in mstrio. Metrics are quantitative measures used to analyze the data in the particular context. Execute one of the following options: To specify default prompt answers, click on 'Add'. For steps, see Interaction of Report Details Preferences and Report Details for Reports. Choose Add Data > Existing Dataset to add data. Custom totals can be used to selectively display subtotals for different metrics in MicroStrategy Developer, as shown in the report below: Custom subtotals can be configured from the Report Editor. Use the MicroStrategy Configuration Wizard to create a new metadata, or an existing one may be used. x, when trying to create a new FreeForm SQL report or Query Builder report one would have to click on New > Report and select FreeForm SQL report in order to open the editor. For more information, see Permissions and Report/Document Execution. Open the Workstation window. x. Sets a maximum for the number of categories in a graph based on the value typed into the Categories field. Click Create on any page, and select New Metric. Create a compound metric called B with expression "RunningSum(A)" as shown below. Each element contains a set of filtering or banding qualifications. In MicroStrategy Developer, choose File > New > Filter. This forces the calculation of the MovingSum to no longer be based on the preceding revenue values but. Explore how to add templates, attributes, metrics, filters, and prompts to a report to produce valuable insights from your data. You can also select an existing template (see How to Create a Report Based on an. MicroStrategy Configuration Wizard The MicroStrategy Configuration Wizard makes changes in two important locations: the registry and the selected metadata. x? In some business scenarios, it is required to create a Report Service document with "image" attribute form displayed in grid but not in the selector for the same attribute. refer to the MicroStrategy Developer Help (formerly MicroStrategy Desktop Help). Use this section to familiarize yourself with the Report Editor interface. This allows enterprise BI developers and administrators to build and administer sophisticated enterprise and mobile analytics applications, at a fraction of the effort it traditionally takes. When the user drills from an attribute, or attribute element, to a template, filter qualifications from the original report are attached to the new template to form a new report to execute against the warehouse. Create Freeform XQuery report: To create a report using custom. Page-by pane: (top of Report View pane) Where you place subsets of your report results to be displayed as separate pages of the executed report. When the Java Editor opens paste the addon code. ; On the Freeform Sources tab, select Create Transaction report. Right-click the table, point to Recognize, and then select Attributes. Specify the delimiter desired for each data item, as shown below: Create a search object using MicroStrategy defined by the search criteria specified by the user, as shown below:In MicroStrategy 2021 Update 7 and later, MicroStrategy users cannot adjust the ACL for FFSQL reports, although they have the Full Control privilege over the same objects. Logical views can be created in MicroStrategy Developer using the Table Editor, which is shown in the image below. x - 10. 4. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. In MicroStrategy Developer, from the File menu, select New, and then choose Report. ; On the Freeform Sources tab, select Create Transaction report. To create to a direct project source. NOTE: Users must be granted 'Create Application Objects' and 'Use Template Editor' privileges. To achieve this, perform the following steps: Create a running sum metric which will return the row number for each record. 3. Specify the nature of the metric limit from the lower-right section of the editor and click 'OK'. From the File menu, select New, and select the type of object to create, such as a report or a filter. In the Format Definition section, click on Cell Formatting. While this procedure creates only Filter derived elements, you can create any combination of Group, Filter, and Calculation derived elements on a report or Grid/Graph. Within the Titles category, select the check box for the title or label to display. How to create a dynamic filter that returns months less than or equal to current date in MicroStrategy Developer 9. ' In Application, change to 'Text File' and select Advanced. Create a metric 'MTD Revenue' with fact 'Revenue'. Click the Find Now button. Introduction MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and. Building reports from scratch A simple report generally has at least one attribute, one metric, and one filter. A valid expression is one such as: SUM (FACT1 + FACT2). In MicroStrategy Web, on a folder page, hover the mouse cursor over the object and click Subscription. Open the MicroStrategy Configuration Wizard. You can also create an Intelligent Cube that contains data from an MDX cube integrated into MicroStrategy from an MDX source such as SAP BW, Hyperion Essbase. Used Enterprise manager to create reports on the project usage and report usages. Follow the steps below to create an attribute qualification filter that will allow the user to enter more than one value to filter on:This document explains, through the use of an example, how to create a dynamic report execution in MicroStrategy Narrowcast Server 9. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. Choose Empty Document. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. Create a Prompt using Prompt Generation Wizard in MicroStrategy Desktop/Developer. How do users create a template? In the Template Editor, from the Object Browser double-click the on attributes to be added in the Template definition. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. If you are on a folder page, click Create on the icon bar on the left, then select New Metric. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. To edit a document in Design Mode, from a folder, right-click the document and select Edit. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. For more information on these report filters and view filters, see Creating filters in reports. 4. 4. Note: If you use gcxi-secrets. Create three attributes named A, B, C, and after them added in a report in Developer, no data returns， as showed below. Bulk Export options are only available in MicroStrategy Developer. Give the Database Instance a name and select the Excel 2000/2003 connection type. On the windows machine, open the start. From MicroStrategy Education, this lesson teaches you how to create create dashboards using templates on the MicroStrategy Web platform. Add the metric "RP First Job. Enable Time Zone Based Reporting in a Project and Set the Project-Level Default Time Zone. Click OK to exit the Freeform SQL Editor and. 4. A developer can build simple or compound metrics, apply to them many additional features like conditionality, level, transformation and also specify the formatting. Metric Editor -> Tools -> Metric Joint Type. 1/10. Click on the "Validate" button to validate the formula. MicroStrategy users can format how the values of metrics and attributes are displayed on their reports. To edit expression or property information, right-click the attribute form and choose Edit Expression or Edit Other Information. In Developer, from the File menu select New, and then Intelligent Cube. x - 10. Open the report or. has a MicroStrategy implementation with 4 environments: Development, QA, Mirror, and Production. Modify the SQL statement or the column mappings as needed. x report. How to create a Report Service document with "image" attribute form displayed in grid but not in the selector for the same attribute in MicroStrategy Developer 9. x SYMPTOM: Dynamic dates can be employed to create a year-to-date report, or even a year-to month report. In MicroStrategy Developer, choose File > New > Report. In MicroStrategy Developer 10. With Architect, you can create and modify multiple facts in your project quickly from an integrated interface. Create an object prompt that prompts the user on the unmasked and the masked attributes, as shown below: Create a report that contains the desired information, including the object prompt in the template as if it were an attribute, as shown below: Execute the report, choosing the masked version of the attribute. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Create two count distinct derived metrics and places them on the report template. 4)Define the drilling objects here in the Drill Paths section. To Create a Metric. Logical views can be created in MicroStrategy Developer using the Table Editor, which is shown in the image below. Displays or hides the All Objects panel. Create a table to relate filtering dates to the dates in the month up to and including the filtering date. 4. Related articles from the Community: Knowledge Base: How to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). Subscription Creation Wizard in MicroStrategy Developer 9. New: Create a new report. Users may wish to consider specifying the connection to one of the data warehouses as the primary database instance for the project and then using Freeform SQL reports to extract data from the second warehouse. In this tutorial, you learn how to create a dashboard dynamically using a template and existing. Click the name of a report to execute it. Select Data > Subtotals. Click OK. Go to Connection Type > Direct (2-tier), and click Next. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. Use expression: Rank([Metric Day]) Create report with Day attribute and add the following 2 filters:A user wants a MicroStrategy Developer report to only retrieve a specified number of rows. Follow the steps below to rank a metric: Create a Rank metric. This opens the Project Documentation dialog, as shown below:In MicroStrategy Desktop/Developer 9. To view page-by section of the report, choose View > Page-by. 1. 3. Run the report and it will prompt the user to select a date. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. You can also begin creating reports in MicroStrategy Developer and MicroStrategy Web. x, it is not possible to specify a date when defining a dynamic date filter. Choose Reports/Documents to be scheduled (Answer the prompts, if any) and click Next. 4. Browse to and select a previously saved Intelligent Cube on which to build your report. 2. KB10969: How to set the default metric Join Type to Outer Join in MicroStrategy Developer 9. In the Multiple objects text box, search for and add filters to use when displaying objects in the prompt. Select one of the following: Create Freeform SQL report: To create a report using custom SQL statements. Right-click the attribute and choose Edit. To create a custom expression filter, the Advanced Qualification Editor must be enabled in the user's project preferences in MicroStrategy Developer 9. 4. The Revenue metric at Subcategory level created in Step 1 should be placed in the Report Objects window if not needed in the. Save and close the filter. Number of Views 6. Click Create on any page, point to New Report, and then select Blank Report, which. To Create a Conditional Metric. Within the Titles category, select the check box for the title or label to display. How do users create a template? In the Template Editor, from the Object Browser double-click the on attributes to be added in the Template definition. You can create events with the following Command Manager script: CREATE EVENT event_name [DESCRIPTION description]; By default, this script is in the folder C:Program Files MicroStrategyCommand ManagerOutlines. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). Use MicroStrategy. This filter, which will be used on the report, qualifies on the current date. Choose File > New Prompt. For example, the Use permission on a metric allows a user to create a report containing that metric. Create Document. ; Click OK. In this example the sorting of region will always be done by a rank of the most recent revenue that the region has. Right-click a project and choose Properties. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. Open a report in MicroStrategy Developer. In the View filter, click Add Condition. Choose 'Save As' from the File menu and in the. 6) Create the desired report and place the 3 metrics on the report. Create a report (for example, customer state, customer city, revenue) and add P1 into report filter. In the Data Source dialog, select Reports. After that, when users select some elements, the 1st text box will display selected elements and covered the 2nd one. 2. Null values are not displayed in a report with attributes in the page-by in MicroStrategy Developer 9. Set the Sort parameter for the metric so that data make sense when displayed. To duplicate a project in MicroStrategy Develper 10. Click OK to accept your changes, and then repeat the previous step to open the New Grid dialog box. This article is to introduce a workaround to achieve the attribute left outer join on. x - 10. Perform the following steps in the MicroStrategy Tutorial project to create a total of summary metrics across different datasets in a Report Services document in MicroStrategy Developer. In the Navigation pane, click Projects and browse to the location of the attribute you want to edit. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. If you created a new dossier, you must save the dossier before adding an existing dataset. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. The below code can be used to create a report based off of a data import. You can also begin creating reports in MicroStrategy Developer and MicroStrategy Web. An invalid expression would be one such as: SUM (FACT1) + SUM (FACT2). Select the appropriate options to define the dynamic recipient list, as described above. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same way you would add report objects. 1, users now have the ability to enable this behavior at the attribute level, so that when an attribute form is set as a Report Sort form in the Attribute Editor, the attribute will sort by that form in all reports by-default, even if that form is not present on the report at all - not even in. Schema objects are building block objects; they are. MicroStrategy Command Manager can trigger. For example, you can edit. The transformation to apply to the metric has already been created. Change the metric join type to 'Outer'. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. Expand the Object Templates category, select General, and from the Show templates for the following objects list, select Report. Go to 'Data' on the top menu bar. However, since a text prompt cannot be directly incorporated in a report object, it must be embedded in a metric. Right click on the ' report (Report Execution) ' page and select “ Create New Add-on ”. Filters are most commonly used on reports, to filter all the data the report would otherwise retrieve from the data source and display. Next, right click anywhere under the data source tab and near any of the measure fields. x-10. Select Display Attribute Forms. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. 4. When applied to a language object, allows users to edit and save translations, and to select the language for display in their Developer or MicroStrategy Web language preferences. Login to MicroStrategy developer as administrator. Open MicroStrategy Developer and create a new Database Instance under the Database Instance Manager. Click Blank. Select the metric on which to set the limit, by dragging the metric from the left frame to the top-right. Open an existing document. . The steps below give a detailed explanation on how to create a report that contains a metric based on another metric that will return a static string of data from the warehouse. Creating logical views. CAUSE: One possible cause is that the conditionality of a metric in the report has been set to remove related report filter elements. In MicroStrategy Developer, the report SQL View shows this time as "Total Other Processing time" in summary and as "Other Processing Time" in the first SQL Pass. Create a filter on attribute "Month" and click "Prompt. at the top of the page. Click Add a New Dynamic Address List. Choose File > New > Intelligent Cube. Put this Prompt inside a metric, as shown below: Create a report and put this metric in the Report objects window. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. To access the Metric Editor, execute the following: From the File menu, go to New and choose Metric. If you created a new dossier, you must save the dossier before adding an existing dataset. The following procedure describes how to create a dynamic date filter based off of a prompt answer. A custom group is made up of an ordered collection of components called custom group elements. Select the environment and project where you want to save your prompt. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document. Make sure the Category attribute has the Image form as a Display form. 1 The following example uses the MicroStrategy Tutorial project to illustrate how to create a report that will display Revenue per Region OR Profit per Region depending on. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. However, once created, these reports can be executed from both MicroStrategy Developer and MicroStrategy Web. To Create a Report Using a Template. Step 2. Open the cube report in Design View. Change the formatting of the percent to total with the appropriate settings (decimal places, negative value formatting, etc). If you do not want this dialog box to be shown in the future,. Filters are most commonly used on reports, to filter all the data the report would otherwise retrieve from the data source and display. Creating a new FreeForm SQL report or Query Builder report in Developer In Microstrategy versions previous to Microstrategy version 9. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. 4. To create an attribute form that allows the attribute to display a name in the format of 'Last_Name, First_Name' in MicroStrategy 10. x - 10. The Results Preview dialog box opens. To save the prompt. 3. Follow the steps below to split a dataset displayed as a grid in a Report Services Document:Creating Hierarchies to Organize and Browse Attributes. Document Creation Guide. In MicroStrategy 9. Open the Filter Editor. Report developers can leverage MicroStrategy reusable metadata objects to create any kind of report to meet. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. If the New Grid dialog box opens, select Blank Report as the report object template. 4. The metadata may be created from any of the nodes and only needs to be done once. Save this report and add it with formatting to a new Report Services Document using the Blank Dashboard template. From the left, click All Objects, then navigate to the objects you want to place on the report. In MicroStrategy Developer, choose File > New > Report. In this example, the Year attribute is used. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. How to include items of Consolidation in report result when no fact data is available in MicroStrategy Developer 9. This video will step through how to create a License Audit report on your MicroStrategy Intelligence Server through License Manager. Use MicroStrategy. However, when defining a new report in MicroStrategy Desktop 9. For example, the value of this metric will be one. To automatically open the report in Excel after you export the report, select the Show application after exporting check box. Create a report and add the Item_Demo attribute, the three metrics created in Step_6, the three metrics created in Step_7, and an attribute element prompt based off the Subcategory attribute. x, there is a graph called Pareto (Percentage). Log in to the project in which you want to create a report. 1, Microstrategy Architect 8. Looker Studio (formerly Data Studio) is a powerful data visualization tool that enables you to build dashboards on top of big data sources, like the Chrome UX Report. Take your reports one step f. Any physical table in the project database instance can be used in the SELECT statement. Open the Workstation window. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. To access the Template Editor, execute the following: From the File menu, go to New and choose Template. On the General tab, type the following information:Open the report you want to create a filter for. 1. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. 1 and 10. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. MicroStrategy Developer is an advanced, Windows-based environment providing a complete range of analytical functionality designed to facilitate the deployment of reports. You can create an attribute based on an existing object. The following code demonstrates how to programmatically create a new report with data and set its graph type using MicroStrategy Web SDK 9. The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build. x, with the Intelligence Server running on Linux, the image in the. Select a prompt answer and click Apply. KB5078: How to create a value prompt in. x. A pop-up appears which shows the create metric option. The New Grid dialog box opens. When the report is executed, the data is shown as below:Mobile - To send the report or document execution to the mobile device. This video is unavailable. Creating a new FreeForm SQL report or Query Builder report in Developer In Microstrategy versions previous to Microstrategy version 9. This may be a physical table or view in the warehouse, or it may be a logical view defined in MicroStrategy. x - 10. Publish the datamart report. Now, when the report is run, the Moving Average is calculated for a data set that is identical to the report that is displayed. The following steps demonstrate how to design this kind of report in MicroStrategy Tutorial project as shown below: Create two compound metrics C_R=Cost/Revenue and C_R_PM=C_R/. Enter 'Year' as the attribute and click 'Prompt' as shown below. They are metrics that are saved and displayed only on the specific report on which they are created. The Bulk Export Setup dialog box is displayed. x, if there are any compound metrics included in the interface, users may click on the word Metrics, and that will break down all compound metrics into its constituent simple metrics. This attribute is referred to as a derived attribute. Type a name for the subscription in the Name field. Business. x Consider that a user requires a report which will prompt on a range of dates and the data on this report must display the date range in the leftmost columns. The following solution allows users to create a report giving them data for the current month and pevious months without creating transformations. From the Tools menu, select View Filter. To edit a document in Design Mode, from a folder, right-click the document and select Edit. You create and interact with dashboards in MicroStrategy Web. ARCHITECT VIDEOS & TUTORIALS. Click 'Save and Close' to exit the Report Limit Editor. MicroStrategy does not provide out of the box functionality to filter a report on metric subtotals because the subtotals are processed in the Analytical Engine after the result set has been retrieved. x - 10. You can create events with the following Command Manager script: CREATE EVENT event_name [DESCRIPTION description]; By default, this script is in the folder C:Program Files MicroStrategyCommand ManagerOutlines. Drag and drop the reports into the Dataset Objects panel of the Document Editor. This document explains how to join tables in MicroStrategy Architect where the attribute ID columns are named differently (also known as heterogeneous column support) by creating an attribute that can join on columns from different tables with different names (heterogeneous column joining). You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. Click in MicroStrategy Web Configuration in Application Settings view to expand the hierarchical tree. " Select "Use a filter to reduce the number of elements" and select the "QUARTER FILTER" created in the previous step. The function 'DayOfWeek' will return an integer value which '1' means 'Sunday', '2' means 'Monday' and so forth. Place the new metric in the desired location, as shown in the screen shot below: To Create an Intelligent Cube Using Freeform SQL or Query Builder. To obtain the Project Documentation for only reports in a certain folder in MicroStrategy Developer, follow the steps below: Log into MicroStrategy Developer. The Input Metric Formula dialog box opens. x. Create a datamart with the attribute that needs to be sorted and a sequential metric that orders the attribute as desired. ; Enter the XQuery statement required to connect to the third-party. Knowledge Base: How to generate an audit report through the command line with the MicroStrategy License Manager 9. Visit the data visualization and data dashboard galleries for inspiration. Click 'OK'. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. To save the prompt. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. the Labels are located on the Look tab. Add metric "Yesterday" to the document section as dynamic text. Click Create on any folder page, point to New Report, and select a template (such as Call Center Analysis) from the list of pre-designed reports. 5. 4. Make the necessary changes to the document and then save and close the document. KB297776: A cross join occurs when the “Item” and “Order. Click Prompt as the image shown below. The steps below show you how to display and format titles for a graph. For this example no sorting is required. ; Enter the XQuery statement required to connect to the third-party.