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] Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model, Stored Procedure Expression Parsing), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via .Net API |
SPECIFICATIONS
Tool: Microsoft / SQL Server Analysis Services (SSAS) version 9.0 (2005) to 15.x (2019) via .Net API
See https://docs.microsoft.com/en-us/analysis-services/
Metadata: [Business Intelligence] Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model, Stored Procedure Expression Parsing), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing)
Component: MicrosoftSqlServerRepositoryAs version 11.1.0
OVERVIEW
This bridge imports Business Intelligence (BI) reporting metadata from Microsoft SQL Server Analysis Services (SSAS), including the analysis databases (OLAP Models) and Analysis Management Objects (AMO).
Bridge supports Analysis Services Tabular, Multidimensional and Azure Tabular models.
REQUIREMENTS
This bridge connects to the SQL Server Repository using the Analysis Services Management Objects (AMO). AMO client libraries are available as installable packages from NuGet.org and the bridge loads it automatically with Miscellaneous -d. You have to install these components with first running.
This bridge uses Windows Authentication to connect to Analysis Services by default. Please be sure the application is logged into Windows Domain as a User which has appropriate rights to the objects you wish to import when 'User' option is empty.
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:
- 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)
In order to provide a complete set of source metadata to reproduce any SSAS issue, provide the exported Analysis Databases (XMLA) files.
Bridge Parameters
Parameter Name | Description | Type | Values | Default | Scope |
Host | Host name or IP address where SQL Server is running. For Azure cloud put fully qualified server name (e.g. asazure://eastus.asazure.windows.net/analysis_service_name). |
STRING | localhost | Mandatory | |
Database | SQL Server Analysis Service Project name to be imported (e.g. "/Adventure Works DW Standard Edition"). For Azure put model name (e.g. /TabularProject). |
REPOSITORY_MODEL | Mandatory | ||
User | SQL Server Analysis Service user name. For Azure it should be valid email (e.g. user@mail.com) added as "Analysis Services Server Admin" on target server. |
STRING | |||
Password | SQL Server Analysis Service Project, Azure account password. | PASSWORD | |||
Miscellaneous | -library.packageId Specify packageId for NuGet package with Microsoft.AnalysisServices.dll. Default value is "Microsoft.AnalysisServices.retail.amd64". -library.version Specify version for NuGet package with Microsoft.AnalysisServices.dll. Default value is "19.20.1". -library.filter Specify filter for DLLs inside NuGet package. Result must include "Microsoft.AnalysisServices.dll". Default value is "/lib/net45/". -d Specify to download NuGet packages if missing. Cache on first download, then reuse. |
STRING |
Bridge Mapping
Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Microsoft SQL Server Analysis Services (SSAS) 2005 to 2017 (Repository)" 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 |