Alignment of Values in Tm1Web

Post Reply
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

Alignment of Values in Tm1Web

Post by par3 »

Hi All,

Cognos Express 9.0
Mozilla Firefox 3.6.9

Is there any way you can align the values, to the left or right, in the cells when using a view in Web. We have a problem that if you have a string measure with a long typed value in, it alway aligns to the right of the cell.

Is there a way to change that alignment?

Thank you.
Neil Watson
Posts: 32
Joined: Wed May 28, 2008 11:41 am
OLAP Product: TM1
Version: 6 and 2.5 to 10.2.2
Excel Version: 2007 2010
Location: Northern England
Contact:

Re: Alignment of Values in Tm1Web

Post by Neil Watson »

Hi,

The alignment used by Web is determined by the alignment set in Excel (either from the Home Ribbon or formatting toolbar or cell Properties), it is possible to align both text and numeric value left, right or centre and also top bottom too.

However, there is a known issue with column widths and the web. If the values in the column exceed the width they have on the web then this throws out any alignment that you have set. Althogh there is a hotfix for this (see notes on versions and patches above). Also be aware that the web will display column widths slightly differently to Excel.

Good Luck
Neil
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

Re: Alignment of Values in Tm1Web

Post by par3 »

Thank you Niel,

The problem however is not with Excel Reports but rather with Cube Views. Any idea on how to change those?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Alignment of Values in Tm1Web

Post by tomok »

par3 wrote:Thank you Niel,

The problem however is not with Excel Reports but rather with Cube Views. Any idea on how to change those?
The only formatting you can do with Views is to change the numeric display.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply