Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | Microsoft |
| Tool Name | SQL Server Analysis Services (SSAS) |
| Tool Version | 9.0 (2005) to 15.x (2019) |
| Tool Web Site | https://docs.microsoft.com/en-us/analysis-services/ |
| Supported Methodology | [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via XMLA XML File |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Microsoft / SQL Server Analysis Services (SSAS) version 9.0 (2005) to 15.x (2019) via XMLA XML File
See https://docs.microsoft.com/en-us/analysis-services/
Metadata: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing)
Component: MicrosoftSqlServerXMLA version 11.1.0
OVERVIEW
n/a
REQUIREMENTS
The Metadata for the Microsoft SQL Server Analysis Services is managed by two tools, each of which produces a single XML file, with extension 'xmla' or 'asdatabase' respectively.
A) SQL Server Business Intelligence Development Studio: The tool generates a file with extension 'asdatabase', when the project is built. Please find the file in the project's bin directory, for example: 'C:\Visual Studio 2005\Projects\Test\bin\Test.asdatabase'
B) SQL Server Management Studio: The tool is used to connect to an existing Analysis Services server. One can export a single XMLA file from the tool by choosing the database and using the command: 'Script Database as->CREATE To -> File...'.
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
SUPPORT
Provide a trouble shooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | ||
| File | Specify here the AS database file path to import. | FILE |
|
Mandatory |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Analysis Services (SSAS) 2005 to 2019 (XMLA File)" Metamodel MicrosoftSqlServerXMLA |
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 |