I am trying to define a parent-child relationship in my SSAS project. The dimension is “employee” with a parent being “supervisor”. The source of my data was automatically imported …
Tag: ssas
SSAS – check if the user has a role assigned
I’m trying to create a way to partially automate creation of roles and role permissions in SSAS multidimensional cube. Due to some restrictions on my side this can only be done with using T-SQL to generate XMLA scripts and sending them to SSAS server. I have XMLA scripts to create, update and delete roles. However, I do not have a
Connecting to the Tabular Instance of an Azure-hosted SQL Server Analysis Services Server
I have set up an Azure Virtual Machine with a SQL Server 2016 Standard Edition image. I have installed an instance of Analysis Services Tabular on the machine and configured endpoints such that I can access it from my local machine. I have deployed SQL Server, SSAS Multidimensional, and SSAS Tabular databases to this machine. I am able to connect