November 10, 2015 at 2:44 am
Hi All,
We have a requirement that a measure [Measures].[Average Margin] should only work with one single dimension in our cube [Hotel].[Airport - Region - Hotel].[Hotel] and none of the other dimensions, even though the underlying measure group is hooked up to some other dimensions.
Obviously we could handle this by scoping every dimension, but we don't want to do this in case we add in other dimensions. Alternately we could add this measure in its own measure group and only connect it to the dimensions we want, but this involves adding another measure group.
Does anyone else have any better/more intelligent ideas?
Cheers,
Jim.
November 10, 2015 at 9:02 am
A scoped assignment seems appropriate in this scenario.
I would recommend a calculated measure which is set to zero/null first, and then updated with the relevant value and dimension scope. Doing it this way would eliminate the need to update the scoped assignment when a new dimension is added.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply