Data Warehouse Story

Description:

This document describes how to create a Time Dimension in Framework Manager which is similar to a Time Dimension created in Powerplay Transformer.

Steps:

1.Right-click on the Namespace and choose Create->Regular Dimension.
2.From Available Items drag the date column and drop it under Hierarchies.
3.Click the ellipsis in Source field to open Calculation Definition windows.
4.Change the name of the calculation to Year.
5.Use ‘cast’ and ‘extract’ functions to extract the years from the date column and convert it to character string, e.g.:
cast(extract ( year, [].[].[] ) , char(8))
6.Back in the Dimension Definition windows, click the ellipsis in the Role field.
7.Assign _businessKey and _memberCaption roles.
8.Under Hierarchies, Add Levels for Month and Day.
9.Repeat the steps 3-7 for the Month and Day using expressions:
cast(extract ( month, [].[].[] ) , char(8))
cast(extract ( day, [].[].[] ) , char(8))
Note:
‘cast’ function has to be used to convert a numeric field to a string as _memberCaption Role cannot be numeric.

written by lynx286 \\ tags: dimension, Framework Manager

Description:

This document describes how to make Custom User Properties for LDAP available to Cognos 8 Components.

Environment:
Cognos 8 BI
LDAP or Active Directory Authentication Source

Solution:

You can use arbitrary user attributes from your LDAP authentication provider (ADS as well) in Cognos 8 components. To configure this, you must add these attributes as custom properties for the LDAP namespace. The custom properties are available as session parameters through Framework Manager.

written by lynx286 \\ tags: Framework Manager, Session Parameters

Description:

How to create optional prompts in Framework Manager.

Solution:

How you create a filter in Framework Manager will depend on whether the filter is seen by a user in Query Studio and or Report Studio.
Here is the expected behaviour seen in Query Studio based on a particular filter

Filter using prompt Macro
E.g. [database].[query subject].[query item] like #prompt(’Prompt name’, ‘Datatype’)#
Because the example uses a macro filter in Framework Manager, then the filter is required and will be seen in Query Studio.

Filter using ? ?
E.g. [database].[query subject].[query item] like ?QueryItem?
To make this filter prompt optional you need to set the “Usage” as optional in Framework manager.

When you then use this query item in Query Studio you will not be prompted for a value. Please note that this is not the case in Report Studio. In Report Studio, you will be prompted for a value, however, as the filter is optional, the user can press the OK button without selecting any data items.

written by lynx286 \\ tags: Framework Manager, Macro, Optional Prompt, Query Studio