how to install microstrategy tutorial project. The MicroStrategy Library installation includes the REST Server and the Collaboration Server. how to install microstrategy tutorial project

 
 The MicroStrategy Library installation includes the REST Server and the Collaboration Serverhow to install microstrategy tutorial project MicroStrategy Tutorial project are updated guide, as well current The sample documents and images in this as the procedures, were

evt. This course is will take you through basics of MicroStrategy Desktop Application right from downloading and installation to creating beautiful dashboards. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. The book starts by detailing the different. ” in the Help menu of your software. Click Yes. Download and Install MicroStrategy Desktop. MicroStrategy Architect opens. The theme of the Tutorial project is a retail store that sells electronics, books, movies, and music. 3. Starting MicroStrategy Web: I can access MicroStrategy Web by any computer that can run a browser. Notice that Windows Authentication is now enabled for login to the MicroStrategy Tutorial project. Building a Dossier Video Tutorials. •Pentaho is a Business Intelligence tool which provides a wide range of business intelligence solutions to the customers. How to create the connection file. Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. This video will help you get started using the MicroStrategy REST API. Navigate to the download site and download the Workstation installation files. The menu also provides. 14. Watch this on-demand webinar to learn why MicroStrategy Workstation is such a valuable tool and how you can leverage it as a one-stop shop for operating and administering your MicroStrategy ecosystem. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. If you are using an external dataset, you would choose and import the data you are using. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. The workflow for this sample is shown below: POST /auth/login. The theme of the Tutorial project is a retail store that sells electronics, books, movies, and music. Select Project Sources and click Next. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. xml. dossier. Deploy the ojdbc8. Note: The user can also do the same for any other out-of-the-box Microsoft Access databases in the MicroStrategy Analytics Modules (CAM, FRAM, HRAM, SAM and SDAM). Type the following command in the Windows command line: <Path> setup. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. 2. Schema objects include facts, attributes, hierarchies, and other objects which are stored in the Schema Objects. x, right-click on the project and select Delete, as shown in the following image: Method 2 - Via MicroStrategy Command Manager: A command in MicroStrategy Command Manager allows for the deletion of projects from. Expand the Database Instances category, and then select Connection Mapping. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. (Metadata and Warehouse are included) • It gets installed during standard installation. Open a new or existing dossier. CryptoRestart the Web Server. In the next screen, click the Node. 7. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. This example explains how to deploy this script with the MicroStrategy Tutorial project available with MicroStrategy Intelligent Enterprise. MicroStrategy Backup Preparations. In this sample, the documents returned by the GET /searches/results REST API are listed on the left side of the web page. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. MicroStrategy Analytics Modules. A typical project contains reports, filters to qualify the report data, metrics that. Step 2) In the Insert Panel. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. Log into the machine where you are installing MicroStrategy Desktop. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. It uses a javascript API to embed the dossier. Business users move seamlessly between all five styles of BI and even combine multiple styles. Learn the essientials of MicroStrategy Architect with this step by step crash course tutorial! In this video I cover lookup tables, fact tables, logical tabl. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. The steps to configure this access are below. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from cubes and reports, create new datasets, add new data to existing. Access MDUpdateUtil. MicroStrategy 10 is an optimized easy-to-use analytics platform that consolidates analytics, mobility, and security in a single integrated platform and delivers dashboards and compelling visualizations to enable data driven decision making to organizations and end-users through the AWS market place. How To Perform an Upgrade with MicroStrategy Backup. 18 and replace it in my Dynamic web project’s old connector. 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. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy. To access the Tutorial project, follow the steps in the section above to log in to MicroStrategy Web or MicroStrategy Developer. tips. Click on the Load button, as shown below: 5. Create basic node js server. js install button to start installing on Windows. MicroStrategy 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. x: Navigate to Programs -> MicroStrategy -> Tools -> Project Mover. You are focused on making sure these data sources are available in MicroStrategy, as well as defining their data structures and relationships for advanced data queries. To create a project source which connects to your data through Intelligence Server, see the Configuring and Connecting Intelligence Server chapter of the Installation and Configuration Help. Later in this MySQL tutorial, Commands like Select, Insert, Group By and advance topics like Wildcards & Functions are covered. MicroStrategy Tutorial. Click Connect. Cognos connection is a web portal that allows users to access Cognos 10 and studios. For example, the attributes Year, Quarter, Month of Year, Month, and Day in the MicroStrategy Tutorial project are gathered close together in the Hierarchy View, as shown below. The installation should be easy if you have a good server to install it in. Assign a friendly environment name. ETTING. Use the knowledge and skills you have gained to drive impact at work and grow your career. Includes this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, How until install he, history, architecture, characteristics, advantages, & applications. 3 : Select the Project Tables View. Even without coding skills. This eBook covers advance topics like Data Marts, Data Lakes, Schemas amongst others. x Addons and Tools : MicroStrategy Tutorial Project Files. Verify the components you want to upgrade and click Next . The Project Creation Assistant opens, as shown below: 3. The table below shows the URL parameters used to execute a document using the URL API. Example using the MicroStrategy Tutorial project: Create a new, empty report. By default, the MicroStrategy Tutorial project is provided as part of the MicroStrategy Analytics Modules project source. Configuring administrative access to MicroStrategy JSP applications . Click the MicroStrategy connector. reportViewMode. 2. Double click the MicroStrategy Installer package. 2 release, the driver file is called odbc8. These projects are tuned for a Microsoft Access warehouse. Create a grid report with the all_sales. • Open a new or existing dossier. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. the user needs to install Microstrategy Architect 9. Click on JDK Download for Java download JDK 8. 5K subscribers Subscribe 3. This tutorial steps through the various capabilities and pages within the Administration portion of a MicroStrategy Project Source. To start the Report Wizard. reportName. Download and Install MicroStrategy Workstation. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. To ensure high performance testing use Jmeter for outstanding results!Includes this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, Whereby to install to, history, architecture, features, advantages, & applications. Instructions for installing, configuring, and using the MicroStrategy Evaluation Edition of the software. You can see this in the diagram in Testing an Environment for the First Time, or by looking at the Intelligence Servers on your MicroStrategy Web Administrator page. Before you begin, exit all applications which may interfere with the installation process. Create the 'Tutorial WH' and 'Operational DM' DSN's in the Intelligence Server Machine 2. To add data to the visualization in this example, you use an existing dataset in the MicroStrategy Tutorial project. Request a demo. This example explains how to deploy this script with the MicroStrategy Tutorial project available with MicroStrategy Intelligent Enterprise. • It has precreated objects, designed to provide an overview of the capabilities and rich functionality of the MicroStrategy platform. When MicroStrategy is installed, there is the option to install MicroStrategy Analytics Modules. This file is the same for both versions and has. P. Log on to the machine where you are installing one or more MicroStrategy products. In the Project Source Name field, type a name for the project source. Thanks, Nitin As part of the 10. Place the installation files directly on the machine you intend to install MicroStrategy on; Ensure that you have a License Key for the version of MicroStrategy you are trying to install; If installing MicroStrategy Office ensure that Microsoft Office is installed prior to running the MicroStrategy Installer; MicroStrategy Office InstallationSOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. We highlight best practices to ensure you successfully upgrade and validate your customizations on the latest release, and share tips and tricks to help you avoid common. Second, create an attribute that contains the longitude of each store and assign it the Longitude geo role. To create a project in DataStage, follow the below steps: Step 1) Launch DataStage softwareTo access the MicroStrategy Installation Wizard. In this case, I created two that I plan to embed. Include this MicroStrategy (MSTR) tour, we will learn Whats is MicroStrategy, How to install it, history, architecture, features, advantages, & business. After installing MicroStrategy, you must complete a few configuration tasks. This new license key can be easily attained from the MicroStrategy download site . Download your preferred platform version into the RDP. This sample uses REST APIs to authenticate the user, get all of the projects, get the configuration-level folders for a specified project, and search for objects in the root folder. This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. Conceptually, a project in MicroStrategy is the environment in which all related reporting is done. In the Device Editor, click the Delivery Options tab. 3. Friends,We provide industry standard online training on MicroStrategy Development, Administration and live project development with hand-holding support of e. Installing and configuring Enterprise Manager. sql files of the Metadata and Warehouse into your MySQL Server Section 2: Creating DSNs for your Tutorial Databases in MySQL MicroStrategy Sample Projects. x server. Data Warehouse Tutorial Summary. exe. MicroStrategy for Jupyter is contained within mstrio-py package and is available after. In this MicroStrategy (MSTR) tutorial, we will lern What is MicroStrategy, How the install information, story, architecture, features, benefit, & requests. If the call is successful, the. If no project sources are defined, then the Configuration Wizard opens. Connecting to Environments in Workstation. ) ,. The information in a dataset can include MicroStrategy objects such as attributes, custom groups, consolidations, and metrics. mstrio provides a high-level interface for Python and R and is designed to give data scientists and developers simple and secure access to MicroStrategy data. MicroStrategy 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. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. An administrator must install the driver for your data source. Before you begin, exit all applications which may interfere with the installation process. Jenkin is the most popular, open source Continuous Integration tool. Specify the port number where the SMTP server receives incoming e-mail. To log in to a specific project, see Starting MicroStrategy, page 2. For example, in the command prompt, type. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. Click on the plus symbol with the label of Connect to a New Environment. All articles. Create a metric with the ApplySimple statement below as its definition and name it. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For JSP: <install directory>\MicroStrategyWS\projectsources. (Note: Target runtime should default to Apache. mdb). Cards. All articles. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". These include the Human. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Connecting to Environments in Workstation. W. This demo will guide you through creating a Data Source Name, and a database connection to a Microsoft SQL Server Database in both Developer and Web. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformClick Yes to open the command prompt with administrator privileges. You will be able to: - connect to MicroStrategy Server. yaml file. Enter your API Server and select your authentication mode and enter your credentials. To plot a sales line for the expected future sales data, apply linear extrapolation techniques to the historical data. Access – LifeTime Download. Many of the examples use the MicroStrategy Tutorial, which is MicroStrategys sample warehouse, metadata, and project with reports. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. Basically, this option will install two sample projects: MicroStrategy Tutorial and Human Resources Analysis Module. In this tutorial video, we'll show you how to download and install MicroStrategy Workstation on your computer for free. Some database-specific object definitions may need to be changed if Tutorial is used on another platform. These two projects are installed and configured. MicroStrategy tutorial project is an excellent tool for beginners and experienced MicroStrategy developers to learn about MicroStrategy and explore its features. Some database-specific object definitions may need to be changed if Tutorial is used on another platform. MicroStrategy Workstation is a powerful tool that lets y. Locate and run the Setup. . Please contact rgs4554@gmail. Intelligence server ensures the scalability and fault tolerance required for analysis of terabyte databases and millions of. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. For steps, see Starting MicroStrategy Developer. configure a project to collect statistics. 8. 1. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. PHP Projects — Create an Opinion Poll Application. Install MicroStrategy Intelligence Server and Telemetry Server; Configure Telemetry Server (Telemetry-Kafka + Telemetry Manager-Zookeeper) Configuration via MicroStrategy tools. For a description of each area or pane of the MicroStrategy Web Report Editor and Design Mode, see MicroStrategy Web Report Editor interface. This endpoint allows the caller to get the list of projects with the MicroStrategy REST Server. The steps to configure this access are below. yaml file: Encrypt the pgWhPasswd using the Platform Analytics tool. Visualpath. Start building with MicroStrategy to deliver exceptional product experiences. 0. 3. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. I do want to note however, when you perform the Desktop installation, install the 'MicroStrategy Tutorial' component. Select Scripts. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. View changes and push updates to end users in seconds. To do it, hover over the icon and click Edit Connector. This guide gets you started using the UNIX, Linux, and Windows versions of the MicroStrategy platform. It is designed to help developers build data-driven client applications quickly and easily. There's a reason we're at the top of the list. The entire liability of MicroStrategy, Inc. Users can click on the 'Get Projects' button to access. ) Install MicroStrategy 10. This provides data scientists access to trusted, operational. This Knowledge Base article introduces "mstrio," Python and R packages which provide an interface for the MicroStrategy REST APIs. documentID. 8. Before we start you will either need to create a new Dossier or use an existing one. For steps to install the MicroStrategy Analytics. java from the Creating a Session topic to create a session on the MicroStrategy Tutorial project and then creates a folder under the Shared Reports folder and moves a report into it. The same is applied when deleting a user programmatically via MicroStrategy Web SDK. x. Will let you know more about it once I started using it. 6 : Select an attribute that is to be a parent attribute in an attribute relationship. The MicroStrategy platform includes a Tutorial project, which is a sample data warehouse and a demonstration project you can use to learn about the various features. MicroStrategy Tutorial project and application set designed to illustrate the platform's rich functionality. This communicates to the various data sources, and runs the reports and distributes to MSTR Desktop and Web users. Wherever you can define an expression, you can use a function. This guide also includes a detailed, step-by-step evaluation process of MicroStrategy features, in which you perform reporting with the MicroStrategy Tutorial project and its sample business data. In this tutorial, we will consider only the Windows version. THIRD PARTY SOFTWARE INSTALLATION WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of. Instructions on how to install MicroStrategy Desktop on a Windows or Mac machine. How to Install and Setup MicroStrategy. Both the data warehouse and the metadata databases reside on Microsoft Access. To see sample dashboards in Developer. Make sure not to duplicate users and groups, and use the destination ACLs. The MicroStrategy Tutorial project has been tested on a warehouse and metadata in Microsoft Access. 0 or later is required to install MicroStrategy products on a. OCUMENTS AND. Published: Dec 28, 2017. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. Set Intelligent Cubes to Publish and Trigger initial Object Migration. Specify the IP address of the SMTP server. MicroStrategy Tutorial project are updated guide, as well current The sample documents and images in this as the procedures, were. as well as an installed MicroStrategy suite of products. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and so on. This will basically copy over an access Metadata and a 2-tier project source already created in Desktop, so you can browse around and take a look at a pre-built environment. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. 👉 Lesson 3. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other. Then use the two Latitude and Longitude attributes to provide latitude and longitude information for map markers in the visualization. Next, select the seed. Select the metadata databases that contain the source project. 1. Employees, Inventory, Finance, Product Sales and Suppliers are analyzed. The access to a single project in a project source can be denied or modified by using a Security Role. A project is the highest-level of intersection of a. 2 : Right-click the MicroStrategy Tutorial project and select Architect. Installation and Configuration Guide Version: 9. 23. 4. For installing the missing package, run the below command: yum install <missing package>Follow the steps below to create the Sum of Last and Last Quarter subtotals in the MicroStrategy Tutorial project: Create a custom subtotal with the formula 'Last(x) {@}' as shown below: Save this subtotal as 'Last(x). If an active connection is detected, the session is renewed. Open the Microsoft Access database selected in Step 3 select Database Tools > SQL Server as shown below. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. select_project(project_id: str | None = None, project_name: str | None = None) → None ¶. 2. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. In MicroStrategy Web, log in to the Tutorial project. MicroStrategy provides a set of packaged analytic components built using the MicroStrategy platform. It gives you an opportunity to familiarize yourself with the Web interface and learn some basic. 6. When a Connection object is created the user will be automatically logged-in. 2. MicroStrategy doesn't support installing an older version over a newer, installed version. 31. Data Warehouse Tutorial Summary. To do it, hover over the icon and click Edit Connector. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. For UNIX and Linux installations, this guide assumes a basic understanding of how to use UNIX and Linux either from a UNIX/Linux server or by using a viewer on a PC. Choose Add Data > New Data. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. In aforementioned MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, How to installing it, history, architecture, features, advantages, & applications. . No oral or written information. To allow users authorized to access MicroStrategy Web Administrator, MicroStrategy Mobile Server Administrator, you must create the users and assign them the role of admin under the Tomcat user configuration file. MicroStrategy Workstation is a powerful tool that lets you administer and control both projects and environments, providing tools for data discovery and visualization. View changes and push updates to end users in seconds. The image below shows the default projects that appear if all default installation options were accepted during MicroStrategy installation. Note: to log into Library and use mstrio user needs to have UseLibrary privilege. Step 8) Complete the installation Click the Finish button to complete the installation. They are located under samples in the SDK installation directory. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (following examples use the MicroStrategy Tutorial project for illustration purposes. These two projects are installed and configured automatically. There are two methods of determining a Project's version: Using the MDUpdateUtil tool. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. The command prompt is displayed. 2. MicroStrategyの各マニュアルは、以下のページをご覧ください。. TensorFlow CNN Image Classification — Learn with Steps & Examples. In MicroStrategy Web 9. Changing the system configuration or subscription information can cause the MicroStrategy Tutorial - Delivery project. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. Learn the essientials of MicroStrategy Architect with this step by step crash course tutorial! In this video I cover lookup tables, fact tables, logical tabl. Select the desired Project Source (Data Source) and click on Next, as shown below: Upon clicking Next, the following window shows the. You can use multiple events to add additional actions when you execute a document. •. MicroStrategy Desktop - The MicroStrategy Desktop environment is very intuitive. Pentaho Business Intelligence is widely used by 1) Business analyst 2). From the Start menu, select Run. If you display tables in logical view, the options in the Project Tables View area can be used to modify the display of data within tables in. and your exclusive remedy, shall not exceed, at the option of MicroStrategy, Inc. From the Start menu, select Run. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. select_project(project_id: str | None = None, project_name: str | None = None) → None ¶. Installation is easy when using pip. A. The menu also provides features to connect to a server if required, view the data sets available, the visualization gallery, and data filtering options, etc. Using this data, you can forecast potential sales for the upcoming years. 2. In this MicroStrategy (MSTR) tutorial, are become students What is MicroStrategy, Select to install it, history, architecture, features, advantages, & applications. MicroStrategy 7 The MicroStrategy Desktop environment is very intuitive. With the integrated option Connect to New Environment: Open Workstation window. Click within the Dataset Objects area to add datasets for the document. Exit all Windows applications before beginning the installation process. Helps you to manipulate the database in a single package. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. e. Once all of the fields have been populated the file can be saved with the configuration options. For example, the MicroStrategy Tutorial project includes a Month of Year attribute which retrieves its primary information in English from the LU_MONTH_OF_YEAR table shown below: For the purposes of this example, you can assume this data is stored in a database named Tutorial (English). email protected] Send suggestions for product enhancements to: [email protected]In MicroStrategy Web, log in to the Tutorial project. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. They consist of the following: Project metadata configured to work with the demonstration warehouse that contains the projects. Program Files (x86)MicroStrategyTutorial ReportingCSVFilesOperational_datamart. . 5. Pentaho suites offer components like Report, Analysis, Dashboard, and Data Mining. MicroStrategy Installation and Configuration provides comprehensive information on how to install and configure MicroStrategy software, as well as basic maintenance guidelines. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. You also provide your projects in Spanish and German. On the Builder page, do the following: Choose the login task from the Task ID combo box, set the Task Envelope to "XML", and set the Task Content Type to "XML (Default)". Install Checklist Install with. The 'Available database types' (left pane of the dialog window) is now populated. 8 platform install, the install process will prompt for a license key. It also provides many examples using the sample Tutorial project that comes with MicroStrategy. Create the respective DSN's in the Intelligence Server machines . Better to use a larger VM for quicker installation. . A project source is required to run MicroStrategy Command Manager and connect to a metadata repository. MicroStrategy Tutorial teaches you Step-by-Step from the basics to more advanced topics. 1. 3 or higherR Script Example. Select a dataset. 👉 Lesson 13. Business, Economics, and Finance. Learn how to download and install the MicroStrategy Intelligent Enterprise Platform, MicroStrategy's suite of tools that lets you control and derive insights from. In this MicroStrategy (MSTR) tutorial, we will learned Something is MicroStrategy, Like to install it, history, architektonischer, features, pros, & applications. INDOWS Introduction. The following SDK sample code demonstrates how to delete a user and its profile using MicroStrategy Java Web SDK. Learn how to use an external REST client to run MSTR related REST requests. Add the attribute Subcategory and metric Revenue to the report template. How To Install MicroStrategy Part-1 Tutorial By Visualpath. Click the Builder tab. Click the MicroStrategy icon, and select Create Document. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. Replace the pgWhPasswd entry with the encrypted key. Notice that the DB instance 'Tutorial Data' is used, as shown below:5/5 videos | 17M 9S total runtime. It uses a javascript API to embed the dossier. the to reflect the Dates inyear. WebObjectsFactory; import. Visit the data visualization and data dashboard galleries for inspiration.