Start Query Studio in Preview Mode

You can configure Query Studio to start in preview mode. Users can then create or modify reports without retrieving actual data from the database. Instead, simulated data is shown.

If you later upgrade IBM Cognos 8, you must reapply this configuration.
Steps

1. Using IBM Cognos Configuration, stop IBM Cognos 8.
2. Rename the c8_location\templates\ps\async\system.xml.sample file to
system.xml.
Tip: To restore the regular mode, rename the
c8_location\templates\ps\async\system.xml file to system.xml.sample.

3. Using IBM Cognos Configuration, start IBM Cognos 8.

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