Azure Analysis Services processing/refresh sample AMO code

Sample code to process object in Azure Analysis Services Visit this web page Data providers for connecting to Azure Analysis Services, URL is https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers At the bottom of the web page, download then install AMO.   using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.AnalysisServices; using Microsoft.AnalysisServices.Tabular; namespace AMOAzureASProcess { class Program…

0

SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle

Problem: You are unable to change the size set parameter in the data source of an SSAS model that gets data from an Oracle database Cause: Oracle .NET provider may not support the property you want to set Solution: Switch to user the Oracle OLE DB Provider. It may support additional properties that are not…

0

Azure Analysis Services Preview shows workspace databases not being deleted

Problem: You may see Analysis Services tabular model workspace databases remain on the Azure Analysis Service server. Cause: When you create a tabular model in Visual Studio, you choose the Azure Analysis Services server as the workspace server, and the default Workspace Retention property is set to Unload from Memory. The workspace on Azure Analysis…

0

Azure Analysis Services Preview -How to add security group

The information posted originally in this blog is now out-of-date due to change in the Azure products. Please open a new support case if you need help with adding security group in Azure Analysis Services. Security group now can be added in format obj:<objid>@<tenanted>  using SSMS or AMO.   Problem: You are not able to…

4