CurrentMember.Properties("key")

#1

Hi Everyone,
I have Program Dimension:
*OperatorType (Internet,Radio,TV etc')
**OperatorName (Radio station,Channel etc')
***ProgramName (program name)

If i want to show the OperatorType key i use the:
[program].CurrentMember.Properties("Key")

with
MEMBER [Measures].[OperatorTypeID]] as
'[program].CurrentMember.Properties("Key") '

SELECT Non Empty
{[Measures].[AdvID],[Measures].[AdvSize],[Measures].[Price],[Measures].[OperatorTypeID]} ON COLUMN,
[Program].[OperatorName].members on rows
from adv_small

but what should I do if i want to show the OperatorType Key and
OperatorName (which is leve down OperatorType) Key?

thanks

#2

NEVER MIND I GOT IT

"Ruby Nadler" wrote:

Quote:

Hi Everyone,
I have Program Dimension:
*OperatorType (Internet,Radio,TV etc')
**OperatorName (Radio station,Channel etc')
***ProgramName (program name)

If i want to show the OperatorType key i use the:
[program].CurrentMember.Properties("Key")

with
MEMBER [Measures].[OperatorTypeID]] as
'[program].CurrentMember.Properties("Key") '

SELECT Non Empty
{[Measures].[AdvID],[Measures].[AdvSize],[Measures].[Price],[Measures].[OperatorTypeID]} ON COLUMN,
[Program].[OperatorName].members on rows
from adv_small

but what should I do if i want to show the OperatorType Key and
OperatorName (which is leve down OperatorType) Key?

thanks

#3

Hi

Could you tell us how do you get it?

Vladimir Chtepa

"Ruby Nadler" <RubyNadler (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:EE253CA7-C0EB-4603-A850-9E6EBA0C3BA7 (AT) microsoft (DOT) com...

Quote:

NEVER MIND I GOT IT

"Ruby Nadler" wrote:

Hi Everyone,
I have Program Dimension:
*OperatorType (Internet,Radio,TV etc')
**OperatorName (Radio station,Channel etc')
***ProgramName (program name)

If i want to show the OperatorType key i use the:
[program].CurrentMember.Properties("Key")

with
MEMBER [Measures].[OperatorTypeID]] as
'[program].CurrentMember.Properties("Key") '

SELECT Non Empty
{[Measures].[AdvID],[Measures].[AdvSize],[Measures].[Price],[Measures].[OperatorTypeID]}
ON COLUMN,
[Program].[OperatorName].members on rows
from adv_small

but what should I do if i want to show the OperatorType Key and
OperatorName (which is leve down OperatorType) Key?

thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

CurrentMember.Properties("key")

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

CurrentMember.Properties("key") - 01-21-2006 , 11:33 PM

RE: CurrentMember.Properties("key") - 01-22-2006 , 04:33 AM

Re: CurrentMember.Properties("key") - 01-24-2006 , 08:13 AM