Create a report in MicroStrategy Developer with attributes Customer, Customer Address and Customer City in the grid. x-10. 3. For steps to subscribe reports/documents to be delivered to a History List, see History List Subscription Editor. 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. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1The single dimension table of a Star schema consists of aggregated data while the data is split into various dimension tables in a snowflake schema. This section covers design information thatis specific for reports and documents that are intended to beused on a BlackBerry. Cards. Resize the columns so that the metric word wraps: Export to Excel. High-quality, Pixel Perfect documents allow you to display your business data in a user-friendly way that is. Create and save the prompt. 4. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. EN. 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. This allows you and other users to navigate to different sections of the graph's results. To view a document in Presentation Mode, do one of the following: . As document designers create documents, they specify the data that appears and control the layout, formatting, grouping, and subtotaling of data. To access the MicroStrategy Installation Wizard. Project attributes allow a designer to. Dashboards usually provide interactive features that let users change how they view the dashboard's data. Argument. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. Click the three dots toggle on the top right of the above text box, select Create Links. When you upgrade Platform Analytics, you must upgrade both the Platform Analytics Project and Platform. MicroStrategy Distribution Services,. The Properties and Formatting dialog box opens. Visual Insight dossiers are interactive displays that you can use to quickly and easily explore your business data. Select the Edit Links option. The option to Drill to Subcategory is available and works. exe -w C:filename. KB30101: How to Enable drilling for Report Services document in MicroStrategy Web. 1. CONTENTS OverviewandAdditionalResources vii Aboutthisbook viii 1. EN. For information on HTML documents, see the MicroStrategy Developer help. You will learn how to add and manipulate data, charts, graphs, images, and other elements to design interactive and informative documents. Micro Strategy also supports mobile BI. A MicroStrategy Report Services document contains datasets from one or more reports. x Report Services documents. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. When 'Save Options' appear, choose the first option, as shown. MicroStrategy Report Services Document Creation Guide プロジェクト デザイン ガイド: MicroStrategy Project Design Guide MicroStrategy 関数リファレンス: MicroStrategy Functions Reference MicroStrategy Mobile 分析ガイド: MicroStrategy Mobile Analysis Guide MicroStrategy Mobile デザインおよび管理 ガイド. : To allow users to use local transactions during offline mode, select Enable smart client in the Document Properties dialog. 2021 Update 7 (September 2022) MicroStrategy Workstation. . For example, the HTML container in the following document uses a URL to display the MicroStrategy Resource Center website. This guide is the primary resource for you to use to learn about designing and creating MicroStrategy Report Services documents using MicroStrategy Developer. Version 10. To create a Freeform SQL report. Go to Format > Color and Lines. Tutorial can be found in the Basic Reporting Guide. MicroStrategy Office is a comprehensive guide that covers how to use the MicroStrategy platform with Microsoft Office applications. 1 CONTENTS BookOverviewandAdditionalResources vi Aboutthisbook vii Resources viii Feedback xvi 1. We will use the data contained within the MicroStrategy Tutorial project that is provided out-of-the-box. Displays or hides the objects on your report. 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. x report. 1 and 10. Avoid Images on Thresholds. The comments written get saved when saving the report or document for which they are. xlsx as an example data set. 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. 2987. 1. To reproduce this issue in MicroStrategy Tutorial, follow these steps: Create a report with Employee, Manager, Year, Month, and Revenue. For example, these reports go from basic execution pointers, quarterly deals by item. This document provides the steps to accomplish the same. The Report Services Document Creation Guide provides instructions to design and create Report Services documents, building on information in the Basic Reporting. The image below shows just a small portion of an. Resources Documentation MicroStrategy provides both manuals and online help; these. 1 - MicroStrategy Product Manuals 2013-04-30 Advanced Reporting Guide for MicroStrategy 9. 3. to create a clustered production instance. Because Microsoft Excel spreadsheets and MicroStrategy Report Services documents often handle objects, formatting, and graph types in different ways, it can be necessary to adjust the way you design a document so that it is displayed correctly when exported to Excel. Type over the existing text or add new text. 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. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. src. Notice only half the metric displays without wrapping. The list of privileges and their descriptions can also be found in the MicroStrategy - System Administration Guide that comes with the product documentation. In MicroStrategy Developer, choose File > New > Report. In MicroStrategy Web, click Create at the top of any page, point to New Document, and select Blank Document. How to Create a Print Button for Flash View Mode within a Report Services Document using the. Displaying outline results. To not create messages for documents when they are. x. Document Creation Guide for MicroStrategy 9. Incorporated. Alternatively, 4. 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. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Default Content Alignment(Presentation Mode Only): This option allows the user to choose center or top left alignment for the content of a Report Services document when it is displayed in Presentation Mode. The Properties dialog box opens. Users must also have the Execute permission for any reports to be tested. Connection to databases, Excel files, and text files is described in Connect to Databases, Excel Files, and Text Files. In MicroStrategy Web, click Create at the top of any page, point to New Document, and select Blank Document. •. 3. Providing analysis and interactivity: Widgets; Editing documents in full screen; Formatting a document; Copying panel. Use this guide to learn about designing and creating MicroStrategy documents using MicroStrategy Developer. On the Freeform Sources tab, select Create Freeform SQL report. Report Services document • 2: Visual Insight dossier: IS_DRILL_IND. The HTML is retrieved dynamically when the document is executed. By creating your own dossiers : Platform Analytics also supports the creation of self-service content (dossiers, reports, and documents) which are based on the out-of-the-box schema and application. Cloudera CDH Hadoop Gateway System. For example, your system contains a set of standard weekly and monthly reports. The Properties and Formatting dialog box opens. Create a grid report in MicroStrategy Web 9. How to make grid in the exported PDF show within one page if the grid in a document is wide in MicroStrategy Ana… Number of Views 736. Datasets define which information the Intelligence Server should retrieve from the data warehouse or cache. This data is positioned and formatted, resulting in a single display of presentation quality. You can also select multiple reports at the same time to create a multi-layout document (see Creating a document from a report for instructions and Creating multi-layout. 5. 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). • MicroStrategy Dashboards and Widgets Creation Guide:. 2. Best practices: Designing documents for Excel. To print a MicroStrategy Web report: 1. 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,. Add the report created in step 1 to the panel in the document. To create only a message for the document, and not for the dataset reports, clear this check box. Limit the Use of Derived Attributes or Metrics. Save the document as D1. users in MicroStrategy Workstation and Library. Installation And Initial Setup. 4. 3 Document Analysis Guide for for MicroStrategy 9. 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. They include visual. It also includes predesigned sample reports. 11: 1. Likewise, footers generally contain page numbers or other similar information. -1: Cache Update: Limits the number of cache updates that a user can process at a time. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. What You Can Do in It. Version 9. Use the Blank Document template to create a traditional document. Open a document in the Document Editor. Get inspiration at the MicroStrategy data dashboard gallery. Below are instructions to achieve this in a Report Services Document. MicroStrategy Report Services Document Creation GuideA MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. See the Dashboards and Widgets Creation Guide for steps to create selectors. 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. Using the Derived Elements Editor: Using the Derived Elements Editor provides the full. The New Grid dialog box opens. MicroStrategy Report Services documents offer dynamic functionality and the flexibility to design documents with headers/footers, filters, and prompts. Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics and data integration. 3. Reporting Guide. The WebIServerSession represents a MicroStrategy Intelligence Server session. 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. For example, a scheduled report executes which shows the Revenue by day for the past week. 4. Go to”Grid”, uncheck “Enable incremental fetch in grid” and apply it. 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. Enterprise Manager comes with several Report Services documents that show one or more related reports in a dashboard-type display. 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. 6. From the Home menu, select Page Setup. To create a document from a report, it is assumed that the report is already created and saved. 5. In general, report creation in MicroStrategy is. reporting functionality can be found in the MicroStrategy Advanced Reporting Guide. -1: Email: Limits the number of reports or documents that a user can send to an email address at a time. Type a value in the field on the right, or click Select Metric to choose another metric to compare the original metric to. 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. Click any report you wish to execute. 4. `. In MicroStrategy Web, edit or execute a report. Creation Guide for MicroStrategy 9. Preview Feature: A new data. In the Source area, select a database instance for the database to access using Freeform SQL. Log in to the MicroStrategy Tutorial sample project. BOOKOVERVIEWAND ADDITIONALRESOURCES Thisguideistheprimaryresourceforyoutousetolearnaboutdesigningandcreating MicroStrategydashboards. Steps to create Report Services documents, add objects, and format the document and its objects. Dossiers. Select the 01 Blank Dashboard template. This document provides the steps to accomplish the same. . Define the sort to be performed by DATE in the Criteria column: Save and close the report. Preview Feature: The FreeForm SQL Report Editor allows you to write your own queries to create reports. Add metric "Yesterday" to the document section as dynamic text. To open documents in various modes. Additional performance tuning best practices for OLAP Services are provided in the System Administration Guide. 3 Document Number: 09521000 Version 10. 1 and above. The following steps explains how to enable Drilling from MicroStrategy Desktop. Create a dossier using the base report created in Step 1. 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. Data can be connected through an API, flat file, or database. To do this, you use the portable documents feature. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 2. 3. Once a Grid/Graph is in the document, you can display it in several ways: •. Users that have the "Edit Notes" privilege can edit notes as described below: Click Edit. Export to Excel. To Create a Report from Scratch. 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. For steps to create a Transaction Services report, see the Advanced Reporting Guide. Notice word wrap is maintained: Create document from this report. exe file. Examples of documents include scorecards and dossiers, managed metrics documents, production and operational documents, and more. Installation and Configuration Guide for MicroStrategy 9. 4. MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy. 9-10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1, Microstrategy Architect 8. Execute the grid, and change the results to display in Outline mode, as shown below: Save the report and exit to the folders. For information on MultiSource, see the Project Design Guide. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. CAUSE This is a limitation of Microsoft Excel. 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 . 4) Mark the Display hidden objects checkbox and click on OK:To access the Derived Elements Editor for a Grid/Graph in a Report Services document, expand the document section that contains the Grid/Graph. MicroStrategy Report Services Document Creation Guide. view Report Services Documents in the MicroStrategy Mobile client, and create Mobile document subscriptions in MicroStrategy Web:. Examples of documents include scorecards and dossiers, managed metrics documents, production and operational documents, and more. 3. Web the dashboards and widgets guide contains instructions for designing and creating microstrategy report services dashboards, a type of document that is optimized for. In addition, they can insert pictures and draw borders in the document. It is necessary to disable the report cache or add the following code to refresh the Report services document. If the document contains multiple layouts, click the tab of the layout whose printing options you want to modify. 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. Report Services Document Creation Guide: Creating Boardroom Quality Documents Version 10. Version 9. MICROSTRA microstrategy. 2048001 - executeRWDocument. x:In MicroStrategy Narrowcast Server 9. Set the selectors S1 and S2 to target the three grids at the same time. Answer: Go with dossier. On the opposite side, a Snowflake schema has a normalized data structure. The data from the report is used to populate the Grid/Graph. For example, headers generally contain titles or other general information that should be shared at the top of all pages of the document. 1, Microstrategy Intelligence Server 8. Additionally, those files (containing millions of rows) were being completely refreshed every hour. 4. Samples of each type of application object are located in the Public Objects folder in the Tutorial project. Create a Report Services Document 2. iOS users can also view multiple layers with. For information on Report Services, see the Document Creation Help. 4. In MicroStrategy Web, open the document in Design or Editable Mode. To benefit from the latest functionality available in this version of MicroStrategy Platform Analytics, an administrator must upgrade the MicroStrategy system, including Platform Analytics. Under General go to the server section. Chance the cover page to an image of your choosing. All Objects. These reports should be kept in cache because they are frequently accessed. About HTML documents. Right-click in an empty area on the right side of. ' In order to create an HTML document, choose a new 'HTML Document. It is used to format data from multiple reports in a single display of presentation quality. NOTE: Users must be granted 'Create Application Objects' and 'Use Template Editor' privileges. Open the document editor and add the above report as a dataset. Configuring Report Services Document Caching via MicroStrategy Desktop. MicroStrategy Freeform SQL reports, in which the SQL is entered directly into the interface. Browse and incorporate these templates into your own data dashboards. ; On the Freeform Sources tab, select Create Transaction report. To burst a file subscription across multiple files. ; Click OK. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. In the upper left part of the Get Info page, notice the following link: Change Cover Page. For steps, see the Basic Reporting Guide. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. Create a Report Services document using R1 as the dataset, drag the grid into the detail header, and execute the document in PDF view. 1m. 1, Microstrategy Web 8. The real-time information from the web or the formatted HTML is displayed within the HTML container, in the following modes in MicroStrategy Web: You can create HTML containers using either of the following methods: You can display a website by typing a URL in the HTML container. Locate and run the Setup. MicroStrategy Document Creation Help. You must have MicroStrategy Report Services to be able to design and work with Report Services documents. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. Creating and modifying Report Services documents. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 1 Handbook Excel Dashboards and Reports The Big Book of Dashboards OLAP Services Guide for MicroStrategy Analytics Enterprise Oracle BI Enterprise Edition Dashboard and Report Best Practices. For information on using the Freeform SQL Editor to report on third-party web services. Designing and creating documents: An overview. 2. Reports and documents are the objects that. In one case, the requirements were to connect to hundreds of parquet files stored in AWS S3 bucket secured with STS authentication. This section describes the ways in which you can design and create a MicroStrategy Report Services document. 3. In general, report creation in MicroStrategy is. In the Report Filter area, double-click the arrow to add a new qualification. x. These. The Report Services Document below has eight levels. For documents, links are functional in Interactive Mode and Editable Mode in MicroStrategy Web. The record types that can be created in MicroStrategy include which following: Scorecards and dashboards: constructed available visual impact, these documents provide a distilled view of the business, organize in adaptive sections. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. MicroStrategy Mobile overview. The New Grid dialog box opens. The user can click the link to email, export, or subscribe to the target. c. 5. Detailed information to create furthermore modify Report Related documents can be found in the Document Creation Help. In a document, you can display a report by adding a Grid/Graph to the document. 3) Click on Browsing. Steps. Right-click the header of the attribute whose elements you want to use to. The Database Administrator must ensure that the user account accessing the database has SELECT permissions for the table involved in the report. •. A Report Services document of this type is a visually intuitive display of data that summarizes key business indicators for a quick status check. Avoid Duplicated Datasets. 1 and 10. Toolbar Options. In Design Mode, a document designer adds widgets to a document and defines them. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. Workstation is the only space for analysts and app architects to build and manage content of all types. MicroStrategy Report Services: Documents and Dashboards MicroStrategy. Go to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. The following steps outline how to accomplish this: 1. Double-click the Grid/Graph to enter edit mode. Drilling on a Grid/Graph object in a document is similar to drilling on a report. Make sure to place the 'Quarter' attribute in the column. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. Informática e Internet · 2015In MicroStrategy Web, open the document in Design or Editable Mode. Add the prompted report to the document as a. Users now get a selector to draw a blank grid in the required sections of the document. In the Navigation pane, click Create a New Document next to Documents. • Use the All Objects panel when working with. A MicroStrategy Report Services document displays your organization's data in a high-quality, Pixel Perfect display. MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web. Performance Implications of Large and Complex Dossiers. Find MicroStrategy’s public API in Postman and make your own copy (Fork). 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. View changes and push updates to end users in seconds. Put the attributes Business line, Category in the grid along with the metric sales. MicroStrategy Office, MicroStrategy. • Manually enter adjustments in the report: The only user-entered fields in the PR26 CDBG-CV report are lines 10 and 11, for funds expended for low/mod housing inIn a 8. Make two grids with different attributes and metrics in each 3. x, with the Intelligence Server running on Linux, the image in the. 3. Click the Apply check mark to create the new threshold or conditional format. MicroStrategy Report Services Document Creation Guide . 3. This is from all MicroStrategy Business Intelligence clients platform. It builds on the basic concepts about documents presented in the Document Creation Guide. 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. A Grid/Graph can be directly associated with one dataset report. The object's editor or wizard opens. vi © 2016 MicroStrategy, Inc. Click Shared Reports. STEPS TO REPRODUCE: Create a report services document. x. After placing data fields into any section, click Save. 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. Web the dashboards and widgets guide provides instructions for designing and creating microstrategy report services dashboards, a type of document that is optimized for. • The following steps explains how to enable Drilling from MicroStrategy Desktop. ; 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. Toolbars are mostly divided by workflow—the Insert toolbar, for example, lists the different. 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. This article describes how to create a link to execute a report with answers to an attribute element list prompt using URL API in MicroStrategy Web 9. . MicroStrategy Report Services, the enterprise reporting engine of the MicroStrategy BI platform, enables the creation and viewing of pixel perfect, highly formatted documents, scorecards, and dynamic dashboards. In MicroStrategy Web, open the document in Design or Editable Mode. Details to design a document or dashboard are in the Report Services Document Creation Guide. Out-of-the-box S3 connector was unable to fulfill those requirements (file type, authentication method, merging. Excel does not allow outline levels great than 8. In order to export a document in excel format using the URL API, the executionMode must be set to 4. Sophisticated Cubes could be bases on MicroStrategy data or imported data. For an overview and steps to add a dataset to a document, see the Document Creation Guide. 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. ImpalaWeb advanced reporting guide for microstrategy 10 dashboards and widgets creation guide for microstrategy 9 3. Dashboards and Widgets Creation Guide for MicroStrategy 9. Create a report (report B) with Prompt #1, and place Customer on the template. You must will MicroStrategy Report Services to be able to devise and work include Report Services documents. 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: •. There are various applications of MicroStrategy. Exit all Windows applications before beginning the installation process. To add a text field to a document. (To follow the examples in this guide, click MicroStrategy Tutorial . The undo stack is managed by the client's browser and will reset itself when the MicroStrategy Web 9. 1m Creating. In MicroStrategy 9. This section describes the ways in which you can design and create a MicroStrategy Report Services document. 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. For information on connecting to databases, see Connect to Databases. The document is displayed in Presentation Mode by default. Report Services Document Creation Guide: Creating Boardroom Quality Documents. Drag the dataset to grid into document. 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. 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. To create a new layout using a Report Services (RS) dashboard template, click the Dashboard Layouts tab,. . In addition, they can insert pictures and draw borders in the document. Detailed examples of advanced reporting functionality can be found in the Advanced Reporting Guide. 0. Click on Browsing Options and `Display hidden objects. 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. MicroStrategy Product Manuals.