Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted
Tag: MDX
MDX Time Calculations Built to Scale
When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent several
Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all you need is the Query
MDX – Color Formatting on All Measures at Once
In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services measures you create. Recently I
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that’s been useful to me recently. This MDX statement creates a named set of the
MDX – Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also have another little feature that
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in
MDX Utility Belt of Calculations Part 4
This is part four in the series of blog posts that will help in building a library of calculations you can use as a reference
MDX Utility Belt of Calculations Part 3
This is part three in a series of blog posts that will help you build an arsenal of MDX calculations that you can have ready
MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations. With
MDX Utility Belt of Calculations Part 1
Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube. That is why I have accumulated
SSRS – Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult to dynamically set default parameter