Note: This function is used for automatically generated relative time categories,
such as year-to-date (YTD Change). It appears in the list of Available Components
when you use the expression editor to create a calculated category.
Tip: To use ToolTip on the pop-up diagram to show the labels and object IDs of
categories, select the Object Identifier check box in the Preferences property sheet,
(Titles tab).
Syntax
change (cat_code, cat_code|set|level)
Example
A dimension contains a level with Quarters Q1 to Q4. To create change categories
for Q1-Q2, Q2-Q3, and Q3-Q4, use the function
change ("Quarter")
Max
Returns the maximum value of selected data items.
Syntax
max (numeric_exp)
Example
max (Sales)
Returns the maximum value of all Sales values.
Min
Returns the minimum value of selected data items.
Syntax
min (numeric_exp)
Example
min (Sales)
Returns the minimum value of all Sales values.
Percent
Returns the percent of the total value for the selected data items.
Users can format the percentage data so that it reads as a ratio (for example: .25 vs.
25%).
Syntax
percent (numeric_exp)
Example
percent (sales 07)
Returns the percentage of the total sales for 2007 that is attributed to each sales
representative.
372 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General