dbTalk Databases Forums  

Item() Question

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


Discuss Item() Question in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cristiano Moraes da Silva
 
Posts: n/a

Default Item() Question - 04-07-2005 , 05:26 PM






I need to get the dimension UniqueName of:

Quote:
StrToSet("Axis(0)").Item(0).Dimension.UniqueName
Why this doesn't work ?

Cristiano
=================================
Cristiano Moraes da Silva
Analista de Sistemas
DBC Database Company
Porto Alegre - RS - Brasil
+55 513330 7777
cristiano (AT) dbccompany (DOT) com.br
www.dbccompany.com.br




Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Item() Question - 04-07-2005 , 05:48 PM






I think it is because .Item will return tuple, and you need a member. You
axis can contain more then one dimension in it. If you are sure, that there
is only one dimension, then

StrToSet("Axis(0)").Item(0).Item(0).Dimension.Uniq ueName


--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/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.
==============================*=================== =
"Cristiano Moraes da Silva" <cristiano (AT) dbccompany (DOT) com.br> wrote

Quote:
I need to get the dimension UniqueName of:

StrToSet("Axis(0)").Item(0).Dimension.UniqueName

Why this doesn't work ?

Cristiano
=================================
Cristiano Moraes da Silva
Analista de Sistemas
DBC Database Company
Porto Alegre - RS - Brasil
+55 513330 7777
cristiano (AT) dbccompany (DOT) com.br
www.dbccompany.com.br





Reply With Quote
  #3  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Item() Question - 04-07-2005 , 05:49 PM



Or perhaps even more efficient:

StrToMember("Axis(0).Item(0).Item(0)").Dimension.U niqueName

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/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.
==============================*=================== =
"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote

Quote:
I think it is because .Item will return tuple, and you need a member. You
axis can contain more then one dimension in it. If you are sure, that
there
is only one dimension, then

StrToSet("Axis(0)").Item(0).Item(0).Dimension.Uniq ueName


--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/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.
==============================*=================== =
"Cristiano Moraes da Silva" <cristiano (AT) dbccompany (DOT) com.br> wrote in message
news:usVcSg7OFHA.3336 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
I need to get the dimension UniqueName of:

StrToSet("Axis(0)").Item(0).Dimension.UniqueName

Why this doesn't work ?

Cristiano
=================================
Cristiano Moraes da Silva
Analista de Sistemas
DBC Database Company
Porto Alegre - RS - Brasil
+55 513330 7777
cristiano (AT) dbccompany (DOT) com.br
www.dbccompany.com.br







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.