SSAS Server

Parent Previous Next

SSAS Server


Tutorial Video


SSAS Provider Requirements

  Microsoft ® .NET 4.5 (Required by SSAS 2017 Only)

  64-bit Operating Systems:

o   Microsoft ® SQL Server ® 2012 Analysis Management Objects x64

o   Microsoft ® SQL Server ® 2012 Analysis Management Objects x86

  32-bit Operating Systems:

o   Microsoft ® SQL Server ® 2012 Analysis Management Objects x86

  SSAS Azure Analysis Services:

o   Microsoft Azure Analysis Services Client Libraries


Best Practices

BI Compare

Documentation

Lineage

Data Dictionary


Getting Started

1.   After creating a solution, click the "Add" button on the right side of the window


     

2.   Give the solution item a meaningful name


3.   Select either the SSAS Server or SSAS Server 2016 provider from the source type drop down


Important Note:

Use the SSAS Server provider when connecting to the following SSAS Modes:

  MultiDimensional instances with server versions between 2005 and 2014

  Tabular instances with server versions between 2012 and 2014


Use the SSAS Server 2016 provider when connecting to the following SSAS Modes:

  MultiDimensional instances with server versions above 2016

  Tabular instances with server versions above 2016

  Azure Analysis Services


4.   Provide a valid server name



5.   If you have selected SSAS Server 2016 and are attempting to connect to Azure Analysis Services, Azure Active Directory credentials are required.


Important Note:

In order to connect to Azure Analysis Services, users will need to download and install the latest Microsoft Azure Analysis Services Client Libraries.



6.   You may also customize your documentation by adding filters


Important Note:

Excluding certain types may affect Lineage Analysis.



7.   Click "OK" to add the SSAS Server to the Solution Items window


Sample Output

Doc xPress is able to document SSAS Cubes and Databases across all major versions of SQL Server: 2005, 2008, 2008 R2, and 2012 Multi-Dimensional. With the SSAS Cube and Database Documentation you can see the properties and attributes of each dimension in a cube.



When documenting KPI's, you can see the trend expression, goal expression and status expression.