Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from MicroStrategy 7.0 to 11.x

Bridge Specifications

Vendor MicroStrategy
Tool Name Intelligence Server
Tool Version 7.0 to 11.x
Tool Web Site http://www.microstrategy.com/
Supported Methodology [Business Intelligence] Multi-Model, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage), BI Report (Dimensional Source, Report Structure) via COM API

BRIDGE INFORMATION
Import tool: MicroStrategy Intelligence Server 7.0 to 11.x (http://www.microstrategy.com/)
Import interface: [Business Intelligence] Multi-Model, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage), BI Report (Dimensional Source, Report Structure) via COM API from MicroStrategy 7.0 to 11.x
Import bridge: 'MicroStrategy' 10.1.0

BRIDGE DOCUMENTATION
The bridge relies on the MicroStrategy Intelligence Server COM/OLE API to import metadata. Therefore, a supported version of MicroStrategy must be properly installed (and able to open the metadata to be imported) on the same computer where the bridge is executed.

Please note, MicroStrategy database corruption may be a problem for the proper function of this bridge. Such corruption may be reported in the MicroStrategy log file: C:\Program Files\Common Files\MicroStrategy\Log\DSSErrors.log. MicroStrategy support is aware of this issue and provides a ScanMD program which may be used to cleanup these errors. Be sure to always run the ScanMD program before using this bridge.

METAMODEL INFORMATION

Prompts:
The bridge metamodel has support for (data) Prompts as subtypes of Classifier and Feature. Data prompts are the kind of prompts that specify a piece of data from a table or dimension. MicroStrategy also support metadata prompts, which, for example, allow choosing a measure or a filter to include in a report. The bridge metamodel then models prompts as Classifier and Feature, and thus does not completely represent the lineage for metadata prompts that depend on objects that are not Classifiers or Features.

Documents:
MicroStrategy Documents can embed Reports or use objects in their Dataset. Relationships between Documents and their Reports are captured with connection and lineage links.

Database Connections:
This bridge does not import database connection or user information.

Dimensions:
This bridge imports MicroStrategy logical tables as Dimensions. MicroStrategy logical tables do not necessarily represent physical tables. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. In addition, multiple logical tables can represent the same physical table. Finally, logical tables carry measures and levels that are dimensional notions.

Reports:
The bridge does not differentiate between user created reports and reports that are created automatically by MicroStrategy with a new project. They are treated the same, and thus reports that you may not be expecting will be imported.

KNOWN LIMITATIONS:
The following relationships are not captured:
- Between HTML Documents and the Reports they embed
- Between Reports and the Intelligent Cube they use

Derived Elements are not supported.

SUPPORT
When reporting issues with the bridge, it is generally necessary for the support staff to reproduce the behavior and thus you must provide the original MicroStrategy metadata. The MicroStrategy Intelligence Server uses a relational database to store the projects' metadata. Use your RDBMS utilities to create a database backup. Please provide the database backup file and the MicroStrategy username/password used to login.

Be sure to always run the ScanMD program (referred to above) before creating this backup file.

How to configure user security for successful harvesting:
In the MicroStrategy Developer desktop tool:
1. connect to the Project Source as Administrator or as another login that can manage security
2. define a User, under Administration / User Manager / Everyone
3. define a SecurityRole, under Administration / Configuration Managers / Security Roles
4. associate the User to the SecurityRole as a member
5. right-click on the Project or User, and grant access to the Project for the User and the SecurityRole
6. check the following privileges (permissions) on the User (for old 7.x versions) or on the SecurityRole (for newer 9.x, 10.x versions):
- Use server cache
- Use Developer
- View SQL
- Administer Caches
- Load and Unload project

Note that the privilege below allows bypassing security checks for each object.
- Bypass all object security access checks
This avoids having to set permissions on every object in the MicroStrategy project that you wish to import, which would be required otherwise.


Bridge Parameters

Parameter Name Description Type Values Default Scope
Version Select the version of MicroStrategy. ENUMERATED
Auto detect
11.x
10.5 to 10.8
9.x to 10.4
8.0.0 to 8.1.2
7.5.2
7.5.0
7.0
Auto detect  
Project Source Enter the name of the MicroStrategy Project Source to connect to. A Project Source is a connection to a repository that is located on a local or remote Intelligence Server which holds connectivity to a data warehouse and contains a number of metadata Projects that operate on this data warehouse. The list of Project Sources that are accessible from this computer is stored in the Windows registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\MicroStrategy\Data Sources
or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MicroStrategy\Data Sources

To connect to a remote Intelligence Server that has not yet been registered on the local computer, when a Project Source pointing to this Intelligence Server is not yet defined, create this Project Source first in MicroStrategy.
REPOSITORY_MODEL   MicroStrategy Tutorial (Direct) Mandatory
Project(s) Enter the name(s) of the Project or projects that you want to connect to in the selected Project Source. REPOSITORY_SUBSET   MicroStrategy Tutorial  
Login user Enter the user name used to connect to the Project Source.

This import bridge is warrantied to be read only and will never affect the Repository contents. It is therefore safe to attempt the initial metadata harvesting as 'Administrator' in order to ensure that the entire Repository content is extracted without any access permission issue. Eventually, the administrator can set up a 'read only' user.

Refer to the tool documentation on permissions and security for more details.
STRING   Administrator Mandatory
Login password Enter the password used to connect to the Project Source. PASSWORD      
Default Language Specify the language you would like to use.
Only MicroStrategy versions 9.x support multiple languages.
ENUMERATED
Chinese (Simplified)
Chinese (Traditional)
English (United States)
French (France)
German (Germany)
Italian (Italy)
Japanese
Korean
Portuguese (Brazil)
Spanish (Spain)
Swedish (Sweden)
English (United States)  
Import schema only Select this option to only import the selected project's schema, and skip reports, documents.
Setting this parameter to 'True' is useful to convert the project to a data modeling tool, because these tools do not consume reports.
'True' - Only the selected project's schema is imported. Only the first project in the list given by the 'Project(s)' parameter is considered.
'False' - The schema for the selected projects are imported, as well as their reports and documents (default).
BOOLEAN
False
True
False  
Data model Tables design level This option controls the design level of the imported tables. It is particularly relevant when exporting metadata to a target tool which supports two views of the model: a logical view and a physical view. Some Data Modeling tools support this concept, where you can decide if a table appears both as a physical table and as a logical entity. Some Business Intelligence tools also support this concept, where you can decide if a table appears both in the physical model and in the business view of the model.

'Logical and physical' - Tables will appear in both in the logical view and in the physical view of the model.
'Physical' - Tables will appear only in the physical view of the model (default).
ENUMERATED
Physical
Logical and physical
Physical  
Incremental import Specifies whether to import only the changes made in the source or to re-import everything (as specified in other parameters).

True - import only the changes made in the source.
False - import everything (as specified in other parameters).

An internal cache is maintained for each metadata source, which contains previously imported models. If this is the first import or if the internal cache has been deleted or corrupted, the bridge will behave as if this parameter is set to 'False'.
BOOLEAN
False
True
True  
Import joins Specify whether joins should be imported.

'True' - The joins are imported. (Default)
'False' - The joins are not imported.
BOOLEAN
False
True
True  
Import hierarchies Specify whether hierarchies should be imported.

'True' - The hierarchies are imported. (Default)
'False' - The hierarchies are not imported.
BOOLEAN
False
True
True  
Multiple threads Number of worker threads to harvest metadata asynchronously.
Leave the parameter blank to have the bridge compute the value, between 1 and 6, based on JVM architecture and number of available CPU cores.
Specify a numeric value greater or equal to 1 to provide the actual number of threads.
If the value specified is invalid, a warning will be issued and 1 will be used instead.
If you experience out of memory conditions when harvesting metadata asynchronously, experiment with smaller numbers.
If your machine has a lot of available memory (e.g. 10 Gb or more), you can try larger numbers when harvesting many documents at once.
Note that setting the number too high can actually decrease the performance due to resource contention.
NUMERIC      
Miscellaneous Specify miscellaneous options identified with a -letter and, if applicable, a value.
-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
-r to remove the report pages and their graphical structure.
-sf to skip importing filters.
-sp to skip importing prompts.
-spv to skip importing creation, modification date and author for schema objects.
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (Browse Project Sources)
Mapping Comments
     
DirectoryStructureModel Project Sources  
Name Name  
StoreContent Project Source  
Name Name  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (Project)
Mapping Comments
     
Attribute Column  
Comment Comment  
Description Definition  
DesignLevel Design Level As defined by 'Tables design level' bridge option
ExtraConstraint Constraint  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Class Warehouse Table  
Comment Comment  
Description Description  
Name Name  
NativeId Native Id MicroStrategy object ID
PhysicalName Physical Name  
ConnectionPackage Schema  
Description Description  
Name Name  
NativeId Native Id  
DesignPackage Hidden Folder, Folder  
Description Description  
Name Name  
NativeId Native Id MicroStrategy object ID
Dimension Consolidation, Attribute, Logical Table, Subtotal, Metric, Fact Each Logical Table is imported as a Dimension. Dimensions are also created to act as Classifier for Attributes, Facts, Metrics, Consolidations and Subtotals
Description Description  
Hide Hide  
Name Name  
NativeId Native Id MicroStrategy object ID
Type Type  
DimensionAttribute SQL Column, Attribute Form, Consolidation Element  
Description Description  
Hide Hide  
InitialValue Initial Value  
Name Name  
NativeId Native Id MicroStrategy object ID
Optional Optional  
OriginalName Original Name  
Position Position as returned by the API
Sort Sort  
DrillPath Hierarchy MicroSrategy hierarchies are imported as MIRDrillPath as they can have many top levels (entry points) and they can span across levels of different MIRDimensions
Description Description  
Name Name  
NativeId Native Id  
Filter Security Filter, Filter, Custom Group Filter indicates how to perform join between Logical Tables
Description Description  
Hide Hide  
Name Name  
NativeId Native Id  
Join Lookup  
Description Description  
Name Name  
NativeId Native Id  
Type Type  
Measure Metric Measure, Subtotal Measure, Fact Measure  
DefaultAggregation Default Aggregation  
Description Description  
Hide Hide  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position as returned by the API
Sort Sort  
Prompt Prompt  
Description Description  
MultipleSelection Multiple Selection  
Name Name  
NativeId Native Id  
Question Question  
PromptAnswer Prompt Answer  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
StoreConnection Database Instance  
Connection Connection  
Description Description  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  
StoreModel Project  
Author Author  
CreationTime Creation Time  
Description Description  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id MicroStrategy object ID
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (Connection)
Mapping Comments
     
Attribute Column  
Comment Comment  
Description Definition  
DesignLevel Design Level As defined by 'Tables design level' bridge option
ExtraConstraint Constraint  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Class Warehouse Table  
Comment Comment  
Description Description  
Name Name  
NativeId Native Id MicroStrategy object ID
PhysicalName Physical Name  
DatabaseSchema Database Schema  
Description Description  
Name Name  
NativeId Native Id  
StoreModel Database Instance  
Author Author  
CreationTime Creation Time  
Description Description  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (Intelligent Cube)
Mapping Comments
     
Attribute Column  
Comment Comment  
Description Definition  
DesignLevel Design Level As defined by 'Tables design level' bridge option
ExtraConstraint Constraint  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Class Warehouse Table  
Comment Comment  
Description Description  
Name Name  
NativeId Native Id MicroStrategy object ID
PhysicalName Physical Name  
ConnectionClassifier Project Custom Group, Project Object, Project Filter, Project Attribute, Project Subtotal, Project Warehouse Table , Project Security Filter, Project Fact, Project Metric, Project Consolidation  
Description Description  
Name Name  
NativeId Native Id  
ConnectionFeature Project Consolidation Element, Project Fact Measure, Project Metric Measure, Project Custom Group Element, Project Filter Element, Project Attribute Form, Project Column, Project Element, Project Subtotal Measure  
Description Description  
ExternalId External Id  
Name Name  
NativeId Native Id  
Position Position  
ConnectionPackage Schema  
Description Description  
Name Name  
NativeId Native Id  
DataAttribute SQL Metric, SQL Attribute Form, SQL Column  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
DataSet Logical Query Table, Query Builder Definition  
Description Description  
Name Name  
NativeId Native Id  
Filter Security Filter, Filter, Custom Group Filter indicates how to perform join between Logical Tables
Description Description  
Hide Hide  
Name Name  
NativeId Native Id  
Prompt Prompt  
Description Description  
MultipleSelection Multiple Selection  
Name Name  
NativeId Native Id  
Question Question  
PromptAnswer Prompt Answer  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Report Intelligent Cube Report, Report Report  
Description Description  
Name Name  
NativeId Native Id  
ReportAttribute Report Metric, Subtotal, Attribute Form, Metric, Report Subtotal, Consolidation Element, Threshold  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
ReportAxis Report Axis Represent report Vertical, Horizontal and Page axis
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Role Role  
ReportChart Report Graph  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportDataSet Metrics, Consolidation, Thresholds, Attribute, Report Metrics, Report Subtotals, Subtotals  
Description Description  
Name Name  
NativeId Native Id  
ReportField Report Field, Calculated Report Field  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportTable Report Grid  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportText Report Text  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Value Value  
StoreConnection Project, Database Instance  
Connection Connection  
Description Description  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  
StoreModel Intelligent Cube, Report  
Author Author  
CreationTime Creation Time  
Description Description  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (Report)
Mapping Comments
     
Attribute Column  
Comment Comment  
Description Definition  
DesignLevel Design Level As defined by 'Tables design level' bridge option
ExtraConstraint Constraint  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Class Warehouse Table  
Comment Comment  
Description Description  
Name Name  
NativeId Native Id MicroStrategy object ID
PhysicalName Physical Name  
ConnectionClassifier Project Custom Group, Project Object, Project Filter, Project Attribute, Project Subtotal, Project Warehouse Table , Project Security Filter, Project Fact, Project Metric, Project Consolidation  
Description Description  
Name Name  
NativeId Native Id  
ConnectionFeature Project Consolidation Element, Project Fact Measure, Project Metric Measure, Project Custom Group Element, Project Filter Element, Project Attribute Form, Project Column, Project Element, Project Subtotal Measure  
Description Description  
ExternalId External Id  
Name Name  
NativeId Native Id  
Position Position  
ConnectionPackage Schema  
Description Description  
Name Name  
NativeId Native Id  
DataAttribute SQL Metric, SQL Attribute Form, SQL Column  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
DataSet Logical Query Table, Query Builder Definition  
Description Description  
Name Name  
NativeId Native Id  
Filter Security Filter, Filter, Custom Group Filter indicates how to perform join between Logical Tables
Description Description  
Hide Hide  
Name Name  
NativeId Native Id  
Prompt Prompt  
Description Description  
MultipleSelection Multiple Selection  
Name Name  
NativeId Native Id  
Question Question  
PromptAnswer Prompt Answer  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Report Report Report  
Description Description  
Name Name  
NativeId Native Id  
ReportAttribute Report Metric, Subtotal, Attribute Form, Metric, Report Subtotal, Consolidation Element, Threshold  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
ReportAxis Report Axis Represent report Vertical, Horizontal and Page axis
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Role Role  
ReportChart Report Graph  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportDataSet Metrics, Consolidation, Thresholds, Attribute, Report Metrics, Report Subtotals, Subtotals  
Description Description  
Name Name  
NativeId Native Id  
ReportField Report Field, Calculated Report Field  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportTable Report Grid  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportText Report Text  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Value Value  
StoreConnection Project, Database Instance  
Connection Connection  
Description Description  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  
StoreModel Report  
Author Author  
CreationTime Creation Time  
Description Description  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (HTML Document)
Mapping Comments
     
ConnectionClassifier Project Custom Group, Project Object, Project Filter, Project Attribute, Project Subtotal, Project Warehouse Table , Project Security Filter, Report Object, Project Fact, Project Metric, Project Consolidation  
Description Description  
Name Name  
NativeId Native Id  
ConnectionFeature Project Consolidation Element, Project Fact Measure, Project Metric Measure, Report Object Elements, Project Custom Group Element, Project Filter Element, Project Attribute Form, Project Column, Report Object Element, Project Element, Project Subtotal Measure  
Description Description  
ExternalId External Id  
Name Name  
NativeId Native Id  
Position Position  
DataAttribute SQL Metric, SQL Attribute Form, SQL Column  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
DataSet Logical Query Table, Query Builder Definition  
Description Description  
Name Name  
NativeId Native Id  
Report HTML Document Report , Document Report, Report Report  
Description Description  
Name Name  
NativeId Native Id  
ReportAttribute Report Metric, Expression, Subtotal, Attribute Form, Metric, Report Subtotal, Consolidation Element, Threshold  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
ReportAxis Report Axis Represent report Vertical, Horizontal and Page axis
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Role Role  
ReportChart Report Graph  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportDataSet Metrics, Consolidation, Thresholds, Attribute, Expressions, Report Metrics, Report Subtotals, Subtotals Represents objects used in the report, and how they are grouped
Description Description  
Name Name  
NativeId Native Id  
ReportField Report Field, Calculated Report Field  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportList Report List  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportMatrix Report Matrix  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPage Report Page  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPageBody Report Page Body  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPageFooter Report Page Footer  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPageHeader Report Page Header  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportRectangle Report Rectangle  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportTable Report Grid  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportText Report Text  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Value Value  
StoreConnection Project, Dataset, Database Instance  
Connection Connection  
Description Description  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  
StoreModel HTML Document, Report, Document  
Author Author  
CreationTime Creation Time  
Description Description  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x"
Metamodel
MicroStrategy (Document)
Mapping Comments
     
Attribute Column  
Comment Comment  
Description Definition  
DesignLevel Design Level As defined by 'Tables design level' bridge option
ExtraConstraint Constraint  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Physical Name  
Position Position  
Class Warehouse Table  
Comment Comment  
Description Description  
Name Name  
NativeId Native Id MicroStrategy object ID
PhysicalName Physical Name  
ConnectionClassifier Project Custom Group, Project Object, Project Filter, Project Attribute, Project Subtotal, Project Warehouse Table , Project Security Filter, Report Object, Project Fact, Project Metric, Project Consolidation  
Description Description  
Name Name  
NativeId Native Id  
ConnectionFeature Project Consolidation Element, Project Fact Measure, Project Metric Measure, Report Object Elements, Project Custom Group Element, Project Filter Element, Project Attribute Form, Project Column, Report Object Element, Project Element, Project Subtotal Measure  
Description Description  
ExternalId External Id  
Name Name  
NativeId Native Id  
Position Position  
ConnectionPackage Schema  
Description Description  
Name Name  
NativeId Native Id  
DataAttribute SQL Metric, SQL Attribute Form, SQL Column  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
DataSet Logical Query Table, Query Builder Definition  
Description Description  
Name Name  
NativeId Native Id  
Filter Security Filter, Filter, Custom Group Filter indicates how to perform join between Logical Tables
Description Description  
Hide Hide  
Name Name  
NativeId Native Id  
Prompt Prompt  
Description Description  
MultipleSelection Multiple Selection  
Name Name  
NativeId Native Id  
Question Question  
PromptAnswer Prompt Answer  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Report Document Report, Report Report  
Description Description  
Name Name  
NativeId Native Id  
ReportAttribute Report Metric, Expression, Subtotal, Attribute Form, Metric, Report Subtotal, Consolidation Element, Threshold  
Description Description  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Optional  
Position Position  
Usage Usage  
ReportAxis Report Axis Represent report Vertical, Horizontal and Page axis
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Role Role  
ReportChart Report Graph  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportDataSet Metrics, Consolidation, Thresholds, Attribute, Expressions, Report Metrics, Report Subtotals, Subtotals Represents objects used in the report, and how they are grouped
Description Description  
Name Name  
NativeId Native Id  
ReportField Report Field, Calculated Report Field  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportList Report List  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportMatrix Report Matrix  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPage Report Page  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPageBody Report Page Body  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPageFooter Report Page Footer  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportPageHeader Report Page Header  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportRectangle Report Rectangle  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportTable Report Grid  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
ReportText Report Text  
Description Description  
Name Name  
NativeId Native Id  
Position Position  
Value Value  
StoreConnection Project, Dataset, Database Instance  
Connection Connection  
Description Description  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  
StoreModel Report, Document  
Author Author  
CreationTime Creation Time  
Description Description  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Last updated on Wed, 11 Dec 2019 18:39:35

Copyright © Meta Integration Technology, Inc. 1997-2019 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.