Subset create by element type(N,S orC)

Post Reply
late.vaibhav
Posts: 21
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 » Wed Oct 11, 2017 10:26 am

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: 5719
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

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

Post by Alan Kirk » Wed Oct 11, 2017 10:41 am

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: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis » Fri Oct 20, 2017 6:53 am

Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

Post Reply