MicroStrategy makes no warranty, express,. 4. For detailed steps to export to Excel, see the Document and Dashboard Analysis Guide . You are redirected to Microsoft log. Click ' Choose files' and select your Excel file or drag and drop the Excel file. To create a Freeform SQL report. 1-10. Specifies the preferences group to display if the Export Options page is to be displayed. When working with Technical Support, there are multiple logs that may be requested when experiencing problems: The exported PDF file (if available)Best practices: Designing documents for Excel. x where the fill color of a visualization is not maintained when exporting to Excel from a Visual Insight dashboard or Dossier. However, it is not the case, the column can be seen in Excel. In MicroStrategy Developer 9. Within vertical bar options, check the "Dual Axis" option. Export to Excel: export a report or document to a Microsoft Excel spreadsheet: EXPORTTOEXCEL: Export to flash: export a report or document to a MacroMedia Flash presentation:. Comma-delimited files exported from MicroStrategy Web are not properly parsed into cells when opened in Microsoft Excel. csv file via Excel, it's possible to try defining the negative number format as (). x and higher, the export engine first creates a temporary file and then saves it to the destination specified in the export option:. Save the project schema to an Excel file. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Follow the steps in the example below which use MicroStrategy Tutorial project: Create and publish a cube with attributes Category and. 2. If you choose to export metric values as numbers, Excel may automatically format the number. Export a Report Services (RS) dashboard to a Flash file, so that users can view the Flash content and interact with it off-line, without using MicroStrategy. From the Tools menu, select Report Options. Therefore, you must install Adobe Acrobat DC or another print driver and add it as one of your print devices. You can also export the dashboard as an image file, with a PNG file extension. Number of Views 3. permalink Exporting outputs. This technical note describes a MicroStrategy Excel issue where the first object column in a report after exporting a report from MicroStrategy Web 9. The Layout name will be the respective Excel Worksheet name. )The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. 1-10. It is possible to create a hyperlink in a report and add it to an image to export a report into any export format availible. x. 2, 10. Excel document delivered through a subscription. Resolution. 2. They can be overridden at the report level, by accessing the Export Options dialog box for. Dashboards. This checkbox is cleared by default. ; Use the Range drop-down to choose to export the Entire dossier or Grids on this page. csv file. The Preferences page opens. From the Insert menu, select Text. As a merch analyst in a buying office, I need to create my own custom reporting I love how flexible MicroStrategy is in that regard. Images are not displayed in Excel documents that are delivered. The share icon allows you to quickly email a link to your dashboard to other MicroStrategy users. 2 : From the Home menu, select Page Setup. Next, click on the ( +) sign in the top right corner to create a new dashboard. Knowledge Base: Annotate and share feature not available for dossiers in MicroStrategy Library application. This option helps our users to send information to other colleagues in various formats or download the Excel for further analysis. x. Set the width of any column to 0 to hide it on the grid. Open a report. | Meet. xUpon executing the above code the following output is generated: Current Header Value is : {&FilterDetails}<br> My Sample Report. KB19099: When exporting a report to Microsoft Excel, the report name is not generated correctly. In MicroStrategy Web, the Excel export date format appears inconsistent when regional settings on the client machine are set to German. This is a know limitation in MicroStrategy Web. KB45709: Grids get cut off in dashboards when exported. Maximum cache memory usage has been reached for existing caches. There's a reason we're at the top of the list. x, it is possible to programmatically export a report to a CSV file as follows: 1. On the left, select Export Reports. After analyzing market trends in the industry, as well as the needs of most of our customers, MicroStrategy is announcing the end-of-life for the MicroStrategy Application for Windows and macOS, with MicroStrategy 2021 Update 10 being the last version available on the MicroStrategy download site. Each exported grid will appear in its own sheet in Excel. This can be achieved by going to the 'Insert' menu and selecting 'Layout'. In MicroStrategy Tutorial: Create a target document. 4. This technical note article describes why a grid information would clip after exporting to PDF or excel if it's inside a panel stack in MicroStrategy Web 9. 23614 may be rounded to $34. Cause. The Recipients Browser opens. Exports the document to PDF. To export a report to PDF. Under Properties and Formatting>Layout for the grid, select "Fit to grid contents" in the dropbox for "Grid Overflow (PDF & Excel)". Go to Data > Export Options, as shown below: Go to the Appearance tab and check the 'Use 6. x Dashboard template, identify the Body in the Document Structure pane. Bookmarks and tables of contents are created by default for a multi-layout document. x only when exporting reports to . In MicroStrategy Analytics Express, you can export the document with advanced templates as Dashboard file (. 1 and above, grid content does not overflow when exporting documents in PDF and Excel, even though the "Grid Overflow(PDF & Excel)" option is set to "Fit to grid contents" and only the first page printsThe data you can view is based on your org/fund access in Banner. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Certification of Intune native EMM SDK for iOS 15. Users may want to dynamically pass multiple selectors' values as prompted answers to another Report Services document that is to be exported to Excel. MicroStrategy Dossier makes it easy to build insightful and engaging dashboards—and with the free-form canvas, the latest 2020 platform release has introduced new game-changing, design-focused features. For export to Excel, HTML, and PDF, you can specify default exporting options, or you can allow users to be prompted to make these choices. Users should also choose the option to embed the image in the export, when exporting to Excel. To export the document to Excel, click the PDF icon in the toolbar to view the PDF, and then select Export to Excel from the File menu. Since the original name of the report contains special characters, it is causing an issue with Single Sign-On session state. The Export Engine (EE) runs as an independent micro-service to export dossiers to PDF that comes with its own logging and troubleshooting steps. See Using the URL API to Access a MicroStrategy Web Page topic for instructions on how to access both out-of. If the recipient is not listed, complete the following steps: Click To to locate the email address of the recipient. The MicroStrategy Internal Reference Number for the issue discussed in this technical note is 437952. x/2021/11. Dashboards are designed using MicroStrategy Web. KB484781: Executing documents with dynamic text or html container in the Detail section results in a blank page if there is a derived unit in the dataset in MicroStrategy Web 2020 Update 2 This article addresses the blank page that is returned when executing a document with dynamic text or html container, with a derived unit in the dataset, in Web. 3. 0. x and 10. x or 10. Once data flows into the interface, the dashboard will come to life. x. Click To to locate the email address of the recipient. Create a simple dashboard in MicroStrategy Web and insert an image. Exports your document to Excel, PDF, HTML, or Flash. Click "Edit Custom Settings. This option is available in Express, Interactive, Editable, and Flash Modes. Grid Settings You can choose how to export wide grids. Click Add. Learn more at us on LinkedIn at MicroStrategy has supported the export to Excel function for a while now, but in MicroStrategy 2020 Update 1, we made Export to Excel more accessible and discoverable. Navigate to the customization plug-in folder inside the plugins folder of the MicroStrategy Web installation. A demo that describes how to create and use MicroStrategy Dashboards. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. Insert a "Blank Dashboard" layout. A demo that describes how to create and use MicroStrategy Dashboards. Notice word wrap is maintained: Create document from this report. Export to an Excel sheet by clicking the menu button in the top right, selecting export, and selecting Excel. ; From the Schedule drop-down, select a schedule or. This can be in the form of graphs, charts, maps or other graphic depictions that. If you choose to export metric values as numbers, Excel may automatically format the number. x where the fill color of a visualization is not maintained when exporting to Excel from a Visual Insight dashboard or Dossier. Append &messageID={&DOCUMENTMESSAGEID} to the URL API. For steps to export documents to Excel, see the Document and Dashboard Analysis Guide. For more information, see Selecting export options for documents. Procedure. Share your dashboard with other MicroStrategy users. Excel with plain text: Export the report to Microsoft Excel as plain text. The Export Options dialog box opens. x, when exporting a document to Excel, the height of the text fields is not adjusted to the content, causing the text to be truncated, even if "Automatically Fit Rows" properties is enabled at the section level. Setting this parameter to 3 will export the document to PDF while 4 will export the document to excel. Data pivoting enables you to rearrange the columns and rows in a report so you can view data from different perspectives. Intelligence Server (for a document exported to PDF from MicroStrategy Web) Web ASPxasp (for documents in MicroStrategy Web) or jsp (for documents in. The table b elow summarizes the Export Engine VLDB properties. Select Excel to export grid visualization data in an Excel file. Run the report to export. This article describes a situation where some metrics occupy different number of cells and are not aligned after a dashboard exported to Microsoft Excel in MicroStrategy Web Loading × Sorry to interruptExport. By default, "Export to Excel" max memory usage is set to 100 MB. The option to "lock columns" is not available when exporting from Microstrategy Web to Excel. ), grids get cut off to stay true to the design of the document. To Create a Transaction Services Report. 4. com. However, when characters such as '%' percent, ':' colon, and '( )' any of the two parenthesis characters are included in the report name, the Excel filename does not include these. Exporting this dashboard to pdf will display the following: ACTION: An enhancement was logged to disable border around selectors during PDF export, but MicroStrategy decided not to. When a dashboard with 2 panel stacks, each with a grid, and one of the grids is configured to hide the Row columns, is exported to Excel, metric columns are missing in one of the grids in MicroStrategy Web 9. To alleviate this, users can change the Maximum memory consumption for Excel files setting in MicroStrategy Desktop as mentioned in KB12795: ‘Unable to generate complete results due to the memory governing limit for Excel exporting. Create different Dashboards in Dossier for Presentation Purpose. x - when designing the document. Action Type. In MicroStrategy Developer, create a metric that returns "negative" values, for example (Cost * -1) Create a new report with this metric and add an attribute, such as Country. Click any report you wish to execute. KB11475: Best Practices when Building Report Services Documents for Export to Microsoft Excel in MicroStrategy 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. However, with the rise of mobility, the advent of the mobile workforce, and an increase in the number of employees who prefer using mobile devices for work-related functions, companies can no longer ignore the importance of building mobile. Select where in the Excel spreadsheet to export the report to: Worksheet: The name of the worksheet to export the report to. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 4. 4. When exporting Excel with formatting, increase the values of the "Maximum number of cells to export to HTML" project export preferences to at least the equivalent of the number of cells in the report. To export a report while viewing it, click the name of a grid report to display it. With MicroStrategy Library, business users can curate a personalized selection of analytical content to refer to easily whenever they need it. Strong semantic layer to define all the business rules and tightly coupled. 4. 02K subscribers Subscribe 2. Select a recipient from the To drop-down list. On the My Subscriptions page, under the Email section, click Add email subscription. Users can follow the steps below to achieve this: Insert a text link to the report services document. MicroStrategy Mobile SDK iOS. Trusted Data for Excel, BI Tools, and Data Science Tools. In Platform Analytics tracks whether the execution was exported and what type of export action occurred (Export to Excel, Export to CSV, Export to PDF, etc). Link to comment Share on other sitesSelect any cell within your data range, and go to Insert > PivotTable > New Worksheet. On the Insert tab, in the Charts section, choose PivotChart . For a multi-layout document, select whether to Export: All layouts, which exports all the layouts in the document. If the Export. The table b elow summarizes the Export Engine VLDB properties. End: The column and row of the worksheet to export the last value of the report to. Copy the following folders from the Web server web application folder into the export engine's resource folder: images, plugins, VisFramework, and WEB-INF. In MicroStrategy Web a user has the option to add header and footer information at 3 levels. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. link MicroStrategy users and groups to users and groups from sources such as Windows NT, LDAP, or a database: LINKTOEXTERNALACCOUNT:KB439303: Report header is not exported to excel when reports contain attribute only and “remove extra column” setting is enabled on export option page in MicroStrategy Web 10. Page-by allows you to view the PDF by a selected group element. Notice that the image displays with no issue in MicroStrategy Web. . This knowledge base article describes the limitation in MicroStrategy Mobile App in iPad, which opens a document as an Interactive document, even when it is set to open by default " Export to excel" mode. Similarly by selecting the export option you will receive the following dialog box with the various export options, such as selecting your format type, delimiter type, exporting each dashboard page on a separate excel tab, etc: Share. Steps to show all the data in exports are explained in this article To export a document directly from a folder. evt. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. Click on the chart settings and then select "Export to Excel" from the list. If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). BOOKOVERVIEWAND ADDITIONALRESOURCES Thisguideistheprimaryresourceforyoutousetolearnaboutdesigningandcreating. Before you export, set the. 2) Intercept and reinterpret. This article demonstrates one working example on how to apply image in threshold and make sure it will display in subtotal section in Excel. Custom number formatting symbols. When you do this, you insert an image into the content via upload and the image is referenced on disk via the. In Export Options, check the option of "Use 6. To automatically open the report in Excel after you export the report, select the Show application after exporting check box. ) If you want to configure export options, complete the following steps: From the Data menu, choose Export Options. 7, exporting results to Excel generates an empty Excel file Number of Views 735 KB46953: Is it possible to use Command Manager to list the prompt values and personalization used. To use the SharePoint Files connector with MicroStrategy Web, your administrator must perform the steps detailed in the Configure the SharePoint Files Connector topic of the MicroStrategy Web Administrator Help. Do one of the following: For a report, click the name of the report to run it. To export a grid to Excel format from. Exporting Report Results from MicroStrategy: Export Engine. Share your dashboard with other MicroStrategy users If your colleagues use MicroStrategy Desktop or MicroStrategy Web, you can share your saved dashboard with. Type a File Name. x and has expertise in Report/Dashboard/Dossier development, visualizations, knowledge in Administration and various. Temporary files are created under the system temp folder on the machine where Excel documents are exported in MicroStrategy Developer. To export a report while viewing it: Click the name of a report to display it. Export options in MicroStrategy: Embed images, Use live Excel charts, Use embedded bitmaps. Number of Views 1. Second, create an attribute that contains the longitude of each store and assign it the Longitude geo role. fyi: MicroStrategy connects to a Oracle server, I tried using the Oracle & ODBC connection. CAUSE By default, MicroStrategy only exports the first page of the page-by. Using Library for Web, business. Slice and dice features are awesome. x, or deliver the report in MS Excel format using MicroStrategy Distribution Services 10. 1, the check box selections are cut off. The Export Engine fetches all the object’s content, calculates their layout and. DESC. Restart you computer and export a report from MicroStrategy Developer to Microsoft Excel. For example, if the name of the document is Multilayout Example, the name of the Excel spreadsheet will also be. The GUID of attributes in profit and loss hierarchy (separated by ':') that has dummy rows to be removed VLDB property lets you identify attributes that include empty elements, which can then be ignored when exporting to Microsoft Excel or to a PDF file. A document, which has more objects such as images, then a table does. Select Data to export the visualization in a . " Why is this happening? The Export Engine has a setting that limits the maximum server . The Flash file is a. Exporting Report Results from MicroStrategy: Export Engine. The target Report Services document contains a. Note: The number of layouts will determine the number of Worksheets in the Excel file. The MicroStrategy for Office add-in enables you to use Microsoft Excel and Microsoft PowerPoint to connect to data in MicroStrategy. This allows end users to share data or view the raw data for further analysis. ACTION This issue has been addressed with Microstrategy Web 10. The "All Objects" option is not available for the following types of reports: Freeform SQL Reports. 5. With MicroStrategy's powerful exporting functionality, users can turn MicroStrategy reports, documents, and dashboards into portable, visually appealing documents stored in any of several widely used formats. If DHTML is disabled, click the Export icon or PDF icon in the Actions column. 1. Navigate to the location to save the exported file, then specify a name. Users may want to dynamically pass multiple selectors' values as prompted answers to another Report Services document that is to be exported to Excel. x, the message below is shown: Unable to export User request is queued. Supported exports include PDF export, export of visualizations as images, and export as CSV or XLSX. Create a source document. Check out the five modern tools you should be using to ensure you are getting the most out of the MicroStrategy platform: 1. CAUSE: The rows are not being resized automatically because the option is not selected in the Properties for exporting to Excel. Select the chart, then size and format as desired from the PivotChart Tools tab. This document provides the steps to accomplish the same. 2. Expand and collapse individual levels by clicking the or icons within each row on the report. 6. Download and Install MicroStrategy Desktop Application. Extract the plug-in to the plugins subfolder inside the MicroStrategy Web installation folder. x and MicroStrategy Desktop 9. Before you export, set the export options to. Learn more. x and 10. g. /images/image_name' as shown below. Before exporting from MicroStrategy Web, the user must select 'Excel XP, Excel 2003 or newer versions' in the Excel Version drop down list under the Export Web Preferences, as shown below: This is necessary for the 'Place each page on a separate sheet' option to become available when exporting the report, as shown below:A user would like to export a report from MicroStrategy Developer or Web to Microsoft Excel having only the metric values and discarding the column headers data. MicroStrategy dashboard (MSTR) file Export the dashboard as a MicroStrategy file, which can be opened in. 1 0 Exporting. Export document to Excel and you will see that the Excel rows does not resize to fit the entire text of the metric name. 4. The demo also covers Dashboard export settings. To configure export settings in MicroStrategy Web. Live Excel charts ensure a smaller export size and integrate fully with Excel. Select MS Excel Worksheet from the Application drop-down menu. (For steps to run a report, see Running a report. x, as shown below: Note: The width of the columns does not fit the item name length and some of the text is overlapped by the adjacent cell which caused by the WordWarp and the fixed. Live Excel charts ensure a smaller export size and integrate fully with Excel. If this option is not chosen, the relative path is resolved on the machine where the document is opened i. Select PDF to export the visualization in a PDF file. If you choose to export metric values as text, Excel will not automatically format the numbers. 5, there are two lines of code shown at the top of the screen, even if the export works. A developer can access this cube directly by determining the port. csv files in the /Compliance_Dashboard sub-directory of the target location. x or 10. To Enable Outline Mode on a Report. Select "Modify Project Source" Go to "Memor"y tab > "Export to Excel" The maximum RAM usage is 2047 MB (2 GB): So for example, if users try to export a report with rows and columns lower than 1,048,576 and 16,384. For example, an attribute form may contain a URL that specifies the location of an image. To export the report to Microsoft Excel as plain text, select Excel with plain text. x layout", the report can be exported to Excel successfully, as image shown below: Alternatively, the export operation can be performed through MicroStrategy Web 9. To export a document to Excel 2003 or later, embed images (see Displaying images in Excel, for instructions and more details) to ensure that the images are displayed correctly in Excel. Save the file. PDF. If the user requires the ability to increase data accuracy after exporting, export to Excel instead of csv. To Enable Outline Mode on a Report. Notepad supports downloading documents to PDF with the ability to customize content such as page orientation,. Make sure the columns in the grid are sized to display the same as in step 3. The Export Options dialog box opens. Additional details about each property, including examples where necessary, are provided in the sections following the table. From the Data menu, select Export Options. Users may want to be able to programatically export Documents which contain multiple tabs in excel. Select Custom as the Category and create the format using the number format symbols listed in the table below. Click Save to save the export file and return. Restart the export engine. Procedure. I have almost 20 custom dashboards saved that I can pull & export as needed, and share with the rest of my working group as well as other departments. From the Home menu, select Export, and then select one of the following export formats. which can then be ignored when exporting to Microsoft Excel or to a PDF file. When users attempt to export reports to Microsoft Excel in MicroStrategy Web Universal, users are prompted to enter their MicroStrategy login information again. This setting only applies to exports to Excel. Click on the chart settings and then select "Export to Excel" from the list. Note that everything looks fine in the export. x: Export to Excel. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector. Advanced Options: Excel. 1 and 10. To export the report to Microsoft Excel as plain text, select Excel with plain text. 4. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. Select 'Export Project Schema. CAUSE: This is a known issue in MicroStrategy Web 9. KB46105: How to configure a grid to overflow when exporting to Excel or PDF in MicroStrategy Web 9. Click the General tab. To increase the number: Right click on the target project source. From the Developer Folder List, go to Administration > Delivery Managers > Devices. You can now export the data as shown above. Get Insights of data and taking faster decisions. csv file format, will not be exported surrounded by quotes, whereas all subsequent object columns are. . From the Home menu, select Export. Export a document to Excel, and the "Mozart Reports" tab should not appear. Save and close the report. Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. For more information, see Selecting export options for documents. If you want to include detail rows in the export, please use the getCustomContentBelowRow callback to generate a representation of the detail row that will be inserted below the master rows in the export. Open the current PDF in a separate window outside of the Document Editor, where each layout starts on a new page. Create or edit reports with authoring functionality. Save the preference and re-login to MicroStrategy Web. Before exporting from MicroStrategy Web, the user must select 'Excel XP, Excel 2003 or newer versions' in the Excel Version drop down list under the Export Web Preferences, as shown below: This is necessary for the 'Place each page on a separate sheet' option to become available when exporting the report, as shown below: Excel exports can be performed with the "Excel with formatting" option, which produces an Excel file with the same formatting seen in the browser of Microstrategy Web. Common Privileges, the user needs privileges to 'Export to Excel'. ‘Export to Excel’ option is not available for a VI dashboard converted to a document in MicroStrategy 10. For a report: From the Home menu, select Send Now. Query Builder Reports. Full Screen Mode. From the File menu, point to Export, then select PDF or Image. x does not export all of the report data when there is an attribute in the page-by. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. @Stefan Zepeda (Inactive) (Microstrategy, Inc. Select an attribute by dragging the attribute from the Object Browser into the Attribute box. 3. 25K. However there is no option to export dossier to html in email. From the File menu, select Send Now (or, from the dossier toolbar, click the Send Now icon ). Current layout, which exports only the layout being viewed. Article Reference Number: KB42796 Third Party Software Installation WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. For more information, click Help in MicroStrategy Web. To add objects, you must drag the objects into the row or column sets in the Editor Panel drop zones. With MicroStrategy's powerful exporting functionality, users can turn MicroStrategy reports, documents, and dashboards into portable, visually appealing documents stored in any of several widely used formats. SYMPTOM: When trying to export a large report in MicroStrategy Web 10. 4. Create a new dossier, and add data. Intelligence Server (for a document exported to PDF from MicroStrategy Web) Web ASPx\asp (for documents in MicroStrategy Web) or jsp (for documents in. 1, 10. or. Ability to export reporting object data from client interfaces into different formats such as CSV, Excel, HTML, PDF, and MSTR Exporting options. Set the default run mode to be "Export to Excel", like shown below. With export, the summary view of the dossier is generated on one page and then a. For flexibility, MicroStrategy allows you to export content from various locations, some of which can be specified by a URL. Allows users to export reports in a specified format (Excel with plain text, Excel formatted, CSV, HTML, or plain text) The page component that should handle the action and the event. 23614 may be rounded to $34. These 5 new export privileges were added to the Common Privileges in MicroStrategy 9. 1, 9. 1-10. x and 10. To increase the number: Right click on the target project source. Pros and Cons. Formatting Click the General tab. Exporting multi-layout documents. If the Power BI admins of your tenant have disabled the “export of data” option in the Admin portal. The options for exporting the report to a Microsoft Excel worksheet are displayed. Export the visible portion of the dashboard as an image, including panels, visualizations, and the contents of the page, by area. Export to PDF. 4(for platform release 10. To export a report while viewing it: Click the name of a graph report to display it. Lastly, connect the bar chart to columns like Project Name, Start Date, and Duration. 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. Modifying the Export preferences to show only 'Report Data' does not yield to the desired output, as shown below:Select a page from a dossier in your library. For a grouped document, select whether to export the entire document or only the selected group element: To export. Report created with Intelligent Cube. 58K. 4 Hotfix 4, a report, document, or dashboard with the character ampersand “&” that is exported to Excel, PDF, or Print will encounter “Server Error”Embed MicroStrategy Dashboards in Sharepoint. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. MSTR file) by selecting Share->Export to Dashboard file, which gives a warning message as shown below.