Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository) - Import
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
requires the tool to be installed to access its SDK.
Bridge Specifications
| Vendor | Microsoft |
| Tool Name | SQL Server Analysis Services (SSAS) |
| Tool Version | 7.0 to 8.0 (2000) |
| Tool Web Site | http://msdn.microsoft.com/en-us/library/ms133828.aspx |
| Supported Methodology | [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via DSO COM API |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Microsoft / SQL Server Analysis Services (SSAS) version 7.0 to 8.0 (2000) via DSO COM API
See http://msdn.microsoft.com/en-us/library/ms133828.aspx
Metadata: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing)
Component: MicrosoftSqlServerDso version 11.2.0
OVERVIEW
This bridge relies on the Decision Support Objects (DSO) COM/OLE API in order to import Microsoft SQL Server Analysis Services OLAP metadata. Therefore, Microsoft SQL Server Analysis Services DSO API must be properly installed on the machine executing this bridge.
REQUIREMENTS
The DSO server relies on the Windows authentication service. To connect to DSO server, add the local user to the remote server as an OLAP administrator.
FREQUENTLY ASKED QUESTIONS
Q: How can I connect to a remote OLAP Server?
A: First you need to install the DSO API on the client computer. Please follow the instructions detailed on this MSDN page:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/prabout_499v.asp
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting 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 -backup option, although this common option is not implemented on all bridges for technical reasons).
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | |||
| Version | Select here the version of Microsoft SQL Server Decision Support Objects (DSO) you want to use. | ENUMERATED |
|
9.0 | ||||
| Server name | Specify here the name of the OLAP server to connect to. If this bridge is installed and executed directly on the OLAP server computer, you can use localhost as value. If this bridge is installed and executed on a client computer, while the OLAP server is running on a remote computer, the DSO API needs to be installed first on the client computer. See the bridge tooltip for details about installing DSO. |
STRING | localhost | |||||
| Import default All level | This option controls either or not the default Level of each Dimension is imported. These default Levels are usually named 'All' and do not participate in the metadata lineage. 'True' The default 'All' Levels are imported. 'False' The default 'All' Levels are not imported. |
BOOLEAN | False |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository)" Metamodel MicrosoftSqlServerDso |
Mapping Comments |
| AliasClassifier | AliasTable | |
| Name | Name | |
| AliasFeature | AliasColumn | |
| Name | Name | |
| Attribute | Column | |
| Name | Name | |
| BaseType | Datatype | |
| Class | Table | |
| CppClassType | set to ENTITY | |
| CppPersistent | Set to True | |
| Name | Name | |
| ClassDiagram | Diagram | Diagrams graphically represent the table layout of each Cube, like the Analysis Services client tool loes. |
| ClassifierMap | Used to connect and store lineage of Dimensions and Cubes to their tables | |
| Cube | Cube | |
| Description | Description | |
| Name | Name | |
| CubeDimensionAssociation | defines which Dimensions are used in the Cube | |
| DatabaseSchema | Database Schema | |
| Name | Name | |
| DerivedType | Datatype | |
| DataType | datatype | |
| Length | length | |
| Name | Derived from the datatype | |
| DesignPackage | Packages represent the logical organization of Dimensions, Cubes, Connections | |
| Name | set to Logical View | |
| UserDefined | Set to FALSE | |
| Dimension | Dimension | |
| Description | Description | |
| Name | Name | |
| Type | Type | set to TIME or REGULAR |
| DimensionAttribute | Dimension Member | |
| Name | Name | |
| FeatureMap | Used to connect and store lineage of DimensionAttributes and Measures to their tables | |
| Operation | expression | |
| Hierarchy | Hierarchy | |
| Description | Description | |
| Name | Name | |
| HierarchyLevelAssociation | Level | |
| Position | Depth | |
| Level | Level | |
| Description | Description | |
| Name | Name | |
| LevelAttribute | Level MemberColumn | |
| Name | Name | |
| Measure | Cube Measure | |
| Description | Description | |
| Name | Name | |
| OlapSchema | OLAP Database | |
| Name | Name | |
| PropertyElementTypeScope | ADODB::Properties DSO::_Properties | Generic object properties |
| Scope | set to MODEL, OLAP_SCHEMA, DATABASE_SCHEMA, DESIGN_PACKAGE, DIMENSION, CUBE, LEVEL_ATTRIBUTE or MEASURE | |
| PropertyType | ADODB::Properties DSO::_Properties | Generic object properties |
| Name | Name | |
| PropertyValue | ADODB::Properties DSO::_Properties | Generic object properties |
| Value | Value | value set on an object |
| StoreModel | Server | Represent the OLAP objects deployed on the Analysis Server |
| Name | name |