– 20 if an error occurred while accessing the PowerCube
v -v or verbose mode; text is output to standard output (stdout), indicating
what was done, including any error messages. If running in interactive
mode, -v is assumed. All text is output in English only.
v -h for command-line help; if cubename is not provided, it prints the usage
and options to the screen.
Analysis Studio Shows the Wrong Currency Symbol
When published to IBM Cognos Analysis Studio, PowerCubes show a default
currency rather than the currency associated with the locale of your servers and
PCs. For example, GBP (£) is shown as $.
To resolve this problem, you can do one of the following:
v Create a currency table when you prepare your model in Cognos Transformer
and embed a default currency symbol into the resulting PowerCubes, based on
the system locale used by your Cognos Transformer computer.
v For PowerCubes that do not contain an embedded currency table, set the
fallbackCurrency parameter as the default currency.
Procedure
1. In Cognos Transformer, from the File menu, click Currency Table and click
OK.
2. Right-click each currency measure and click Allow currency conversion. This
default currency table does not include currency information for any locales
other than your running locale. Also, you cannot convert to a different currency
while working in Analysis Studio.
3. Define a default currency by setting the fallbackCurrency parameter in the
installation_location\configuration\qfs_config.xml file to GBP (Great Britain
Pounds) or to an alternative currency code as listed in the installation_location\
bin\ccli18nrescr_xx.xml file.
Here is an example. <!-- execution layer providers--> <provider
name="PowerCubeODP" libraryName="pcodp" connectionCode="PC"> ...
<providerDetails>
<parameters>
<!--
Max
depth
of
nested
calculated
members
within
a
query.
-->
<parameter
name="maxCalculatedMemberNestingDepth" value="30"/> <!-- Normalize
yen/won
currency
symbols
-
set
to
"false"
to
disable
-->
<parameter
name="normalizeYenWon" value="true"/> <!-- Fallback currency for cubes
with no default currency specified - set to USD, EUR etc. -->
<parameter name="fallbackCurrency" value="USD"/> </parameters>
</providerDetails> </provider>
Changes to Decimals in Currency Formats
When you open a PowerCube in an IBM Cognos studio or in IBM Cognos
Business Intelligence Mobile Analysis version 8.3, you may notice changes in the
number of default decimal places shown in currency formats.
This behavior is due to the following changes:
v The default decimal formatting in currency formats is now determined by the
measure format selected in the cube, instead of from the data source currency
table definition.
244 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General