How to find the length of the element in the dimension?
i need a function here? like TI.....
could you please help here its urgent for me.
Thanks for understanding.
How to find the length of the element in the dimension?
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: How to find the length of the element in the dimension?
Do you mean the number of characters in element's name?
There is a rules/TI function called LEN() that returns the length of a string.
There is a rules/TI function called LEN() that returns the length of a string.
Kamil Arendt
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: How to find the length of the element in the dimension?
Tried the LONG function? 

-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: How to find the length of the element in the dimension?
... apparently so urgent that there is no time to read the manuals in which you will find the following function:mincharug.shulft wrote:could you please help here its urgent for me.
LONG
This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes.
LONG returns the length of a string.
Syntax
LONG(string)
Example
LONG('Sales') returns 5.
You can find the reference material online here http://publib.boulder.ibm.com/infocente ... m1_ug.html
I think I notice a pattern.
http://www.tm1forum.com/viewtopic.php?f ... 542#p21542
http://www.tm1forum.com/viewtopic.php?f ... 054#p23054mincharug.shulft wrote:Hello guys this is urgent .could please helps me out on this.
http://www.tm1forum.com/viewtopic.php?f ... 094#p23094mincharug.shulft wrote:It urgent for me please help me.
http://www.tm1forum.com/viewtopic.php?f ... 992#p26992mincharug.shulft wrote:could u help me its urgent for me.
[beaten to it, but why waste all that copying and pasting .... LEN is the Excel equivalent of Long as is MID to SubSt ...]mincharug.shulft wrote:kindly let me know if possible its burning for me.
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: How to find the length of the element in the dimension?
Duh!lotsaram wrote:LEN is the Excel equivalent of Long as is MID to SubSt ...

Kamil Arendt