FAQ
Members List
Calendar
Mark Forums Read
Axis() Question
dbTalk Databases Forums
Databases
microsoft.public.sqlserver.olap
Axis() Question
microsoft.public.sqlserver.olap
microsoft.public.sqlserver.olap
Discuss
Axis() Question
in the
microsoft.public.sqlserver.olap
forum.
Thread Tools
Display Modes
#
1
Cristiano Moraes da Silva
Posts: n/a
Axis() Question -
03-15-2005 , 12:51 PM
Hi all!
I need to Filter this SET: Axis(0)
to show only Members of level (0)
SetToStr( StrToSet("Axis(0)") ) ==> {[Time].[All Time],
[Time].[All Time].[2002], [Time].[All Time].[2003], [Time].[All
Time].[2003].[Quarter 1], ..... }
I need :
{ [Time].[All Time], [Time].[All Time].[2002], [Time].[All
Time].[2003] }
Thanks in advance,
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
Cristiano Moraes da Silva
#
2
Deepak Puri
Posts: n/a
Re: Axis() Question -
03-15-2005 , 02:17 PM
Hi Cristiano,
How about using Filter() with .Ordinal:
Quote:
SetToStr( Filter(StrToSet("Axis(0)") as a0,
a0.Current.Item(0).Level.Ordinal < 2 ) )
Quote:
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Deepak Puri
#
3
Cristiano Moraes da Silva
Posts: n/a
Re: Axis() Question -
03-15-2005 , 02:20 PM
I do:
Intersect( StrToSet("Axis(0)"), [Time].[Year].Members )
another methods??
=================================
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
Cristiano Moraes da Silva
«
Previous Thread
|
Next Thread
»
Thread Tools
Show Printable Version
Email this Page
Display Modes
Linear Mode
Switch to Hybrid Mode
Switch to Threaded Mode
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.
Contact Us
-
dbTalk Databases Forums
-
Archive
-
Top