(Update—there’s been a terminology change since I wrote this! I originally wrote about Dimension Sets, but in MR 2012, Dimension Sets are now called Dimension Value Sets. And just to make things tougher, Dimension Sets now refer to something completely different. Gotta love it. Anyway, I’ve edited this post to reflect this change.)
I was recently asked about my top tip for faster easier reporting in Management Reporter.
It didn’t take much thought—my answer was using Dimension Value Sets. They can streamline and simplify and ease maintenance.
Set up a Dimension Value Set once, use it across multiple building blocks, and maintain it in one place. What’s not to love?
Well I’ll tell you what’s not to love—there’s a bug that won’t let you subtract an account. To be precise, you can subtract it in the set, but MR won’t do what you say (I can’t help but be reminded of my husband). Let’s hope for a fix soon because these are a good investment of time. (Update—this has been fixed.)
OK one more thing—migrated FRx reports do not take advantage of this type of design. So it’s always good to review migrated FRx reports with an eye for this type of improvement.
So without further delay, here are a couple of examples of how you can use already-created dimension value sets. They’re not just for rows anymore! [click to continue…]
{ 0 comments }