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
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
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
Problem Today, I received a special requirement from my client that they wanted to build a report for counting distinct Brand Name of Digital Media Type. For example, a data source as below And the client expected the output as below As you saw two above image, the client only wanted to count unique Brand … Continue reading Understanding SCOPE statement in MDX
In a couple of weeks ago, one of my colleagues discussed with me about some solutions for High Availability and Disaster Recovery in Microsoft SQL Server. However, it seems there were some misunderstanding about Proof of Concepts (POC) among Window Failover Clustering (WSFC), SQL Server Failover Cluster Instances (FCIs) and AlwaysOn Availability Groups. In this … Continue reading Understanding Window Server Failover Clustering, SQL Server Failover Cluster Instances and AlwaysOn Availability Groups
Problem I need to build a report that compares total sales amount of top 10 Product Sub Categories from January to February, 2013 and the same period in last year. It means I need to build the report that is named as Year-over-Year of Calendar Year To Date ( CYTD YoY) Solution In MDX language, … Continue reading YTD function in MDX
In the previous article, I provided the simple example to start working on ADOMD libraries. The small application was implemented to execute the MDX file. The MDX query returns data from Jan to September in 2014 and the same period in 2013 (Year-To-Date report) Now, we need a flexible method that allows us to choose … Continue reading How to pass parameters to MDX script through ADOMD libraries?