MicroStrategy 7.0 to 11.x - Import - Cloud

Talend Cloud Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Catalog

Note: This bridge is not available in Talend Cloud Data Catalog by default. You need to set up a remote harvesting agent to import metadata from this source. For more information, see Deploying a remote harvesting agent in Talend Cloud Data Catalog Administration guide.

Bridge Requirements

This bridge:
  • requires the tool to be installed to access its SDK.

  • is only supported on Microsoft Windows.

Bridge Specifications

Vendor MicroStrategy
Tool Name Intelligence Server
Tool Version 7.0 to 11.x / 2020
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
Data Profiling
Remote Repository Browsing for Model Selection
Multi-Model Harvesting
Incremental Harvesting

SPECIFICATIONS
Tool: MicroStrategy / Intelligence Server version 7.0 to 11.x / 2020 via COM API
See http://www.microstrategy.com/
Metadata: [Business Intelligence] Multi-Model, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage), BI Report (Dimensional Source, Report Structure)
Component: MicroStrategy version 11.0.0

OVERVIEW
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.

REQUIREMENTS
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.

FREQUENTLY ASKED QUESTIONS
n/a

LIMITATIONS
Refer to the current general known limitations at http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html or bundled in Documentation/ReadMe/MIMBKnownLimitations.html
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
Provide a trouble shooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with option -backup)
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 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 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.
BOOLEAN
False
True
False  
Data model Tables design level 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.
ENUMERATED
Physical
Logical and physical
Physical  
Incremental import Incremental import only extracts what has changed since the last import. The initial full metadata harvesting (model import) of a very large source system can take a long time. However the extracted metadata are organized as a multi-model, where each model is a unit of change (e.g. Schema of a RDBMS server, or report of BI server). Subsequent model imports are dramatically faster than the initial import as this bridge will automatically try to detect changes in the source system, in order to only process the modified, added or deleted models and reuse all unchanged metadata from the model cache. Note however that the detection of change is more or less efficient depending on the sources system: e.g. BI servers can quickly provide the list of new, modified or deleted reports, but not all data stores offer a schema level change detection.

'True'
Import only the changes made since the last import

'False'
import all metadata. This option is required after upgrading the bridge in particular to take full advantage of any additional metadata coverage.

For debugging purpose, the option -cache.clear of the Miscellaneous parameter can be used to clear one model from the cache which is located (by default) in: $HOME/data/MIMB/cache/<BridgeId>/<ModelId>
BOOLEAN
False
True
True  
Import joins Should joins be imported?

'True'
The joins are imported.

'False'
The joins are not imported.
BOOLEAN
False
True
True  
Import hierarchies Should hierarchies be imported?

'True'
The hierarchies are imported.

'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 INTRODUCTION
Specify miscellaneous options starting with a dash and optionally followed by parameters, e.g.
-connection.cast MyDatabase1="SQL Server"
Some options can be used multiple times if applicable, e.g.
-connection.rename NewConnection1=OldConnection1 -connection.rename NewConnection2=OldConnection2;
As the list of options can become a long string, it is possible to load it from a file which must be located in ${MODEL_BRIDGE_HOME}\data\MIMB\parameters and have the extension .txt. In such case, all options must be defined within that file as the only value of this parameter, e.g.
ETL/Miscellaneous.txt

JAVA ENVIRONMENT OPTIONS
-m <Java Memory's maximum size>
1G by default on 64bits JRE or as set in conf/conf.properties, e.g.
-m 8G
-m 8000M

-j <Java Runtime Environment command line options>
This option must be the last one in the Miscellaneous parameter as all the text after -j is passed "as is" to the JRE, e.g.
-j -Dname=value -Xms1G
The following option must be set when a proxy is used to access internet (this is critical to access https://repo.maven.apache.org/maven2/ (and exceptionally a few other tool sites) in order to download the necessary third party software libraries.
-j -Dhttp.proxyHost=127.0.0.1 -Dhttp.proxyPort=3128 -Dhttps.proxyHost=127.0.0.1 -Dhttps.proxyPort=3128 -Dhttp.proxyUser=user -Dhttp.proxyPassword=pass -Dhttps.proxyUser=user -Dhttps.proxyPassword=pass

-jre <Java Runtime Environment full path name>
It can be an absolute path to javaw.exe on Windows or a link/script path on Linux, e.g.
-jre "c:\Program Files\Java\jre1.8.0_211\bin\javaw.exe"

-v <Environment variable value>
None by default, e.g.
-v var1=value1 -v var2="value2 with spaces"

MODEL IMPORT OPTIONS
-model.name <model name>
Override the model name, e.g.
-model.name "My Model Name"

-prescript <script name>
The script must be located in the bin directory, and have .bat or .sh extension.
The script path must not include any parent directory symbol (..).
The script should return exit code 0 to indicate success, or another value to indicate failure.
For example:
-prescript "script.bat arg1 arg2"

-cache.clear
Clears the cache before the import, and therefore will run a full import without incremental harvesting.
Warning: this is a system option managed by the application calling the bridge and should not be set by users.

-backup <directory>
Full path of an empty directory to save the metadata input files for further troubleshooting.

DATA CONNECTION OPTIONS
Data Connections are produced by the import bridges typically from ETL/DI and BI tools to refer to the source and target data stores they use. These data connections are then used by metadata management tools to connect them (metadata stitching) to their actual data stores (e.g. databases, file system, etc.) in order to produce the full end to end data flow lineage and impact analysis. The name of each data connection is unique by import model. The data connection names used within DI/BI design tools are used when possible, otherwise connection names are generated to be short but meaningful such as the database / schema name, the file system path, or Uniform Resource Identifier (URI). The following options allows to manipulate connections. These options replaces the legacy options -c, -cd, and -cs.

-connection.cast ConnectionName=ConnectionType
Casts a generic database connection (e.g. ODBC/JDBC) to a precise database type (e.g. ORACLE) for SQL Parsing, e.g.
-connection.cast "My Database"="SQL SERVER".
The list of supported data store connection types includes:
ACCESS
CASSANDRA
DB2
DENODO
HIVE
MYSQL
NETEZZA
ORACLE
POSTGRESQL
PRESTO
REDSHIFT
SALESFORCE
SAP HANA
SNOWFLAKE
SQL SERVER
SYBASE
TERADATA
VECTORWISE
VERTICA

-connection.rename OldConnection=NewConnection
Renames an existing connection to a new name, e.g.
-connection.rename OldConnectionName=NewConnectionName
Multiple existing database connections can be renamed and merged into one new database connection, e.g.
-connection.rename MySchema1=MyDatabase -connection.rename MySchema2=MyDatabase

-connection.split oldConnection.Schema1=newConnection
Splits a database connection into one or multiple database connections.
A single database connection can be split into one connection per schema, e.g.
-connection.split MyDatabase
All database connections can be split into one connection per schema, e.g.
-connection.split *
A database connection can be explicitly split creating a new database connection by appending a schema name to a database, e.g.
-connection.split MyDatabase.schema1=MySchema1

-connection.map DestinationPath=SourcePath
Maps a source path to destination path. This is useful for file system connections when different paths points to the same object (directory or file).
On Hadoop, a process can write into a CSV file specified with the HDFS full path, but another process reads from a HIVE table implemented (external) by the same file specified using a relative path with default file name and extension, e.g.
-connection.map hdfs://host:8020/users/user1/folder/file.csv=/user1/folder
On Linux, a given directory (or file) like /data can be referred to by multiple symbolic links like /users/john and /users/paul, e.g.
-connection.map /users/John=/data -connection.map /users/paul=/data
On Windows, a given directory like C:\data can be referred to by multiple network drives like M: and N:, e.g.
-connection.map M:\=C:\data -connection.map N:\=C:\data

-pppd
Create the connections and connection data sets in DI/ETL design models. This feature should only be used when intending to export to another DI/ETL tool.

MICROSTRATEGY OPTIONS
-r
Remove the report pages and their graphical structure.

-sf
Skip importing filters.

-sp
Skip importing prompts.

-spv
Skip importing creation, modification date and author for schema objects.

-folders.exclude <file path>
The folders.exclude option allows you to to exclude folders within a project. You have to specify path to file with list of Microstrategy folder paths.
-folders.exclude E:\Microstrategy\folders.txt
folders.txt file contains for example two folder paths
\MicroStrategy Tutorial\Object Templates
\MicroStrategy Tutorial\Profiles
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"MicroStrategy 7.0 to 11.x / 2020"
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 / 2020"
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 / 2020"
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 / 2020"
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 / 2020"
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 / 2020"
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 / 2020"
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