Measure Selector with fixed selections
We have some reports where we display a value like "Total Eggs" and the "Standard Total Eggs" so the user can see how they are performing compared to the standard.
Currently we are using two measure selectors to get this as flexible as possible for the user to switch these measures, but this also means they do have to select both measure selectors, else they will not have the correct standard shown.
We thought of something like the stored criteria (for dimensions) where we can save the combination "Total Eggs" and "Standard Total Eggs" etc. and the user simply chooses something like "Total Egg Compare"
1
Comments
Hi Rene,
If you are using SSAS I think of an solution in MDX where you can create one calculated measure "Total eggs" that shows "Total eggs" or "Standard Total Eggs" depending on a dimension named e.g. "Measure Selector".
You could set the default member to "Total eggs" but when you add the "Measure Selector" dimension to your crosstab, you can see the 'normal' measure and the Standard measure in comparison.
So you would only need one measure instead of two, but you need an additional dimension "Measure selector".
BR / Marlene
Thank you. We appreciate your input.
The status of this post will be updated as your request is being processed by TARGIT.
Until then, the post will remain here to gather further interest (more votes) and comments.
Best regards / Ole
Please sign in to leave a comment.