TM1ViewFormat property

Item

Description

Purpose

Contains a string that indicates the applied format of the cube view.

If the string is NULL, this view has no format. The string has the following format:


<format_code>:<format_string>
[<form_feed><dialog_helper_str>]

Where the format_code is a single character - either b or c.

The format_string is a digit template. This template varies depending on the format chosen for the view. Examples of each possible format are shown below.

The dialog_helper_str is something like F|2|Y. These strings are for use by the IBM® Cognos® TM1® Server Explorer.

Deprecated: This property is obsolete and will be removed from the TM1 product in a future release. Use the property TM1ViewFormatString in place of this property in all new TM1 applications.

Examples

General:

b:0.######### G|0|

 

Fixed:

b:0.00;(0.00) F|2|Y

 

Comma:

b:#,##0.00;(#,##0.00

 

Currency:

b:\$#,###.00;(\$#,##

 

Date:

b:dddd, mmmm dd, yyy

 

Time:

b:h:nn:ss AMPM T|0|

 

Percent:

b:#.00% P|2|

 

Scientific:

b:#.00E+## S|2|

 

Custom:

c:####.##

Type

TM1_BOOL

Updateable

No