SSAS (OLAP + Tabular + Azure Analysis Services)

Version Supported:
Tabular - up to 2022
OLAP - up to 2022
Tabular on Azure - up to 2022

Tool Permissions Prerequisites

Warning: Missing permissions could end up in broken lineages.

SSAS - OLAP (On Prem or hosted on Azure)

• NT User with “Read definition” for each DB on the server. (Windows Authentication).

SSAS - Tabular

• NT User with “Full control” for each model on the server. (Windows Authentication) .

SSAS - Tabular on Azure Analysis Services (managed PaaS)

• 'Active Directory Password Authentication' User with “Full control” for each model on the server

Setting up SSAS (OLAP + Tabular + Azure Analysis Services) Metadata Source

Metadata Sources are set on the Octopai Client (OC) 

Tabular:

OLAP:

Azure Analysis Services:

Video - Extraction Guide

Watch the following video to learn about the Azure Analysis Services Extraction process

How to verify the extracted Metadata File

Access the Octopai Target Folder (TGT)

1. Go to the TGT Folder located on the Server where the Octopai Client is installed.
   By default: C:\Program Files (x86)\Octopai\Service\TGT
2. Open the zip file having the Connector Name
   Example:
3. Verify its content
   Quantity & Quality of inner files

Troubleshoot

Error during the extraction:

• Check the permissions
• Send the log with the connector number and name to Octopai Support - C:\Program Files (x86)\Octopai\Service\log