Following steps for configuring and testing the OpenPage data source connection in Framework manager:
Step 1: Open IBM Cognos Framework Manager
Step 2: Click “Open a Project…”
Step 3: Navigate to the folder containing the Framework model. Double click on the .cpf file.
Step 4: If correctly configured, FM will prompt for the user to log on. Use the same credentials as Cognos Connection / OpenPages.
Step 5: In the Project Viewer window, expand the Data Sources folder.
Step 6: Find the “OpenPages DataSource” data source connection and click on it, as shown above.
Step 7: The properties pane at the bottom should update to show the properties of the connection. The two of interest are:
a. Content Manager Data Source – this is the name of the Data source as defined in Cognos Connection and should be typed in identically (i.e., “OpenPages DataSource”)
b. Schema – this should be changed to OPUSER or whatever the DB2 schema is.
Step 8: In the Project Viewer, expand any query subject example: OpenPages Report Portfolio > Database Objects > Business Entity > RV_ENTITY (SPINE)
Step 9: Right click on query subject RV_ENTITY (SPINE) and click Test.
Step 10: In the resulting pop-up, click Test Sample in the bottom right. If successful, then data will be returned.