Like microstrategy has over 300 connectors and power bi has only 100 connectors. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. xxx. mdb The database doesn't need to be on the I-Server, although the I-server needs to be able to see the machine the database is on. Al momento, MicroStrategy Desktop e MicroStrategy Workstation non devono essere installati sullo stesso computer a causa di problemi di incompatibilità di registrazione di specifiche DLL in questi prodotti. These fixes address performance (8), security (5), and stability (24) among other issues. Overview 1. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. The Report Data Mart Setup dialog box opens, as shown below: On the General tab, from the Data mart database instance drop-down list, select a database instance for the data mart table that will be created. Click Show connection string and select Edit connection string. Extract the downloaded files. Use Cube Advisor to create Intelligent Cubes: 1. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. xml file under C:Program filesMicroStrategyWeb Services. Helps you to manipulate the database in a single package. Every MicroStrategy BI application requires at a minimum: 1. )MicroStrategy - Configuration Objects. Expand the My Personal Objects folder, and then open the My Reports folder. Under the General tab, go to Database connection > Select the connection > click on ‘Modify’ > In the Database Connections window > Go to the Advanced tab > under Connection Caching > Set ‘connection lifetime’ and the ‘connection idle time out’ to. Zendesk Connector. Companies of all sizes use this platform to assess, visualise, and build dashboards. Databases can be found in almost all software applications. exe. To Create a Query Builder Report. Advanced Apps. Business Intelligence with MicroStrategy 10 Analytics. A project is the highest-level of intersection of a. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. MySQLPwd. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Check out our publicly available live demo environment where you can run reports and documents and dashboards at demo. From the Warehouse Tables pane, you can update all tables for a data source or update individual tables as described below: •. Can configure environment variables (e. PlatformAnalytics. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. Download the Hortonworks Sandbox 2. MicroStrategy online training & certification course by Multisoft Virtual Academy is a valuable resource for individuals and corporate teams seeking to harness the power of this robust business. Format – PDF. The goal is to derive profitable insights from the data. The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. Exit all Windows applications before beginning the installation process. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. Developer enables you to model applications using an intuitive, graphical interface. Data Warehouse Tutorial Summary. It gives you the leverage of generating real-time reports and monitoring data. Microstrategy Tutorial. Step 2) Run the following command to create SALES database. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both MicroStrategy Developer and Web. Create a second report with the year and quarter attributes and the revenue metric. organize, and analyze #Dossiers. Patent Nos. MicroStrategy online training & certification course by Multisoft Virtual Academy is a valuable resource for individuals and corporate teams seeking to harness the power of this robust business. Open a dossier. Click Modify. Data can be connected through an API, flat file, or database. Select a recipient. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. To access the MicroStrategy Installation Wizard. Now log into MicroStrategy Developer and go under Administration tab. From the File menu, select New, and select the type of object to create, such as a report or a filter. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. To create a user with standard authentication to use in your DSN creation, expand Security, right-click, and choose New Login. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. From the drop-down menu, choose the database instance against which the user ID should be verified. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). It provides the fundamental knowledge of MicroStrategy architecture, database connections, cluster notes, web server configuration, etc. Under Open Database Connection (ODBC) data sources, select the warehouse DSN. The following screenshot displays this interface: If the metadata resides on a Microsoft Access database, the following additional steps need to be performed before the upgrade: Open the Microsoft Access database selected in Step 3 select Database Tools > SQL Server as shown below. If two users with different security filters run the same report, they may get different results. Click OK and you will see the DB role created with the name of your Data Source. Log in to the Windows server as a user with administrator privileges. Understanding microstrategy vs power bi is very important for concept clarity. This is the username of an administrator user in the database. db2 create database SALES. For information on creating a new database connection, see Connecting to the Data Warehouse. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. Get inspiration at the MicroStrategy data dashboard gallery. Microstrategy is rapidly increasing in popularity and is being leveraged across. Database Server hosting the Statistics/Enterprise Manager Warehouse database is not running. g. Click within the Dataset Objects area to add datasets for the document. x and 10. MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. The system hierarchy is displayed. Download the Hortonworks Sandbox 2. Update Schema 18. Design intuitive analytics reports with MicroStrategy ONE. Exploring Sample Dossiers in Library. microstrategy. Step 1) Open ‘Contact_Form_Split’. With MicroStrategy products, a guide for how to download and use URL Scanner. Before you begin, exit all applications which may interfere with the installation process. Then right click on the database,. yaml. Before you begin, exit all applications which may interfere with the installation process. x, Visual Basic 5. Click within the Dataset Objects area to add datasets for the document. Business Intelligence with MicroStrategy 10 Analytics. It lets the users view various information about the schema design of a MicroStrategy project. MicroStrategy - Creating Dashboard. mstr file, the file is no longer linked to the original data sources and is not updated. For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. This is the password of an administrator user in the. In this tutorial we are going to discuss Installation of MicroStrategy. PostgreSQL JDBC driver. Using system prompts, users can use. Microstrategy Tutorial. Installed with MicroStrategy. Under this database, create two tables product and Inventory. MicroStrategy Community includes technical notes that document the history of changes to. project_name is the project for which. OLAP 3. sql files of the Metadata and Warehouse into your MySQL Server Section 2: Creating DSNs for your Tutorial Databases in MySQL. It has a simple menu to import data for analysis and export the result of analysis. 5. List Attributes statement. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. These are discussed below. Use your preferred restoration method or the commands below: The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. If the New Metric dialog box is displayed, click the Empty Metric. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. The following page is our compilation of the different types of cases that come into technical support and what we initially collect when the customer contacts us. Download the files from the MicroStrategy download site. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. Using Workstation, developers and administrators can build and administer sophisticated enterprise and mobile analytics applications with a fraction of the effort it has traditionally. It also provides descriptions of the module s. Visit the Download site now 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. One or more of the following patents may apply to the product sold herein: U. In the Source area, select a database instance for the data source to access using Query Builder. 8. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. If you have a license for the MultiSource Option, selecting a check box for a database instance also makes the database instance available from the Warehouse Catalog to. x, SQL Server 6. Some database-specific object definitions may need to be changed if Tutorial is used on another platform. Download the 100% Free MicroStrategy. For information about how to use MicroStrategy Platform Analytics, see Platform Analytics Help. 4. Learn more. This is a "Must See" video for anyone using or developing in MicroStrategy 10. Design workflows, create content groups, or customize application components with the no-code framework. 8. 2987. Definition. SYMPTOM: This issue only presents itself using FFSQL and is tied to number rows returned by the query. In the Source area, select a database instance for the data source to access using Query Builder. The Project Configuration Editor opens. MicroStrategy Tutorial. All articles. MicroStrategy-Tutorial-Documentation . 4. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. Before you begin exploring the Tutorial schema using Architect, there are a few conventions and fact information that can help you understand the overall Tutorial schema. It shows many attributes grouped into separate visualizations. To see sample dashboards in Developer. List Attributes statement. From an open dossier, tap Share > Download Dossier. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. Power Query: It can be used to search, access, and transform public and/ or internal data sources. MicroStrategy is a powerful Business Intelligence and Visualization software. Custom Groups 15. In MicroStrategy Secure Analytics 10. Select Pick Tables to select single or multiple tables to import data from. An empty database is created. In MicroStrategy 9. Network problems causing connection failure to the database server. Make sure the folder is saved in the XAMPP PHP installation directory as shown above. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. For information on creating a new database login, see Connecting to the Data Warehouse. Once data flows into the interface, the dashboard will come to life. A project source is required to run MicroStrategy Command Manager and connect to a metadata repository. An example is: MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesAd hoc ReportingSortingYearly Sales!i inserts the job priority of the report which is represented as an integer from 0 to 999 (can be used in all Pre/Post statements). PDF Version Quick Guide MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. LU_. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. In MicroStrategy 2021 Update 2, Platform Analytics warehouse database is not update to date. By default, the mstr database. x. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. This group must have the Web user privilege to be able to use MicroStrategy Web at all, and also other privileges to be able to utilize all of MicroStrategy Web functionalities. Using system prompts, users can use. Below screen show installation progress. You can use various combinations of tables and columns to support and identify the translated data in your database. MicroStrategy's software allows. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Follow the next steps in order to grant the "Create and edit database logins" privilege to the user: Right click the account in 'User Manager' and select 'Edit'. The upgrade database type window appears. The 'Database Name' option allows the MicroStrategy Narrowcast administrator to create the Object Repository or the Subscription Book Repository in any of the databases that exist in the database server pointed to. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. g. In MicroStrategy Developer, open the Basic Report from the MicroStrategy Tutorial. - Selection from MicroStrategy Quick Start Guide [Book]How part of this MicroStrategy getting you wants learn how to get started by MicroStrategy reporting, how to initiate the MicroStrategy Desktop, starting the MicroStrategy Net, opening a story, components of a message, row plus columns, grids plus graphs, OLAP services and other. Steps. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. Configuration objects include objects such as users, database instances, database login IDs, and schedules. The fuel for business dashboards is data, so each one needs to have one or more data sources. 4 is also now available on our software download site and the MicroStrategy on AWS cloud provisioning console. MicroStrategy Tutorial. Download Software; Release Announcements. MicroStrategy Tutorial (Direct) Advance Features 1. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. If installed over previous versions of the product, the folder remains the same. Multi-Metric KPI and the Comparison KPI Visualizations. Download the 100% Free MicroStrategy. Create mobile applications with write-back enabled functionality (transactions) for extended business value. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. The Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. To resolve this issue, users must execute the steps below: Log into MicroStrategy Desktop as the administrator. It is one of the best free database that falls under the category of a NoSQL database. Click Next in the start up screen. Go to Project access, to give Public/Guest basic access to the project. To update all tables for a data source, right-click a data source, and select Update. To alias an object name in MicroStrategy Web: 1. log in to the project source containing the MicroStrategy Tutorial and expand the. When the IF() operator is used, a conditional statement will be generated as part of the SQL to be executed on the database as long as the calculation is not forced by the Analytical Engine (e. · Best practices on creating dashboards. Patent Information This product is patented. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. Lists all attributes from a given location path within a project. Hire IT Professionals for your Projects! Hire Programmers, Hire IT Professionals, IT Staffing, Software Development! Hire Certified and Experienced Professionals on any Skill. Schools & Partners Schools & Partners edX For Business with these online courses and programs MicroStrategy offers an all-in-one business intelligence platform, allowing. The New Grid dialog box opens. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. The recent version was released on 7th January 2019, and it introduces many new ground-breaking enhancements and features. View AllFiles. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. MicroStrategy courses can be tailored to developers, analysts, and architects, each focusing on different topics tailored to the respective job roles. It is important to understand that certain capabilities powering the user workflows might not be supported in Snowflake. exe. Click OK and you will see the DB role created with the name of your Data Source. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. A database table used to uniquely identify attribute elements. 4 %âãÏÓ 2 0 obj >stream xÚìÁ € ÿ«ë €Ù±ƒ”8¶ ûº ˆƒ@@p, Bæâ Ä ¸ Ý…®A× £h¤‚ 6. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. 6,154,76 6, 6,173,310, 6,260,050,. The Tutorial project includes sample data, such as actual customer names and items purchased. Logical view: A logical table that is created using a SQL statement instead of being a direct representation of a physical table. In the "Select Data Source" window, go to the "Machine Data Source" tab and select the DSN created in. Choose Presto for Database and choose the Presto Version. Navigate to a prompted report and click Insert. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. The utility is found under Program FilesCommon FilesMicroStrategy. Click the Load button. MicroStrategy OOTB PostgreSQL JDBC driver fails to connect PostgreSQL database when authentication method is scram-sha-256Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. 0:As part the this MicroStrategy tutorial you will lessons how to get started with MicroStrategy financial, how to start the MicroStrategy Tabletop, starting the MicroStrategy Web, opening a report, components of a tell, row and column, grids and diagrams, OLAP services and more. Within a project, a security filter may be specified for any user. Among the many features, the one that stands out is the HTML 5 integration with enterprise for graphs and widgets, the cube wrangling,. Step 2) Run the following command to create SALES database. Follow the steps below to set up the Tutorial environment. 4. It can connect to data warehouses, relational systems, flat files,. 2. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Enable the option “Ignore current table name space when reading from the database catalog and update using new table name space. Views 1538. 0/6. MicroStrategy - Creating Dashboard. Open the workstation-mac-x. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Attribute: Year, Category. Extract the downloaded file. Under this database, create two tables product and Inventory. However, if the results of that report are cached, the results can be returned immediately without having to wait for the database to process the job the next time the report is run. Optimize database performance and utilization based on query types, usage patterns, and application design requirements. Platform Analytics and Enterprise Manager are both monitoring tools that capture data about MicroStrategy. Step 1) Download MongoDB Community Server. It also stores other types of objects that allow you to access that information. Click Blank Report. In general, ApplySimple can be used to create the following objects: Attribute form. Download. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. MicroStrategy Architect provides an intuitive way to explore the MicroStrategy Tutorial schema. Click within the Dataset Objects area to add datasets for the document. We empower you with the skills to get the most out of your analytics investment. The modeling tool allows architects to transform a complex enterprise data environment. jar file to i-server machine. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. Zendesk. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. Log on to the machine where you are installing MicroStrategy Workstation. Description. Lookup tables are usually joined to fact tables to group the numeric facts in the fact table by dimensional attributes in the lookup tables. Create a blank dossier or open an existing one. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. As part of aforementioned MicroStrategy teaching you be learn how to get started with MicroStrategy reporting, how to start the MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, key of a report, rows and column, lattice and graphs, OLAP services also more. · How to professionally and effectively. MicroStrategy logical tables do not necessarily represent physical tables. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. SYMPTOM: The user wants to show different metrics in different colors in a graph in Dossier ACTION:. They typically consist of descriptions of dimensions. 1. Navigate to MicroStrategy Tutorial and expand the Schema Objects option. In addition to the files listed in the table below, common files needed to run MicroStrategy are placed in the following directories by default: When installed on 64-bit Windows. For Oracle 12. old box. As part in this MicroStrategy tutorial yourself will learn how the acquire starting include MicroStrategy reported, how toward start the MicroStrategy Windows, starting which MicroStrategy Web, opening a report, components is an report, row and colums, grids and graphs, OLAP services and more. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. pdf. g. !o inserts the report name (can be used in all Pre/Post statements). MicroStrategy Education offerings. The Apply functions also hand off to your RDBMS functions that are specific to your database. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. Reports. Platform Analytics and Enterprise Manager are both monitoring tools that capture data about MicroStrategy. The report-related objects placed on the template. MicroStrategy describes its core reporting. Introduction MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and. For Oracle 12. There are Power BI components are 5 main components released in the market. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. Select the Tutorial Data database instance. èÿ 4HÈ5ÞNwuÕùªž‡o UçœÁ ° ßÿùä#0r¯uí#@®Û ]• r}ÿç“Ê ¹¾ÿóIå €Óħò @¨·Ä7|> dù5ñ5»ÛÛ÷M Èo‰Oå €,ÿN|* y7ñ©| âO‰¯ÙýÁ¡ï. To Create a Query Builder Report. Currently this issue is tied specifically to using Amazon Athena with a DSN-less connection in MicroStrategy Web 10. · How to install additional visualizations to your profile. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. In MicroStrategy Web, log in to the Tutorial project. Click OK. Download and extract the MicroStrategy installation package from the MicroStrategy download site. Request a demo. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. Cards. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. Download and unzip "Tutorial Project Files" from the download site according to the version you are using. sql Restore the SQL files to the empty databases created in step 4. Locate the path to the following SQL files part of the Tutorial Project Data download (within a folder titled ' Databases ') from the prerequisites section: -poc_metadata. 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. Connecting to Environments in Workstation. MicroStrategy. Extract the downloaded files. The MicroStrategy Desktop environment is very intuitive. Do not check the box for "Share this connection with all users". The Report Editor opens. To create a Freeform SQL report. A dashboard is made up of multiple visualizations. For a description of each area or pane of the MicroStrategy Web Report Editor and Design Mode, see MicroStrategy Web Report Editor interface. All articles. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Without data, the dashboard will not show the user anything. exe file. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. Click OK. To simulate Region in element browsing in the MicroStrategy Tutorial project, the counting pass requires a metric defined as follows: Note: <Distinct=True> is normally hidden, but can be displayed using the "Show Function Parameters" option in the View menu of the metric editor. Course Name: Information for Decision Making (INST 714) Group Members: Ankit Shah, Charanya Rammesh, Maithreyi Chander, Sourabh Dwivedi MicroStrategy MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Get the detailed steps on the download preparation, pre-requisite to run the tool. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. 0, in addition. Download the Trial Version. In the following example, we will create a dashboard showing some common. 3 introduces a modern look and feel to the Tutorial project and makes it easier to identify and view the latest capabilities. MicroStrategy Tutorial. Navigate to the download site and download the Desktop installation files. x generates SQL with brackets around column names with spaces, instead of using quotes. Accept the End-User License Agreement. For information about how to use MicroStrategy Platform Analytics, see Platform Analytics Help. TheLogicalDataModel 19MicroStrategy comes with a sample project called MicroStrategy Tutorial. Using the MicroStrategy Tutorial Project, this behavior can be reproduced with the following steps: Create a text box in a document with dynamic text (e. In the Database Instance pane, select the check box next to the database instances for the data sources to include in a project. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Click Next and select the project wanting to be. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. This will launch the "Select Data Source" window. MicroStrategy i About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. In the Data Source dialog, select Reports. About sample data and. %PDF-1. MicroStrategy provides Apply functions as a means of handing off these data and RDBMS-specific functions to your database, which results in your database—not. If a message saying that the type already exists, click on Yes to update it. CONTENTS 1. With a project open in Architect, select the Project Tables View. Take the following steps: In. Enable users to interact with personalized chat for further product discovery. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. MongoDB is a document-oriented NoSQL database used for high volume data storage. Deploy the ojdbc8. This will launch the Upsizing Wizard. It can connect to data warehouses, relational systems, flat files,. MicroStrategy-Tutorial-Documentation . pdf), Text File (. mstr file to a contact, email, another application, or save it on your device. Navigate to the download site and download the Desktop installation files. 2 release, the driver file is called odbc8. As parts of save MicroStrategy tutorial you will learn how to get started with MicroStrategy reporting, how to start the MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, components of a report, row and columns, lattices and graphs, OLAP ceremonies and more. ePAPER READ . Microstrategy Architecture 2. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. 3. AutoStyles 14. x. SecurityRegion table defines from which region a user is allowed to view data.