Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from Microsoft SQL Server Analysis Services (SSAS) 2016 (File)

Bridge Specifications

Vendor Microsoft
Tool Name SQL Server Analysis Services (SSAS)
Tool Version 13.0 (2016)
Tool Web Site http://msdn2.microsoft.com/en-us/library/ms175609.aspx
Supported Methodology [Business Intelligence] Multi-Model, BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via XMLA(TMSL) JSON File

Import tool: Microsoft SQL Server Analysis Services (SSAS) 13.0 (2016) (http://msdn2.microsoft.com/en-us/library/ms175609.aspx)
Import interface: [Business Intelligence] Multi-Model, BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via XMLA(TMSL) JSON File from Microsoft SQL Server Analysis Services (SSAS) 2016 (File)
Import bridge: 'MicrosoftSqlServerAs' 10.0.0

The bridge imports SSAS Tabular models at compatibility level 1200 and later from a .bim or .asdatabase file.

FREQUENTLY ASKED QUESTIONS:

WHAT IS .BIM FILE AND HOW TO PRODUCE IT:
Analysis Services supports Tabular Model Scripting language(TMSL). The 'model.bim' is a TMSL file in JSON format. Only tabular models created at the 1200(SQL Server 2016) compatibility level or higher are described in TMS in JSON format. To create new .bim file SSDT (SQL Server Data Tools) could be used. SSDT build porject's .bim model into final .asdatabase and both of them have the same structure. The bridge could import .asdatabase as well. It's possible to upgrade an earlier version tabular model to use TMSL by switching up its CompatibilityLevel to 1200 or higher.
SUPPORT:
When experiencing issues with the bridge, you should report the issues in a manner that is reproducible by the support engineers. In order to provide a complete set of source metadata to reproduce the issue, please export and attach the Analysis Service files. As always, attach the MIMB Log file, as well.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File Specify here the model file path to import from FILE
*.asdatabase
*.bim
  Mandatory
Miscellaneous Specify miscellaneous options identified with a -letter and value.

For example, -m 4G -j -Dname=value -Xms1G

-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
STRING      

 

Bridge Mapping

Mapping information is not available

Last updated on Mon, 20 Aug 2018 16:01:35

Copyright © Meta Integration Technology, Inc. 1997-2018 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.