Hello,

does someone know
how to get a member
propertie of another
cube ?

lookupcube(
"Rating",
"(Groupe.["+Concessionnaire.currentmember.name+"].properties("Rating"))"
)

This syntax does not
work as long as the
lookupcube function
is used to get a
measure and not a
propertie.

Thanks

Maybe I am missing something, but since you have Concessionnaire dimension
in your cube, why don't you ask for it's member property directly ? Why do
you need to go to another cube ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"%u" <nospam (AT) nospam (DOT) com> wrote

Hello Mosha,

yes your are totally right. It is what I will do.
But it was interesting to know if it was possible to get
a member property between two cubes.

Thanks.

You can get anything from another cube as long as it can be found inside
some cell. So you could create calculated member which referenced member
property, and query for it.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================