com 02. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. In addition, they can insert pictures and draw borders in the document. In MicroStrategy Developer 9. Notice word wrap is maintained: Create document from this report. Repeat Steps 3 through 6 using a second grid that displays 'Profit'. Toolbar Options. Each custom format can have up to four. More advanced Report Services Documents can be created to further utilize this feature as well. Dashboards and Widgets Creation Guide Creating Interactive Dashboards for your Data Version: 9. 3. 3, March 2016 To ensure that you are using…It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. This section covers design information thatis specific for reports and documents that are intended to beused on a BlackBerry. From a folder page, click the name of a document to open it. Detailed information to create furthermore modify Report Related documents can be found in the Document Creation Help. For information on HTML documents, see the MicroStrategy Developer help. . Environment: Microstrategy Desktop 8. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. Create a Report Services document that contains Report A as a dataset. 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 Developer, log onto the desired project. Execute the document and confirm that the message in the textbox does not appear when there is a value returned for "Year" 4. For issues related to Workstation connecting to the Intelligence Server, ensure that the Workstation version is the same/or compatible with the Intelligence Server environment. Documents and dashboards allow you to display your business data in a user. Click on Browsing Options and `Display hidden objects. 3) Click on Browsing. 0 Crashes when running a Report Services Document in Flash Mode. A MicroStrategy Report Services document displays your organization's data in a high-quality, Pixel Perfect display. Samples of each type of application object are located in the Public Objects folder in the Tutorial project. Version 9. Add the following Autotext: {&Prompt1&} and {&Prompt2&} as show below: The two prompt AutoText values will correspond with the two Dynamic. This article notes a behavior for documents and group by headersAutotext code/macros in Microstrategy Document/dashboard. For steps, see the Basic Reporting Guide. Lookup table for the Cache Hit indicator: • 0: Reserved. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This allows you and other users to navigate to different sections of the graph's results. The Document Editor has multiple toolbars you can use to access different document features. 3. 4. Design and Administration Guide: A Platform for. Project attributes allow a designer to. Save the report as R1. Alternatively, a user account having those permission may be used for warehouse access and this should be updated in the Developer (Database Instance > Database Connection > Database Login). Using of MicroStrategy Report Services documents, you can create scorecards and dashboards. 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. When you group records in a document, you set up the document's hierarchy and therefore its inherent sort order for the data displayed in the document. The Dashboards and Widgets Guide contains instructions for designing and creating MicroStrategy Report Services dashboards, a type of document that is. Connection to databases, Excel files, and text files is described in Connect to Databases, Excel Files, and Text Files. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. Reports . MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. 2. Documents and Dashboards for MicroStrategy Report Services Dashboards and Widgets Creation Guide for MicroStrategy 9. Run this to Interactive mode and notice that all three metrics appear with Revenue and Profit on the Y1 axis and Random Number on the Y2 Axis. 4, June 2017 Copyright © 2017 by MicroStrategy Incorporated. It allows the user to set the server name, port and project, among others, to start an Intelligence Server session. A link with a URL made up of the object ID and specific link syntax. Custom number formatting symbols. It gives you the leverage of generating real-time reports and monitoring data. x MicroStrategy Intelligence Server and newer clustered environment, subscriptions created using a time-based schedule are not restricted to the primary node only. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk. After that, when users select some elements, the 1st text box will display selected elements and covered the 2nd one. This template uses a single. It should appear in the following format:In developer the table object appears as managed by the system, and has no dependencies, in workstation it says the same "cannot delete because of dependencies" without having them. 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. Save this report and add it with formatting to a new Report Services Document using the Blank Dashboard template. 1 and was defined to display in Flash Mode. Center alignment is set by default. 10. Open a document in the Document Editor. Execute reports or documents that reference the object. x:In MicroStrategy Narrowcast Server 9. View changes and push updates to end users in seconds. Locate and run the Setup. Designing and creating documents: An overview. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. In case of multi-pass reports all passes for a MicroStrategy job are. 1 or earlier. Computing & Internet · 2015What is report service document in MicroStrategy? A MicroStrategy Report Services document displays your organization’s data in a high-quality, Pixel Perfect display. Create a new report with an attribute in the row, year on the column, and a metric (with a long name like 'Quarterly Standard Deviation of Daily Revenue') and save and close. Step 1. Export a Report Services document to Excel with formatting using URL API in MSTR Web. 3 2012-09-30 MicroStrategy Product Manuals R Markdown. CONTENTS BookOverviewandAdditionalResources vi 1. 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. Create a report with the metric "Yesterday". In MicroStrategy Developer, from the File menu, select New, and then choose Report. • Use the All Objects panel when working with. For example, you can use a Report Services document or dashboard from the MicroStrategy Tutorial project in your own project. Tutorial can be found in the Basic Reporting Guide. Select the Edit Links option. 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. For example, if you want to send reports via email, and your recipients use an email client such as Microsoft Outlook, you can create a. Examples of documents include scorecards and dossiers, managed metrics documents, production and operational documents, and more. 4. ; On the Freeform Sources tab, select Create Transaction report. A Grid/Graph acts as a standard MicroStrategy report. 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. MicroStrategy Mobile overview. Place the second grid right below the first. 1. -1: Cache Update: Limits the number of cache updates that a user can process at a time. Mobile, MicroStrategy Server, MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy MultiSource, MicroStrategy OLAP Services, MicroStrategy Intelligence Server, MicroStrategy Distribution Services, MicroStrategy Report Services, MicroStrategy Transaction Services, MicroStrategy Visual Insight,. 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. In a document, you can display a report by adding a Grid/Graph to the document. 5. Reports and documents are the objects that. Is it possible to prevent the delivery of reports and documents that do not return any data as a report-level setting in MicroStrategy Distribution Services 9. 1m Boot Up to Ubuntu, Fedora, KNOPPIX, Debian, openSUSE, and 13 Other Distributions Document Analysis Guide for MicroStrategy 10 MicroStrategy Report Services: Documents and Dashboards CCNP Security SISAS. To see sample dashboards in MicroStrategy Web. 1 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version show In the Run Modes area, select the format (s) in which the document can be exported: •. Under Collections, click on the the “…” next to. Version 10 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shown i Universal, MicroStrategy Office, MicroStrategy Data Mining Services, MicroStrategy Narrowcast Server, MicroStrategy Health Center, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Developer, MicroStrategy Web Professional, MicroStrategy Architect, MicroStrategy SDK, MicroStrategy Document Creation Help. 1m Creating. In MicroStrategy Web, menu and toolbar disappears from reports and Report Services documents, as shown below: The correct report or Report Services document page including menu and toolbar should be as shown below: CAUSE: One of the cause is that MicroStrategy Web is not deployed correctly. smw” “UserName=User1 “Password=1234”. Dashboards and Widgets Creation Guide for MicroStrategy 9. Reports and documents are the objects that. Notes. To set a column to be optional, configure the transaction in MicroStrategy Web and uncheck the option ‘Input is required’. This option is available in Design and Editable Modes. Create a report services document and add report “Survey” as dataset. For example, a scheduled report executes which shows the Revenue by day for the past week. The following steps outline how to accomplish this: 1. At the Project Level: In the Project Configuration Editor, under Caching -> Result Caches-> Creation, select the setting called "Enable Document Output Caching in Selected Formats" along with the desired output formats, as seen below: A separate section called. 28 Displaying, hiding, and. Right-click any of the attribute elements on the grid. Go to the Data menu and notice that the Prompt Ordering option does not appear, as shown below:Hee-Wei Tan (Inactive) · May 1, 2017 ·. In documents, links can be added to objects in a Grid/Graph, and they can link to another document or to a report. As seen below, in order to create a MicroStrategy Report Services document, choose a new 'Document. Go to the Report -> Data->Intelligent Cube Options->Point grid to. smw format. 0. Use the following formula for the derived metric: (Profit 2003 – Profit 2002)/Profit 2002. For example, if the selector source is Region, Use last is selected, and Number of elements is defined as one, the last region (Web) is displayed. x and edit the graph as shown below: In the Desktop Toolbar, select Graph> "Graph Options". Exit all Windows applications before beginning the installation process. Additional performance tuning best practices for OLAP Services are provided in the System Administration Guide. In MicroStrategy Developer, choose File > New > Report. Create a metric selector S2. The Tutorial project includes sample data, such as actual customer names and items purchased. MicroStrategy Intelligence Server provides one centralzed architecture for all users' monitoring, reporting and analysis requirements. Uncheck the option “Enable report drilling” and select OK. MicroStrategy Report Services Document Creation Guide プロジェクト デザイン ガイド: MicroStrategy Project Design Guide MicroStrategy 関数リファレンス: MicroStrategy Functions Reference MicroStrategy Mobile 分析ガイド: MicroStrategy Mobile Analysis Guide MicroStrategy Mobile デザインおよび管理 ガイド. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. This chapter describes how to create these types of objects. Use selectors to flip through the panels in a panel stack or display different attribute elements or metrics in a grid or. Preview Feature: A new data. The text field for new notes opens. The Dashboards and Widgets Guide contains instructions for designing and creating MicroStrategy Report Services dashboards, a type of document that is optimized for viewing online and for user interactivity. On the opposite side, a Snowflake schema has a normalized data structure. It's being used even in the biggest financial, telecom and manufacturing organizations in the World. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The text field for new notes closes, and all the existing notes become active. The list of privileges and their descriptions can also be found in the MicroStrategy - System Administration Guide that comes with the product documentation. For basic information on MicroStrategy reports in general, see. x MicroStrategy Intelligence Server clustered environment, subscriptions or administrative tasks created using a time-based schedule only run on the primary node. This guide discusses settings that are most relevant to implementing MicroStrategy with SQL Data Warehouse. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. x, Attributes/Metrics cannot be deleted due to dependencies on Report Services Document, although the attribute is not seen either in the Document, or its composing dataset. Drilling on a Grid/Graph object in a document is similar to drilling on a report. From the Home menu, select Page Setup. For details on how the data from multiple datasets is joined, see Using datasets in documents. Choose the option Get Info. Likewise, footers generally contain page numbers or other similar information. The Properties and Formatting dialog box opens. From the Insert menu, select Text. In MicroStrategy Web, click Create at the top of any page, point to New Document, and select Blank Document. Create a selector on metrics, targeting the graph in step 3. Reporting Guide. MicroStrategy Web users that are licensed for MicroStrategy Report Services can view and interact with a document in Flash Mode, if the document was created before MicroStrategy 10. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. Refer to the Advanced Reporting Guide for more information on Transaction Services reports. Drilling is available for Report Services Documents starting in MicroStrategy 9. Preview Feature: The FreeForm SQL Report Editor allows you to write your own queries to create reports. 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,. All articles. In the first step we creat the metric with the equation: RunningSum (Sum (1)) 2. However, since a text prompt cannot be directly incorporated in a report object, it must be embedded in a metric. 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. Click the down arrow next to data > choose "Hide nulls/zeros" to enable the hide nulls/zero option. To create History List messages for Report Services documents that are exported to other formats, select the Save exported results for interactive executions sent to History List check box. Details to design a document or dashboard are in the Report Services Document Creation Guide. To ungroup the object elements: The Create Group feature is only available through document view mode. (A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Press the SHIFT key while dragging and dropping the above report to the document design area. MicroStrategy. 3. Types of Subscriptions. You can also create links in documents. In MicroStrategy Web, open the document to import layouts into, in Design Mode or. User without the Web Document design privilege cannot edit a document by navigating from Library Web to MicroStrategy Web. Configuring Report Services Document Caching via MicroStrategy Desktop. You need to know the link syntax and find the. 2. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. • 4: Custom SQL Wizard: MicroStrategy Query. Web the dashboards and widgets guide contains instructions for designing and creating microstrategy report services dashboards, a type of document that is optimized for. x and 10. Create a simple report with multiple prompts, as shown below: Use the report as a data set in a Report Services document. 1 and 10. 2048001 - executeRWDocument. In MicroStrategy Web, edit or execute a report. 1, Microstrategy Web 8. 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. ; Enter the XQuery statement required to connect to the third-party. MicroStrategy Document Creation Guide is a comprehensive manual that teaches you how to create and format various types of documents using MicroStrategy tools. 11: 1. 4. ; You can create multiple cache, History List, Intelligent Cube, or Mobile subscriptions at one time for a user or user group using the Subscription Wizard. Execute. Add the report created in step 1 to the panel in the document. Place an image or auto text field in a MicroStrategy Report Services document. MicroStrategy 9. To measure the time spent in these components, refer to the following resources: Intelligence Server and Client. Web the dashboards and widgets guide provides instructions for designing and creating microstrategy report services dashboards, a type of document that is optimized for. MicroStrategy Report Services Document Creation GuideMicroStrategy Report Services Document Creation Guide. These. It is organized to help guide you through creating a new document, from creating the document itself, to adding objects to the new document, and formatting the. The Properties and Formatting dialog box opens. KB30101: How to Enable drilling for Report Services document in MicroStrategy Web. Analysts can then display and interact with the widget in both MicroStrategy Web and MicroStrategy Developer. Answer: Go with dossier. The New Grid dialog box opens. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter. Users now get a selector to draw a blank grid in the required sections of the document. 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 . Resize the columns so that the metric word wraps: Export to Excel. 4. Users that have the "Edit Notes" privilege can edit notes as described below: Click Edit. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. Make sure to place the 'Quarter' attribute in the column. Check the option to 'Open in new window'. Parameterized reports, HTML widgets, document templates, custom output formats, and Shiny documents. The Report Services Document Creation Guide contains instructions to design and create Report Services documents, building on information in the Basic Reporting Guide and Advanced Reporting Guide. In the layout tab, click "Allow multiple selections". Save the document as D1. MicroStrategy Mobile is an application for mobile devices that allows analysts to view, refresh, and analyze MicroStrategy reports and Report Services documents. Execute R2 and right-click on the Year attribute. For information on using the Freeform SQL Editor to report on third-party web services. For example, these reports go from basic execution pointers, quarterly deals by item. Learn how to create, edit, and share reports, dashboards, and documents using Excel, PowerPoint, Word, and Outlook. The select types that can be creates in MicroStrategy inclusion the following: Scorecards plus dashboards: designed. . Create Cube B which contains all objects in the report and publish it . All rights reserved. To update the cover pages for Report Services Documents: Go to Workstation. 1, SQL, SQL *Loader, Oracle 10g, Windows 2003, UNIX. If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). Dashboard-style Documents. For steps to enable a bubble grid widget as a selector, see. Log in to the project in which you want to create a report. Right-click the header of the attribute whose elements you want to use to. 1, Microstrategy Web 8. Visit the data visualization and data dashboard galleries for inspiration. For information on integrating MDX cube sources into MicroStrategy, see theMDX Cube Reporting Guide. vi © 2016 MicroStrategy, Inc. Select Export from Home menu, and then click PDF. 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 data is positioned and formatted, resulting in a single display of presentation quality. When you upgrade Platform Analytics, you must upgrade both the Platform Analytics Project and Platform. The Dashboards and Widgets Guide contains 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 upper left part of the Get Info page, notice the following link: Change Cover Page. In microstrategy web, open the document in design or editable mode. A MicroStrategy Report Services document contains objects representing data coming from one or more reports, as well as positioning and formatting information. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. If Current state is set to either Use first or Use last, type the number of elements to display in the Number of elements field. Document designers also create Report Services (RS) dashboards, as described in Designing dynamic enterprise RS dashboards. Click OK. MICROSTRA microstrategy. In MicroStrategy Web, create a Report Services Document and insert a panel in the document. MicroStrategy Distribution Services, MicroStrategy Report Services, Report Services Document Creation Guide: Creating Boardroom Quality Documents Version: 9. 4. The following code snippet will execute the Report Services Document, loop through the elements in the page by and export each available element to PDF public static void executeDocument() throws Exception { //Create connection with the Intelligence Server: iSession = createSession("localhost", "MicroStrategy Tutorial", "administrator. 4. 2. Report Services Document Creation Guide: Creating Boardroom Quality Documents Version 10. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Enterprise Manager comes with several Report Services documents that show one or more related reports in a dashboard-type display. Add a text field using one of the following methods depending on your goal for the text field: •. You will also learn how to export and distribute your documents in different formats, such as PDF. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. 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. MicroStrategy Integrity Manager 9. You can include a security filter as part of an XQuery report to restrict the web services data that a MicroStrategy user can access. MicroStrategy integration with Kafka. 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. Limit the Use of Derived Attributes or Metrics. MicroStrategy Report Services Document Creation Guide プロジェクト デザイン ガイド: MicroStrategy Project Design Guide MicroStrategy 関数リファレンス: MicroStrategy Functions Reference MicroStrategy Mobile 分析ガイド: MicroStrategy Mobile Analysis Guide MicroStrategy Mobile デザインおよび管理 ガイド. Report Services Document Creation Guide. Dashboards, which are a type of document, provide a lot of interactive. The user can click the link to email, export, or subscribe to the target. Report designers can read detailed information with examples on how to create report objects and design reports, in the Advanced Reporting Guide. In the document, add a Slider selector under the graph. 3. 3. 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. 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). Report Services Documents in 10. To view a document in Presentation Mode, do one of the following: . 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. An HTML document is an HTML container for formatting, displaying, and distributing multiple reports on the same page, or at the same time within a project. A new document opens in Design Mode. When you create a document, you can specify the data that appears, control the layout, formatting,. To execute a report or document, a user must have Execute access to all objects on the report/document. 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. MicroStrategy provides predefined document templates, including the Blank Document template and the Blank Dashboard template. A MicroStrategy document contains objects representing data coming from one or more reports, as well as positioning and formatting information. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. To Create a Freeform SQL Report. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this. Before MicroStrategy 10. Installation And Initial Setup. Execute the document and the R generated. Report Services Document Creation Guide: Creating Boardroom Quality Documents. Use this guide to learn about designing and creating MicroStrategy documents using MicroStrategy Developer. pdf) concerning the respective databases and ODBC drivers. 2. Save and close the report. For an overview and steps to add a dataset to a document, see the Document Creation Guide. Save the report. 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. Create a grid that contains the same attribute and metric as the graph. Upgrading Platform Analytics. x, as shown below. 3 Document Analysis Guide for for MicroStrategy 9. From a folder page, click the name of a document to open it. Report Services documents are an excellent source of summarized data from related areas of analysis. This is from all MicroStrategy Business Intelligence clients platform. In MicroStrategy Web, open the document in Design or Editable Mode. The following steps explains how to enable Drilling from MicroStrategy Desktop. The data from the report is used to populate the Grid/Graph. Hive. If the document is already open in Design Mode, click the Editable Mode icon . Report Services Document Creation Guide: Creating Boardroom Quality Documents Version: 9. 5. 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 report must contain the input object for each value that you want to allow users to change. x. You can also select an existing template (see How to Create a Report Based on an Existing Template ). Right-click the grid, then select Properties and Formatting. 1 users are unable to undo changes made on a Report Services Document after exporting, printing or saving. 1 CONTENTS BookOverviewandAdditionalResources vi Aboutthisbook vii Resources viii Feedback xvi 1. 2 :Documents allow you to showcase your business data in a user-friendly, boardroom-quality way that is suitable for presentation to management. 3. At the base report level, go to Data > Advance Sorting, then add Month to the 'Sort By' column. MicroStrategy Office, MicroStrategy. Create a Report Services document using R1 as the dataset, drag the grid into the detail header, and execute the document in PDF view. 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. Once this dataset has been defined, users have the ability to create a grid report through the document editor. Datasets provide the data that appears in documents. For information about how result (report or document) caches are used in MicroStrategy, see Result Caches.