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
