Possible data marting applications include
The primary purpose of data marting is the creation of relational tables that can be used and updated in the same manner as those in a project schema. Data mart tables are created from the information in the columns and rows of reports that are selected or created for this purpose.
To create a relational table for data marting
MicroStrategy then creates the data mart table in the database you have selected. When table creation is complete, the system returns a message that includes the table name and notification that table creation was successful.
For table and metric alias naming, ensure that the table and metric alias names follow the naming convention rules for your particular database platform. You will receive an error if you do not use a valid table or metric alias name.
The output of data mart reports: relational tables
When the contents of a report have been used as input for data marting purposes, the result is a table located in a relational database. Data mart tables possess all the characteristics of other data warehouse tables, and have, therefore, the same requirements for creation, including
Any character other than D, U, or O, invalidates a placeholder and causes it to be deleted from the data mart table. Placeholder characters are case-sensitive; they should be entered in all-uppercase.
If the data mart database is in the same physical location as that of the warehouse, the results do not need to be brought to the server for placement.
If the data mart database is in a different physical location from that of the warehouse, the results set needs to be brought to the server for insertion into the new platform.
The settings at the data mart report level always override the settings at project level. By default, the Maximum execution time is set to ‘0’, which means that the project level setting will be used. The project level setting is available in the Governing category of the Project Configuration Editor. For example, if the maximum execution time at data mart level is set to '0', and the setting at the project level is set to 10 seconds, the report will timeout after 10 seconds. But, if you set the maximum execution time as 5 seconds, and the project level setting is specified as 10 seconds, the data mart report level overrides the project level settings, and the report will timeout after 5 seconds.
Pre- and post-SQL statements allow the application of user-defined SQL before and after the creation of data mart tables. Possible uses include GRANT privileges and index creation.
Pre- and post-table creation settings apply to data mart tables only; they do not affect settings generated to process a report.
Custom groups in data mart tables
Since custom groups do not exist as columns in the warehouse, when a report includes a custom group the resulting data mart table contains data that does not directly map to corresponding columns in a warehouse table. For this reason, data derived from custom group columns is handled differently.
This figure shows how columns appear in data mart tables created from reports that include custom groups.
In a table structured as shown:
The figure that follows shows part of a sample table that includes custom group data.
In this example,
A points to the element-ID column as it appears in the data mart table. Element IDs (1, 2, 3,...) are extracted from the corresponding custom group elements in the report.
B points to the element names as they appear in the data mart table. These names are extracted from the corresponding custom group element names in the report.
Similarly, when a report includes columns that reflect consolidations, the SQL Engine provides element ID valuesfor the data mart table. In such cases, the table structure looks like the following.
In a table structured as shown:
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.