Hello,
I have a statistical measure called outcome. It has
some numeric codes describing the different possible
outcomes of a survey. I also have some calculated members
that utilize the codes. For example I might 201 or 203
outcomes from some surveys. The calculated member I
created, called COMPLETED, checks to see if the value is
201 or 203 and returns a 1 indicating a true condition.
----------------------
IIf(Measures.[OUTCOME]=201 or Measures.[OUTCOME]=203 , 1,
0)
----------------------
I want to rollup a count of all 1's for this calculated
member COMPLETED within an arbitrary dimension. All I get
are 0's because I don't go to the leaf levels.

Does anybody have any suggestions?

From your description, it sounds like "Outcome" should be a dimension
more than a measure in the cube. Then it will be easy to roll up related
codes in a dimension hierarchy. If the leaf level always maps to single
fact table records, then a calculated member should also be possible.

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!