How do I define a measure to do the following?
I have a base measure, [Billed Revenue], that I want to sum up across several months. The user will select a month in Excel. An Excel CubeValue function will call
into the cube passing two members: the month & the measure.
Most of my measures use PeriodsToDate. But this crosses all my defined boundaries. This set of months starts with the last month of the PRIOR YEAR & ends with
the user specified month.
(So that you know where I'm headed with this,
the final form of th
View Complete Post