TM1Web not displaying all text

[JamiseBondi]

Hi,

I have a workbook with a dimension in the row that has long element names. In excel these element names appear as expected but these same element names are being truncated in the web. There are element names with up to 80 characters.
As an example, one line in excel shows an element with 73 characters and in the web I'm only seeing 66 characters. What are the limitations regarding how much text we can see in the web?

Thanks.

[tomok]

Hi,

I have a workbook with a dimension in the row that has long element names. In excel these element names appear as expected but these same element names are being truncated in the web. There are element names with up to 80 characters.
As an example, one line in excel shows an element with 73 characters and in the web I'm only seeing 66 characters. What are the limitations regarding how much text we can see in the web?

Thanks.

It would help if you would define "in the web". Cube viewer, or web sheet, or both?

[JamiseBondi]

Sorry Tomok,

I mean in a workbook. The same workbook that renders all text in perspectives doesn't render all the text when viewed through TM1web. Hope that explains it. if you need a screenshot to illustrate I'm happy to do so.

[declanr]

Sorry Tomok,

I mean in a workbook. The same workbook that renders all text in perspectives doesn't render all the text when viewed through TM1web. Hope that explains it. if you need a screenshot to illustrate I'm happy to do so.

If you press the "auto fit selected column width" button with the column highlighted does it expand to show your text?

TM1 Web has always shown things slightly differently to excel, particularly in regards to column widths etc, just experiment with making them a little wider than appears necessary in excel. True mastery of TM1 Websheet formatting requires trial and error... a lot of it.


Edit - sorry just noticed your original post mentioned 80 character element names, I don't know exactly what TM1's limit is but I have experienced issues similar to this when testing some stuff out.

Would it be possible to break the names down into a number of attributes and show them across 2 or 3 columns?

[JamiseBondi]

Hi Declan,

Here is an example of the cubeview and workbook web views. You'll see that the column widths are wide enough to allow the full amount of text to display. The option of breaking down the element name is going to be more trouble than it's worth but thanks for the suggestion.

Any comments welcome, even if it's to say that it's not possible

workbookview.jpg (11.49 KiB) Viewed 7770 times

cubeview.jpg (7.04 KiB) Viewed 7770 times

[declanr]

Hi Declan,

Here is an example of the cubeview and workbook web views. You'll see that the column widths are wide enough to allow the full amount of text to display. The option of breaking down the element name is going to be more trouble than it's worth but thanks for the suggestion.

Any comments welcome, even if it's to say that it's not possible

workbookview.jpg

cubeview.jpg

I just re-tested this as the last time I had issues with name lengths was a few years ago (primarily because I've been lucky enough to use relatively small names since then)... and it seemed to work fine for me, are you sure you pressed the adjust to column width button (as highlighted?):



For reference I tested it in 10.1 and an excel LEN() function tells me that the second element name is 101 characters long.

[Wim Gielis]

For reference I tested it in 10.1 and an excel LEN() function tells me that the second element name is 101 characters long.

Or the TM1 ELSLEN function... It's one the functions I never used in my career.

[declanr]

Or the TM1 ELSLEN function... It's one the functions I never used in my career.

Why would you use a different function when you've got Len() and Long() at your disposal?

I used it in 1 workbook about a year ago for no reason other than it niggles at me when I know there are functions in the reference guide that I haven't used, my OCD was calmed by the knowledge that I have now used it once

[JamiseBondi]

Thanks Declan and Wim,

Declan you're 100% right. I thought you were referring to the width of the column in excel and it looked OK so I didn't think to go any further on it, especially seeing as though there was a bit of empty space between the text and the border but after pressing the autofit button the extra characters showed up - I deserve a fine for that thanks for the pointer!

[tomok]

The appearance of a published Excel sheet is sometimes different when viewed in Excel and TM1Web. The differences used to be really bad back in version 9.4 but have gotten progressively better in newer releases. Still, the bottom line is you can't assume that a hidden column, merged cell, or row height or column width will look the same in the Web as it does Excel. Sometimes you have to "play" with the format to get it to work the way you want. I haven't checked the Excel-to-HTML scheme in version 10.2 (since the web server is totally re-written) but I hope it is better in this regard.

[declanr]

The appearance of a published Excel sheet is sometimes different when viewed in Excel and TM1Web. The differences used to be really bad back in version 9.4 but have gotten progressively better in newer releases. Still, the bottom line is you can't assume that a hidden column, merged cell, or row height or column width will look the same in the Web as it does Excel. Sometimes you have to "play" with the format to get it to work the way you want. I haven't checked the Excel-to-HTML scheme in version 10.2 (since the web server is totally re-written) but I hope it is better in this regard.

In my initial test 10.2 is a LOT better in that regard but currently has another few annoyances of its own, I however will wait until the first fixpack comes out before I start moaning about them as I wouldn't use anything in production until we reach at least 1 fixpack anyway.