Over-riding data formatting defined in database

In Cognos Report Studio, we can define the formatting of data items that we have seen in many recipes. However, sometimes, the formatting defined in the report does not take effect. In this recipe, we will consider one such scenario.

Getting ready

We will use the dimensional GO Sales SSAS Cube package for this.

Open the GOSALESDW cube in the SQL Server BIDS (Business Intelligence Development Studio) and change the data format of the Stmt Month measure as shown in the following screenshot:

Getting ready

Process the cube. Create a new crosstab report in Cognos Report Studio against the GO Sales SSAS Cube package.

How to ...

Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.