By default, it is 34952, but ask your MicroStrategy. 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. It is a graphic-intensive technique that results in a data model representing the definition, characteristics, and relationships of data in a business, technical, or conceptual. MicroStrategy Project Design Guide. The table below shows the URL parameters used to export a document to PDF using the URL API. As an Analytics Architect, you are exposed and asked to leverage an ever-growing list of data sources within your Intelligent Enterprise. If you use the MicroStrategy Tutorial project to perform the examples in the procedures that follow, you can become familiar with the Report Editor environment and the features it offers. R Script Example. This graph suggests that customers who are. 1. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Select the 01 Blank Dashboard template. 0, element list prompts can be used in database passthrough functions, e. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Data mining examples included in the MicroStrategy Tutorial project, in Public ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Data Mining Services; In addition, this section describes the process of how to create and use predictive models with MicroStrategy and provides a business case for illustration. A Security Filter only exists in association with a user and a project. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. Customer Satisfaction, is available in the MicroStrategy Tutorial project. PrerequisitesTo illustrate the issue, a fact table CAT_ITEM_SLS has been added into the MicroStrategy Tutorial project and populated with a small set of three rows. Select project for the given connection based on project_id or project_name. For example, a simple logical data model for a retail company can organize all necessary facts by store. ("MicroStrategy Tutorial"); //Project where the session should be created serverSession. Configure the properties for your objects. After the project source is found, it is expanded. In some business scenarios, users may wish to create a prompt to order the date from ‘StartDate’ to ‘EndDate’ (Between Day1 and Day2) as one prompt/index in MicroStrategy Web. How to build a custom subtotal that calculates as a metric and is placed under a second metric in MicroStrategy Developer 9. Click within the Dataset Objects area to add datasets for the document. Log into the MicroStrategy Cloud environment. Only the database names listed in DBAdminConfig. For example, in the MicroStrategy Tutorial project, the Time hierarchy includes relationships between the attributes Year, Quarter, Month of Year, Month, and Day. Creating Dashboards and Reports to. MicroStrategy 2020以降、PostgreSQL データベース用のTutorial Project Files が提供されます。 以下の手順を従ってTutorial環境をセットアップしてください。 1. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. MicroStrategy Project Design Guide. 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'. MicroStrategy 2020以降、PostgreSQL データベース用のTutorial Project Files が提供されます。 以下の手順を従ってTutorial環境をセットアップしてください。 1. If you followed the Tutorial example in the procedure above, you created the Month filter which excludes the months April, May, and December. Forecast" report, which is part of the MicroStrategy Tutorial project, to PDF. So the Out of Compliance message is as expected. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. A working project with data objects. 912 Advanced Project Architecting 2021. KB45459: How to migrate the MicroStrategy Tutorial Project warehouse from Microsoft Access to Microsoft SQL Server in Micr…. These recommendations are based on the other customer orders and are meant to provide customers with additional movie options that they are most. MicroStrategy Intelligent Enterprise™ Platform Help. To view and edit the parents and children of an attribute. This procedure provides steps to re-create the example of explicit table aliasing described in this section. MicroStrategy Project Design Guide. Description: This Intellipaat MicroStrategy certification training course is meant for an in-depth understanding of the MicroStrategy platform, its architecture, the significance of business intelligence, etc. Learn More. To add data to the visualization in this example, you use an existing dataset in the MicroStrategy Tutorial project. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. x: Navigate to Programs -> MicroStrategy -> Tools -> Project Mover. Right-click in the grid and select New to create a new connection mapping. If an active connection is detected, the session is renewed. Click Next and select the project wanting to. Open the Attributes folder and then the Geography folder. 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 theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. If the connection information to the MicroStrategy Repository has changed since the last installation, you are prompted to provide the database login username. 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 main. Company;MICROSTRATEGY BOOTCAMP: ACCELERATE YOUR TRAINING MicroStrategy’s renowned bootcamp experience enables students to earn their Analyst (ANL) or MicroStrategy Architect (MCA) certifications in an accelerated timeframe. A MySQL Server and rights to create and restore databases MySQL ODBC 5. In the sample that was provided, you create an instance of the report “01 Basic Report” in the “MicroStrategy Tutorial” project. LOAD PROJECT "project_name ";where: PROJECT "project_name" is the name of the project to be loaded, of type string. Project Architecting 2021. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. MicroStrategy for Jupyter is contained within mstrio-py package and is available after. Company;MicroStrategy is an enterprise business intelligence application. It offers a wide range of analytical capabilities. The MicroStrategy Tutorial project comes with the following groups of reports: Business Roles: This folder contains reports for different types of business intelligence users, such as billing. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. Step 2) Accept the Terms. EN. MicroStrategy Project Design Guide. MicroStrategy Tutorial. 2. MicroStrategy Tutorial schema. Research, develop, and deploy sophisticated machine. This video demonstrates overview of MicroStrategy Architect and schema objects. The steps below show you how to create a similar training report in the Tutorial project. This example uses the MicroStrategy Tutorial project: In MicroStrategy Developer 9. Make sure not to duplicate users and groups, and use the destination ACLs. is the project for which the project configuration properties will be listed, of type string. "exclusive_constituent": When the changeset is created with "schemaEdit" = true, an "exclusive_constituent" lock is placed on the schema. yaml are backed up by this tool. Navigate to MicroStrategy Tutorial and expand the Schema Objects option. MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, MicroStrategy i About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Set the metadata language for users to Spanish . The example analyzes customer orders of movies, and recommends other movies based on their selections. 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. Using this data, you can forecast potential sales for the upcoming years. Kickstart Your Career. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the. You can also construct these types of metrics using the times operator (see Times (*)). Following are the various Schema Objects with their description. A logical data model graphically depicts the flow and structure of data in a business environment. This technical note describes how to create a sample prompt in MicroStrategy Tutorial Project. EN. reportViewMode. Sample values are used for parameters in the sample URLs, such as "localhost" for Intelligence Server or "MicroStrategy+Tutorial" for the project. The Tutorial project offers an opportunity to use MicroStrategy even if your organization does not yet have its own data available in a MicroStrategy project. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Step 1) Open your Facebook app on your mobile phone and Log in. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. Data Warehouse Consulting. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. When a subtotal is applied to a metric on a report, the placeholder inputs that metric’s values. Using MicroStrategy Office, attempt to connect to the project and. BIArchitectureandtheMicroStrategyPlatform 1 Businessintelligencearchitecture 2 TheMicroStrategyplatform 8 Theprojectdesignprocess 18 2. 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 steps below show you how to create a similar training report in the Tutorial project. Get Started. . 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. For steps, see Starting MicroStrategy Developer. The examples below use the Lag function. * optional arguments. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. In the MicroStrategy Developer File menu, point to New > Fact. You can also construct these types of metrics using the times operator (see Times (*)). Initially, all of the documents in the MicroStrategy Tutorial project under the Public Objects folder are displayed on the left side of the web page. x-10. Make sure not to duplicate users and groups, and use the destination ACLs. 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. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. Identify the project by passing the project ID in the request header. Workstation is the only space for analysts and app architects to build and manage content of all types. . ) The Login. Access MicroStrategy Platform. It can connect to data warehouses, relational systems, flat files,. By setting the showOptionsPage parameter to "false", you prevent the Options page— on which you normally specify the export format— from being displayed. Double-click the Region attribute to add it to the. Freeform SQL Report Error. Authenticates the user and creates a new connection with the Intelligence Server. Choose the Database option > Type a Query. EN. 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. It is recommended that, if you plan to try the Tutorial - Delivery sample project to learn about Narrowcast Server, you perform the 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. Create the respective DSN's in the Intelligence Server machines . The Expression page is where the expression is built. Multiply returns the product of two or more values. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. If you use an index value, you specify it using base 0. Both examples can be found in the MicroStrategy Tutorial project in the following folder: MicroStrategy Tutorial/Schema Objects/Facts. Select the 01 Blank Dashboard template. The following properties in the Web API map to ones exposed by MicroStrategy Developer, as shown on the dialog below:The Evaluation Guide includes instructions for installing, configuring, and using the MicroStrategy Evaluation Edition. It provides a way of organizing facts so that they can be analyzed from different business perspectives. (To follow the examples in this guide, click MicroStrategy Tutorial . This can be achieved using the custom subtotal feature set in MicroStrategy Developer 9. The steps also include an example for most steps, based on Tutorial sample data in the MicroStrategy Tutorial project. Below is the R script for the forecasting analytic. Forecast" report, which is part of the MicroStrategy Tutorial project. Revenue and Last Month's Revenue are the standard metrics from the MicroStrategy Tutorial project. 2. Metadata Repository. If you are using the MicroStrategy Tutorial to create the example mentioned above, log in to the MicroStrategy Tutorial project. yaml. If a report is required to show orders that are shipped on the same date, a filter that can perform a comparison between these two attributes is necessary. Then, you add an object node that points to the elements of the “Region” attribute. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. This report has two attributes and three metrics. In addition, a 2-Tier Project Source is also created and accessible from MicroStrategy Developer. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. 2. By. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. EN. Loads a project in an Intelligence Server. Overview and Introduction to MicroStrategy. Example. MicroStrategy has a metadata-driven architecture. Login to MicroStrategy developer as administrator. Connectivity Components. MicroStrategy Project Design Guide. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. Sample values are used for parameters in the sample URLs, such as "localhost" for Intelligence Server or "MicroStrategy+Tutorial" for the project. Data Warehouse Consulting. This business analyst course. ITIL framework helps in improving project delivery success and managing constant business and IT change. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. CREATION_TIME: The date and time the report was created, returned as a date/string. Parameters attribute_id (str) – the attribute guidContribute to moawasthi/EmbeddedDemo-master development by creating an account on GitHub. You want to retrieve the document's. At this point, the project designer must add the column containing the customer dates of birth as an additional attribute form of the Customer attribute. )By default, the MicroStrategy Tutorial project is provided as part of the MicroStrategy Analytics Modules project source. This is an example of how to achieve Option 2 using MicroStrategy Tutorial project in 3-tier, keeping the same Database Instance and Database Connection but changing the DSN. Session Management Session_CreationCONTENTS 1. 2. Multiply returns the product of two or more values. You can specify the project using either the object ID of the project or the project name. EN. Android Internals - Volume I - Jonathan Levin 2014-10-24 An in-depth exploration of the inner-workings of Android: In Volume I, we take the perspective of theMicroStrategy Project Design Guide. Follow the steps below to reproduce this issue in the MicroStrategy Tutorial Project: Create a report with attribute Year in the page-by, attribute Quarter in the columns and metric Profit. Run the report in Grid View. It was incorporated in 1979 but parted away from NCR in October 2007. Get Started. The Expression page is where the expression is built. Visit the data visualization and data dashboard galleries for inspiration. Micro Strategy also supports mobile BI. We will use the data contained within the MicroStrategy Tutorial project that is provided out-of-the-box. The sample prompt is as show below. Open the Microsoft Access database selected in Step 3 select Database Tools > SQL Server as shown below. This document is an example of using Transaction Services to. MicroStrategy Project Design Guide. Related versions:This article describes how to setup metrics so that smart metric options are automatically inherited in MicroStrategy. MSTR Learning Portal: How to Download Course Materials. The elements, however, are. Used-by dependents are not automatically migrated with their used objects. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. Export the document to Excel. For those coming from. The sample prompt is as show below. For example, in the MicroStrategy Tutorial project, the Time hierarchy includes relationships between the attributes Year, Quarter, Month of Year, Month, and Day. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. You choose , navigate to Shared Reports -> Subject Areas -> Customer Analysis -> . EN. %PDF-1. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. The MicroStrategy Tutorial project includes examples of Transaction Services in the location: MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Transaction Services. Learn more about MicroStrategy REST API Playground here. 1. For "project package" and "project security package", the related project ID is required in the request header of each endpoint. It is a lock exclusive. The steps below walk you through the process of creating a data mart report and then executing the report to create a data mart table. Your Story. Ambiguous cases can arise in cases where multiple datasets contain the same objects. Pareto Chart. The LU_YEAR and LU_REGION tables from the MicroStrategy Tutorial project shown below are used to illustrate the various logical view options available for displaying columns and attribute forms in tables. If you specify both the project ID and the project name, the project ID is used. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. . In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. Platform: Intellipaat. Select the MicroStrategy Tutorial application and click Select. A Security Filter only exists in association with a user and a project. In the pane on the left, navigate to the attribute whose form you want to filter a report's. In the Navigation pane, click Create a New Document next to Documents. 2 Click the project to log in to. ALTER PROJECT CONFIGURATION DESCRIPTION "MicroStrategy Tutorial Project (version 7. How to Download Course Materials. )For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. In the Object Browser on the left, click Schema Objects to open the Schema Objects folder. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. EN. 4. 2 release, the driver file is called odbc8. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. MicroStrategy 10 Certification Training. MicroStrategy Tutorial. Published: Jul 17, 2017. The document that is selected is then. SUMMARY. These recommendations are based on the other customer orders and are meant to provide customers with additional movie options that they are most. The YR_CATEGORY_SLS table of the MicroStrategy Tutorial project shown below is used as an example of how you can modify and view tables definitions using Architect. Our specialists can help your business stakeholders and implementation team at every phase of your data warehouse project and provide subject matter, industry and technology-specific expertise. Explore the folders and double-click any report or dashboard to run it and see the sample data results. The table below shows the URL parameters used to execute a document using the URL API. The MicroStrategy Tutorial is an interactive product demonstration designed to showcase the rich functionality of the MicroStrategy 2020 Platform. xml in a text editor and make a copy of the text between. Risk-adjusted returns of currencies, indexes, metals, stocks, & bonds vs BTC. The Open command searches for the project source by name. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. In the context of MicroStrategy functions, this book discusses derived expressions. Tutorials Choose your MicroStrategy version: New in MicroStrategy 2021 HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. Examples based on the MicroStrategy Tutorial project have been provided to explain this information. MicroStrategy Tutorial. In the Database Instance pane, select the check box next to the database instances for the data sources to include in a project. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. Expand the Public Objects folder, then expand the Reports folder. 2 Click the project to log in to. R. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. . Select and edit the specified. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results Pane -> Results -> To Text; ALTER PROJECT CONFIGURATION DESCRIPTION "MicroStrategy Tutorial Project (version 7. A derived expression can only use single-value functions, and arguments that are used in the expression are columns. The page component that should handle the action and the event. It supports Standard and LDAP authentication modes. Once the REST API layer has validated the user's credentials using the specified authentication mode, it initiates a session with the Intelligence server and creates a unique authorization token for. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. 1. However, the sample reports, documents, objects,. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Tutorial Project Filesを利用するTutorial環境のセットアップ. Open the Basic Report from the Tutorial project, located in Shared Reports MicroStrategy Platform Capabilities Advanced Reporting. Click on “Show advanced options” next to the Language section and change the Metadata and Data Language to another language different from the default one. A project source is required to run MicroStrategy Command Manager and connect to a metadata repository. Only objects at the project level can be passed in the request body when creating a "project package". Connect to MicroStrategy Using a Workstation Identity Token. In the search results, they can look for a particular document and select it. It is possible to get a list of users associated to a particular security filter inside a project using the Web SDK. This behavior is by design. Element "2009" and "2009 and 2010" both contain Year=2009, as shown below: Create a report with Category and Year_Con in rows and Revenue in columns. Preview MicroStrategy Tutorial (PDF Version) Buy Now. This example explains how to deploy this script with the MicroStrategy Tutorial project available with MicroStrategy Intelligent Enterprise. A project is the highest-level of intersection of a. Login to MicroStrategy developer as administrator. Reports. The mstrio-py Python library provides a Connection module to initiate a session with the Intelligence Server. MicroStrategy Web. An authorization token allows the API layer to hide internal session-related implementations such as managing different project-specific sessions. Open the Microsoft Access database selected in Step 3 select Database Tools > SQL Server as shown below. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. MicroStrategy Certified Professionals: Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. 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. MICROSTRATEGY BOOTCAMP: ACCELERATE YOUR TRAINING MicroStrategy’s renowned bootcamp experience enables students to earn their Analyst (ANL) or MicroStrategy Architect (MCA) certifications in an accelerated timeframe. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Print Page Previous Next Advertisements. There are Power BI components are 5 main components released in the market. The two Min(Rev, Last Month Rev) metrics are defined differently to produce the same results (the lesser of the two preceding metrics) at row. Without data, the dashboard will not show the user anything. Data mining examples included in the MicroStrategy Tutorial project, in Public ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Data Mining Services; In addition, this section describes the process of how to create and use predictive models with MicroStrategy and provides a business case for illustration. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. This graph suggests that customers who are. This template uses a single. Projects generally also contain other. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. In some business scenarios, users may wish to create a prompt to order the date from ‘StartDate’ to ‘EndDate’ (Between Day1 and Day2) as one prompt/index in MicroStrategy Web. Wait for some time. The purpose of this lock is to prevent accidental modifications to the schema in a project. It turns data into reports for making and executing key organization decisions. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Access to the MicroStrategy Tutorial data warehouse provided in the MicroStrategy Practice Project, Tutorial Project Online course (Practice Tutorial_WH). You will be able to: - connect to MicroStrategy Server. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. 1 : In MicroStrategy Developer, log in to the project to create attribute roles with explicit table aliasing. The 'Order Date' attribute from the MicroStrategy Tutorial project records the date an order is placed. Once the page shows “Continue to. Your Story. 1. The Project Configuration Editor opens. Even without coding skills. As an Analytics Architect, you are exposed and asked to leverage an ever-growing list of data sources within your Intelligent Enterprise. This code sample uses SessionManagementSample. This MicroStrategy tutorial will walk you through the process of creating a report from start to finish, including importing data, creating a project, and designing a report. The search is case sensitive. Adding External Data Video Tutorials Additional Tutorials HyperIntelligence Video. Identify the report by passing the report ID in the path of the request. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. You have to deploy SessionManagementSample. Article Reference Number: KB442042. This graph report, named Scatter Plot Chart - Revenue vs. MicroStrategy Project Design Guide. Connect to environment without providing user’s credentials. Starting from MicroStrategy 9. These tables include a combination of attribute and fact definitions. MicroStrategy Project Design Guide. ) By default, the MicroStrategy Tutorial project is provided as part of the MicroStrategy Analytics Modules project source. For simplicity, CustomGroupCreationSample does not provide details on how to obtain the ID for the attribute. 3. This function differs from the Product function (see Product), which returns the product of values in a single value list. g, the fact table used before was at Year level, now become at the Day level. Argument. MicroStrategy Tutorial data model.