Configuring Cognos cubes

To use a Cognos lookup table, you use the administrative console to export a cube package definition for MortgageLendingBAM so that it can be imported into the Cognos Framework Manager. You then create a query subject from a lookup table and create a relationship between the query subject and the sample MortgageLendingBAM monitor context.

1. Export a cube package definition for MortgageLendingBAM:
   1. From the administrative console, click Applications > Monitor models > [MortgageLendingBAM_Version] > Manage Cognos Cubes.
   2. From the Manage Cognos Cubes page, click Export.
   3. Specify the location where you want to export the cube package (for example, C:\LDAPsample).
2. In Cognos Framework Manager, open the file you exported in step 1:
   1. Open Cognos Framework Manager.
   2. Click File > Open (All Files (*.*)), and select the exported Cognos cube model file MortgageLendingBAM_<version>_fromCognos.xml from your local file system (C:\LDAPsample, for example).

      The cube model is now loaded into Framework Manager.

3. Create a query subject:
   1. From the Project Viewer, right-click namespace Mortgage Lending BAM MC Query Subject, and click Create > Query subject.
   2. In the Name field, type a name for the query subject (for example, Cognos Value Mapping).
   3. Select Data Source (Table and Columns) to manually build a SQL query, and click OK.
   4. From the Database objects column of the Select columns page, select FGS_SP_COGNOS_VALUE_MAPPED_T, and click the right arrow icon to move it to Included columns.
   5. Click Next on the Select Columns page and on the two pages that follow. Finally, click Finish.

      The newly created Cognos Value Mapping query subject is visible in the Project Viewer.

4. Create a relationship between Mortgage Lending BAM MC and the newly created query subject:
   1. From the Project Viewer, right-click Mortgage Lending BAM MC Query Subject, and click Create > Relationship.
   2. On the Relationship Expression tab, type a name (for example, Cognos Value Mapping to Mortgage Lending BAM MC).
   3. Click New Link.
   4. In the Query subject column for Cognos Value Mapping, highlight ACTUAL_FILTER_VALUE.
   5. In the Query subject column for Mortgage Lending BAM MC, highlight LoanOfficer.
   6. For Cardinality, select 1..1. For Operator, select =. For Cardinality, select 1..n.

      Notice the expression that is generated:

      Cognos Value Mapping.ACTUAL_FILTER_VALUE = Mortgage Lending BAM MC.LoanOfficer

   7. Click OK.
5. Add the data security filter:
   1. From the Project Viewer, click Project > Mortgage Lending BAM > Mortgage Lending BAM MC > Mortgage Lending BAM MC Query Subject > Mortgage Lending BAM MC.
   2. Click Actions > Specify Data Security.
   3. On the Specify Data Security page, click Add Groups.
   4. On the Select Users and Groups page, from the Cognos namespace, select All Authenticated Users and click the right arrow. Then click OK.
   5. Select Create/Edit Embedded from the list in the Filter column, and type the following expression:

      [Mortgage Lending BAM MC Query Subject].[Cognos Value Mapping].[USER_ID]  = #sq($account.parameters.uid)#

   6. Click OK.
6. Publish the package to the Cognos Business Intelligence server by right-clicking the Mortgage Lending BAM package and clicking Publish.