Page 1 of 1
Retaining TM1 cell formats while slicing data to excel
Posted: Wed Dec 01, 2010 6:28 pm
by suhamore
Is it possible to retain TM1 cell formats while creating a slice/active form from TM1 cube viewer?...So, if some value is displayed as % in cube viewer, it should be displayed as % only when we slice that view into excel? currently, it is displayed in decimal format. TM1 version is 9..4.1 FP3
Re: Retaining TM1 cell formats while slicing data to excel
Posted: Thu Dec 02, 2010 8:08 pm
by ajain86
have you tried starting with in-spreadsheet browser instead of cube viewer.
I believe that retains formats when it is sliced.
Re: Retaining TM1 cell formats while slicing data to excel
Posted: Thu Dec 02, 2010 9:20 pm
by suhamore
ajain86 wrote:have you tried starting with in-spreadsheet browser instead of cube viewer.
I believe that retains formats when it is sliced.
Thanks Ankur. Yes, in-spreadsheet browser will retain the formats.
But I am looking for options, if any, to retain the formats after we create slice or active form in excel from cube viewer. It would be very difficult to ask our business users to switch to in-spreadsheet browser from cube viewer.
Re: Retaining TM1 cell formats while slicing data to excel
Posted: Thu Dec 02, 2010 10:07 pm
by Martin Ryan
An active form should retain the formatting. Mine does anyway - 9.5.1.
Martin
Re: Retaining TM1 cell formats while slicing data to excel
Posted: Tue Dec 07, 2010 4:07 pm
by suhamore
More tests and this is what I have found.
If you have the formatting applied to an element that is in the columns of the cube view it will slice/carry over to excel. If you have formatting applied to elements in a row or title it will not carry over. (9.4.1 FP3)