COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: bobznkazoo on 31 Oct 2014 10:56:17 AM

Title: Display different currency symbols in different measures in same cube
Post by: bobznkazoo on 31 Oct 2014 10:56:17 AM
We would like to display different currency symbols in different measures in the same cube.  One measure will have sales data for the company (ie: GBP).   Another measure will have the same sales data that has been through a currency conversion process in the Framework Manager query that converts to another currency (ie: USD).  In the future we may have a third currency converted (ie: CAD) for display in yet another measure.

I have looked into using the Currency Conversion table for the cube, but that seems to only display currency symbols based on your location and still only displays a single symbol for all measures.

Has anyone done this before?  We are using Transformer v10.1.1.