Using SSAS dimension data with different labels

Using SSAS dimension data with different labels

In relation to my article about using date pickers to filter SSRS cube data, I have been asked a few times how it would be possible to use one set of parameters to select the date range that points to dimension data from different cubes.For example, I have a report that pulls data from two different cubes. In the one cube, the main time dimension is called “Date”, and in the other cube there is a time dimension that is…

Read More Read More

Dashboard example

Dashboard example

Yesterday I attended and also spoke at SQL Saturday in Columbus Georgia. My presentation was all about effective dashboard design, tips and tricks how to make your dashboard efficient and some other things that you should definitely not do when designing dashboards. Not even a day later I encountered a dashboard where I can back up two of my arguments that I included in my presentation. One of the arguments was that maps as a display medium are often used…

Read More Read More

SSRS: Using date pickers to filter SSAS cube data

SSRS: Using date pickers to filter SSAS cube data

When you have a report that pulls data from an SSAS cube, you have most likely used a date range filter on which time series you would like to display. It is not so straightforward though, to create date-parameters in SSRS and in your MDX query you refer to these queries. Because MDX needs to interpret the date values in a completely different syntax, we have to format the data. This post shows you how to accomplish this. This post does…

Read More Read More

Not having to delete the data file every time you run a report

Not having to delete the data file every time you run a report

In SQL Server Reporting Services, every time you preview a report, a file of type .data is stored in your project folder that caches the data when the report is run. When you have your data sets all set up and you’re only working on the layout of the report, this is a very good functionality because every time you preview your report, SSRS doesn’t have to pull the data from the source every time. However, when your data sets…

Read More Read More

Spatial data across country borders in SSRS

Spatial data across country borders in SSRS

SQL Server 2008 R2 has really nice features in Reporting Services where you can work with maps and for example plot markers on a map to get a geographical overview of whatever you like. There are many tutorials out there how to get started on this, but one of the things that I haven’t found much information about is about the following: I had the situation where I wanted to show customers per country on a map. So I created…

Read More Read More

SQL Server 2012 RC0 installation

SQL Server 2012 RC0 installation

With the announcement that Microsoft has released SQL Server 2012 RC0, I thought at first I’d skip installing that, because right now I have a virtual machine running CTP3, and I can remember it took quite a while to set that up. I was very delighted to hear that RC0 does not need to be installed as a brand new fresh reinstall! When you have CTP3 installed, you can simply upgrade the version. At the setup screen, click on the…

Read More Read More

.NET Framework 3.5 for Report Builder when you have 4 installed

.NET Framework 3.5 for Report Builder when you have 4 installed

I wanted to use the Report Builder of my SQL Server 2008 R2 installation, and when I clicked on the button “Report Builder” in my Report Manager, I got this message: To use Report Builder, you must install .Net Framework 3.5 on this computer So first of all, I checked which version of the .NET Framework I had installed, and it turned out to be version 4 already! When you get this message, here’s what you need to do: In…

Read More Read More

PASS Summit 2011 – A first timer’s experience

PASS Summit 2011 – A first timer’s experience

From October 11th to the 14th, the yearly PASS Summit took place for the second last time in Seattle (it’s going to be in Charlotte NC as of 2013). I had never attended this conference, and initially I planned to go to SQL Bits or SQL Pass Camp. I looked at the itinerary of SQL Bits, and I didn’t really see a lot of interesting sessions that could fill two days, but at the schedule for PASS Summit, there were…

Read More Read More

Various SQL date formats to use with SSIS, SSAS and/or SSRS

Various SQL date formats to use with SSIS, SSAS and/or SSRS

While designing data warehouses, SSIS packages, etc., like myself you’ve probably ran into the issue of having to format different date and time values that ends up in a long string of SQL code or expressions in SSIS. The purpose of this post is to collect some links to various pages where these kind of date and time formatting can be found. Getting only date part of a datetime field First of all, the function that I used the most…

Read More Read More