microstrategy tutorial project download. x and 10. microstrategy tutorial project download

 
x and 10microstrategy tutorial project download  The steps to configure this access are below

Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions; Resources;. MicroStrategy Tutorial ; MicroStrategy Cloud Community Connectors; Third-party software libraries. Risk-adjusted returns of currencies, indexes, metals, stocks, & bonds vs BTC. Link a MicroStrategy user to a windows user in MicroStrategy Developer, by going to Authentication - Metadata, as shown below: Go to the MicroStrategy Web Services machine and locate the ProjectSource. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. As an Analytics Architect, you are exposed and asked to leverage an ever-growing list of data sources within your Intelligent Enterprise. Double-click the Region attribute to add it to the. To Access Fact Expressions For a New Fact with an Expression. Click the MicroStrategy icon, and select Create Document. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server;If you do the same task in the MicroStrategy Tutorial project is it slow? If the issue is a report/document is it also slow in Web? We will need the following logs to start the troubleshooting process: DSSerrors. When we place some common attribute or metric in multiple visualization, it is easy to study the variations among them. MicroStrategy Desktop's intuitive toolset and built-in templates make it easy to build compelling analytical books of visualizations, dashboards, and reports in a matter of minutes—we call these MicroStrategy Dossiers TM. App Description: This App is a sample demo app to show the users how to use MicroStrategy REST APIs as well as how to embed dossier (s) into a 3rd party application. This chapter shows you how to log in and get started using MicroStrategy Web and MicroStrategy Developer. Request a demo. " Save it in My Objects. Watch on. Python coding is short, minimal and easy. MicroStrategy logo [][cran] mstrio: Simple and Secure Access to MicroStrategy Data . Click on the data set “Population by country” and select “Edit Data Set”:CONTENTS BookOverviewandAdditionalResources vi 1. The steps also include an example for most steps, based on Tutorial sample data in the MicroStrategy Tutorial project. The Year - Define a new member attribute expression dialog box opens. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. !Now, let’s create create a dashboard. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. SQL Server DataTypes with Examples — Varchar, Numeric, DateTime in SQL. AuthorURL API. From the View menu, select Report Details. View changes and push updates to end users in seconds. The MicroStrategy architecture is a meta-driven type where metadata is the central repository of all the objects and can be used by all of the MicroStrategy products. However, to add other project sources, users can perform the following steps: Go to C:Program FilesMicroStrategyWeb Services (this is the default MicroStrategy Web service installation folder), and. Description. passwordConnect to MicroStrategy Using a Workstation Identity Token. Name. xml file under C:Program filesMicroStrategyWeb Services. csv file format, will not be exported surrounded by quotes, whereas all subsequent object columns are. LOAD PROJECT "project_name ";where: PROJECT "project_name" is the name of the project to be loaded, of type string. By default, the MicroStrategy Tutorial project is provided as part of the MicroStrategy Analytics Modules project source. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. You will be able to: - connect to MicroStrategy Server. The object's editor or wizard opens. Schema objects include facts, attributes, hierarchies, and other objects which are stored in the Schema Objects. UNLOCK PROJECT "MicroStrategy Tutorial" FORCE; . You can view the updated status through this API. 1. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. The connection process to Excel files involves the following steps: To connect to Excel file data, you must first prepare the Excel file as a valid data source and create a data source name for the Excel file. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. Log on to the machine where you are installing MicroStrategy Workstation. Select project for the given connection based on project_id or project_name. !In this case, we are going to use the “MicroStrategy Tutorial” project, but you have to choose theYour Story. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. Our experts demo best practices for some of the most popular use cases Workstation helps you seamlessly accomplish, like importing. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click Select. This VB . Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. If an active connection is detected, the session is renewed. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. This reads the settings from the updated DATABASE. The system hierarchy is displayed. The logical data model provides a picture of all the pieces of information necessary to understand your data and how it relates to your business. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Best for digitizing all HR processes. Functions in MicroStrategy are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-selected calculations. Follow the instructions and copy the project to your 3-tier project source. The ITIL full form is Information Technology Infrastructure Library. Opening the login page to gather user for credentials. 2. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. count = projects. To do it, hover over the icon and click Edit Connector. Self-Service Analytics with Amica. Open a report. The steps below explain what is happening as the custom ESM attempts to authenticate a user and create a session. This tutorial steps through how to switch to Free-form Layout within a Dossier. htm" SHOWSTATUS TRUE IN PROJECT "MicroStrategy Tutorial";MicroStrategy is a powerful Business Intelligence and Visualization software. The Tutorial project includes sample data, such as actual customer names and items purchased. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Notice that the DB instance 'Tutorial Data' is used, as shown below:Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. To start with ReactJS, we need to first import the react packages as follows. Note, in the traces above "Project -1" will be occur when the user connects in a three-tier project source. The main goal of cloud computing is to give data centers access to many. The table below shows the URL parameters used to export a document to PDF using the URL API. MicroStrategy - Creating Dashboard. In. If the call is successful, the. Click on the upgrade button. For steps, see Starting MicroStrategy Developer. MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. The tutorial is composed of a MicroStrategy 2020 project, MicroStrategy Tutorial (a metadata and sample data are included). . The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. Specifies the ID of the report services document to export to PDF. 7) Checkbox. Workstation makes it easy to build compelling visualizations and interactive dossiers in a matter of minutes and then easily share those dossiers with others. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click Next and select the project wanting to. Getting Started with MicroStrategy Reporting. 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 that MicroStrategy offers. After changing the description for a project in MicroStrategy Developer 9. Please contact rgs4554@gmail. Workstation is the only space for analysts and app architects to build and manage content of all types. This graph report is a modified version of the graph report named BoxPlot - Visualizing Statistics of Daily Revenue by Quarter, which is available in the MicroStrategy Tutorial project. List Attributes statement. It is the on-demand availability of computer services like servers, networking, databases, data storage, etc. From the File menu, select New, and select the type of object to create, such as a report or a filter. 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. This behavior is inherent to Microsoft Excel. Users can click on the 'Get Projects' button to access. MicroStrategy Workstation is a powerful tool that lets you administer and control both projects and environments, providing tools for data discovery and visualization. Open Workstation in smart mode. On the top right side click on tab Free trial from the main page. -u Username: Identifies the user name to be associated with the project source name. Conceptually, a project in MicroStrategy is the environment in which all related reporting is done. Item I, project . Custom visualizations are not automatically enabled for all projects in MicroStrategy Web 9. Expand the Database Instances category, and then select Connection Mapping. Assign a friendly environment name. It uses a javascript API to embed the dossier. - push data back to MicroStrategy and save it as a new cube. 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". Read these top trending MicroStrategy Interview Q’s that helps you grab high-paying jobs! To see a report’s filtering information in Desktop: 1. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. 2. Project default data language is different from dossier data language; Dossier attribute is mapped to project attribute; Blank cells for the attribute; Glossary How to Map Imported Data to a Project Attribute Steps to Reproduce The following example uses MicroStrategy Tutorial Project. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server;Connect to your Microstrategy Tutorial (Direct) project source, right click on the Microstrategy Tutorial project, and click "Duplicate Project". Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. Identify the report by passing the report ID in the path of the request. Reports. Visit the Download site now. Executes the report services document specified by the documentID argument. Write project name. Employees, Inventory, Finance, Product Sales and Suppliers are analyzed. 1. After failing to connect to a Intelligence server, the Project list drop-down list appears as blank at the "enter Base Project Information" page of MicroStrategy Integrity Manager Wizard 9. 2 KILOBYTE Views 24 min read Updated on March 6, 2023 Like part of this MicroStrategy training you will learn what to get started with MicroStrategy reporting, how toward commence the MicroStrategy Office, starting this MicroStrategy Rail, opening an report, components. User without the Web edit Dossier privilege cannot edit a dossier by navigating from Library Web to MicroStrategy Web. 11 and change the Data Engine version to 2019, the reports which use transformation metric with multiple transformation levels show incorrect data and SQL as the data were retrieved from lower level fact tables, e. When accessing the new Download site, you are immediately greeted with key components of our latest platform release, along with any updates or additional tooling that is available for the release. How to use Guacamole to copy and paste text or files in. Notice that Windows Authentication is now enabled for login to the MicroStrategy Tutorial project. 1. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. Download Salary Trends. Deploy the ojdbc8. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. List Project Configuration Properties statement. Create another report with the Year attribute and the prompt in step 2 (report B). Locate the Imported Cube and right-click on Create Dashboard . Ports and connectivity informationIn MicroStrategy Web, log in to the Tutorial project. g. This is useful in the context of the out-of-the-box MicroStrategy Web, as well as when integrating MicroStrategy Web with an external Web site, portal, or other third-party application. Navigate to MicroStrategy Tutorial and expand. For Oracle 12. 2 Publisher: MicroStrategy Installation Instructions: To view this dossier with the visualization, download the . Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Business Intelligence with MicroStrategy 10 Analytics. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. VB. yaml. project_name is the name of the project, of type string, between double quotes ("). As part of this MicroStrategy tutorial you becomes learned how to get started with MicroStrategy how, how to start the MicroStrategy Desktop, starting the MicroStrategy Webs, opening a write, components of an report, row and columns, grids and graphs, OLAP services and more. Step 2) Add Trial Info and qTest Info. If you want to set up a new system using your own data, you must read this chapter. Loads a project in an Intelligence Server. Open the MicroStrategy Tutorial Project. The page component that should handle the action and the event. Video Tutorials; Product Documentation; Education Courses; Blog; Solution Gallery; Get Help. Download the O’Reilly App. Reports. Click on download community edition your download will begin. With Architect, you can create and modify multiple facts in your project quickly from an integrated interface. Data Warehouse (DWH), is also known as an Enterprise Data Warehouse (EDW). On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Download MicroStrategy Badge for your iOS or Android device. Before you begin, exit all applications which may interfere with the installation process. 👉 Lesson 3. 2. This graph report, named Scatter Plot Chart - Revenue vs. Make sure not to duplicate users and groups, and use the destination ACLs. 4. 1. The theme is an Electronics, Books, Movies and Music store. Step 6) Once the software is installed click on start free trial. To access documentation resources on Windows. It will enable you to gain in-depth knowledge on MicroStrategy architecture, designing schema objects using MicroStrategy web and desktop, scorecards, etc. It provides a way of organizing facts so that they can be analyzed from different business perspectives. Metric Editor -> Tools -> Metric Joint Type. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. The MicroStrategy Office User Guide covers the instructions for using MicroStrategy Office to work with MicroStrategy reports and documents in Microsoft® Excel, PowerPoint, Word, and Outlook, to analyze, format,. jar. MicroStrategy offers an intuitive way to create and modify business. Provide the Environment URL and click Continue. x to Excel as a . It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. This VB. In this tutorial we are going to discuss Installation of MicroStrategy. MicroStrategy download site to. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. Apache Jmeter is a popular open-source performance testing tool. x utility by going to Start -> Run -> CMDMGR. Both examples can be found in the MicroStrategy Tutorial project in the following folder: MicroStrategy Tutorial/Schema Objects/Facts. xxx. Dossiers. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Click on “downloads” in Windows file explorer. reportName. Optional. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. After downloading, the installation is a very straightforward process in which you need to MicroStrategy comes with a sample project called MicroStrategy Tutorial. Related articles from the Community: Knowledge Base: Free-form layout in Dossier; Knowledge Base: Best Practices for Creating responsive DossiersMicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. The MicroStrategy Tutorial is a MicroStrategy project and a set of demonstration applications designed to illustrate the rich functionality of the MicroStrategy platform. To view sample RS documents created for each mobile device, in the MicroStrategy Tutorial project, navigate to the Shared Reports folder. Download MicroStrategy Desktop. Cards. Allows users to export reports directly to PDF. The Open command searches for the project source by name. MicroStrategy Architect opens. After the attribute form names are enabled, the grid will display. For technical details on the MicroStrategy Tutorial, see the MicroStrategy Project Design Guide. Item 0, projectSource 'Get the collection of projects for the project source. SAP HANA can load data from SAP and Non-SAP data source through SLT, BODS, DXC, and Sybase. You can fast-track onboarding new employees. When the user clicks a document in the list, it is embedded as a dossier in the right pane of the web page. Learn techniques for analyzing how to best customize aspects of MicroStrategy Web to. Example. This report has two attributes and three metrics. 👉 Lesson 1. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. We fixed 157 total defects with Hotfix 8 (10. Class Summary Behavior Driven Development (BDD) is a rising methodology to test and check your code. Download & Install Node. Select the folder to open based on the device you are using. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. Bypassing the login page by providing credentials in the URL. Users then see the Connect to MicroStrategy window. Types of Filters in Tableau — Condition by Formula, Extract, Context. 1. 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. 3. 1 and 10. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere. Click the MicroStrategy icon, and select Create Document. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. To explore this sample project data, in the Folder List expand MicroStrategy Tutorial, then expand Public Objects, then expand Reports. Privileges allow users to access and work with various functionality within the software. x Addons and Tools: MicroStrategy Tutorial. projectSource. MicroStrategy Architect opens. Create a new metric "My New Revenue Metric" and add a description: "This is a testing metric. Open the workstation-mac-x. 4. Create your First Cucumber Script (2 Examples) 👉 Tutorial. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Using system prompts, users can use. From the File menu, select New, and select the type of object to create, such as a report or a filter. 4. Navigate to the download site and download the Workstation installation files. 99 until Nov 24. The MicroStrategy Analytics Module project source includes the MicroStrategy Tutorial project. MicroStrategy's. All articles. Enable users to interact with personalized chat for further product discovery. The steps to configure this access are below. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. 👉 Lesson 2. In this scenario "Project 0" corresponds to "MicroStrategy Tutorial". Watch on your big screen. Click on the plus symbol with the label of Connect to a New Environment. More details are explained below with an example from the MicroStrategy Tutorial project. All users created in the MicroStrategy system are assigned a set of privileges by default. The REST API is designed to help developers build data-driven client applications quickly. Create the respective DSN's in the Intelligence Server machines. If you are using the MicroStrategy Tutorial project and its sample data, log in to the Tutorial project. Check out our publicly available live demo environment where you can run reports and documents and dashboards at demo. Because of this, in a project where many changes are continuously made to a given project, the size of the Change Journaling tables (DSSMDJRNXXXX tables) can quickly increase. Goto “src”. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In this demo, we show documents in the MicroStrategy Tutorial project under Public Objects folder. Click the Load button. To create a Pareto grid like the one above, follow the steps below in the MicroStrategy Tutorial project: Create a report with Region on the rows and Revenue on the columns, as shown below: Create a RunningSum metric on Revenue to use for creating the cumulative percentage later, as shown below:The MicroStrategy Project Design Guide provides comprehensive information on planning, creating, and modifying a project in MicroStrategy and covers a wide range of project-related topics, including the following: BI Architecture and the MicroStrategy Platform, provides an introduction to business intelligence architecture and some of the. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. Specifies the ID of the report to execute. MicroStrategy製品にバンドルされるPostgreSQLデータベース、あるいは、お客様ご自身のPostgreSQLデータベースにMicroStrategyTutorial_2021_FilesDatabases配下の. To display one gauge that displays data for every item, place both the metric and attribute in the columns. 2 : Right-click the MicroStrategy Tutorial project and select Architect. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. Go to Web Preferences and select Project Default -> Grid Display. Explore the folders and double-click any report or dashboard to run it and see the sample data results. Provide the Environment URL and click Continue. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. Follow the steps below to reproduce the issue in the Microstrategy Tutorial project: Create a report with Subcategory and Revenue. Bitcoin Strategy. Click the MicroStrategy icon, and select Create Document. Open the MicroStrategy Tutorial Project. Unload Project statement. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. Related versions:The MicroStrategy REST API is an Application programming interface that lets developers quickly extract subsets of pre-processed data in JSON format. Step 7) In next screen, Enter Email address and click on activate button. 2 Right-click the MicroStrategy Tutorial project and. Use. Published: Apr 27, 2017. 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. Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create filters, prompts and metrics. Open MicroStrategy Web and click New Dossier. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the. Follow the steps below to reproduce this issue in the MicroStrategy Tutorial project: Create a simple report with multiple prompts, as shown below:. Tutorial Project Filesを利用するTutorial環境のセットアップ. The sample URL shown below illustrates how to export the "Electronics Revenue vs. It is ready to be used and requires no additional configuration tasks. The default folder is: C:\Program Files (x86)\MicroStrategy\Product Name when installed on a 64-bit Windows environment. Log in to the MicroStrategy Tutorial sample project. To log in to a specific project, see Starting MicroStrategy, page 2. Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Products AI / BI Platform AI Apps Multi-Cloud Dossier Library Workstation HyperIntelligence Embedded Analytics Innovation Futures Solutions Roles IT Leaders. Specifies the ID of the report services document to export to PDF. . PDF Version Quick Guide MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. We fixed 157 total defects with Hotfix 8 (10. List Project Configuration Properties statement. Create the respective DSN's in the Intelligence Server machines . Step 9) Click on “Launch” button. A project is the highest-level of intersection of a. ; In the Project Source Name field, type a name for the project source. Create the respective DSN's in the Intelligence Server. The Expression page is where the expression is built. Select the desired option for 'Show attribute names'. Create an attribute element list prompt for the Year attribute. This REST API authenticates a user. 2. UNLOAD PROJECT "MicroStrategy Tutorial";How to Create a New Database Instance Using the MicroStrategy Web SDK 9. This privilege is required to define conditional formatting. INFO College Research Groups. reportID. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. By. Next. Double-click the Region attribute to add it to the. Step 5) Once the download is completed click on the setup file. The mstrio-py Python library provides a Connection module to initiate a session with the Intelligence Server. Nothing here yet? Log in to post to this feed. This will launch the Upsizing Wizard. Can be used instead of reportID. It is best for real-time voice call changer filters and sound effects to. 8), of which 78 were reported by our customers. These fixes address performance (8), security (5), and stability (24) among other issues. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. This Python script example will help you to: 1) List all OLAP cubes in your project 2) Download real SQL query for each cube 3) Parse the SQL and extract details about tables and columns being used 4) Export gathered details to CSV files for further processing. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". PrerequisitesNode. 3. Use the sample Tutorial project to create a new report with Customer Region as the attribute and Revenue as the metric. reportViewMode. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. Allows users to export report services documents directly to PDF.