How to find the length of the element in the dimension?

Post Reply
mincharug.shulft
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

How to find the length of the element in the dimension?

Post by mincharug.shulft »

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.
User avatar
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?

Post by qml »

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.
Kamil Arendt
User avatar
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?

Post by garry cook »

Tried the LONG function? :?
lotsaram
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?

Post by lotsaram »

mincharug.shulft wrote:could you please help here its urgent for me.
... apparently so urgent that there is no time to read the manuals in which you will find the following function:

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
mincharug.shulft wrote:Hello guys this is urgent .could please helps me out on this.
http://www.tm1forum.com/viewtopic.php?f ... 054#p23054
mincharug.shulft wrote:It urgent for me please help me.
http://www.tm1forum.com/viewtopic.php?f ... 094#p23094
mincharug.shulft wrote:could u help me its urgent for me.
http://www.tm1forum.com/viewtopic.php?f ... 992#p26992
mincharug.shulft wrote:kindly let me know if possible its burning 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 ...]
User avatar
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?

Post by qml »

lotsaram wrote:LEN is the Excel equivalent of Long as is MID to SubSt ...
Duh! :oops:
Kamil Arendt
Post Reply