Subset create by element type(N,S orC)

Post Reply
late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

Subset create by element type(N,S orC)

Post by late.vaibhav »

Hi,

i would like to create subset based on the element type, mean i need to create subset only with numeric elements or string elements.

Kindly provide the solution....
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Subset create by element type(N,S orC)

Post by Alan Kirk »

late.vaibhav wrote: Wed Oct 11, 2017 10:26 am i would like to create subset based on the element type, mean i need to create subset only with numeric elements or string elements.

Kindly provide the solution....
And did you have any specific method of creating this subset in mind? GUI, MDX, TI, etc, etc...

Have you looked at the various element information functions in the Reference Guide?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Subset create by element type(N,S orC)

Post by Wim Gielis »

Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply