I have 2 date fields in my cube, date mailed and date returned and 1 measure
called "Mailed Count". When a user filters the dimension "date returned" I
need to have the measure "Mailed Count" show the mailed quantity based on
the "Date Mailed" dimension even though the user already filtered by the
"date returned" dimension. In short, I need a way, I assume a calculated
measure, to show the ([date mailed].[Same timeframe as chosen in the "date
returned" dimension, [measures].[mailed count])

Any help or suggestions with this problem are greatly appreciated
Scott J

I figured this out so I thought I would share:

Using the function and syntax below I was able to get the value I wanted
when someone changes the "Date Returned" dimension. The total count should
disregard the specified date returned filter value, but use it to specify
the date mailed information. In short, the LinkMember function does exactly
what I was looking for, take a filter value from one dimension and use it to
find the same level in a different dimension.
(LinkMember([Date Returned].currentmember, [Date Mailed]), [Date
Returned].[All Dates Returned], [Measures].[Mailed Count])



"Scott Jucovics" <sjucovics (AT) yahoo (DOT) com> wrote

And you put this in a calculated member ?


"Scott Jucovics" <sjucovics (AT) yahoo (DOT) com> skrev i en meddelelse
news:Ob1fFotMEHA.3472 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

yes, the equation below was added as a Calculated Member

"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Just a note, when using the LinkMember function, be sure when using dates
that the dimension key and name are the same. I had difficulty arriving at
correct values until I realized the dimension I used with Dates used a
numeric value while the dimension name had textual information as well.

"Scott Jucovics" <sjucovics (AT) yahoo (DOT) com> wrote