Extracting Friendly Labels from MDX in Reporting Services
In Reporting Services (SSRS), I found myself in a situation where I needed to extract friendly labels from MDX member keys. I had a fiscal year parameter being passed to another report via a drill through action, and I needed to display the selected fiscal years on the drill through report. So I had to convert something like [Fiscal Period].[Fiscal Year].&[2014], [Fiscal Period].[Fiscal Year].&[2013] to “Fiscal Year: 2014, 2013”. There are a couple of ways of doing this. If your labels always contain the same number of characters, you can use the MID function as shown later. I have multiple multi-value parameters being passed, however, so I wanted to be able toRead More →