,
balanced hierarchies , or measures . IBM DB2 OLAP and Hyperion Essbase data sources are interchangeable and IBM Cognos 8 works with each of them in exactly the same way. For example, you can connect to an Essbase data source using a DB2 OLAP connection.
Before connecting to a DB2 OLAP or Essbase data source, some
configuration is required if the data source uses scenario dimensions ,
balanced hierarchies , or measures .
When a Hyperion Essbase System 9 Data Source is configured with an LDAP namespace, single signon is supported. The user ID and password used to log on to the LDAP namespace automatically connects to the data source. For more information about configuring an LDAP namespace for IBM DB2 OLAP and Hyperion Essbase Data Sources, see the IBM Cognos 8 Installation and Configuration Guide.
You specify connection parameters when you create a data source or modify
a data source connection .
Parameter | Description |
Server name | Enter the name of the server where the database is located. For UNIX, this can be the TCP/IP address of the server. |
Signon | For more information on signon, see Securing Data Sources. If no authentication is required, click No authentication. For Essbase Server System 9 and IBM Cognos 8.4, single signon is supported if your Essbase server is configured for an LDAP namespace.
If a user ID and password is required in the connection string, click Signons.
|
If you connect to a Essbase/DB2 OLAP data source and it contains a scenario dimension, you must manually configure the scenario dimension so that IBM Cognos 8 recognizes it. Otherwise, IBM Cognos 8 treats the scenario dimension as a regular dimension.
For information on how an attribute of a dimension is represented in a model and all associated packages, see Specify the Attributes of a Dimension.
In the Hyperion Solutions Essbase Administration Services tool, assign a User Defined Attribute (UDA) named COGNOS_SCENARIO_DIMENSION to the scenario dimension.
Essbase/DB2 OLAP Provider does not determine if a hierarchy is balanced or unbalanced. It considers all hierarchies as being unbalanced by default.
In a balanced hierarchy, each path descends to the same depth while the branches in an unbalanced hierarchy descend to different levels.
In the Hyperion Solutions Essbase Administration Services tool, create a special User Defined Attribute (UDA) named COGNOS_HIERARCHY_BALANCED in the outline of the Essbase/DB2 OLAP database. The UDA is created for the root member of the corresponding dimension containing a balanced hierarchy.
Set the attribute to 1.
To improve the readability of the values reported, you can specify an alternative format string for any measure. Define a UDA for the appropriate members in the Account dimension:
COGNOS_FORMAT=format_string
The format_string value can be any one of the predefined number formats listed in the table below. You can use a preset numeric format to show values as millions (M) or thousands (K). For example, 1,801,791 can be shown as 1.8M or 1,801.8K.
The predefined format strings are as follows:
| Format Option | Sample Value | Example |
General | 1000000 | 1000000 |
| 0 | 1000000 | 1000000 |
| #,##0 | 1000000 | 1,000,000 |
| $0 | 1000000 | $1000000 |
| $#,##0 | 1000000 | $1,000,000 |
| 0% | 1000000 | 100000000% |
| %0 | 1000000 | %100000000 |
| 0E+000 | 1000000 | 1E+006 |
| 0K | 1000000 | 1000K |
| #,##0K | 1000000 | 1,000K |
| K0 | 1000000 | K1000 |
| K#,##0 | 1000000 | K1,000 |
| $0K | 1000000 | $1000K |
| $#,##0K | 1000000 | $1,000K |
| 0M | 1000000000 | 1000M |
| #,##0M | 1000000000 | 1,000M |
| M0 | 1000000000 | M1000 |
| M#,##0 | 1000000000 | M1,000 |
| $0M | 1000000000 | $1000M |
| $#,##0M | 1000000000 | $1,000M |
With the exception of the General format string, you can also preset the number of decimal places to show, using the format_string ~n, where n is the number of decimal places. For example, 1,801,791 can be shown as $1,801,791.00 using the format string $#,##0~2. If you do not want any decimal places, end the format string with ~0.
If your client application uses a different locale, you must replace the Currency ($), Thousands (,) and Decimal (.) symbols in the format_string value for the COGNOS_FORMAT UDA with the corresponding locale symbols in effect for the client application.
If you do not specify the number of decimal places to show, or if the format string does not match one of the predefined values (including locale symbols), the General format string is used by default.
You can apply a different format for each measure. The following illustrates some examples of how you can apply different formatting to different measures:
| Measure | Applied Format |
| Measures (Account dimension) | COGNOS_FORMAT=#,##0 |
| Units | COGNOS_FORMAT=#,##K |
| Costs | COGNOS_FORMAT=$#,### |
| Profits | COGNOS_FORMAT=0% |
You can choose how an attribute of a dimension is represented in a model and all associated packages. An attribute of a dimension can be represented as a separate dimension or as a property (query item) of the dimension with which it is associated. You can set this behavior when creating a package using DB2 OLAP or Essbase data sources.
In IBM Cognos Connection, in the upper-right corner, click Launch, IBM Cognos Administration.
On the Configuration tab, click Data Source Connections.
Click More beside the data source with which you want to create a package.
Click Create a Package.
The New Package Wizard appears.
Enter a name for the package and click Next.
Select a catalogue and click Next.
Select a cube and click Next.
Assign a language specific alias table and click Next.
Choose a language for the alias table and click Next.
Choose how to present model attributes. Select Separate the Dimensions or Properties of the dimension they are associated with. The default selection is Properties of the dimension they are associated with.
Click Finish.
