Occasionally there may be a need to manually process the cube. This would occur when the cube design has not changed but new data has been imported into […]
SSAS: – Implementing Perspectives
A perspective is a very useful feature within SSAS as it allows the designer to mask the underlying complexity of the cube based on the user. The perspective […]
SSAS: browsing the cube
With the cube processed we are now ready to browse or query the cube to fetch some data from it. There are many way of doing this; the […]
SSAS: – Defining a measure
Now that the dimension has been defined we need to add a measure to our cube in order to be able to answer the question “What is distribution […]
SSAS: – Define translation
In previous posts we explored the properties of a cube and some basic tasks that we would need to perform as part of creating and managing a cube. […]
Create a 5 star rating indicator using SSRS
Today we are going to create a 5 star rating indicator in SSRS. Indicators are available in SQL Server 2008 R2 and above and provide a quick way […]
MSBI at the Airport
I was recently at Bangalore International Airport and while waiting for a flight was looking for a way to pass the time. I noticed there is an fnb […]
Changing the background colour for a Cell in SSRS conditionally
In this blog we look at how to change the background colour for a cell in SSRS using IIF conditional logic. He below screenshot shows a table with […]
Add a subtotal and Grouping to an existing report in SSRS
In this blog we cover how to add a Grouping to an existing Report. For the original report creation steps please visit this blog. In our report we […]
FOREX Conversion in OLAP Cube
I was conducting training recently where the participants asked for a solution on how to convert data from many different currencies into a target currency using an exchange […]