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

Advertisements

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

How to pass parameters to MDX script through ADOMD libraries?

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?

How to execute MDX query with ADOMD libraries

In previous article, I introduced the solution to execute a MDX query by SQL store procedure. However, it has some limitation such linked server performance, user permission... There are other approaches to overcome those disadvantages of the store procedure. In this article, I will introduce ADOM.NET library which also support executes a MDX file. It … Continue reading How to execute MDX query with ADOMD libraries