MicroStrategy MCD Practice Project â MicroStrategy Tutorial Page 1 of 38 Revised: 10/8/2009 © 2009 MicroStrategy, Inc. Creating a filter based on business attribute forms. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. 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. Reporting remains consistently accurate in OLAP servers as the speed of data sharing does not impede the process. • It is the most useful tool for resolving big data related issues. With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize. The new platform version focused heavily on embedded analytics with a host of new features for HyperIntelligence, a tool first introduced in 2019 that utilizes. The REST API is designed to help developers build data-driven client applications quickly. Intelligence Everywhere. Data mining generally refers to examining a large amount of data to extract valuable information. Microstrategy is rapidly increasing in popularity and is being leveraged across. Anybody can use these data mining features like report designers, business users and analysts. Customers wishing to use Platform Analytics in 11. To view the structure of the MicroStrategy Tutorial. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. To explore this sample project data, in the Folder List expand MicroStrategy Tutorial, then expand Public Objects, then expand Reports. Please follow this product guide to MicroStrategy is a vendor of Business Intelligence application software. If prompted for file conflicts, select 'Replace'NOTE: “Microstrategy Tutorial” will be replaced with the project specified to have the PASTATISTCS altered for. For example, the MicroStrategy Tutorial project includes a Month of Year attribute which retrieves its. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. It is a. Microstrategy Dossier creation. Click . MicroStrategy Tutorial. Create a metric that sums the fact Units Sold. Platform Analytics is a completely new product introduced in MicroStrategy 11. 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. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. The MicroStrategy Tutorial, MicroStrategy’s. A typical project contains reports, filters to qualify the report data, metrics that calculate the data, attributes that provide context for the metric data, and mathematical functions. The Tutorial project includes sample data, such as actual customer names and items purchased. Choose your MicroStrategy version: 2021. For more information on what a logical data model is and how to create one, see The Logical. Data Mining. This data can then be added to your map in Esri Maps for. To build a report using the Report Wizard: To start the Report Wizard. It describes how MicroStrategy works with and stores the data you import. The MicroStrategy OLAP Services product lets MicroStrategy Desktop, Web, and Office users slice and dice data in reports without having to re-execute SQL against the data source. This endpoint allows the caller to get the list of projects with the MicroStrategy REST Server. After enabling Mobile Telemetry for the project, users can run a report on the Mobile App. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Connection mappings allow you to assign a user or group in the MicroStrategy system to a login ID on the data warehouse RDBMS. A Datawarehouse is Time-variant as the data in a DW has high shelf life. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. to open the Shared Reports folder of the. From the Data menu, choose Rename/Edit Objects. Using Database Views Many practical MicroStrategy-Teradata implementations do use a set of database views on top of the physical tables in Teradata. login_mode ¶ Authentication mode. MySQL workbench has a built in model validating utility that reports any issues that might be found to the data modeler. This knowledge base article explains how to create an attribute form as a hyperlink or uniform resource locator (URL) in MicroStrategy Developer 9. Full control. You must log in as a user with. Select a security filter from the Available list and click > to assign it to the user or group. In microstrategy architect , we define logical data model within the tool. Open Workstation in smart mode. In the Source area, select a database instance for the database to access using Freeform SQL. 3. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. What you'll learn. Click here to view help for the latest version of this product or search MicroStrategy Community. The New Grid dialog box opens. Developer enables you to model applications using an intuitive, graphical interface. 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. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. Explanation: MicroStrategy is a powerful data analytics and business intelligence tool that helps organizations to analyze large amounts of data and make informed business decisions. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. 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. MicroStrategy Data Mining Services allows organizations to use predictive functions that are natively available within MicroStrategy, or import models from third-party data mining vendors. Add 2 new relationships as follow: vi. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. • Warehouse and Metadata is in MS Access. MicroStrategy Tutorial. 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. For this, it uses a relational OLAP architecture. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. 0. In the relational database, a compound key is a primary key. MicroStrategy Education. Graph Reports − These reports show various graphs created from the data sets. Column data descriptions and identifiers: Attribute forms. Data Warehousing Fundamentals in Microstrategy. Its flagship platform contains multiple features designed to help enterprises make data -driven decisions and optimize business processes. Data warehouse for data storage and relational design, page 4. There are mainly three different types of data models: Conceptual: Conceptual data model defines what should the system contain. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. 1. MicroStrategy comes with a sample project called MicroStrategy Tutorial. 4. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. MicroStrategy comes with a sample project called MicroStrategy Tutorial. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. MicroStrategy Tutorial. For more information on what a logical data model is and how to create one, see The Logical. Data models show: • Data elements grouped into records • Relationships and associations surrounding those records For information about data. MicroStrategy Data Mining Services facilitates the development and deployment. The SSAS full form is SQL Server Analysis. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. seq. 3. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43 MicroStrategy Tutorial. MicroStrategy comes with a sample project called MicroStrategy Tutorial. Twenty-seventh Edition, version 9. Data Mining and Predictive Analysis You can deploy a wider range of data mining and data modeling tools along with MicroStrategy to augment its native analytical capabilities. All 3 types of objects are pre-created. For new installations of MicroStrategy 8. Process Advisors. Browse courses: Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. The retail store sells electronics, books, movies, and music. MicroStrategy’s gateways span more than 99% of the data ecosystem your organization has, and MicroStrategy is always committed to expanding these gateways to meet—or exceed— your enterprise data needs. A process should be put in place to ensure continued. We would like to show you a description here but the site won’t allow us. Request a demo. Physical Data Model is the default schema in Erwin format that can be used to generate scripts for creating tables and/or as an initial design for a new data warehouse. A logical data model graphically depicts the flow and structure of data in a business environment. MicroStrategy’s ability to build a modeled schema has historically been the standard for ensuring a single version of truth across the enterprise. It is a theoretical presentation of data objects and associations among various data objects. You will gain expertise to do multidimensional data modeling involving hierarchies, levels, measures and schemas. You must log in as a user with administrative privileges. Perform transformation functionality as the editor provides correction suggestions as you go through the data transformation process. This type of business analytics employs techniques such as drill-down, data discovery, data mining, and correlations to uncover the root causes of. You can then build predictive analytics reports on top of it and. The customer needs to upgrade to these new releases to pick up the fix. It has a simple menu to import data for analysis and export the result of analysis. Section:2. On the Freeform Sources tab, select Create Query Builder report. There are two approaches to modeling in MicroStrategy: Create project models from MicroStrategy Developer Create ad hoc models from MicroStrategy Web Architect Interface in MicroStrategy Developer Connect to a database instance and drag tables. Attribute forms are identifiers or descriptors of an attribute, as explained in Logical data modeling conventions. Useful Functions: Next Topics » Creating A Dataset Report: Creating A Predictive Model: Importing The. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. It aids in AI-assisted data exploration, automates dossier design processes, and offers tools like SQL generation and ML-based visualization methods. This is different from the physical data model or warehouse schema, which arranges data for efficient database use. 214 Introduction to Coding with MicroStrategy SDK 2022. 3. And, because it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. Self-Service Analytics with Amica. A description form. x, "Use relational model" is selected by default. 014 Data Scientist ANALYST (ANL) DATA SCIENTIST (SCI) DEVELOPER (DVL) 2022. MicroStrategy enables data scientists to import MicroStrategy data into RStudio and Jupyter Notebook. In the "Select Data Source" window, go to the "Machine Data Source" tab and select the DSN created in Step 2. Undo and redo the wrangling operations that are done on a dataset. Both partitioning schemes depend on proper treatment of attribute data. 6. MicroStrategy Project Design Guide. The project schema refers to an internal map that MicroStrategy uses to keep track of attribute relationships, fact levels, table sizes, and so on within a project. It incorporates data transformation and descriptive statistics. There should be at least ten input records in the training data. MicroStrategy’s OLAP functions allow business users to understand and predict business events without being trained on analytic techniques. With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize data and better reflect relationships. The following examples use the MicroStrategy Tutorial project for illustration purposes. - pull data out of it. 65K. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. Setup and Configuration. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. You will gain expertise to do multidimensional data modeling involving hierarchies, levels, measures and schemas. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. 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. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. . It is also known as Star Join Schema and is optimized for querying. By the end of the MicroStrategy training at Tekslate, our course participants will be able to . It does not represent the physical data structure in the company. HBase can store massive amounts of data from terabytes to petabytes. Founded in 1989 by Michael J. A data model can be simple, such as a single table. After the third-party application develops the PMML-based predictive model based on the dataset, MicroStrategy imports the model to generate reports. Then we map this logical data model…A database table used to store sales data (revenue, profit, cost, and so on) at different logical levels. project_id ¶ Id of the connected MicroStrategy Project. This article explains how to model recursive hierarchies in MicroStrategy. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. Even though a large number of attributes were included, the resulting model includes only those attributes that were established as strong predictors-gender, age. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. MicroStrategy Project Design Guide. There are Power BI components are 5 main components released in the market. Build a map-enabled report In this topic. Click Run newly saved report to execute the report and display the results, showing sample data from the sample data warehouse. The MicroStrategy Tutorial is an interactive product. In addition, it will also be helpful for. The retail store sells electronics, books, movies, and music. 2987. A project is the highest-level intersection of a dataColumn data descriptions and identifiers: Attribute forms. 2. A logical data model graphically depicts the flow and structure of data in a business environment. Power View: This component allows you to visualize, analyze, and display data. Untuk itu, MicroStrategy HyperIntelligence hadir demi mengakselerasi pentingnya pengelolaan data dalam pengambilan keputusan bisnis. For example, you could create qualifications for six months ago and for 8 months ago. The data mining process involves using the predictive models based on existing and historical data to project potential outcome for business activities and transactions. For information on connecting to databases, see Connect to Databases. g. This Article answers some frequently asked questions that are related to Microstrategy Education courses. It can connect to data warehouses, relational systems, flat files,. Projects generally also contain other. Business users move seamlessly between all five styles of BI and even combine multiple styles. Initially, it was Google Big Table, afterward; it was renamed as HBase and is primarily written in Java. MicroStrategy Project Design Guide. Click "Ok" and enter the credentials to connect to the database. 2 In the Tutorial project, click the MicroStrategy icon and select Shared Reports. MicroStrategy describes its core reporting. In the first section of the course,we will be discussing data warehousing and dimensional modeling concepts. Copy and past all the cube files included with the Tutorial Data download from the prerequisites section (in a folder called 'Cubes'). A good reference document is the Teradata white paper Data Model Overview: Modeling for the Enterprise While Serving the Individual. 02:18. Diagnostic analytics shifts from the “what” of past and current events to “how” and “why,” focusing on past performance to determine which factors influence trends. MicroStrategy OAuth 2. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. There are 3 ways of configuring thresholds: Go to Format tab → Data Points → Threshold. Controlling Access to the Database: Connection Mappings. 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. The actual model building is a simple 2-lines code using auto. You combine data in the logical layer. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze internal and external data in order to make business decisions and to develop mobile apps. Questions you should ask about your project include: •. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. The MicroStrategy Tutorial data model A data model is a logical map that represents the inherent properties of enterprise data, disregarding software, hardware, or machine performance considerations. It will give a clue on how the information within an organization are related. The User Editor opens. For the structures to match, the tables must have the same column names and the data types for each column must be "compatible" across databases. so you can still create and execute reports, but cannot run the documents/dashboards. The count function parameters used in the metric should be changed to Distinct Count and a suitable FactID should be selected in order to use the correct fact to calculate the customers. EN. From the Data menu, select Thresholds. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. The dimension tables are normalized which splits data into additional tables. The MicroStrategy REST API is an Application programming interface that lets developers quickly extract subsets of pre-processed data in JSON format. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. Click OK. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. The MicroStrategy ONE platform provides access to AI-powered workflows, unlimited data sources, cloud-native technologies, and unparalleled performance to speed up time from data to action. Database Instance. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Regression analysis using data mining functions is described in. The MicroStrategy dashboard: Become acquainted with the dashboard, which is the. Founded in 1989 by Michael J. MicroStrategy is an enterprise BI application software. In contrast, the logical data model is a logical arrangement of data from the perspective of the general user or business analyst. PMML supports a number of different data. 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. The following illustration shows how each component is represented within a logical data model: Structure of a Logical Data Model. Select MicroStrategy Tutorial as data source and choose table “LU_MONTH”. New in MicroStrategy 2021. This model is typically created by business stakeholders and data architects. MicroStrategy Project Design Guide. 1x security model:. MicroStrategy Enterprise Manager를 사용하려면 MicroStrategy Command Manager가 설치에 포함되어야 합니다. Gather information about your data source. Select the Tutorial Data database instance. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Here's how sql server is used on microstrategy developer resumes:Freeform SQL Report Error. project_name ¶ Name of the connected MicroStrategy Project. For those coming from previous software generations (7, 8, or 9) MicroStrategy Desktop was the tool that was used to create the metadata and reports on a Windows (PC only) environment. Dimensional Modeling concepts. Some Data Modeling tools support this concept, where you can decide if. 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. MicroStrategy Project Design Guide. To overcome, the proposed method presents a new strategy to automate the multidimensional design of Data Warehouses; this algorithm uses an enterprise schema of an operational database as a starting point to design data warehouse schema. Switch from Developer to the modern Workstation to empower your architects with a one-stop shop for all things MicroStrategy. A day earlier, during the opening keynote address of the conference, MicroStrategy, a long-established BI vendor based in Tysons Corner, Va. All Rights Reserved INTRODUCTION This. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. Author: Intellipaat. iv. MicroStrategy Tutorial. There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5) DataMarts. Modeling is creating information that describes another set of data. The New Grid dialog box opens. Look for "Tutorial Data" and "Operational Datamart". 1 Follow the steps above to log in to MicroStrategy Web. Use the predictive metric in reports to produce forecasts. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. Copy and past all the cube files included with the Tutorial Data download from the prerequisites section (in a folder called 'Cubes'). There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5). 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. Standard = 1 (default) or LDAP = 16. Click within the Dataset Objects area to add datasets for the document. The Data Mining Services can be used by business users, report designers and analysts to view and build predictive. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. Explore the folders and double-click any report or dashboard to run it and see the sample data results. 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. Overview of Data warehousing. 4 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the softwarePerform the same procedure for the database instance "Operational Datamart" to update the database login information for Operational datamart. The count function parameters used in the metric should be changed to Distinct Count and a suitable FactID should be selected in order to use the correct fact to calculate the customers. 3. In this example, you get the list of projects in the MicroStrategy Tutorial metadata. It uses the sample MicroStrategy Tutorial project. PMML is an XML standard that represents data mining models developed and trained by data mining tool. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Architect your schema based on enterprise business needs to. ) Formatting Visuals. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. A layer is similar to a legend item on a paper map. The model is automatically embedded in a new predictive metric. Open the table menu and click “Define Relationships”. ACTION: Open the 32-bit ODBC Administrator by launching "odbcad32. Micro. 11771 views | June 22, 2020 05:24. The Create New Form Expression dialog box opens. This model has been designated by its producer as a Non-Scoring Model. 4. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. x even 'Show System Objects' option is selected, as shown below: NOTE: Run the report, and check SQL View. Modeling is creating information that describes another set of data. Save the relationship and the dataset. It offers multiple import/export options, enhancing data literacy and agile application development. Creating Attributes and Metrics. ROLAP Architecture. From the drop-down list in the toolbar, select the metric to which you want to apply the threshold. When creating the attributes for your project, rename each attribute to match the names in the logical data model. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. 17K KB7453: When creating a new report in the Design Mode, the ’Schema Objects’ folder does not appear in. The concept of Dimensional Modelling was developed by Ralph Kimball and consists of “fact” and “dimension” tables. Choose the MicroStrategy Tutorial application and click Select. Click “Prepare Data” to enter the Preview window. The Data Mining Services can be used by business users, report designers and analysts to view and build predictive reports and distribute these reports to users on any device. Watch on. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or. username ¶ Username. MicroStrategy Schema Modeling. In a BI platform, the logical data model is designed and built using current user. It offers a wide range of analytical capabilities. In the Public Objects folder, select Metrics. Design intuitive analytics reports with MicroStrategy ONE. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. As a suite of applications, it offers data discovery, advanced analytics, data. Dimensional Modeling. There are two approaches to modeling in MicroStrategy: Create project models from MicroStrategy Developer Create ad hoc models from MicroStrategy Web Architect Interface in MicroStrategy Developer Connect to a database instance and drag tables onto the canvas. To view the MicroStrategy Tutorial data model using Architect. For example, in the MicroStrategy Tutorial, the ID form of the attribute Day contains two expressions. Note: MicroStrategy Tutorial ships with a many-to-many relationship between Catalog and Item. Compared to other Business Intelligence tools, MicroStrategy is capable of providing a complete enterprise-level reporting solution that is flexible, scalable, robust, and user-friendly. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. What you'll learn. Apache HBase is needed for real-time Big Data applications. Logical Data Model Components. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and. Take note of the following. Data is composed of observable and recordable facts that are often found in operational or transactional systems. EN. This business analyst tutorial for beginners is designed to help you understand Business Analysis right from Software Engineering Methods & Lifecycles to Requirements Preparation, analysis, and presentation. 3 Expand Subject Areas, expand Sales and Profitability Analysis, and then click Category Sales Report to run the report and see the sample data results. Intermediate. A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the report results. • Warehouse and Metadata is in MS Access. Thus, for a given table name, columns and data types should match across all database instances hosting the table. MicroStrategy Tutorial : Login user:. Design schema objects like facts, attributes, and hierarchies using architect design tool. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions. 215 Embedding Analytics with MicroStrategy REST API 2022. In MicroStrategy Desktop, log in to a project. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. Application Development tools, 3. In this table, the PARENT_ID column logically points to another row in the same table (ID column). Well-coordinated with the ETL team and data modeling team to build reporting database according to our requirements. The data model has two layers: The default view that you first see in the Data Source page canvas is the logical layer of the data source. Devising a logical data model for your business. • Adopted best practice framework for easy updates without metadata changes • Over 50 defects improved in Critical Update 1. Using this tool, users can easily transform big data into instinctive dashboards and reports for greater.