Creating a Simple Date Dimension Using Recursive Common Table Expressions (CTE)
In this post I’ll explain how to create a simple date dimension to use it in your data warehouses and…
Resolving “Object reference not set to an instance of an object.” Error When Deploying your Tabular Model
You’ve changed something in your Tabular model and you’re facing an ugly “Error: Object reference not set to an instance…
How to Automate SSAS Tabular Model Processing
You are working on a BI project that involves SSAS Tabular model. As you cannot process the model manually you…
How to manage the user access rights to see database views but not source tables using T-SQL
Problem: There is a group of users that are not intended to have direct read access to the database tables.…