Notice surprising patterns with visualizations. Type the pop-up text in the Tooltip field. 3. Click Show Advanced Options. From the Format menu, select Apply Document Theme. 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. See Defining selectors. Toolbar Options. To see sample documents in MicroStrategy Web: 1. To change the mode, click its icon on the toolbar. 2. To print the current layout only, select Current layout. MicroStrategy SDK 2022. The URL API call is normally used to pass the prompt answers from the first report to the second Report Services Document. MicroStrategy Knowledge Base document KB4100-7X0-0070 describes the steps to update table structure in the Microstrategy Developer Warehouse Catalog. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. When you execute the document, the. You can use MicroStrategy Web to create a Grid/Graph that contains. ADDITIONAL INFORMATION: The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data. In this example, you execute a document called "Casino Analysis" (located in MicroStrategy Tutorial>Shared Reports>MicroStrategy Platform Capabilities>MicroStrategy Report Services>Visual Insight). Refer to the following MicroStrategy Knowledge Base document for more information: KB30866: New feature in MicroStrategy Intelligence Server 9. The legend frame is moved to one of the default locations on the graph report. Dynamic Custom Group in Dashboards or Dossiers. A widget is a type of MicroStrategy Report Services control that presents data in a visual and interactive way. From the left, select General. " Why is this happening? The Export Engine has a setting that limits the maximum server . 2. Saving the dashboard in MicroStrategy Developer converts it to a document; it cannot be converted back to a dashboard. 3. On the Freeform Sources tab, select Create Freeform SQL report. If the document is open in Presentation Mode, click the menu icon on. The option to view or create Documents isn't visible in MicroStrategy Web 9. 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. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. 2. On the My Subscriptions page, under the Email section, click Add email subscription. There are two ways to insert an image through MicroStrategy Web interface directly: 1. Note: Users cannot schedule reports with prompts unless the report has default answers. Click Field to open a drop-down menu of the attributes and metrics on the Grid. A Grid/Graph can be directly associated with one dataset report. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Additionaly, pictures can be inserted borders drawn in the document. Download the PDF manual and get started with MicroStrategy Office today. From the Data menu of the Document Editor, select Edit View Filter. scpMicroStrategy Web's open and customizable architecture allows you to change the look, feel, and even the functionality of MicroStrategy Web. 3. Click in the desired section of the Layout area. Always consider to collect database statistics as the query execution plan is generated based on that. On the left, select Page. This is shown in the following MicroStrategy Developer image in which two Month controls, in different document sections, are aligned. 215 Embedding Analytics with MicroStrategy REST API 2022. The following example, using the MicroStrategy Tutorial project, includes the attribute Month with three forms: ID, DESC and DATE. Useful Design TechniquesTo hide the 'My Reports' link after the Administrator has enable this feature, users must follow the steps below: Log into MicroStrategy Web as a user with web administration privileges. Copy the URL link for the report that appears inside the source tag, like shown below. 1. You can also create links in documents. If the document contains multiple layouts, click the tab of the layout whose printing options you want to modify. Navigate to Subscription Monitor in MicroStrategy Developer; Right-click and go to 'View Options' where it is possible to enable the Owner field; From the right-click menu, it is also possible to create a filter based on fields in case there are a number of subscription messages to go. Choose Recipients of the subscription and click Next. Also, see the documentation for your particular Web application server for additional tuning information. Editable mode allows the designer to work in a "What You See Is What You Get" environment, so that every applied change is immediately visible on the screen, with no need to switch. When you create a document, you can specify the data that appears, control. Click on "Properties and. Select the Outline checkbox and click OK. In MicroStrategy Web, open the document in Design Mode. 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,. This article explains how to resolve IIS executionTimeout errors that occur when executing MicroStrategy Web documents with large amounts of data selected in a filter. The Document Editor has multiple toolbars you can use to access different document features. Interactive dashboards in MicroStrategy. Select the theme and click OK. Many times, a MicroStrategy Web environment that is running poorly can see an improvement in performance from. From the Data menu of the Document Editor, select Edit View Filter. In MicroStrategy Developer, double-click the document name or icon. As shown in the screen shot below, in the Rename/Edit Objects Window, select the "Replace dynamic text" checkbox as shown below. Documents in MicroStrategy Web have the same functionality as documents in MicroStrategy Developer, such as viewing, printing, and exporting. MicroStrategy Office is a comprehensive guide that covers how to use the MicroStrategy platform with Microsoft Office applications. 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. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. When you move the cursor to the Layout area, the pointer becomes crosshairs. To export the report to Microsoft Excel as plain text, select Excel with plain text. A selector can change in a panel stack. Position the MicroStrategy Developer window and the Document Editor window to view both windows at the same time. 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. view filter are local to the report and report filter can be used for other reports as well. 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”. The chapter is focused on creating new documents, so it includes procedures and best practices to create and design documents. The steps below show you how to create a custom group in MicroStrategy Web. Right click the Regions column header and select Advanced Formatting. We empower you with the skills to get the most out of your analytics investment. The example above was created in the MicroStrategy Tutorial project using the Inventory and Unit Sales - TVs report as a dataset. Event Based Schedules Event based schedules run reports and tasks when the event associated with them is triggered. In the original project, create the document to be used as a portable document. 3. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. A common requirement is to have a link in the second Report Services Document to return to the first report. ; Type a name for the subscription in the Name field. Users can wrangle, model, and enrich your data from PostgreSQL, as well as blend with other data sources. Redis uses approximately 1. The purpose of this knowledge base article is to explain how to pass selections of multiple selectors to a document using URL API in MicroStrategy Web 10. Selector: The following options are available for selectors. Display map markers as static images in the visualization, or display the map markers as dynamic bubbles. Enterprise Manager is a set of pre-built documents that display data on how people are using your app, such as what device they're using, which documents they view the most, and app performance. This setting removes the sections that do not have any metric data. ( How?) On the Insert menu, point to Selector, then choose the selector style. SQL view also includes various execution statistics for a report, such as the number of rows, number of columns, the time it took to execute, and so on. When you export a report, you move a copy of the report into. Click on Dossiers in the left panel of Workstation. To configure export settings in MicroStrategy Web. Using Subscription Monitor in MicroStrategy Developer. From the Home menu, select Page Setup. 2 : Select the horizontal section to resize. The same report accessed in web. wherer as report filter is applied in the calculation itself i. You can modify project-wide graph settings in the User Preferences page. Select Export from Home menu, and then click PDF. In the image below, the Customer State 'Connecticut' was generated using a dynamic-text field: {[Customer State]}Launch the Web Customization Editor. About prompts. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. 9 and 10. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. Trim the sections for which no data was available. In MicroStrategy Web, open the document in Design Mode or Editable Mode. The following is an example of the syntax necessary for file delivery, the name of the file can be specified with static text and/or Information Objects:A control document is a file specified per publication that alters MicroStrategy Narrowcast Server 9. If you arrived here from Workstation, click here for help. It also helps configuring the data interaction between one object and the others. These MicroStrategy Web features are discussed briefly in the topics listed below. 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. Click the hyperlink on the document and it opens the target report/document/VI dashboard and notice that the Selector B values are not getting passed on to the prompt in the target report/document/VI dashboard, instead the target report/document/VI dashboard displays the data for all the elements of the attribute used in selector B . x using multiple events event. Follow below steps to apply the. When you select a large amount of data in a filter, the document produces the errors shown below in both the browser and console. Now that that’s settled, let’s jump into some best practices for dossier authoring. Click Click here to start a new qualification to begin to create a new view filter. The Export to PDF dialog box opens. In MicroStrategy Developer, choose File > New > Report. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Select the theme and click OK. 1. 1. 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. 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. To export a report while viewing it: Click the name of a report to display it. 0. 3. To Create a Subscription in MicroStrategy Web. Add one of the controls listed above. Add metric "Yesterday" to the document section as dynamic text. 5-2 GB for a Metadata with > 1 million objects and a high transaction load. Toolbars are mostly divided by workflow—the Insert toolbar, for example, lists the different. 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. 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. In MicroStrategy Web, if you do not own Distribution Services: In a report or document, from the Report Home or Document Home menu, select Add to History List or Add to Mobile. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. CTRL + click to select the desired reports from the MicroStrategy Developer window. To export a report while viewing it: Click the name of a report to display it. Installation on the Desktop. Getting started with documents. Analyze the low performance query using DBA knowledge, add. The PDF that results from this selection is called a page of the original document. Using the exact name of the font, enter a name for the new shortcut prefixed with " pkr ". Right-click the document name or icon, and select Edit. You can add one or more datasets to the document. Data (attributes, consolidations, custom groups, and metrics) from the document's datasets. To apply gradient colors, which blend two colors to create a gradual color change in the background, see Steps to apply gradient colors. 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. In MicroStrategy Web, on the reports page, under the name of the report/document that you want to create a subscription for, click the Subscriptions icon . In this grid, pull Customer attribute to the rows and Profit metric to the column as shown below:The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The best practices are grouped into the following sections: •. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. The highlight on hover is enabled in Presentation mode by default to indicate the viewer’s mouse focus. Interact with the data in real time (with targeting, filtering, and more). In the Document Properties -> Document section, uncheck all available. Therefore, prompts allow report designers to create reports that let users change the report content at run. Add the two reports Report Item Orders and Revenue and. 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. To create a selector that updates a dynamic text field on a panel stack. The dataset appears in bold text. For general tuning of Snowflake, please take advantage of the Snowflake Tuning page. To select multiple objects, press and hold CTRL while clicking the objects. Open the document in the Document Editor. To find out if you are hitting any of the scenarios listed below, take advantage of MicroStrategy Integrity Manager and the Upgrade Analysis Dossier. Selecting the display theme for a document . From the Home menu, point to Export. The document opens in PDF View, in Acrobat Reader. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. The aim of this KB is to have a look at the Live connected intelligent cubes performance considerations as it’s necessary to understand how many steps are involved in the process, of course each step consumes time, hence the more steps the more time will take a dossier to. To format numbers in text fields. P83. This article will not discuss the hardware. The text field for new notes opens. The following clarifies these two possible meanings and their respective contexts:. Custom groups enable users to view specific elements based on a metric or specification. The Document Editor has multiple toolbars you can use to access different document features. 1. Exercises: Documents and MicroStrategy OLAP Services. These can be used to enhance a grid’s ability to convey richer meaning To access documentation resources on Windows. MicroStrategy Basic Reporting Guide is a comprehensive manual that teaches you how to create, execute, and analyze reports using MicroStrategy. In the folder list, right click on the report > Share > Show HTML. x reports display the 'Metrics' column on the report grids by default. Adding Text and Data to Documents discusses. 3. Click the Enterprise Reporting Documents folder. MicroStrategy out-of-box provides two display themes: The Light theme and The Dark theme. 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. For more information, click Help in MicroStrategy Web. ( How?) Double-click the Grid/Graph to enable edit mode. Selecting a display theme for an object The Light and Dark themes quickly change the. You will also discover how to leverage the MicroStrategy platform and its features to. The formatting of the new section is. In MicroStrategy Web, log in to the Tutorial project. Enter a description for the custom group in the Enter Custom Group Description Here field. The first document was technical document entitled "Narrowcast Server 7. This is how the behavior is set and displayed from within MicroStrategy Developer 9. Click the check mark symbol on the right of the drop-down. 2. If the designers do not have access to the image, they cannot see the image while creating the document. To do this, click Grid > Automatic Column Widths, as shown below: Drag the column handles and adjust to the desired width. Follow these steps to format the DHTML Heat Map widget to have custom colors ranges in a Report Service Document in MicroStrategy Web 10. 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. 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. 213 SDK for Customizing Analytical Applications 2022. wherever you want on the canvas and use the layers. Place Intelligence Server close to the both the data warehouse and the metadata repository. You can modify options such as paper size, borders, section display, and horizontal overflow. In MicroStrategy 10. From the drop-down list of all the Grid/Graphs on the document, select the Grid/Graph to apply the view filter to. In the initial release of the MicroStrategy app, users can change the look of the app by switching to the Dark Theme under Preferences. In MicroStrategy Web, open the document in Design or Editable Mode. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 4. It builds on basic concepts about reporting functionality presented in the Basic Reporting Guide. Open a document in the Document Editor. For tuning details, see the appropriate section in the Installation and Configuration Guide. Exporting a document. x, it is possible to use dynamic content from a grid report inside a Control Document. 421 Advanced Mobile Applications. browse button. ) User can now select the Gotham Medium font in Developer. •. If you hold down the CTRL key while resizing, snap to grid is temporarily turned off. WebSphere Application server is a third party tool therefore if further information is needed contact IBM support since this document is just provided as an introduction to this topic. To find the value for this parameter, do the following: In MicroStrategy Web, open the document in Design mode. Yes, it's true. MicroStrategy Document Creation Help. You can also apply a set of color and shading schemes to all the objects on a graph report. The PDF that results from this selection is called a page of the original document. MicroStrategy Web Universal (J2EE) Tuning actions for the J2EE version of MicroStrategy Web Universal vary according to the Web server you are using. Do one of the following: For a report, click the name of the report to run it. 213 SDK for Customizing Analytical Applications 2022. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Video Tutorials. 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. The HTML tags format the first line as a heading 2. To remove a dataset from the document, click the name of the dataset that you want. 4. Click the Export to Excel icon in the toolbar. In MicroStrategy Web, open the document in Design Mode. Gather information about your MicroStrategy project. Choose the option Get Info. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. Follow the steps above to create a threshold for a metric on a report. 3. Excel with plain text: Export the report to Microsoft Excel as plain text. x users have the ability to disable this option. High-quality, Pixel Perfect™ documents allow you to display your business data in a user-friendly way that is. Make the necessary changes to the document and then save and close the document. NET) The most significant things you can do: Tune Microsoft's Internet Information Services (IIS). Go to the "Preferences > Project Defaults > Folder Browsing" section and check the 'Hide 'My Reports' link when user does not have web save. Click the document name or icon. 3 : From the Format menu, select Properties and Formatting. For tuning details, see the appropriate section in the Installation and Configuration Guide. 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. In MicroStrategy Web, open the document in Design or Editable Mode. 2. 3. x, grid and graph displays are cut off on the right side. You can select more than one dataset report to include on the document. To email a report or document on a schedule. Click any report you wish to execute. A MicroStrategy connection file (. Select Image from the Insert menu, or click the Image icon in the toolbar. Opens the report in PDF format. Open a document in the Document Editor. The Properties and Formatting dialog box opens. Select Image from the Insert menu, or click the Image icon in the toolbar. Go to MicroStrategy Web, right click on the HTML container. mstrc. In MicroStrategy Web, you can also interact with documents, schedule them, and send them to specified email addresses. Click OK. Apologies, but something went wrong on our end. Formatting text fields. A multi-layout document contains multiple documents, each in its own layout, creating a "book" of documents. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. View the orange Certified ribbon on the dossier. Make two grids with different attributes and metrics in each 3. Note: More elaborate programs will require additional library files and are out of the scope of this document. There are several important factors to consider before tuning your. Edit All Project-Level Settings. Right-click the document name or icon, and select Edit. Double-click the document name or icon . The Excel File will contain only the selected Grid Object data from the Document. Therefore, prompts allow report designers to create reports that let users change the report content at run. 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. . In the Run Modes area, select the format (s) in which the document can be exported: •. 6. Include bookmarks in the PDF. Dashboard-style Documents. When you add a new text field, its formatting is determined by the control defaults. 1. In the Grouping panel, right-click the grouping field on which to enable page-by. Home Published: September 27, 2022 • 994 Views Creating and Editing Reports in MicroStrategy Library It's true! Reports are now available in MicroStrategy. 2. The folder where the product you want to use to accesses the image. Place intelligence server close to the both the data warehouse and the metadata repository. 411 Project. You can add documents to your Library using MicroStrategy Workstation or Web. Select Add Subscription for the type of subscription you want. ACTION: Create a new Document in MicroStrategy Web 9. General hardware recommendations. Click the Export to PDF icon in the toolbar. To Create a Subscription in MicroStrategy Web. 155 Derived Metrics, View Filters, and Derived Elements. The following figure displays the SQL. To create multiple. The image must be stored so that it is available to both the Intelligence Server and to the designers of the document. From the Metadata drop-down list, specify the language in which to display the. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. 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. 4. Alternatively, when the Schedule Manager folder is selected, users may go to the File menu in MicroStrategy Desktop and Select New and then Schedule. Navigate to & expand System Pickers, then select fontPicker. 20. 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. Excel with plain text: Export the report to Microsoft Excel as plain text. •Integrity. To add a text field to a document. x. If the document contains multiple layouts, click the tab of the layout to change. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. Right-click an underlined object on the grid, point to Drill, then select the destination object. For steps, see the Basic Reporting Guide. MicroStrategy Web Universal (J2EE) Tuning actions for the J2EE version of MicroStrategy Web Universal vary according to the Web server you are using. In the Run Modes area, select the format (s) in which the document can be exported: •. Auto alerts. In the Property List Window, set the 'Hide if empty' value to 'True. However, these settings depend on the type of SQL being sent to the warehouse, database load, and dataset size. If the document is not grouped, no bookmarks are generated. Toolbars are mostly divided by workflow—the Insert toolbar, for example, lists the different. Select Add Subscription for the type of subscription you want.