Right-click an underlined object on the grid, point to Drill, then select the destination object. In the Document Properties -> Document section, uncheck all available. 1. As such, it is subject to any recommendations issued by Microsoft. 0. Result caches: Report and document results that have already been calculated and processed, that are stored on the Intelligence Server machine so they can be retrieved more quickly than re-executing the request against the data warehouse. Another method to format all controls of the same type in a single way, or to format all documents in a single way, is to use an Autostyle, which is a saved set of formatting that can be applied to all controls of a given type or to a set of documents so that they all have the same look and feel. Details for MicroStrategy Web and Web Universal follow: MicroStrategy Web (ASP. Stay tuned for our next set of releases, especially MicroStrategy 2021 Update 4 scheduled for the end of the year. " Why is this happening? The Export Engine has a setting that limits the maximum server . A selector can change panels, the focus of a grid or graph report, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack, as described below. Apologies, but something went wrong on our end. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. 2. jpg. For documents, links are functional in Interactive Mode and Editable Mode in MicroStrategy Web. The HTML tags do not apply to the text until the document is displayed in MicroStrategy Web. x, grid and graph displays are cut off on the right side. In this example, you execute a document called "Casino Analysis" (located in MicroStrategy Tutorial>Shared Reports>MicroStrategy Platform Capabilities>MicroStrategy Report Services>Visual Insight). When you move the cursor to the Layout area, the pointer becomes crosshairs. Follow below steps to apply the. Steps to format borders. In the initial release of the MicroStrategy app, users can change the look of the app by switching to the Dark Theme under Preferences. You can modify certain settings in the MicroStrategy Web server machine or application for best performance. 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. Enterprise Manager comes with several Report Services documents that show one or more related reports in a dashboard-type display. Modifying the look of icons, reports, and folders. To export a document template. The user can see that there is plenty of white space to the right, but the grid or graph does not extend past. On the Freeform Sources tab, select Create Freeform SQL report. This document provides best practices on maintaining the MicroStrategy metadata health by controlling the size of the Change Journaling Tables and cleaning up. 5. Click Field to open a drop-down menu of the attributes and metrics on the Grid. From the Home menu, point to Export. 0 (for specific system requirements, refer to the Readme. 3. Click Field to open a drop-down menu of the attributes and metrics on the Grid. . The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Enterprise Manager and to address issues encountered during the statistics logging and. ( you can set 5 Lk for 8. Network configuration best practices. "" -n "" -u -p -f. These can be used to enhance a grid’s ability to convey richer meaning To access documentation resources on Windows. MicroStrategy Administration •With system Manager – Combine multiple processes for MSTR environment into single work flow that can be deployed at a scheduled time or on Demand. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. This document describes how to show a grid in a Report Services Document in several columns in MicroStrategy 9. x and 10. To get all of these features and security updates, you can download the latest release from the MicroStrategy Resource Center to on-prem deployments, or access MicroStrategy on AWS or Azure via the MicroStrategy Cloud Console. 2. The dialog box for Options for PDFs opens. You use the authorization token returned in step 1 as the value for X-MSTR-AuthToken and provide the project ID. Documents Documents allow you to select the color theme, fonts, and the colors of the document's objects. The dataset appears in bold text. In the Layout area, right-click in the section above or below where you want to add the new section, and then select either Insert Section Above or Insert Section Below. 2. In the Grouping panel, right-click the grouping field on which to enable page-by. There are multiple ways to intervene the database to generate a better SQL execution plan. The URL API call is normally used to pass the prompt answers from the first report to the second Report Services Document. 0, and right click the document, you will notice that the Edit option is greyed out as seen below:. The second line is displayed in a blue Courier font by the HTML tags. The Grouping Properties dialog box for that grouping field opens. Note: You can also set-up Cover Pages by using APIs. This can give you insight into tuning advanced report-related project settings. Refer to the following MicroStrategy Knowledge Base document for more information: KB30866: New feature in MicroStrategy Intelligence Server 9. The first document was technical document entitled "Narrowcast Server 7. The following figure displays the SQL. In MicroStrategy Web, open the document in Design or Editable Mode. Drill to other destination objects. For a list of auto text codes, see Displaying document and dataset information: Auto text codes. To view a document in your content library, click on any of the object tiles that have a Document icon. Right-click the selector to update, and select . Drill on an item in a graph. Note that the benefit of tuning this aspect of the system may not result in significant decreases in file descriptors, and may result in other performance penalties, as cache files are only accessed when the cache is actively being loaded,. For more information, click Help in MicroStrategy Web. Select Grouping Properties. KB440273. When you move the cursor to the Layout area, the pointer becomes crosshairs. xls format. If the Edit icon is displayed in the upper left corner of the Grid/Graph, you can click the icon to enter edit mode. •Command Manager - Performs various administrative and application development tasks by using text commands that can be save as script. MicroStrategy Optimization: VLDB Settings. 10. Open MicroStrategy Workstation or MicroStrategy Web. It builds on basic concepts about reporting functionality presented in the Basic Reporting Guide. Navigate to & expand System Pickers, then select fontPicker. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. In MicroStrategy 2019, exporting a dossier with a large amount of content to a PDF may result in the following error: "Dossier content size exceeds the PDF Export Engine limit. x. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. On the My Subscriptions page, under the Email section, click Add email subscription. In the PDF Options dialog box determine the report scaling and orientation, and press Export. The data loading process gathers and prepares data for analysis and reporting in the Enterprise Manager project. To sort data, hover over a row or column, click the pop-up menu icon , and select one of the following: To sort the data in ascending order, click Sort ascending. Execute the grid, and change the results to display in Outline mode, as shown below: Save the report and exit to the folders. You can modify the document's appearance before printing to ensure that the end result (the printed document) appears as desired. X . If the Export to Excel icon is unavailable, you must select Excel as an export format. The MicroStrategy Intelligence Server backs up all cache files to disk and must use file descriptors to access them. 411 Project. Add metric "Yesterday" to the document section as dynamic text. Navigate to the folder to save the file in, then click OK. MicroStrategy Office is a comprehensive guide that covers how to use the MicroStrategy platform with Microsoft Office applications. It’s the collision of two worlds: technology and magic. In this case, change both to 116px (with 8px default left/right/top/bottom margins. 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. A cache will be created on MicroStrategy Intelligence Server for each individual dataset report(s) in the Report Services document. To enhance PDF viewing performance, open Acrobat Reader before opening the document. To enable totals or subtotals for a metric. Click in the desired section of the Layout area. Add the two reports Report Item Orders and Revenue and. Notice surprising patterns with visualizations. The steps below show you how to create a custom group in MicroStrategy Web. This article highlights the performance optimization in MicroStrategy 2020 that reduces the initial loading time of. Do one of the following: For a report, click the name of the report to run it. P82, was marked "FOR INTERNAL USE ONLY. When you add a new text field, its formatting is determined by the control defaults. The chapter is focused on creating new documents, so it includes procedures and best practices to create and design documents. The Properties and Formatting dialog box opens. From the Tools menu, select ExportDocument Template. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. When 'Save Options' appear, choose the first option, as shown below: Right click on P1 and select 'Search for Dependants. To export the report to Microsoft Excel as plain text, select Excel with plain text. The owner usually defines the permissions for how the object can be used and by whom. 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 ). After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. 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). When you specify an image by supplying the source. link MicroStrategy users and groups to users and groups from sources such as Windows NT, LDAP, or a database: LINKTOEXTERNALACCOUNT:To send a report or document to a network folder on a schedule. Dashboard-style Documents. The document has one layout and no grouping. To edit a document in Design Mode, from a folder, right-click the document and select Edit. Change the data of the report and re-execute it. To find the value for this parameter, do the following: In MicroStrategy Web, open the document in Design mode. JSON length allowed in the POST request of exporting in the. In the. ACTION: The DHTML Heat Map widget can be configured as below: In a document, insert a grid with one attribute and 2 metrics. Drilling allows users to look at specific data at levels other than that of the originally displayed Grid/Graph. To edit a document in Design Mode, from a folder, right-click the document and select Edit. Click the link for the desired manual or other documentation source. 215 Embedding Analytics with MicroStrategy REST API 2022. Many times, a MicroStrategy Web environment that is running poorly can see an improvement in. ) Obtain the Gotham Medium font file (in . • Determine the optimal time to run scheduled jobs, load data, or perform system and database maintenance. A multi-layout document contains multiple documents, each in its own layout, creating a "book" of documents. You can also apply a set of color and shading schemes to all the objects on a graph report. x, Control Documents provide a way to personalize the name of files generated by services. Document Editor:. The Configure Transactions Editor opens. Click Show Advanced Options. Adding Text and Data to Documents. Click on a dossier. 3. 1. Double-click any of the documents listed on the right-hand side of Desktop, to execute it and see the results. To add a text field to a document. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. Use the document-level behavior: The document-level behavior is set in the Mobile category of the Document Properties dialog. M icroStrategy Features. You can modify export options in the User Preferences page. 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. You can use the visualization to: Filter the map markers shown in the visualization by selecting map markers for which to display data. Use developer tools to view the HTML so that you can find the element ID for the group-by element. Formatting text fields. 2. Place Intelligence Server close to the both the data warehouse and the metadata repository. Right-click the section and select Properties and Formatting. Open the document to print. The recommended VLDB optimizations for Oracle 11g are listed below. If the document is open in Presentation Mode, click the menu icon on the right, and select Edit. Select or multi-select users as recipients of the dossier. What could be better? The event will be held May 1–4 in Orlando, Florida — and we couldn’t be more excited. The governing limit for the Platform Analytics cube is 20 GB out-of-the-box. Details: With the Data Import functionality, MicroStrategy imports data from Snowflake into our fast in. Select the prompt to modify and click the up or down arrows to change its order. Add a text field using one of the following methods depending on your goal for the text field: •. The Properties and Formatting dialog box opens. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. To email a report or document on a schedule. For descriptions of the various options, see How to Email a Report or Document. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. 5. We're. 0. Download the zip. Toolbars are mostly divided by workflow—the Insert toolbar, for example, lists the different. Click on "Properties and. When user selects nothing, both text box will be hidden so nothing displayed. xls format. MicroStrategy users can directly query your PostgreSQL database using our data import component. x. Build faster,more secure, more resilient applications and develop them quicker than ever. 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. The schedule wizard will be displayed as shown below. 1. Consequently, the size of the JVM's heap can affect the MicroStrategy Web deployment. This document was created by thorough research and customer site visits to understand different customers’ use cases of Snowflake with MicroStrategy. Documents can appear in almost as many ways as you can imagine and are generally formatted to suit your business needs, in a single display of presentation quality. In MicroStrategy Developer, double-click the document name or icon. The ODBC connection uses 3. Click on Dossiers in the left panel of Workstation. 4. To find out if you are hitting any of the scenarios listed below, take advantage of MicroStrategy Integrity Manager and the Upgrade Analysis Dossier. 0: Schedule administrative tasks to be performed on all nodes of the cluster. Then to provide the prompt answer in the metric alias, use the following syntax. Forecast Sales. Mac. In this Example we will use the MicroStrategy Tutorial Project using a Time Dimension Attribute going across along with the metrics where any other non-Time dimension attribute going vertically, without repeating Attribute values. When you move the cursor to the Layout area, the pointer becomes crosshairs. If the document contains multiple layouts, select one of the following: To print the entire document, select All layouts. In MicroStrategy Developer, choose File > New > Report. Viewing the SQL provides a good way to troubleshoot and fine-tune the selection of data that is retrieved from your data source and displayed in reports. Refer to the following MicroStrategy Knowledge Base document for more information: KB30866: New feature in MicroStrategy Intelligence Server 9. Each layout will start on a new page. Add the. Click the name of the document to run it. Document Editor. x, if a report is in outline mode with totals enabled, when exported to Excel with the report collapsed to the lowest level, the exported version expands to show everything. Excel: This allows the user to export the document to Microsoft Excel in . Drilling on a Grid/Graph object in a document is similar to drilling on a report. You can now see Dossiers and Documents in Dark Mode. To analyze the cache hit ratios for prompted jobs, select Prompted jobs at the prompt. In MicroStrategy Web, open the document in Design Mode. 3. Therefore, prompts allow report designers to create reports that let users change the report content at run. 0 Tuning Guidelines" to Papp. To open and interact with a document (in default PDF View) From a project in MicroStrategy Developer, navigate to the folder containing the document. In MicroStrategy Web, open the document in Design or Editable Mode. The new template should be viewable when prompted to choose. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. You can modify project-wide graph settings in the User Preferences page. Excel: This allows the user to export the document to Microsoft Excel in . x, this can be done at the document level. Add the report created in step 2 as dataset report of the document which is required to display yesterday's date. For background information on datasets, see Using datasets in documents. The Select Dataset dialog box opens, allowing you to select an existing dataset or import data. this is the memory MSTR uses for worker set. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. Type over the existing text or add new text. 2. This checkbox is cleared by default. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. Copy the URL link for the report that appears inside the source tag, like shown below. Open a document in the Document Editor. Make two grids with different attributes and metrics in each 3. The default MicroStrategy 2020 settings are optimal for SAP HANA 2. When data is imported from a non-MicroStrategy source in MicroStrategy Web, the data is mapped to define attributes and metrics, and then published as an Intelligent Cube. Follow the instruction below to prohibit users from exporting a specific document: 1. Windows. Documents can appear in almost as many ways as you can imagine and are generally formatted to suit your business needs, in a single display of presentation quality. Double-click the document name or icon . Select the Subscription Properties (seen. x - 10. Save the image in the images folder where the. These MicroStrategy Web features are discussed briefly in the topics listed below. In Developer: In a report or document, from the File menu, select Schedule delivery to, then select History List, Update cache, or Mobile. In the Source area, select a database instance for the database to access using Freeform SQL. From a project in MicroStrategy Developer, navigate to the folder containing the document. In the Dataset Objects panel, right-click the dataset that you want to be the primary dataset and select Set as grouping and sorting dataset. MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. You can select more than one dataset report to include on the document. Always consider to collect database statistics as the query execution plan is generated based on that. MicroStrategy Knowledge Base document KB4100-7X0-0070 describes the steps to update table structure in the Microstrategy Developer Warehouse Catalog. Stay tuned for more information. 710 Introduction to Data Science 1 112 1 4 hrs 4 hrs ARCHITECT PASS 2022. In MicroStrategy Web, open the document in Design or Editable Mode. Utilize any of the following design options when creating a document: Display theme for a document; Display theme for an object Documents allow you to showcase your business data in a user-friendly, boardroom-quality way that is suitable for presentation to management. About prompts. The menus, options, and icons available to you depend on your security privileges. In the Run Modes area, select the format (s) in which the document can be exported: •. To print the current layout only, select Current layout. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. From a project in MicroStrategy Developer, navigate to the folder containing the document. Enter a name for the custom group in the Enter Custom Group Name Here field. (Optional) Use the Up and Down buttons. Video Tutorials. Right-click the control and select Properties and Formatting. 1. MICROSTRATEGY INCORPORATED SEC File Number 000-24435 Address of Issuer 1850 Towers Crescent Plaza Tysons Corner VIRGINIA 22182 Phone (703) 848. Below are some keyboard shortcuts to fine-tune the layers' positions. This setting removes the sections that do not have any metric data. x. 1. Click the name of a grid report to execute it. scpMicroStrategy Web's open and customizable architecture allows you to change the look, feel, and even the functionality of MicroStrategy Web. 3. After that, when users select some elements, the 1st text box will display selected elements and covered the 2nd one. With a . The term "versioning" has two different meanings in a MicroStrategy context. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data warehouse. It allows users to retrieve more information after the document has been executed. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. These MicroStrategy Web features are discussed briefly in the topics listed. 2. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. To specify the group-by element in a document, you use the gkey parameter in the URL. Use Index on all Key columns ( for conditions from WHERE clause,. Click the Export to Excel icon in the toolbar. Place the "Top 10 Customers vs All" (as is done with an attribute), the "Percent to Total Customers Revenue", and "Revenue" on the report and the result will as shown in the screen shot below: Users can create a report. To add a page break to a document. If users want to be able to create their own filters, thresholds, or change the graph style used to display data. Prior to MicroStrategy 9. To Create a Subscription in MicroStrategy Web. Note: By clicking the "Don't show this message next time" option, the "Automatic Column Widths" option must be turned off manually. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. 710 Introduction to Data Science 1 112 1 4 hrs 4 hrs ARCHITECT PASS 2022. MicroStrategy analytical modules are packaged analytic components built using the MicroStrategy platform. 5+: Preview Dark Mode. From the list of document templates, click Blank Document. 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 leveraging these you can review how these changes are impacting your environment during an upgrade to the latest release of MicroStrategy. To edit a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. To delete a layout from a multi-layout document INTRODUCTION This knowledge base article provides best practices for configuring, monitoring and troubleshooting Enterprise Manager 10. Display map markers as static images in the visualization, or display the map markers as dynamic bubbles. 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. In the "Format: Template" window click on the "Color and Lines" tab. Some examples of how you can customize and integrate MicroStrategy Web functionality include: Adding a company logo to the MicroStrategy Web interface. MicroStrategy Web (. MicroStrategy Incorporated, any security holder of MicroStrategy Incorporated, or the staf f of the Securities and Exchange Commission, upon request, full. ; Type a name for the subscription in the Name field. Check the Certified option and click Ok. mstrc file, users can simply import the file and enter their credentials, and then they will be connected to a MicroStrategy On-Premises Environment. MicroStrategy Desktop 8. ( 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. Selecting the display theme for a document . The document displays in its default display mode. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. 5. The Properties dialog box opens. This is shown in the following MicroStrategy Developer image in which two Month controls, in different document sections, are aligned. A prompt is a question the system presents to a user when a report is executed. Administrators are encouraged to consult the following Microsoft. CTRL + click to select the desired reports from the MicroStrategy Developer window. You can also apply custom themes to an object. Method 2: Document with a Grid without the Grid Title Bar. 4. . Add one of the controls listed above. If the designers do not have access to the image, they cannot see the image while creating the document. Click the Export. View Documents. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document designers understand how end users will use documents for data analysis. You will learn how to use various report components, filters, metrics, and prompts to design effective and interactive reports. The Browse for Folder dialog box opens. In the Layout category in the Preferences dialog box, select the Re-calculate legend size automatically when data changes check box, and then the Reposition chart frame and legend check box. To do this, click Grid > Automatic Column Widths, as shown below: Drag the column handles and adjust to the desired width. 9. 2. 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. MicroStrategy Web 8. 4. From the Insert menu, point to Selector, then choose the type of selector to add to the document. Open the document in the Document Editor. All articles. Click OK. Tuning a MicroStrategy system is not an exact science. Page-by allows the end user to select and dynamically display elements from a grouping field as criteria for analysis. Report and document URLs can be included in Report Services documents to link to specific reports and documents. Use Aggregate tables 2. Navigate to MicroStrategy Library and users will see the orange certified flag displayed for the dossier. pkg. 2. The following example, using the MicroStrategy Tutorial project, includes the attribute Month with three forms: ID, DESC and DATE.