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:
Process the cube. Create a new crosstab report in Cognos Report Studio against the GO Sales SSAS Cube package.
How to do it...
Drag Organization Code1 on to rows, Current Month on to columns and Stmt Month as the measure.
Select the Stmt Month measure and define its data format to be Number and decimal points to 1.
Run the report to test it. You will notice that the formatting is not reflected in the output.
Now, go back to Cognos Report Studio. Select the measure...
