Bridge Specifications
| Vendor | Microsoft |
| Tool Name | SQL Server Analysis Services (SSAS) |
| Tool Version | 9.0 (2005) to 10.5 (2008 r2) |
| Tool Web Site | http://msdn2.microsoft.com/en-us/library/ms141026.aspx |
| Supported Methodology | [Business Intelligence] BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Conversion) via .Net API |
SPECIFICATIONS
Tool: Microsoft / SQL Server Analysis Services (SSAS) version 9.0 (2005) to 10.5 (2008 r2) via .Net API
See http://msdn2.microsoft.com/en-us/library/ms141026.aspx
Metadata: [Business Intelligence] BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Conversion)
Component: MicrosoftSqlServerRepositoryAs version 12.0.0
OVERVIEW
The bridge exports OLAP Models into a corresponding SQL Server Repository using the SQL Server SDK APIs, including the Analysis Management Objects (AMO).
REQUIREMENTS
In order for this bridge to connect to the SQL Server Repositories and export, it is necessary to ensure that the SQL Server Client Components are installed properly and corresponding services are running locally or in your local network. The bridge uses Windows Authentication to connect to Analysis Services. Please be sure the application is logged into Windows Domain as a User which has appropriate rights to the objects you wish to import.
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
In order to provide a complete set of source metadata to reproduce the issue, please export and attach the Analysis Databases (XMLA) files.
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | |||
| SQL Server version | Specifies the version of SQL Server. | ENUMERATED |
|
2008 | ||||
| Host | Host name or IP address where SQL Server Analysis Services Repository is running. | STRING | localhost | Mandatory | ||||
| Database | SQL Server Analysis Service database name to be exported. E.g. Adventure Works DW Standard Edition |
REPOSITORY_MODEL | Mandatory | |||||
| Connection String | Connection String to Fact Tables database. In most cases to connect to SQL Server database it is enough to use a basic connection string that looks similar to: Provider=SQL Client; Data Source= SQL Server host; Integrated Security= Security Package; Initial Catalog= database Name where 'SQL Client' The SQL Client Library. Usual value is: SQLNCLI.1 'SQL Server host' The name or IP address of the server computer. 'Security Package' Determines the security package to use during the session. Usual value is: SSPI 'Database Name' The name of the database. It is possible to modify the Connection String in exported model using Data Source properties and Connection Manager dialog. |
STRING | Mandatory | |||||
| Database Export Mode | Specifies the mode of Analysis Service (AS) database exporting. 'Create' Creates a new AS database. If the database already exists, an error message is shown. 'Update' Updates an existing AS database. If the database does not exist, an error message is shown. 'Override' Overrides an existing AS database. If the database does not exist, the bridge creates new one. |
ENUMERATED |
|
Create |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Analysis Services (SSAS) (Repository)" Metamodel MicrosoftSqlServerRepositoryAs |
Mapping Comments |
| AggregationRule | AggregateFunction | A string defined in the measure |
| Rule | Value | |
| Cube | Cube | |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| PhysicalName | Name | |
| CubeDimensionAssociation | Defined by containment relationship between Cube and Dimension | |
| Dimension | Dimension | |
| Description | Description | |
| Hide | visible | |
| Name | Name | |
| NativeId | ID | |
| NativeType | Type | |
| PhysicalName | Name | |
| DimensionAttribute | DimensionAttribute | |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| PhysicalName | Name | |
| Hierarchy | Hierarchy | |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| PhysicalName | Name | |
| HierarchyLevelAssociation | Defined by containment relationship between hierarchy and level | |
| Join | Relationship | Defined by DataSourceView |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| Type | Type | |
| JoinRole | Defined by the relationship | |
| Level | Level | |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| NativeType | Type | |
| PhysicalName | Name | |
| LevelAssociation | Defined by the contiainment between Level and Attribute | |
| LevelAttribute | DimensionAttribute | Contained by a Level |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| Optional | Usage (Attribute) | |
| PhysicalName | Name | |
| LevelKey | ValueColumn | |
| Description | Description | |
| Name | Name | |
| NativeId | ID | |
| NativeType | Type | |
| PhysicalName | Name | |
| Measure | Measure | |
| DefaultAggregation | AggregationString | |
| Description | Description | |
| Hide | visible | |
| Name | Name | |
| NativeId | ID | |
| NativeType | Type | |
| PhysicalName | Name |