I have a problem that doesn't seem like it should be that difficult, but has
me totally stumped...

My dimension (Account) has a custom property called "RelatedAccount". In
that property, I have the name of another member within the dimension. I
want to be able to utilize the name of the account in RelatedAccount to go
grab the actual value from the other account referenced there. Is this
possible?

Here's an example to clarify...

Account - RelatedAccount [Corresponding Measure value]
BS1000 IS1000 3,000,000
....
....
IS1000 [empty] 50,000


So I want to be able to query for: I know the BS account, now give me the
value in the corresponding IS account. For anybody familiar with the
banking/financial services industry, this should look familiar. For
example, I have Loan assets of $3,000,000 in account BS1000 - now I need to
be able to easily see the corresponding Interest earned off those assets,
which is the $50,000 located in account IS1000.

I have tried all sorts of variations of StrToMember, etc, etc - but haven't
had any luck. I can easily get the property ("IS1000"), but can't get it to
resolve that to the actual measure contained in that account (the $50,000).

Please help me! I have a deadline! :-)

Thanks,
John

jlauer (AT) removetoreply_navigatorsystems (DOT) com

You might want to look at Russ Whitney's **excellent** article in SQL Server
Magazine; August 2003 called:
"Member Properties Boot Camp"
http://www.winnetmag.com/Article/Art...384/39384.html
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"John L. Lauer" <jlauer (AT) navigatorsystems_removeforreply (DOT) com> wrote in
message news:OhTHIBsbEHA.796 (AT) TK2MSFTNGP09 (DOT) phx.gbl...