See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Name the types of transformation?In SQL View look at where the cross join appears, and between which tables the cross join appears. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. MicroStrategy is a business intelligence tool that is widely used for deriving valuable insights from data in the form of visually insightful reports, graphs and charts. The idea here is to force MicroStrategy to use always the SQL code always the calendar lookup table: Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to the. Case functions Microstrategy. Relate tables are often used to create relationships between attributes. The red lines are used in System Hierarchy graphical view to represent joint child relationships. Now Edit the. Create a Report Services Document 2. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. The Calculated Member dialog opens. Step 1) In this step, Go to package (Here Modelling) and right click. Joint Child in Micsrostrategy is used to handle what type of keys? Options. Click Add New Form. Save the prompt as "Call Center Prompt". Alternatively, you can build the relationship directly into the fact table. - Email: This is the physical address of the user that the email is going to be sent to. The Create Personal View dialog box opens. Add the 'Day' attribute as level with Filtering and Grouping set to 'Standard' and remove the default 'Report Level' target. In these examples, it is important to notice the relationship between the three attributes. Specify a name and location for the new security filter and click Save. 3) Edit Link function cannot be enabled if this workaround applies. In the "Choose Outline" window, expand the folder "Schedule_Relation_Outline" and select "Delete_Schedule_Relation_Outline", as shown in the screen shot below. An inner join is created and a line representing the join appears in the Query Builder pane, running. In order to create a Gantt chart in MicroStrategy Developer 9. To add new users or groups to the object's access control list (ACL): Click Choose Users/Groups. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. MicroStrategy offers an intuitive way to create and modify business. Open the dossier you want to modify. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. SecurityRegion table defines from which region a user is allowed to view data. Open Default_Accounts. For more information on using joint element lists in filters, see the Filters section of the MicroStrategy Developer Help (formerly the MicroStrategy. Bulk Export options are only available in MicroStrategy Developer. The multiple columns are joined with other attributes, typically in a many-to-many relationship. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. 1. Answer: With OLAP services users can create a unique report views by removing or adding attributes and metrics contained within the intelligent cube. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. Select one: To create a new security filter, click New. To Define a Join Between the Columns of Two Tables. In a relationship between Year and Quarter, Year is the parent attribute and. Composite keys are constituted of two or more columns which together act as unique identifier. 2) The example in this technote uses URL API for child report, therefore the syntax is evt=4001. It is recommended that HTTP path should be used for reference image. Choose one of. A joint child is Microstrategy way of handling Composite Keys. Case functions Microstrategy. To handle this case in Microstrategy we make this set of columns. This video demonstrates how to create custom SQL filters in MicroStrategy. KB18269: 'The job execution time limit set in MicroStrategy Intelligence Server has been exceeded for job XXX. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. mmp. Source: MicroRooster. Create a report with Category, Subcategory and Revenue. Click the Add icon to the right of the Element list. A joint child is MicroStrategy way of handling Composite Keys. The first value in each attribute is added to the list. Attributes Child Candidates are chosen by taking all the attributes that share a source table with the attribute in question and subtracting the attribute in questions. _____ type of filtering raises the report filter to the level of the target. CA_FI_LEDGER will display finance document detail related to a purchase order. To burst a file subscription across multiple files. From the Visualizations panel, select Grid . 4) Next, change the Theme back to None and click Apply. When a joint child attribute, which is an attribute that exists at the intersection of other indirectly related attributes, is added, this affects how the attribute elements and transformation values are displayed. Place the new metric in the desired location, as shown in the screen shot below:The MovingSum function is found in schema objects > functions and operators > functions > OLAP functions. 2. Groups may also be assigned permissions to objects. " Select "Use a filter to reduce the number of elements" and select the "QUARTER FILTER" created in the previous step. The 'photo_upload' table has to be pre-populated with *exactly* 10 rows of data, the values for the 'ID' column should. Select Filter definition prompt -> Choose from an attribute element list as shown below. This method is the most straightforward way to effectively manage many-to-many relationships. An inner join is created and a line representing the join appears in the Query Builder pane, running from the column in the first table to the column in the second table. In the layout tab, click "Allow multiple selections". Report will display result as below. You link directly related attributes to each other by defining parent-child relationships, as explained in Attribute relationships. The data for the Lookup_Region table came from a different source system than the data for the Lookup_Call_Ctr and the source systems have different naming conventions. 1KB46734: In MicroStrategy Web 9. When Distinct. Click Condition on the Metric component pane. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. The Report Data Options dialog box opens. •. The Preview Dialog opens. 3. Sum(Revenue){~+}. This is part 1 of a series of advanced MicroStrategy Architect tutorials where I will demonstrate how to create joint child relationships. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. The simple key shows how you can identify a calling center with only its Call_Ctr_id. exe to this machine. Creating a report for analysis. Create application objects. Composite keys are constituted of two or more columns which together act as unique identifier. Logical Views allows application architects to create any desired view. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. Expand the Database Instances category, and then select Connection Mapping. Click Insert Visualization . When you design a logical data model for your project (see The Logical Data Model), the relationships between attributes should become apparent. Click Certify. MicroStrategy announced they are providing customers with a bundled data warehouse solution that will include the MicroStrategy Business Intelligence Platform™ with IBM's DB2® Universal Database (UDB) Data Warehouse (DWE) Standard Edition. Open the template in the Template Editor; the rest of the instructions remain the same. 1. Click 'Add External Data' and then 'File From Disk'. . More details can be found here. 4. This video demonstrates how to create custom SQL filters in MicroStrategy. mstrc) Open Workstation. Ans: Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. This online training video demonstrates how to create transformation objects in MicroStrategy. In this video I discuss when to use joint element lists in MicroStrategy and demonstrate how to create them. Once these Logical views are created, they are available to the report designer in a way similar to any other table. • Analytical Engine. Slowly Changing Dimensions. x and are instead displayed at the bottom of the page as shown in. Cross-tab stage. Create an hidden attribute (let's call it "Date_on_fact") map it on the fact table and the calendar table and make it child of both "Order Date" and "Invoice Date". 0, a VLDB property is available to control the join behavior between component metrics in a nested compound metric: "Nested Aggregation Outer Join," located under Joins in the. Click on #mstrIconProject to expand the properties defined for this rule. The report displays the quarter, the promotion. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. For example, a scheduled report executes which shows the Revenue by day for the past week. Setting the metric formula join type for. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. Whenever a report is executed and SQL is generated, the MicroStrategy SQL Engine performs the following steps to determine what tables is to be used: Get the set of tables that can resolve the report, according to (mainly, but not exclusively) the attributes on the template, attributes on the filter and the metric dimensionality. • Query Engine. x with any number of attributes. 5. x, red lines are integrated with the default black lines when displaying the attribute relationships as shown in the image below. the Grid Lines are on the Display Status tab. In the Subscription Editor, click Burst…. A transformation table is a type of relation table, normally used to create a transformation metric. L1_ID as varchar (10))) CustCol_1, sum. 3. The schema looks like the following diagram. In MicroStrategy projects, you explicitly define any direct relationships between attributes. Create a metric 'MTD Revenue' with fact 'Revenue'. Go to 'Data' on the top menu bar. This video also has a a brief discussion about how to create advanced filters as joint element lists. 5. Drag the Date or Age attribute in the vertical section. If an environment does not already exist, an environment will need to be created first. Create a joint element list qualification. A ragged hierarchy is the one in which the parent or child attribute element of one or more attribute elements are not present in the level immediately above or below the attribute. Relate tables contain the ID columns of two or more attributes, which will define associations between them. Without submitting a new request to the data warehouse, the new calculation is performed. This video also has a a brief discussion about how to create advanced filters as joint element lists. Click Next. Report filters based on attributes unrelated to the attribute in the metric condition are still kept and included in the. Go to Project Configuration > Database Instances > Connection Mapping as seen below: Click on New to create a new Connection Map and fill in the Criteria for the USA users for their connection mapping, as shown below: Note: When creating a new connection map, the users can choose from the following two types of database instances. Browse to the filter you want to convert and click Open. The purpose is to show how a filter can be manipulated to give the developer full access over the where clause generated by MicroStrategy's SQL engine. Create New Metric in a report or VI. From the Visualizations panel, select Grid . Create an hidden attribute (let's call it "Date_on_fact") map it on the fact table and the calendar table and make it child of both "Order Date" and "Invoice Date". Right-click the table and select Create Attribute. Save and close the metric. Add a Joint Element List Filter as: (Year, Subcategory) IN {(2014, Art & Architecture), (2015, TVs), (2016, Pop)}. Click on the "Validate" button to validate the formula. A child must always have a parent and a parent can have multiple children. Member attributes: This component contains the attributes to which the transformation applies, that is, the different levels to which the rule applies. x, select 'Project Documentation' from the Tools menu to start the wizard. The following options are available: Ø Transaction Mapping options. The idea here is to force MicroStrategy to use always the SQL code always the calendar lookup table:Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. In the right corner of the dashboard, change the data source to none. Joint Element Lists are an advanced filtering qualification in MicroStrategy Developer / SQL Engine that can be used to filter on combinations of attribute element. In short, some attribute elements don't have a relationship with their parent/child attribute. Microstrategy allows reporting on: Which of the following are valid types of. MetricB will serve as the length/duration from the starting point. This will do the following things: Back up the entire registry to " reg_backup_<timestamp>. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Select the Include extra fields in output (precision, city, country, etc. For example, there. To view and edit the parents and children of an attribute. x - 10. From the 'Edit' menu, choose 'Group'. To create an attribute filter. ) check box to. To Create a Derived Metric Using a Function. How to design a bar graph report with the color of children bar graph inherited from the color of the source bar being drilled in MicroStrategy Developer 9. Open the document in Design or Editable Mode. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. Select Joint Element List from the Option pull-down list. Ragged Hierarchies in Microstrategy. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as joint child. The Create New Attribute Form dialog box now appears. Rather than creating facts by manually creating a fact expression, you can allow Architect to automatically create simple facts defined on one column. Then click on New Document. Click Save and Close to save the metric and close the Metric Editor. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. x. Below is one solution in the Tutorial project as an example. To display a group horizontally. Metric Editor -> Tools -> Metric Joint Type. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. • In what quarters was a certain item involved in a certain type of promotion? To answer these questions, you must combine the two relationship tables, creating one. Open up the same document in MicroStrategy Web 10. Follow the steps below. 1. If a user creates a report with two attributes, for example Country and Warehouse, the user may want to create a joint element list filter in order to choose different. Import the Data. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as. Method 1. The abundant design options deliver full control over position, formatting, and interactivity. 4. From the Choose a Permission Level drop-down list, select the predefined set of permissions, or select Custom to define a custom set of permissions. Un-map the "Order Date" and "Invoice Date" from the fact tables. Creating your chart. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on. Select the Subtotals/Aggregation tab. Ø Local Transaction options. MicroStrategy's Report Builder steps you easily through the process of quick report creation, and lets you access a wide variety of report objects in your project to define your report. 4. Setting the metric formula join type for compound metrics. mstrc) Open Workstation. A split hierarchy is one - that at the lowest level - has more than one child. Click the attribute and drag the border of the attribute (parent) to another attribute (child). Method 1 requires you to create a separate relationship table (in this case, Rel_Color_Item) and add both attribute IDs to the fact table as shown in the following diagram. The parent element appears in Parent. 5. How to create a MicroStrategy connection file (. or. . Import the Data. In the Filter Editor, use the Object Browser to search for the attributes, metrics, filters, prompts, or reports you want to use in your filter. In Teradata, the Extract function returns the month, day or year from a date field. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Create a Report Services Document 2. The score displayed at the end of. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. The elements of a metric level are described below: •. We are going to create a graphical Calculation View “CA_FI_LEDGER” by joining two Analytic View “AN_PURCHASE_ORDER” And “AN_FI_DOCUMENT”. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. Below are the steps to enable/disable the settings of data blending: 1. Level dialog box. In the right corner of the dashboard, change the data source. When you create a new user, you need to provide some or all of the following information: Login information. Workaround / Solution. Ø Local Transaction options. In the Source drop-down list, select Google. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. The Grouping panel is displayed. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Zip File Name: Type a name for the zip file in the Zip File Name field. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. x, follow the steps below: Create a report with two metrics and at least one attribute, as shown below: Change the report to graph mode. This video also has a a brief discussion about how to create advanced filters as joint element lists. Double-click on CSS to expand the child nodes under it. Select the Password protect zip file check box and type a password for the zip file. The Level advanced options dialog box opens. This is a known issue prior to MicroStrategy SQL Engine 9. 1. OR, to convert an existing filter into a security filter, click Import. These attributes are then linked with a parent-child relationship. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. The default join behavior will be "Use minimum relation," regardless of what the setting is set to. Choose from the menu Graph > Grids and Scales. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. This join type lets you display only those attribute elements that are common to the lookup tables and the fact tables in your data warehouse. This technical note describes the steps to create a report that displays a row for each of the months in a year up to a month specified in a report filter qualifications in MicroStrategy Developer 9. The first value in each attribute is added to the list. Type the Name of the personal view. Select an in-memory cube. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformRight-click the table and select Create Fact. This article describes the purpose of the Sub Query Type VLDB property in MicroStrategy. Choose attribute Call Center and use the Region Filter created in the previous step. Create an auxiliary metric that uses the 'End on hand' fact but aggregates values one level higher than the one in the report, as shown below: Create a subtotal based on the auxiliary metric, as shown below: Add this new subtotal to the list of available subtotals for the 'End on Hand' metric. From the drop-down menu, choose the database instance against which the user ID should be verified. Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Open the report’s subscriptions in MicroStrategy Web: Scroll down to the Email subscription and click the option to “Add email subscription”: Choose the schedule by clicking the drop-down and selecting the. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. 2. g. Specify the desired delivery options including recipient address, subscription name. Place only the lowest level filter in the filter section of the report. This report shows the complete set of data. Right-click the table, point to Recognize, and then select Facts. The maximum number of partitions is dictated by the number of cores on the box. . If an environment does not already exist, an environment will need to be created first. 47K. When creating a count metric within the Metric Editor, users are able to highlight Count, right-click, and select "Count Parameters". Click Save and Close to save the metric and close the Metric Editor. Composite keys are constituted of two or more columns which together act as unique identifier. This technical note explains how to create a joint element list filter in order to choose different criteria for two different attributes in MicroStrategy Developer 9. Using a combination of filters and metric dimensionality, the same results can be achieved. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. This function allows you to. Insert an HTML container (and not an image) and insert the script below. Click Add a new table. Typically, dimensional hierarchies are presented as independent of time, e. Create a report in Tutorial with Region, Call Center, Distribution Center, and Cost. Click the location on your document in which to place the widget. Open the Filtering Options pane. To burst a file subscription across multiple files. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. It is used to apply database (row-level) security to a MicroStrategy user. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Two forms of attribute relationships, many-to-many relationships and joint child relationships, can introduce additional complexity to the schema and warehouse design. When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. Users can select multiple Attribute Elements using CTRL+clicking on the space in the cell next to the Attribute Element, but these are not passed from parent to child Report/Document in MicroStrategy Developer 9. To reference an image using relative path, the following locations are required to store the image in order to display in multiple MicroStrategy products. A message is displayed at the top of the report, document, or quick dashboard, confirming that the personal view is saved. To create an object prompt. When a joint child attribute, which is an attribute that exists at the intersection of other indirectly related attributes, is added, this affects how the attribute elements and. Examples include "Region = Northeast" or. •. The example below shows that the years 2008 and 2009 are not passed from parent to child Report/Document:How to create a report that shows the beginning and ending values of a date range on the template in MicroStrategy Developer 10. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Select the. x, select 'Project Documentation' from the Tools menu to start the wizard. mstrc) Open Workstation. For example, the joint child attribute Promotion is added to the previous report. In the Datasets panel, click More next to the dataset name and choose Edit Dataset to add data to the dataset. Once these Logical views are created, they are available to the report designer in a way similar to any other table. Hierarchy 2: 4. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Click Insert Visualization . Define the relationship. The report execution is typically a 3 step process process of the below: Query Stage. For example, a scheduled report executes which shows the Revenue by day for the past week. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 3. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. css to expand the rules defined within this CSS file. For example, in the Last Year transformation in the MicroStrategy Tutorial, the member attributes are Year, Quarter, Month, and Day. How to create a MicroStrategy connection file (. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. This is a filter which contains a prompt on an attribute element list. Follow the steps below to reproduce this issue in MicroStrategy Tutorial: This example requires 6 attributes to effectively demonstrate the issue: -Region and Employee, where Region is the parent of Employee (one to many) This issue occurs specifically when there are attributes on the document that contain joint-child parent-child relationships. You. x. Since the fact table is at the lowest level, the MicroStrategy Engine finds the join path through the lookup tables. For example, a scheduled report executes which shows the Revenue by day for the past week. Method 2. x Product Suite, all the application, schema and configuration object definitions and other project-related settings are stored in the metadata. There's a reason we're at the top of the list. Show more In this video I discuss when to use joint element lists in MicroStrategy and demonstrate how to create them. 3. x-10. Add the following expression if using SQL Server. The full path and file name of the MicroStrategy Enterprise Manager project package file used to create the project. Define the advance sort on the derived. Want to learn more? Check out my Architect course. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. On the Template tab, click Change Template to use one of the five card templates. The Configure Transactions Editor opens. Click on the Insert Outline icon in the Microstrategy Command Manager toolbar. Users can use Microstrategy Desktop to create reports that access SAP data and join data across SAP BW Info Cubes and Query Cubes as. Create a file subscription in MicroStrategy Web. The bundled data warehouse solution will be available immediately through IBM and will. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so that you get the correct data for reports that use the parent attribute in a joint child attribute. 2. Select any project that is in the project source that contains the users and groups and click Next. Custom number formatting symbols. However, it may be desired to created a similarly structured qualification on attribute forms besides the ID. This article notes a limitation of MDX data sources for filters on different levelsCreate a PostgreSQL user for Platform Analytics and the warehouse. Populate and Evaluate: Fill report data required for display. Step 1 – Create a new report and add the attribute month and the revenue metric as seen in the below screenshot. x-10. 1. To do this: a. 4. Qualifications are the actual conditions that must be met for data to be included in the custom group element. What is a joint child? A joint child is Microstrategy way of handling Composite Keys. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER. After selecting the blank dashboard, unlock it from the Options. In MicroStrategy Developer, log in to the project source that contains the MicroStrategy Tutorial project and then log in to MicroStrategy Tutorial. Examples include "Region = Northeast" or. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. Create a blank dossier or open an existing one. Ans: Joint child helps to maintain the composite keys which are constituted with more or more columns as unique identifiers. After dragging and dropping the correct elements, you. 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'. 2. Create a metric qualification. 4. September 18, 2018. Save and run the report. In the left side of the Security Filter Manager, in the Security Filters tab, browse to the security filter that you want to apply, and select that security filter. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. Follow the steps below to reproduce this issue in MicroStrategy Tutorial: This example requires 6 attributes to effectively demonstrate the issue: -Region and Employee, where Region is the parent of Employee (one to many)Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. sql . Want to learn more? Check. Revenue + Profit. KB5078: How to create a value prompt in MicroStrategy Developer 9. The parent-child relationships you create determine the system hierarchy within the project. Copy the code for the D3 visualization you are using. In MicroStrategy Web, open the document in Design or Editable Mode. MicroStrategy Reporting Suite is a complete business intelligence platform that covers all the data analysis needs of an enterprise. Create the report with 3 attributes and 1 metric.