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....
Subset create by element type(N,S orC)
-
- 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:
- 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)
And did you have any specific method of creating this subset in mind? GUI, MDX, TI, etc, etc...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....
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3117
- 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)
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
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