A MicroStrategy Report Services document displays your organization's data in a high-quality, Pixel Perfect display. Web the dashboards and widgets guide provides instructions for designing and creating microstrategy report services dashboards, a type of document that is optimized for. Right-click the header of the attribute whose elements you want to use to. Lookup table for the Cache Hit indicator: • 0: Reserved. 1 - MicroStrategy Product Manuals 2013-04-30 Advanced Reporting Guide for MicroStrategy 9. For steps, see the Basic Reporting Guide. • The following steps explains how to enable Drilling from MicroStrategy Desktop. Resources Documentation MicroStrategy provides both manuals and online help; these two information sources. A MicroStrategy Report Services document displays your organization's data in a format that is similar to a PowerPoint presentation, where several grid and graph reports can be viewed at the same time, along with images and text. A sales team might use a business dashboard to connect. It creates a derived element whose definition can be edited by right mouse clicking on the attribute header to bring up the Derived Elements editor. Under Collections, click on the the “…” next to. 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 and 10. Execute the document and the R generated. 3. Download the PDF manual and get started with MicroStrategy Office today. To create a Freeform SQL report. The Training Metric Wizard can be used to create several different types of predictive models including linear and exponential regression, logistic regression, decision tree, cluster, time series, and association rules. Reporting Guide. Right click on a Report Services Document. 4 • You can add multiple layers on a Google map widget by inserting datasets into the document. The report-related objects placed on the template, such as attributes. Click on the object and click on the control on the right of the Property List: Navigation > "Is hyperlink". Contents Report Services Document Creation Guide. 5 - MicroStrategy Product Manuals 2015-02-01 The Dashboards and Widgets Guide provides instructions for designing and creating MicroStrategy Report Services dashboards, a type of document that is optimized for viewing online and for user interactivity. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. 3. There are various applications of MicroStrategy. DesigningandCreatingDocuments 1 Introduction 1 Beforeyoubegin 2 DisplaymodesinMicroStrategyWeb 2 DesigningandcreatAnswer: Go with dossier. In MicroStrategy Web, click Create at the top of any page, point to New Document, and select Blank Document. As seen below, in order to create a MicroStrategy Report Services document, choose a new 'Document. 1, SQL, SQL *Loader, Oracle 10g, Windows 2003, UNIX. Login to Postman and search for MicroStrategy in the homepage search bar. smw format. Version 9. For example, a scheduled report executes which shows the Revenue by day for the past week. x Report Services documents. Learn how to create, edit, and share reports, dashboards, and documents using Excel, PowerPoint, Word, and Outlook. In the document, add a Slider selector under the graph. Then, configure the slider to control the graph. You can also create links in documents. When there is no data returned by the grid, the text message is visible along with the text defined in Project Configurations > Report definition > Advanced > No data returned > Display message in document grids. Click the Apply check mark to create the new threshold or conditional format. EN. When you create a document, you can specify the data that appears, control the layout, formatting,. Create a new document. Create a report in MicroStrategy Developer with attributes Customer, Customer Address and Customer City in the grid. Right click on the grid and go to “Properties and formatting”. A new document opens in Design Mode. Hive. A wide Report Services document will display on multiple pages when in PDF view event the it was design to display everything on one row/page. It is necessary to disable the report cache or add the following code to refresh the Report services document. SHOW MORE. Preview Feature: Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more. For documents, links are functional in Interactive Mode and Editable Mode in MicroStrategy Web. Create a metric selector S2. In the Subscription Editor, click Burst…. refresh(false, true); The example provided in this document is provided “as-is” and user has read the following customization warning:Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. Understanding and working with document sections. Create a report (report C) with Prompt #2, and place Call Center on the template. 0 Reviews. Samples of each type of application object are located in the Public Objects folder in the Tutorial project. 1 Document Number: 09500931 Second Edition, version 9. You can create derived elements with the following methods: Quickly creating groups, calculations, and sorts: While reviewing the data on a report or document, you can quickly group attribute elements into derived elements for further analysis of your data. Dashboard-style Documents. Use selectors to flip through the panels in a panel stack or display different attribute elements or metrics in a grid or. Server, MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy MultiSource, MicroStrategy OLAP Services, MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services, MicroStrategy Transaction Services, MicroStrategy Visual. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. You can connect. A Control Document, also called an Execution Control Document, is a plaintext document containing information formatted to a specific syntax which allows various message properties to be set or overwritten. This template uses a single. 11: 1. Direct Cubes over View Reports. Documents allow you to showcase your business data in a user-friendly, boardroom-quality way that is suitable for presentation to management. Save the dossier. For steps to subscribe reports/documents to be delivered to a History List, see History List Subscription Editor. Client: Confidential, November 2006 –August 2008 Location: IndiaIn-Memory Analytics Guide for MicroStrategy 10 OLAP Services Guide for MicroStrategy 9. Create a simple report with multiple prompts, as shown below: Use the report as a data set in a Report Services document. This document provides the steps to accomplish the same. For example, a scheduled report executes which shows the Revenue by day for the past week. MicroStrategy integration with Kafka. The Report Services Document Creation Guide provides instructions to design and create Report Services documents, building on information in the Basic Reporting. This section describes procedures for grouping and sorting records in a MicroStrategy Report Services document. You can create an indented grouping of related data on a grid report or a Report Services document by organizing the data into a standard outline style. It gives you the leverage of generating real-time reports and monitoring data. To Create a Report from Scratch. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks MicroStrategy Analytics Desktop User Guide Contents © 2016 MicroStrategy, Inc. URLs that point to the same MicroStrategy Web server as the one that you are using are not supported. Design and Administration Guide: A Platform for. In the newly opened window, expand "Series" and select the series that the user wants to show as a step line as shown below: In this menu, enable the check box : "Show Step. The setting to enable or disable "Total" in a page-by is located in the "Advanced Subtotals Options" dialog box. You can also access the Item Order Form document in the Tutorial project to review each component of the document, and refer to the Report Services Document Creation Guide for steps to create a document. These. MicroStrategy Product Manuals. Design workflows, create content groups, or customize application components with the no-code framework. Open the Report Services Document in MicroStrategy Desktop 9. 4. Alternatively, 4. From the Insert menu, select Text. 1. A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. Q24. 4. Query Execution - Reference MicroStrategy Product Documentation > System Administration Guide > Chapter 5 for a complete list on how to monitor Job Execution and system usage; Data Preparation, XML Generation and. When subtotals are enabled on a Microstrategy Desktop report, attributes in a page-by are defaulted to display "Total" as the last option in the drop-down box. Make two grids with different attributes and metrics in each 3. By default, if a cache is present for a subscribed report or document, the report or document uses the cache instead of re-executing the report or document. Calculated expressions are created using text fields and require braces { } around the. Create and save the prompt. view Report Services Documents in the MicroStrategy Mobile client, and create Mobile document subscriptions in MicroStrategy Web:. reporting functionality can be found in the MicroStrategy Advanced Reporting Guide. 4. . You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. Certain situations may prevent users from using this feature, such as: 1. In the upper left part of the Get Info page, notice the following link: Change Cover Page. And leverage the Page-By function to focus your analysis on one element. In MicroStrategy Web, open the document in Design Mode. Add the filter to the report. Click on the "Insert" menu and select "Grid" while in the document editor. The document is displayed in Presentation Mode by default. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document designers understand how end users will use documents for data analysis. Save the report as R1. 3. View standard reports in MicroStrategy Library to get a simple, grid view of data. Detailed information to create furthermore modify Report Related documents can be found in the Document Creation Help. This helps users discover new content and insights from both Report Services documents and. evt. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Check Details. A MicroStrategy Report Services document displays your organization's data in a format that is similar to a PowerPoint presentation, where several grid and graph reports can be viewed at the same time, along with images and text. For steps to enable a bubble grid widget as a selector, see. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. In the first step we creat the metric with the equation: RunningSum (Sum (1)) 2. 4, June 2017 Copyright © 2017 by MicroStrategy Incorporated. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Within the control, click on "Hyperlink" and enter in the syntax of the mail tag. Steps to create Report Services documents, add objects, and format the document and its objects. Set the selectors S1 and S2 to target the three grids at the same time. Log in to the MicroStrategy Tutorial sample project. In a text editor (such as Notepad), enter the command line statement that the task scheduler should execute. x users have the ability to disable this option. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager et MicroStrategy Data Mining Services sont des marques ou des marques déposées de MicroStrategy Incorporated. Documents allow you to display your reports as either a Grid, Graph, or both a Grid and Graph. The following steps would allow users to create an information window that is triggered by clicking on a neutral “button”. . This report must contain the input object for each value that you want to allow users to change. For steps to create a Transaction Services report, see the Advanced Reporting Guide. •. . Configuring Report Services Document Caching via MicroStrategy Desktop. Execute. You can: View the results of the document. Dashboard AnalysisGuide, which provides abasic understanding of how to manipulate the data in a document or RS dashboard to analyze business information. The undo stack is managed by the client's browser and will reset itself when the MicroStrategy Web 9. Displaying outline results. Report Services Document Creation Guide. Users now get a selector to draw a blank grid in the required sections of the document. In the Report Filter area, double-click the arrow to add a new qualification. You can modify the appearance of an HTML document, just like any other HTML page, to include text, images, hyperlinks, tables, and one or more report objects. 5. To view a document in Presentation Mode, do one of the following: . Create a grid report with the all_sales. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. Right-click the grid, then select Properties and Formatting. Reporting Guide. The table below shows the URL parameters used to execute a document using the URL API. 1, SQL, SQL *Loader, Oracle 10g, Windows 2003, UNIX. 5. Analysts can then display and interact with the widget in both MicroStrategy Web and MicroStrategy Developer. To hide entire sections of a MicroStrategy Report Services document complete the following steps: Select the section you want to hide on the MicroStrategy Report Services document. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Enterprise Manager comes with several Report Services documents that show one or more related reports in a dashboard-type display. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. Export to Excel. This article notes a behavior for documents and group by headersAutotext code/macros in Microstrategy Document/dashboard. MicroStrategy Report Services Document Creation Guide For more information on the Height can shrink and Height can grow options, see the Document Creation Guide. If the document is already open in Design Mode, click the Editable Mode icon . In MicroStrategy Web, open the document in Design or Editable Mode. To burst a file subscription across multiple files. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. This allows you and other users to navigate to different sections of the graph's results. • Using of MicroStrategy Report Services documents, you can create scorecards and dashboards. Create a file subscription in MicroStrategy Web. CONTENTS OverviewandAdditionalResources vii Aboutthisbook viii 1. Visit the data visualization and data dashboard galleries for inspiration. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this. Check Details. When you create a document, you can specify the data that appears, control the layout, formatting, grouping, and subtotaling of data, and specify the position of page. When 'Save Options' appear, choose the first option, as shown. xls format. At this stage, all metrics are available in both S1 and S2, but the order is different. The documents must be worked on simultaneously, so. MicroStrategy Report Services Document Creation Guide プロジェクト デザイン ガイド: MicroStrategy Project Design Guide MicroStrategy 関数リファレンス: MicroStrategy Functions Reference MicroStrategy Mobile 分析ガイド: MicroStrategy Mobile Analysis Guide MicroStrategy Mobile デザインおよび管理 ガイド. Dossiers. Open the document editor and add the above report as a dataset. A document can be grouped and sorted using fields from the primary dataset only. You can create the following types of subscriptions for a report or document: Cache update subscriptions refresh the cache for the specified report or document. Version 9. The object's editor or wizard opens. Create a Report Services Document 2. 1 To ensure that…In MicroStrategy 10. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. To open documents in various modes. Grid: Displays the Grid/Graph as a standard MicroStrategy grid report with rows and columns of attributes and metrics, as. Web the dashboards and widgets guide contains instructions for designing and creating microstrategy report services dashboards, a type of document. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. exe -w C:filename. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. A Grid/Graph acts as a standard MicroStrategy report. 1. ' For more information, refer to the MicroStrategy Product Manuals and look for Document Creation Guide. This should be set to 'True' by default as shown in the image below:As shown below: Put 1st text box above 2nd text box, and apply background color to 1st text box so that is covers the 2nd one. Create a selector on metrics, targeting the graph in step 3. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1The Report Services Document Creation Guide contains instructions to design and create Report Services documents, building on information in the Basic Reporting. Make two grids with different attributes and metrics in each 3. Datasets provide the data that appears in documents. Samples of each type of application object are located in the Public Objects folder in the Tutorial project. View changes and push updates to end users in seconds. 1 users are unable to undo changes made on a Report Services Document after exporting, printing or saving. Create a report with the metric "Yesterday". Create a new Document in MicroStrategy Web 9. Since: MicroStrategy Web 7. MicroStrategy allows to pass selector values across Report Services documents using Edit Links. On the Freeform Sources tab, select Create Freeform SQL report. In MicroStrategy Developer 9. Web To Create A Bubble Grid Widget, See. x Report Services Document Creation Guide Book 2 Adding Script and Data to Documents. MicroStrategy, Dec 20, 2011 - Computers. Preview Feature: A new data. This procedure assumes that the Transaction Services report that you want to link to the Grid/Graph, text fields, or transaction table has already been created. One key feature is MicroStrategy Developer's Training Metric Wizard. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks Learn how to use MicroStrategy OLAP Services to enhance your data analysis and reporting capabilities. Click Shared Reports. Web dashboards and widgets creation guide. Measuring the Performance of Public Services 2012-02-02 Michael Pidd Shows how the principles,. IS_CACHE_HIT_TYPE. Document Creation Guide. 0. Save the report. MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy. Follow the steps below to split a dataset displayed as a grid in a Report Services Document:MicroStrategy is a business intelligence tool that is widely used for deriving valuable insights from data in the form of visually insightful reports, graphs and charts. Reports and documents are the objects that. Step 1. For basic information on MicroStrategy reports in general, see. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. To access the Template Editor, execute the following: From the File menu, go to New and choose Template. For identification purposes, this example will refer to this object as 'Grid A'. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks From the File menu, select New, and select the type of object to create, such as a report or a filter. Examples of documents include scorecards and dossiers, managed metrics documents, production and operational documents, and more. Detailed information to creation the modify Report Services. 4. 1. MicroStrategy Office is a comprehensive guide that covers how to use the MicroStrategy platform with Microsoft Office applications. This section describes the ways in which you can design and create a MicroStrategy Report Services document. Add metric "Yesterday" to the document section as dynamic text. ) • To create a new layout using a saved document,. The Database Administrator must ensure that the user account accessing the database has SELECT permissions for the table involved in the report. For information on Report Services documents, see the Report Services Document Creation Guide. Toolbar Options. Execute the report and notice how users are unable to see the date range filter for this report: Add the report as a dataset to a new Report Services Document . The Document Editor has multiple toolbars you can use to access different document features. Upgrading Platform Analytics. When exported to Excel, both values 61 and 62 are visible at level 3 in the Excel file. The HTML is retrieved dynamically when the document is executed. The report is added as a Grid/Graph (an object that acts like a standard MicroStrategy report) in the Detail Header of the new document (see Creating a document from a report). You will learn how to add and manipulate data, charts, graphs, images, and other elements to design interactive and informative documents. A Grid/Graph can be directly associated with one dataset report. This technical note explains how to display both value and percentage in a pie chart in MicroStrategy Developer Report Services Documents The following steps describe how to have both the value and percentage displayed in a pie chart in MicroStrategy Developer 9. Right-click in an empty area on the right side of. x-10. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document designers understand how end users will use. Notice only half the metric displays without wrapping. A MicroStrategy Report Services document contains objects representing data coming from one or more reports, as well as positioning and formatting information. Upgrade Guide Version 10 Document Number: 09321000. 3. c. 5. Refer to the Advanced Reporting Guide for more information on Transaction Services reports. 3. Users that have the "Edit Notes" privilege can edit notes as described below: Click Edit. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Log in to the project in which you want to create a report. MicroStrategy Report Services Document Creation Guide プロジェクト デザイン ガイド: MicroStrategy Project Design Guide MicroStrategy 関数リファレンス: MicroStrategy Functions Reference MicroStrategy Mobile 分析ガイド: MicroStrategy Mobile Analysis Guide MicroStrategy Mobile デザインおよび管理 ガイド. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. The document is displayed in Presentation Mode by default. For information on using the Freeform SQL Editor to report on third-party web services. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. These auto text codes are automatically replaced by information about the. Business Intelligence Platform Built For The Internet, Office In telligence, MicroStrategy Office, MicroStrategy Report Services , MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager und MicroStrate gy Data Mining Services. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. In MicroStrategy Web, open the document in Design or Editable Mode. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. For detailed instructions to create a document, see Creating documents. For example, a scheduled report executes which shows the Revenue by day for the past week. Displays or hides the All Objects panel. Click any report you wish to execute. Target type: Dataset. ; On the Freeform Sources tab, select Create Transaction report. Notice word wrap is maintained: Create document from this report. To benefit from the latest functionality available in this version of MicroStrategy Platform Analytics, an administrator must upgrade the MicroStrategy system, including Platform Analytics. Log on to the machine where you are installing one or more MicroStrategy products. Transaction data submitted during offline mode (a local transaction) is written back to the local dataset when the Internet connection is reestablished, and any document pointing to this local dataset receives this transaction. The text field for new notes opens. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. It builds on the basic concepts about documents presented in the Document Creation Guide. Once data flows into the interface, the dashboard will come to life. For example, you can use a Report Services document or dashboard from the MicroStrategy Tutorial project in your own project. 1. x. See the Basic Reporting Guide for steps to creating reports. ' In order to create an HTML document, choose a new 'HTML Document. Environment: Microstrategy Desktop 8. To create a new layout using a Report Services (RS) dashboard template, click the Dashboard Layouts tab,. EN. Right click the column once again and choose option “Edit selector…”. The sections listed below provide the configuration steps for the different data sources: Connect to Databases. This guide discusses settings that are most relevant to implementing MicroStrategy with SQL Data Warehouse. This article was created to clarify the behavior change when running a report with the report editor if there is a rank in the view filter and the data has NULL values. EN. 1 these privileges. Details to design a document or dashboard are in the Report Services Document Creation Guide. For more information, see the Document Creation Guide. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. 5. View the report as a grid and the graph. We then created a report in either web or developer with our new banding metric along with any desired attributes or metrics we want in our documents detailed section (we chose profit and customers from tutorial for our example)Creating and Managing Devices. Web Dashboards And Widgets Creation Guide For Microstrategy 9. 1, Microstrategy Architect 8. This document describes how to show a grid in a Report Services Document in several columns in MicroStrategy 9. 4. MicroStrategy provides a detailed document of its technical support policy and procedures, covering topics such as support liaisons, service levels, escalation process, and maintenance fees. Web for information on report services, see the document creation. When sharing a Dossier in MicroStrategy Library, the content of the email received is in English when the recipient user's language is set to a language other than EnglishThe full set of VLDB properties is documented in the MicroStrategy System Administration Guide. Go to Widget properties and match each. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. 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. • 4: Custom SQL Wizard: MicroStrategy Query. CONTENTS BookOverviewandAdditionalResources vi 1. Create a new Report Services document with the report as a dataset. How to Create a Report Services Document Header/Footer Only for Exports or Printing with MicroStrategy Web. Providing analysis and interactivity: Widgets; Editing documents in full screen; Formatting a document; Copying panel. First, you open a blank document and select a report to use as the document's dataset. Creating multi-layout documents. This technical note describes how to invoke and execute any JavaScript function from a regular hyperlink within a Report Services Document. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. On the same right mouse click context menu under the attribute header, users will see an. Documents allow you to showcase your business data in a user-friendly, boardroom-quality way that is suitable for presentation to management. Drag R2 to document as grid. ' For more information, refer to the MicroStrategy Product Manuals and look for Document Creation Guide. . This data is positioned and formatted, resulting in a single display of presentation quality. Excel: This allows the user to export the document to Microsoft Excel in . Report Services Document Creation Guide: Creating Boardroom Quality Documents. Add the prompt to a report. To learn more about the Required column, refer to article KB207490. 4. (For an introduction to controls in documents, see the Report Services Document Creation Guide. The following steps describe how to create a link to a MicroStrategy Web report in a document so that users can click on the link to execute the report. In MicroStrategy Developer, choose File > New > Report. Consider the following example: In MicroStrategy Tutorial, create a simple attribute off the LU_YEAR table and name it "DELETE ME". Avoid Duplicated Datasets. Create a grid that contains the same attribute and metric as the graph. This chapter describes how to create these types of objects. Datasets define which information the Intelligence Server should retrieve from the data warehouse or cache. 2. x Distribution Services, it is possible to create an email subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. Opens the report in PDF format. 1 and 10. to create a clustered production instance. Creation Guide for MicroStrategy 9. MicroStrategy Freeform SQL reports, in which the SQL is entered directly into the interface.