How to fix “Invalid object name OPENJSON” in SQL Server 2016

Situation Microsoft introduced a great feature in SQL Server 2016 that support JSON data. However, you can get the error Invalid object name OPENJSON when you work on databases that their compatibility level are lower than 130.   Solution To fix this error, you need to update your database compatibility to 130 ALTER DATABASE <Database … Continue reading How to fix “Invalid object name OPENJSON” in SQL Server 2016

Advertisements

Dimension properties when designing in SSAS

When you start designing dimensions of an OLAP cube in Business Intelligence Studio( version 2008) or SQL Server Data Tools, there are some properties and configurations which I think that they are quite important. I have tried to summarize all of them in one picture and hopefully it can help you to be easy for … Continue reading Dimension properties when designing in SSAS

Working with PERSPECTIVES in SSAS cube

Situation In your organization, you are building a complex OLAP cube for your departments such as Finance, Sales, Human Resources ...  that includes a lot of tables, measures, KPIs, Calculated Measures... However, you don't want a complex model for users to explore. Human Resource users want only to see dimensions, measures and KPI that serve … Continue reading Working with PERSPECTIVES in SSAS cube