Friday, February 12, 2010

Unsupported IBM Cognos 8 Formatting

About 30% of the formatting functions available in IBM Cognos 8 are not supported in Microsoft Excel. In particular, Excel does not allow changing locale-dependent formatting attributes, such as the following:

Decimal Separator

Exponential Symbol

Group Separator

Monetary Decimal Separator

AM String

Day Name

Day Short Name

Decimal Delimiter Symbol

Month Name

Month Short Name

PM String

In addition, Excel does not support the following:

Format Width

International Currency Symbol

List Separator

Percent Symbol (Excel does not support percent symbols for charts)

Multiplier

Overline Text Format

PerMill Symbol

Plus Sign

Scale (Excel has a different scaling formula than IBM Cognos 8)

Calendar (Excel does not allow changing the calendar)

Era Name

First Day Of Week

Show Era

No comments:

Post a Comment

Working with Compression on HDFS

Copy and uncompress file to HDFS without unziping the file on local filesystem If your file is in GB's then this command would cer...