I’m struggling implementing a calculated measure in one of my cubes. Basically I need to take two measures, divide them for a given period, and them sum the results together. For example, if the user selects 2012 as the year, I need to do the following:
(Q1, Q2, etc. are children under 2012 in my date.calendar dimension hierarchy)
(Q1 Purchases / Q1 Base) +
(Q2 Purchases / Q2 Base) +
(Q3 Purchases / Q3 Base) +
(Q4 Purchases / Q4 Base) +
But this needs to work dynamically based on whether the user selects multiple years, a single year, a single quarter, independent quarters for any given years, etc. Anyone have any ideas?
Thanks in advance,