2987. Add additional column in the same Excel file 4. For this check an attribute search is performed. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Here’s how to insert a pivot table: Go to your Dashboard sheet and on the Insert tab, click the PivotTable button. Sample. Selector two selects Region element. We’ve evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . ACTION: The issue has been fixed in 10. Diagnostic analytics shifts from the “what” of past and current events to “how” and “why,” focusing on past performance to determine which factors influence trends. In the Run Modes area, select the format (s) in which the document can be exported: •. SYMPTOM: Reports and Dashboards no longer display one of the two attributes that have been linked together in a VI Dashboard from cubes that are used as datasets. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. 4. 2. Right click on top of the regular attribute and the create attribute option won't be displayed. 4. Once data flows into the interface, the dashboard will come to life. Create a connection from external tools that can read from the CDM (Common Data Model) format. KB248510. 1 these privileges can be found in the MicroStrategy Supplemental Reference for System Administration guide. Output Mode. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize data into multiple chapters and pages to provide a. The binary generated for this mode is different from the binary generated for PDF. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. Assuming that a new Dashboard will contain 0 datasets, developers can insert logic to enable panels such as the "Add Existing Dataset" panel when a Dashboard has 0 datasets. That is accomplished with the connector. Create a new derived metric in a VI Dashboard with the formula below: Sum(IF((Year@ID=2014),Cost,0)){} 2. On Dashboard page, from tools menu, click the "add external data" option > add some data (Cube 2)> data is added in Dashboard Datasets > save the Dashboard. Reporting. In the following example, we enable concurrency scaling on the Amazon Redshift cluster for the MicroStrategy dashboard queries. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. The next step is to create filters. Incorrect data is seen in a metric calculation of an aggregate from base derived metric with date attribute filtering in Dossier/VI Dashboard when the attribute join behavior is set to Outer Join To Lookup. 11K KB34605: "Keep filter modifications" option when saving a prompt report is no longer available in MicroStrategy Web 9. Turn on Dossier Cache. Analyze Your Data. Create a new Custom Group by right-clicking on the right-pane of MicroStrategy Developer > New > Custom Group or File > New > Custom Group. Refresh the document and note that the format is lost; CAUSE: This is a limitation of MicroStrategy Office 10. Make sure 'Show Title Bar' is unchecked. MicroStrategy Dashboards allow any user to seamlessly transform MicroStrategy reports into interactive dashboards! So you can get Governed, high quality, sec. Learn more. 6, a new parameter has been introduced in the URL API. Populate & Evaluate Stage: Fill report data for display. Tableau. For examples of the different types of visualizations, see Visualizations in dashboards. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Limit the Use of Derived Attributes or Metrics. All visualizations will be publicly viewable. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsDashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. Microstrategy provides an equal number of visualizations as Tableau Desktop and also provides the same features like it. Dashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. This type of business analytics employs techniques such as drill-down, data discovery, data mining, and correlations to uncover the root causes of. ), and execute Java programs. One use case is to determine if a Visual Insight Dashboard is new. 3. Before Customization: After Customization: Launch the Web Customization Editor. Go to file system Shared folder, Cube 1 can be located and scheduled to refresh. (To follow the examples in this guide, click MicroStrategy Tutorial . mstrc”. jsp file that you downloaded or create a JSP file that defines your custom login page. The next time you create a new document, this new template is displayed in the New Document dialog box. 4. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the dataThis issue was fixed in MicroStrategy 10. STEPS TO REPRODUCE: 1. You can quickly create a VI dashboard from existing sources: reports, documents, and Intelligent Cubes. Make planning, designing, and implementing a solution easy. 4. Insert an HTML container (and not an image) and insert the script below. You can determine how the widget is displayed in different MicroStrategy Developer views and MicroStrategy Web modes, as outlined in the steps below. Save the modified HTML5VI_Content_Core file and restart MicroStrategy Web to apply the changes. Unfortunately, this often results in different copies of. Expert Help. To take advantage of this feature, the user can either specify a key, which can be obtained via code or in the html; or they can specify the sheet based on the index. Get inspiration at the MicroStrategy data dashboard gallery. Create a report with: MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, Attribute is lost from reports/dashboards that use a cube whose attribute was linked to another attribute in a VI dashboard in MicroStrategy 9. 1. In MicroStrategy 9. Visit the data visualization and data dashboard galleries for inspiration. The Calculated Member dialog opens. Avoid Images on Thresholds. In 2020 following their initial Bitcoin investment, their cash and cash equivalents asset allocation reduced by $397,052,000 or 86. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. Wordsmith is the world’s only self-service natural language generation engine. In the worksheet menu, select Move to. 4 and 10. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Creating Documents and Dashboard. Learn more. For example, the CEO of a technology company might want a personalized report or dashboard of focus group data on a new product within 24 hours. Content. x, a workaround is available below: STEPS TO FOLLOW: 1. 0. These auto text codes are automatically replaced by information about the document. Convert the Visual Insight dashboard to a document. "Create New Report" and "Browse All Objects" only appears if attributes are available in the project schema. These limitation will be removed in a soon to be released. 4. The purpose of this feature is to allow a user to execute a dashboard and when the dashboard is returned it will have selected specific sheet. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy for Jupyter is an extension for Jupyter Notebook which provides a graphical user interface for mstrio-py methods with the help of which user can perform all of the import and export actions without writing a single line of code manually. Create a VI dashboard and use the report created in step 1 as the underlying dataset. For information on connecting to databases, see Connect to Databases. Right-click an element in the grid and select Calculated Member. x. Choose one of the following: Save the metric. Dossiers. Observe the layout and color are different as shown below: CAUSE: This is a known issue with MicroStrategy 10. Right click on the padlock symbol, click on Properties and Formatting. Compare the options for embedding dashboards. 160. 1. To create a MicroStrategy Environment connection file . The next two steps are easy to follow: On the desktop page for large screen devices, add a basic Embed widget by dragging and dropping it into the main workspace. Run the following. Dossiers can be created by using the new Desktop product or. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. . Now explore the schema attribute in MicroStrategy's Workstation which allows you to create and edit the attributes such as facts, logical tables, metrics inside your workstation. Add metrics: Revenue, Profit and Cost to Vertical Axis. 4. The Select Dataset dialog box opens. Microstrategy Dossiers With the release of MicroStrategy 10. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the data In MicroStrategy 10. How? Select Save As from the File menu. Design workflows, create content groups, or customize application components with the no-code framework. blogspot. On Dashboard page, from tools menu, click the "add external data" option > add some data (Cube 2)> data is added in Dashboard Datasets > save the Dashboard. On the VI dashboard toolbar click the Add Dataset drop down list and click from DATA ANALYSIS 102 at NIT RourkelaUse a report with a metric qualification prompt as a dataset a VI Dashboard/ Document with a heat map visualization. But it’s nipping at the heels of leading BI software with cutting-edge capabilities and wins in a close MicroStrategy vs. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. “Dashboards have been critical in maximizing productivity and maintaining accountability of our teams,” says Frank Olivo of Sagapixel. MicroStrategy is a business intelligence tool that is widely used for deriving valuable insights from data in the form of visually insightful reports, graphs and charts. blogspot. Autotext code/macros in Microstrategy Document/dashboard. 2. After two update cache subscriptions (one with format HTML5 & one with format Presentation) created and triggered, all existing XML and HTML5 caches are deleted and a new XML cache created. Simple and minimal dashboard designs minimize clutter, enabling users to easily see and access dashboard elements. 0 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. If you do not use a Consolidation or Custom Group and right click on an attribute, the Create attribute option will be displayed. The Select Dataset dialog box opens. Add a graph matrix visualization. xTo create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Report created with Intelligent Cube. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. How to show hidden objects? In the Datasets panel, click the arrow icon in the top right. 2. To open the demo visualization in MicroStrategy Web, choose: Create > Upload MicroStrategy File > View Dashboard. Open the Diagnostics and Performance Logging Tool from the MicroStrategy Intelligence Server machine. Upgrade to this version to take. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 2. MicroStrategy (Nasdaq: MSTR) is the largest independent publicly-traded business intelligence company, with the leading enterprise analytics platform. Once you select the data from the source, the data is automatically added to an interactive grid. This article explains how to programmatically set a selector in a dashboard using MicroStrategy SDK 9. 4 - 10. Source: MicroRooster. Take this SEM dashboard, for example. To successfully link attributes between datasets at the document/dashboard level, a set of rules need to be followed. The following KB article iterates through the formatting properties and values of a grid object from a Visual Insight dashboard using the MicroStrategy Web SDK 10. Loading. Create a Visual Insight dashboard and add the above cube as the dataset: 3. If the New Document dialog box is not. At this point, we have created our two reports for our basic dashboard. This video tutorial demonstrates how to create an Agile dashboard from a classic report. Over 12+ years of experience in Data Warehousing & Business Intelligence application development, maintenance and various project implementations11+ years of IT experience with strong expertise in using MicroStrategy tool Suite as Reporting, dashboard and Administration. . Set the two metrics outer join; Run the report, add a new subtotal as below:. Modern Design for Dashboards . KB439316: The update cache subscription doesn't refresh the cache created by VI Dashboard in MicroStrategy 10. The impact is limited to the 'browse all objects' option on dashboard in MicroStrategy Web 10. MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy. 1. Add an attribute element prompt on Month. blogspot. MicroStrategy on AWS: Intro to Visual Insight. javac, jikes, etc. When users add an attribute with large number of elements into the Filter Pane of Dossier/VI Dashboard and set the selector type to Checkbox, a search box will also be displayed so users can search the elements, which is very convenient. x. This editor contains the "Condition" field by default, so you are able to select your filter normally from the list. This is a list of the available auto text macros that the Report Services Document engine recognizes. Filters within the filter panel can be expanded, collapsed and re-arranged. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. STEPS TO REPRODUCE The following steps are based on the MicroStrategy Tutorial project Using the. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe Import Data button does not work when creating a New Visual Insight Dashboard in MicroStrategy Web 9. Google Looker Studio: Best for Data Sources. Watch the MicroStrategy team review how to build dossiers with governed data and security filters, ensuring end users get the interactive insights that they need. MicroStrategy URL Parameters. A demo that describes how to create and use MicroStrategy Dashboards. What is a VI Dashboard? An object that utilizes Flash technology to create instant visualizations from new low-complexity data and existing BI Data. KB318925: The legend of the Document converted from VI Dashboard is missing after editing threshold in MicroStrategy Web 10. Use the Edit Links function to create a hyperlink to Target Report for each attribute. Visualize Flows with Sankey Diagrams. By linking dossier-style documents and dossiers together, you create the experience of a mobile app. “When we first started—and. Business intelligence (BI) tools enable analyzing, discovering, and reporting on data to help executives and managers make more informed business decisions. 4. To use the report as a data mart report, from the Data menu, select Configure Data Mart. Follow the steps below to reproduce the issue in MicroStrategy Tutorial project: 1. Published: Jun 7, 2017. There are several ways to create a Visual Insights dashboard from a prompted report. This video will go over MicroStrategy Visual Insight: What is Visual Insight (VI), What is a VI dashboard, Characteristics of a VI dashboard, Creating a VI dashboard, VI dashboard Panes, VI capabilities. A pie or ring chart requires at least one attribute and one metric. 5. This feature, however, might be distracting when designing or viewing a Free-form layout. 5 for iPad. 1 the ability to link between cubes was introduced, however this only works when linking cubes that are created with. Command. 2, the link sent to the user will take the user to a Report Services Document version of the. A MicroStrategy user ID to be linked to the address. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. Tableau Explorer. If you are looking for visualizations customized for MicroStrategy 9. 4. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. This explains why these fonts are not included in MicroStrategy Products. After converting a VI Dashboard to a document, the ‘Export to Excel’ option is not available when executing the document: CAUSE The ‘Export to Excel’ option is disabled by default in converted documents. When exporting a VI Dashboard to PDF, the titlebar does not fit the grid size in MicroStrategy Web 10. Avoid Duplicated Datasets. The columns correspond with each of the three required subscription properties: Physical address. Add metrics: Revenue, Profit and Cost to Vertical Axis. Each button can be configured differently and. Open the dossier you want to modify. In the Datasets panel, double-click attributes and metrics to add them to the visualization. To learn more about embedding dashboards for. This metric is used for getting "1" value for all rows. Change visualization to Line chart. Add Region in Horizontal Axis. Note that for custom visualizations to work in mobile, you need to also include the MobileBase plugin provided by MicroStrategy in the mobile plugins directory. WORKAROUND STEPS: 1. MSTR's Test) - Run the. CAUSE. MicroStrategy Parameterized Query feature for better performance. In the bottom left corner, click on the button "Generate Connection File". MicroStrategy. 1 some of the Dashboards do not have the option to link or unlink attributes. KB20300: After removing the Tahoma font in MicroStrategy Web 10. After creating custom threshold ranges and colors run the VI Dashboard/ Document. STEP 1: Enable the MCE trace. Using a text editor, either open the LoginPage. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. Performance Implications of Large and Complex Dossiers. CAUSE: This is a known issue in MicroStrategy Web 10. A sales team might use a business dashboard to connect data. Labels or Tags are types of classification components that help to categorize elements. Create links to other dashboards with more granular data. Select the Intelligent Cube, and click Next. . Follow the simple steps below to create a datamart report: 1. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to. As known, MicroStrategy Web preferences can be. MicroStrategy Workstation Become a More Intelligent Enterprise Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Our vision is to enable Intelligence Everywhere™. 3. If dashboards monitor metrics in real-time, scorecards measure progress towards a goal. Create Custom Tooltips. Delete the cube cache from cube monitor. This article demonstrates how to achieve the same in Report Service Document. • Chapter 2, Importing Data into MicroStrategy Desktop describes how to import data into MicroStrategy Desktop, for use in creating dashboards. Open the document in Design or Editable Mode. Create Dashboard A with the above report as the dataset. Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create. 5. Community & Support Search Discussions Open A Case View My CasesFollow the steps below using the MicroStrategy Tutorial project: 1. All the existing visual Insights dashboards will be converted to Dossiers. 4 Easy to use new editor for MicroStrategy documents and dashboards from VitaraCharts plug-in. Clear the Totals check box to remove the standard subtotals. x, what is the difference between the "Create New Report" option. But cube 2 is not listed in the file system. The Dashboard can be executed successfully. Create a report with any attribute and any metric. 1. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. All the existing visual Insights dashboards will be converted to. Microstrategy Web Advanced . Visualizations. You can immediately begin sorting, pivoting, and filtering data. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. STEPS TO FOLLOW: Create a new dashboard or document. It helps to browse and explore data with flexibility and also measure and observe data effectively. Once the Visual Insight page has loaded, navigate to the View Source option of the Web Browser. To create a customized autostyle, follow the steps below: Open a template or report editor and define a base template. The parent element appears in Parent. This article demonstrates how to achieve the same in Report Service Document. If this is the first time you're connecting to the MicroStrategy for Power BI connector, a third-party notice appears. MicroStrategy 10 Certification Training. MicroStrategy also has an intuitive dashboard and tools within the panel. Require users to answer prompts. . It is possible to use more than one cube in a single Dashboard. The following example shows how to access this in. Create a document with two selectors A & B (checkbox,listbox,drop-down selector) and a panelstack 2. The course also lets you analyze MicroStrategy data flow. MicroStrategy has no obligation to monitor the Communication Services. Show more. 0. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Elsewhere. When you re-prompt a VI dashboard that has apostrophe in it's name it fails to execute with a completely blank screen in MicroStrategy Web 10. Use Case 4. To open the demo visualization in MicroStrategy Desktop, double click the . Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. The worksheet query is stored in the dashboard and can be modified in that context. Create a derived metric (“New Metric”) with the following syntax: Sum([Metric String]){~+, [Attribute 2]+} Add that metric in a grid visualization, you will notice the cells are blank: Setting a threshold on a derived metric using the max function. 8. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. Right click on panel > Properties and Formatting. Assuming that a new Dashboard will contain 0 datasets, developers can insert logic to enable panels such as the "Add Existing Dataset" panel when a Dashboard has 0 datasets. Answer: Go with dossier. x, derived attribute returns only filtered row from one of the blended dataset, or in some cases returns NULL rows when it's defined with two linked attributes which exists in multiple datasets in the dossier/VI. Tableau Desktop has a provision to connect to any kind of data source and provides numeral native data source connectors. Format this dashboard yourself with the help of this 2 minutes video and before/after dashboard samples. Step 2: Add views to your dashboard by dragging sheets onto the dashboard. Number of years active 18. hex colors for dashboard how to make excel graphs look professional html colors for dashboard kpi template line. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. Example: It should be like 2nd dossier should be selected as Year=2017 and Month=Feb (as we have selected the same in Dossier 1) but we should also get the other elements in. Modify the existing Custom Group Element. Answer: Go with dossier. MicroStrategy on AWS: Intro to Visual Insight. )Victor Oliveira - Sales EngineerOrganizations struggle with making the lives of business users easier and with less steps on the process of self-service anal. 4 and 10. Right mouse click on the report and choose "Create dashboard". You cannot place the widget in the Detail section of a document. MDX Reports. Once you have your design requirements, we can begin looking at the different authoring capabilities between a dossier and a document. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCreate a dashboard VI on MicroStrategy web 10. 1. They are useful in creating custom calculations required by business. ACTION: The issue has been fixed in 10. Navigate to the document in MicroStrategy Developer. They are the derived columns which show results such as sum or average of some numeric values of a column in source data. The simplest way to design nested or cascading selectors is to design the entire dashboard first and leave the creation of the selectors to the very end. Ultimately, it. Python and R wrappers for the MicroStrategy REST APIs Connecting. It offers an intuitive way to create and modify BI. A VI dashboard is a customized, interactive display that you can use to explore your business data. If an environment does not already exist, an environment will need to be created first. From the left, click Document. 6 or above, ensure the steps in KB441194 are also implemented. Visualization with Multiple Datasets. 4. Followers. Save the document. Enable “Use as Information Window”. Gartner’s Magic Quadrant for BI and Analytics report will help. VI Dashboards allow users to quickly and elegantly display and consume data. 4. Whether it’s modernizing legacy systems or maximizing investments in your data and people. The following steps outline how to accomplish this: 1. A MicroStrategy user ID to be linked to the address. Users that are required to solely consume Visual Insight Dashboards without the possibility make changes or review dataset objects and filters, administrators may control functionality available to a given user or group through privileges: In order to prevent users from seeing the above panels, remove the Web Analyst privilege "Web Edit. This document explains the difference between the “Browse All Objects” option and the “Create New Report” option when creating a VI dashboard in MicroStrategy Secure Enterprise 10. If DHTML is disabled: From the drop-down list, under Format, select Legend. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. Create a compound metric called B with expression "RunningSum(A)" as shown below. Browse and incorporate these templates into your own data dashboards. An online search reveals that MicroStrategy has less market penetration than Tableau. 7) Data labels for line chart display overlapped with the line in VI dashboard in MicroStrategy Mobile 9. The steps to create a dashboard in Microstrategy are as follows: Click on Create on the left side of the Microstrategy web application. In a report, right-click an object and select Edit Links. CAUSE This is a known issue with MicroStrategy 10. Creating your custom visualization typically requires only a few steps:To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. From the Visualizations panel, select Grid . Hear from a trusted source BI initiatives come with many functional requirements and priorities, so finding the right platform can be tough. This is a first of many Dashboard videos and focuses on creating Dashboard templates that are reusable and can be moved between projects and project sources. MicroStrategy for Jupyter is contained within mstrio-py package and is available after. You can immediately begin sorting, pivoting, and filtering data. 3. 5. 11. This video shows a few tricks and tips to format and enhance your charts in MicorStrategy. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. This Tutorial describes how to set a Dossier/VI Dashboard as the Default Start page in MicroStrategy Web. MicroStrategy - Creating Metrics. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. • Providing guidance to other. 4. 4: Determine the delivery location (recipient) for the report or document by doing one of the following:. Filter the data, by the elements of an attribute or the value of a metric. Follow the steps below. MicroStrategy® Incorporated (Nasdaq: MSTR) (“MicroStrategy” or the “Company”), the largest independent publicly-traded analytics and business intelligRitinder Kaur Business Intelligence 1 comment. 2 and above, this can be integrated into a dashboard for easy navigation and user interaction. The Grouping panel is displayed. x-10. I will also demonstrate how to use panel stacks, s. The purpose of this feature is to allow a user to execute a dashboard and when the dashboard is returned it will have selected specific sheet. The email will contain a URL API link to the dashboard, however, in MicroStrategy Distribution Services 10. Create a document using these two reports as datasets.