Proactive caching with in-Memory tables as notification

  Recently we encountered an issue using a Multidimensional Model where ROLAP and proactive caching were enabled on one of the partition. The notification was set to SQL Server table to track the changes and refresh the cache.   The behavior we noticed was that if a SQL Server Table was set to a Memory…


Dynamic RLS support for Analysis Service Tabular Model based on multiple roles for each user

Tested on: SQL Server Analysis Service 2016 Tabular, Azure Analysis Service.   Hello everyone, I am sure that whenever you wanted to implement Row Level Security(RLS) for Analysis Services Tabular Mode you might be wondering how I will implement RLS when some of my user has multiple roles assigned. Well here is the solution for…


SSAS translation for client application

Tested on: Excel 2013, Excel 2016, Reporting Services 2012/2014/2016.   Hello Everyone, in this blog I will discuss on how to view SSAS translation in different client Application.   Before I begin with the details on this blog, if anyone doesn’t know what Translation in SSAS is, then I request you to go and check…