MicroStrategy Library is an interactive application of the MicroStrategy Business Intelligence platform that lets business users harness the analytical power of MicroStrategy in a simple, clean and modern user interface. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. Details for MicroStrategy Web and Web Universal follow: MicroStrategy Web (ASP. The ability to view or edit certain settings is determined by a user's. To view a custom HTML5 visualization in a document on an Android phone: Copy the visualization plug-in to the plugins folder in the MicroStrategy Web. 2. The Export to Excel dialog box opens. In the folder list, right click on the report > Share > Show HTML. Import the document into the replacement project. For detailed steps, see the Document Creation Help. Dashboards in MicroStrategy Web. A line appears in the Layout area to divide the sections. 0. There is a lot of excitement around this update as it will include highly anticipated features like Information Windows and the ability to create and edit dossiers right from MicroStrategy Library and the MicroStrategy App. Includes scorecards. x. 215 Embedding Analytics with MicroStrategy REST API 2022. The following figure displays the SQL. The Document Editor has multiple toolbars you can use to access different document features. Go to Properties and Formatting > Layout, change the width and height so the container is larger than the HTML body, including margin. For general tuning of Snowflake, please take advantage of the Snowflake Tuning page. In MicroStrategy Web 9. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. 421 Advanced Mobile Applications 2022. Note: Users cannot schedule reports with prompts unless the report has default answers. Select the Subscription Properties (seen. In the Document Properties -> Document section, uncheck all available. If the document contains multiple layouts, select one of the following: To print the entire document, select All layouts. There are multiple ways to intervene the database to generate a better SQL execution plan. Select the prompt to modify and click the up or down arrows to change its order. pkg. 013 Developer (DVL) 2 2022. Refresh the page, check Medium ’s site status, or find something interesting to read. Selecting the display theme for a document . Click the document name or icon. To apply gradient colors, which blend two colors to create a gradual color change in the background, see Steps to apply gradient colors. In MicroStrategy Web, open the document in Design or Editable Mode. 2. In MicroStrategy 11. Drilling on a Grid/Graph object in a document is similar to drilling on a report. For steps, see the Basic Reporting Guide. In the Threshold Editor, select the threshold to copy, and click Copy in the toolbar. To Enable Outline Mode on a Report. Create a Report Services Document in MicroStrategy Tutorial 2. 2 : Do one of the following, depending on which type of control that you want to use in the document: • To link a Grid/Graph to the Transaction Services report, right-click the Grid/Graph, then select Configure Transaction. A URL which defines the object's location in MicroStrategy Web. ( How?) On the Insert menu, point to Selector, then choose the selector style. Selectors provide dossier-style documents with interactivity, allowing each user to change how they see the data. This is how the behavior is set and displayed from within MicroStrategy Developer 9. 1 and select the new template Navigation Bar for iPad as shown below: Notice that this document only allows Design and Editable mode in the toolbar, like shown below. Place Intelligence Server close to the both the data warehouse and the metadata repository. For example, each member of a team of document designers creates complex documents for his own department, such as human resources or finance. Ex. When you add a new text field, its formatting is determined by the control defaults. Documents Documents allow you to select the color theme, fonts, and the colors of the document's objects. 4. Click the numbered buttons above the report to expand or collapse data for the page. 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. Formatting text fields. 411 Project. 4. Specifically, this guide provides the following information:Expand the document section where you want the image by clicking the plus sign next to the section name. Gather information about your user audience. In MicroStrategy Web 2019, reducing the size of your browser while viewing a dossier in presentation mode causes the information to be truncated. If the document is open in Presentation Mode, click the menu icon on. 3. mstrc. 3. To sort the data in descending order, click Sort. Place Intelligence Server close to the both the data warehouse and the metadata repository. The Bulk Export Setup dialog box is displayed. Click the location in the layout area to add the selector to. In documents, links can be added to objects in a Grid/Graph, and they can link to another document or to a report. Dynamic Custom Group in Dashboards or Dossiers. The text field for new notes opens. Enable quick switch between graph view and grid view. Type over the existing text or add new text. From the Data menu, select Configure Bulk Export. Select the Dropdown Icon () on the right-hand side of the title bar. Many times, a MicroStrategy Web environment that is running poorly can see an improvement in performance from. The Document and Dashboard Analysis Guide describes the steps for a business analyst to execute and analyze a document in MicroStrategy Web and MicroStrategy Developer. 2. Selecting the display theme for a document . For information on connecting to databases, see Connect to Databases. To do this, select either the bar containing the section's name, or click inside the section in a blank area (not on a control). Functions —These are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-defined calculations. The document opens in Design View in the Document Editor. Dynamic Custom Group in Dashboards or Dossiers. Follow the steps below to split a dataset displayed as a grid in a Report Services Document:Create a Report Services document using R1 as the dataset, drag the grid into the detail header, and execute the document in PDF view. Select the Copilot icon in the left margin of your. From the left, select General. However, dynamic tooltips added to grids and graphs are displayed as static text after executing the document in Web. Use the document-level behavior: The document-level behavior is set in the Mobile category of the Document Properties dialog. Tell a story with your data using the dossier chapter/page format. The default MicroStrategy 2020 settings are optimal for SAP HANA 2. A text field to type new notes. Go to the "Preferences > Project Defaults > Folder Browsing" section and check the 'Hide 'My Reports' link when user does not have web save. Also, see the documentation for your particular Web application server for additional tuning information. This is shown in the following MicroStrategy Developer image in which two Month controls, in different document sections, are aligned. Inside 'Panel1', add a grid by clicking Insert 'Grid. It also. Save the report in MicroStrategy Web 10. To edit a document in Design Mode, from a folder, right-click the document and select Edit. This document demonstrates how to change the type of the date to a desired format such as 20080121 and use it as the filename. Right click and select New and then Schedule. Select File > Document Properties. ' Both R1 and D1 are listed as dependents as shown below:A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Click within the Dataset Objects area to add datasets for the document. KB442449: Dossier Performance: Connect Live performance considerations. The object uses a black Tahoma font and the Forecolor option is the color of the font. Saving the dashboard in MicroStrategy Developer converts it to a document; it cannot be converted back to a dashboard. At this stage, all metrics are available in both S1 and S2, but the order is different. When you execute and view a report in MicroStrategy Web, the interface allows you to manipulate and explore the report data you are viewing. To apply gradient colors, which blend two colors to create a gradual color change in the background, see Steps to apply gradient colors. For details, see the MicroStrategy Tech Notes TN11275 and. To unsubscribe a report or document, select the checkbox in the Unsubscribe column and then click Unsubscribe. To Export a Report or Document from the History List. ). For more information on dossier design, see Dossier Authoring Best Practices from a MicroStrategy Expert. 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, unified Web interface. Selecting a display theme for an objectThis "How to" technical note describes a way to hide the metrics columns from a document grid in MicroStrategy 10. In the Office Add-ins dialog, click Upload My Add-in. The add-in introduces the ability to import and refresh reports and. Creating documents You can create a document in one of several ways, depending on your needs: • On your own from start to finish using Design Mode or Editable Mode, which allow you to select the information to be included and the formatting of the document (see Creating a document from scratch ). The key features of MicroStrategy platform are –. VLDB settings 4. When these reports are used in a Report Services document, the same 'Metrics' column is displayed, as shown below:As an Analyst, you are passionate about using data to help drive informed business decisions within your organization. MicroStrategy Desktop 8. Follow below steps. Here, you can select the way that you want to export grid reports, graph reports, and HTML documents. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode 1. 3. ACTION: The DHTML Heat Map widget can be configured as below: In a document, insert a grid with one attribute and 2 metrics. ( you can set 5 Lk for 8. Therefore, prompts allow report designers to create reports that let users change the report content at run. To manage your subscriptions in MicroStrategy Web. This document provides best practices on maintaining the MicroStrategy metadata health by controlling the size of the Change Journaling Tables and cleaning up. Note: More elaborate programs will require additional library files and are out of the scope of this document. 413 Advanced Documents: Interactivity and Joining Datasets 2022. The Excel File will contain only the selected Grid Object data from the Document. In Design Mode, a document designer adds widgets to a document and defines them. About prompts. In the Source area, select a database instance for the database to access using Freeform SQL. The setting to enable or disable "Total" in a page-by is located in the "Advanced Subtotals Options" dialog box. To analyze the cache hit ratios for prompted jobs, select Prompted jobs at the prompt. From the Insert menu, select Text. To select multiple objects, press and hold CTRL while clicking the objects. MicroStrategy Report Services documents offer dynamic functionality and the flexibility to design documents with headers/footers, filters, and prompts. It is possible to pass a specific attribute element to a new prompt from one document to another document using URL API in MicroStrategy Web in MicroStrategy 9. The document opens in PDF View, in Acrobat Reader. The test is for a single cube (4M rows) republish executed on the MicroStrategy 2021 Update 2 release with platform as 32 CPU, 244 GB memory Amazon Linux machine. Click Show Advanced Options. Once the prompts are in the correct order (for the example, the order is Region and Call Center), click OK to return to the Document Editor. P83. From the drop-down list of all the Grid/Graphs on the document, select the Grid/Graph to apply the view filter to. These icons provide different ways for you to view, interact, and share your document. You can access document features such as inserting a Grid/Graph or formatting a text field using the toolbar options in the Document Editor. 2. wherer as report filter is applied in the calculation itself i. As we know, the two key factors which decide the success of BI application software implementation are. Advanced Metrics, explains level metrics, conditional metrics, transformation. KB426596: In MicroStrategy Web 10. Save the document as D1. In MicroStrategy Web, open the document in Design Mode. 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. The amount of data retrieved and objects being used in a Report Services Dashboard have a direct impact in the size of the final Dashboard. This checkbox is cleared by default. A 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. Chance the cover page to an image of your choosing. These MicroStrategy Web features are discussed briefly in the topics listed. Expand the document section where you want the image by clicking the plus sign next to the section name. Below tuning suggestion is based on IBM Document on Performance Tuning. In MicroStrategy Developer, choose File > New > Report. 3. The default engine version of MicroStrategy 2021 is AE13. Learn how to create, edit, and share reports, dashboards, and documents using Excel, PowerPoint, Word, and Outlook. For detailed information on tuning your MicroStrategy environment, see the Tuning your System for Best Performance chapter in the System Administration Help. However, these settings depend on the type of SQL being sent to the warehouse, database load, and dataset size. Use developer tools to view the HTML so that you can find the element ID for the group-by element. Right-click the section and select Properties and Formatting. To display it as both a grid and graph simultaneously, in the Property List: Appearance section, select Grid and Graph from the View mode drop-down list. If you arrived here from Workstation, click here for help. Document Editor:. MicroStrategy out-of-box provides two display themes: The Light theme and The Dark theme. Select the theme and click OK. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. The chapter is focused on creating new documents, so it includes procedures and best practices to create and design documents. The sections below also. ACTION:The ‘Export to Excel’ option is disabled by default in converted documents. For details, see the MicroStrategy Tech Notes TN11275 and. 2) Choose the End Date and set a qualification as End Date less than Start Date as seen below: 3) Double click on the threshold and check Replace Data, type a replace text like “Invalid Date”. 10, 10. The Document Editor has multiple toolbars you can use to access different document features. You can modify certain settings in the MicroStrategy Web server machine or application for best performance. 0 (for specific system requirements, refer to the Readme. . For example, you may want to see all the customers in a retail store that bring in over $1,000k in revenue per month, or a teach may want to only view data on students who scored over 2000 on their SATs. • Determine the optimal time to run scheduled jobs, load data, or perform system and database maintenance. The use of slowly-changing dimensions is described in the following MicroStrategy Knowledge Base document: KB5200-800-0479 - How to implement slowly-changing dimensions using. 4. 3. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. x ODBC calls by default. MicroStrategy use TLS v1. When you delete a layout, it is removed from the document. Data (attributes, consolidations, custom groups, and metrics) from the document's datasets. Place intelligence server close to the both the data warehouse and the metadata repository. When you move the cursor to the Layout area, the pointer becomes crosshairs. x, Control Documents provide a way to personalize the name of files generated by services. Here is what the report looks like in Developer : When exported to Excel the results are as follows:Go to Tools -> Report Options (Document Options in the case of a document/dashboard) Navigate to the Delivery tab, where the following 3 options exist: Select “Only allow specific users to subscribe to this report”. The goal is to get the below Grid result in a Report Services Document:It is very common to have two Report Services Documents linked to each other using a URL API call. To Create the Item Order Form Document. Excel: This allows the user to export the document to Microsoft Excel in . This should be set to 'True' by default as shown in the image below:Dialog that is displayed when a user selects About from the MicroStrategy Office Help menu: client_name: The name of the client application (replaces MicroStrategy Office) server_name: The name of the server application (replaces MicroStrategy Web Services) web_link_url: Target URL of the Web link in the Help menu: web_link_textThis tab is accessed by selecting Options from the Grid menu when a report is displayed as a grid. This icon becomes visible when you point to the name of the report or document. Controls are shown in the document's Layout area as you design the document. In the Source area, select a database instance for the database to access using Freeform SQL. From the Home menu, select Export. To find the value for this parameter, do the following: In MicroStrategy Web, open the document in Design mode. 215 Embedding Analytics with MicroStrategy REST API 2022. If users want to be able to create their own filters, thresholds, or change the graph style used to display data. The Grouping Properties dialog box for that grouping field opens. For steps, see Starting MicroStrategy Desktop. In MicroStrategy Web, open the document in Design Mode or Editable Mode. The PDF that results from this selection is called a page of the original document. It’s the collision of two worlds: technology and magic. 1. Gather information about your MicroStrategy project. 2. Click the link for the desired manual or other documentation source. 2. In this case, change both to 116px (with 8px default left/right/top/bottom margins. To add a text field to a document. When you move the cursor to the Layout area, the pointer becomes crosshairs. Do one of the following: For a report, click the name of the report to run it. CAUSE: One of the possible causes is because "Use Dynamic HTML?" is set to NO. For formatting ideas, see Formatting suggestions. We decided to gather them in one placing using our experience and MicroStrategy materials. 4. For a document, edit the document in Design Mode or Editable Mode. Place Intelligence Server close to the both the data warehouse and the metadata repository. This article highlights the performance optimization in MicroStrategy 2020 that reduces the initial loading time of. Custom groups enable users to view specific elements based on a metric or specification. To email a report or document on a schedule. Drag and drop the reports into the Dataset Objects panel of the Document Editor. See To copy a document between projects for a detailed procedure. Select Add Subscription for the type of subscription you want. Use the document-level behavior: The document-level behavior is set in the Mobile category of the Document Properties dialog. Go to MicroStrategy Web, right click on the HTML container. Dedicate a machine for the metadata repository. Open a document in the Document Editor. Add the report created in step 2 as dataset report of the document which is required to display yesterday's date. To do this, click in a blank area in the section. The user will now be. Administrators are encouraged to consult the following Microsoft. Export the document from the original project. To print a document. 0. The Properties dialog box opens. xls format. ADDITIONAL INFORMATION: The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate. Always consider to collect database statistics as the query execution plan is generated based on that. 1. Disable Highlight in Presentation Mode. Report Services Documents in 10. Therefore, prompts allow report designers to create reports that let users change the report content at run. Connecting in two-tier mode invokes a direct connection from MicroStrategy Desktop to the metadata. Excel with plain text: Export the report to Microsoft Excel as plain text. You can use MicroStrategy Web to create a Grid/Graph that contains. A control can be any of the following: •. Insert a new grid which contains the attribute and all metrics from M1 and M2 groups. To create a static label, type text: a. Select Export from Home menu, and then click PDF. When you move the cursor to the Layout area, the pointer becomes crosshairs. In the. Starting in MicroStrategy 2021 Update 8, Applications Architects can define any dossier as a template. x, as shown below. This additional layer of abstraction provides flexibility for the MicroStrategy Architect, who can tune the MicroStrategy model by making changes to the views rather than physical changes to the underlying tables. Additional performance tuning best practices for OLAP Services are provided in the System Administration Help. To export a report while viewing it, click the name of a grid report to display it. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. Auto alerts. The owner usually defines the permissions for how the object can be used and by whom. 0: Schedule administrative tasks to be performed on all nodes of the cluster. Right-click an underlined object on the grid, point to Drill, then select the destination object. Select Image from the Insert menu, or click the Image icon in the toolbar. In the Page-By mode drop-down list, select one of the following:Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Search for users or add users by clicking on the add icon. Dashboard-style Documents. The Insert Function dialog box opens. Download the zip. ACTION To enable ‘Export to Excel’ option, navigate to Tools à Document Properties à Document and enable Excel export format under Run Modes section:The document contains a text field (listed as Region) and image (listed as CompanyLogo), as well as two graphs, named Sales By Region and Commute. To print all of the pages in. The Properties dialog box opens. Create and save the prompt. To Create a Subscription in MicroStrategy Web. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. When you export a report, you move a copy of the report into. Gather information about your data source. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. 3. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. The Export Reports preferences page allows you to specify exporting preferences. To edit a document in Design Mode, from a folder, right-click the document and select Edit. In MicroStrategy Developer, double-click the document name or icon. From the drop-down list of all the Grid/Graphs on the document, select the Grid/Graph to apply the view filter to. In MicroStrategy Web, you can also interact with documents, schedule them, and send them to specified email addresses. Navigate to the folder to save the file in, then click OK. ( How?) Select the control and do one of the following: Size the control on the Layout area: Select the control, and drag any of its red sizing handles to its new size. Save the image in the images folder where the. In MicroStrategy Web, open the document in Design or Editable Mode. Visit the data visualization and data dashboard galleries for inspiration. Stay tuned for our next set of releases, especially MicroStrategy 2021 Update 4 scheduled for the end of the year. For instructions, see Selecting available export formats. 1. In the Run Modes area, select the format (s) in which the document can be exported: •. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. ; Type a name for the subscription in the Name field. 9 and 10. Report Services documents utilize MicroStrategy objects to run complex and sophisticated reports. For tuning details, see the appropriate section in the Installation and Configuration Guide. The ED’s allegations say that the Bengaluru-headquartered startup has violated rules under the Foreign Exchange Management Act (FEMA), to the tune of. This bypasses the Intelligence Server, which manages and processes Report Services documents. Interact with the data in real time (with targeting, filtering, and more). The following clarifies these two possible meanings and their respective contexts:. To view a document in your content library, click on any of the object tiles that have a Document icon. In this grid, pull Customer attribute to the rows and Profit metric to the column as shown below:Mobile - To send the report or document execution to the mobile device. view Report Services Documents in the MicroStrategy Mobile client, and create Mobile document subscriptions in MicroStrategy Web: MOBILEVIEWDOCUMENT:. Build faster,more secure, more resilient applications and develop them quicker than ever. In MicroStrategy Web, log in to the Tutorial project. 2. On the Freeform Sources tab, select Create Freeform SQL report. In MicroStrategy Web, you can also interact with documents, schedule them, and send them to specified email addresses. MicroStrategy Mobile on an Android Phone. The second document, Ex. 2. Toolbar Options. x The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. Documents in MicroStrategy Web have the same functionality as documents in MicroStrategy Developer, such as viewing, printing, and exporting. Flip through the panels in a panel stack. Many times, a MicroStrategy Web environment that is running poorly can see an improvement in. The Properties and Formatting dialog box opens. A dataset is a MicroStrategy report that is used on a document. 1. Using the exact name of the font, enter a name for the new shortcut prefixed with " pkr ". view filter are local to the report and report filter can be used for other reports as well. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. A broad selection of data visualizations (called widgets) and a wide variety of formatting options, including graph styles, shapes, document headers and footers, and watermarks, allows you to customize and fine-tune the. The modules can be mapped to a different warehouse, used as starter kits to develop custom applications or used as a source of reporting ideas for designing effective grid reports, graph reports, documents, and dashboards. In MicroStrategy Web 10. For documents, links are functional in Interactive Mode and Editable Mode in MicroStrategy Web. browse button. Flip. Enter the offset of the drop shadow, in points, in. Right click on the dataset report in document design mode. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. rst, is saved in the selected folder. Event Based Schedules Event based schedules run reports and tasks when the event associated with them is triggered. Build faster,more secure, more resilient applications and develop them quicker than ever. On the My Subscriptions page, under the Email section, click Add email subscription. In the image below, the Customer State 'Connecticut' was generated using a dynamic-text field: {[Customer State]}Launch the Web Customization Editor. JSON length allowed in the POST request of exporting in the. Steps to format borders. The formatting of the new section is. The editable mode is a fantastic resource for fine-tuning the layout of a document. The document, named document_name. Minimum MicroStrategy version: 10. We empower you with the skills to get the most out of your analytics investment. Related versions: 10. If the document is open in Presentation Mode, click the menu icon on. 9. Click Certify. x. •. Interacting with a Document: Selectors. Steps to Reproduce. For each form listed, select or clear the corresponding checkbox in the Show on Grid column. NET) The most significant things you can do: Tune Microsoft's Internet Information Services (IIS). One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. Toolbar Options. Documents have a series of icons at the top of the page. In MicroStrategy Web, open the document in Design or Editable Mode. . Show Title Bar: Determines whether the title bar of the selector is displayed when a user views the document. After the layout is removed, the dataset that the layout used remains in the Dataset Objects pane for the multi-layout document. The New Grid dialog box opens.