Browsing All Posts published on »March, 2011«

SSRS Sparkline report using MDX

March 23, 2011

4

In this post I am going to describe how to create a report with Sparklines using an MDX query. In my current role I do a lot of Proof Of Concept pre-sales work for different industries, and I’ve really grown to love sparklines. I think they are fantastic in giving users an understanding of how […]

Using the DatePicker in SSRS with MDX

March 22, 2011

4

This post, continuing on from the previous post https://jsimonbi.wordpress.com/2011/03/22/using-a-date-parameter-in-ssrs-with-mdx/, shows how to use the DatePicker functionality within SSRS as a parameter for an MDX query. First we set up the Date parameter, which we will call pDate. We change the data type to Date, and leave all other tabs with the default settings. We then […]

Using a Date Parameter in SSRS with MDX

March 22, 2011

2

There are two ways of using a date parameter within SQL Server Reporting Services for reports using SSAS as the source. I’d firstly like to thank my friend Boyan Penev for helping me out with some MDX questions I’ve had – please visit his excellent blog: http://www.bp-msbi.com/ The first method is to use a MDX […]

Data Modeling Conundrum Follow up

March 17, 2011

9

As a follow up to my previous post on a Data Modeling Conundrum in January (see https://jsimonbi.wordpress.com/2011/01/16/data-modeling-conundrum/) I left it open as to what the appropriate dimensional model should be. To recap from my first post, let’s say that I’m trying to track Marine Incidents. Zero or many vessels may be involved in an incident, […]

SQL Hierarchy Comparative Performance

March 1, 2011

2

This is the last post I will be doing on SQL Hierarchies. Since I’ve covered the most common methods for dealing with hierarchies I thought it worthwhile to do some performance comparisons. I will be testing displaying the descendants of the root node, as well as testing aggregations from a sales table for both the […]