Troubleshooting
Problem
Consultant/customer would like more information about the Framework Manager models in Controller.
Symptom
.
Cause
By default, there are two Framework Manager models included in Controller. These can be found in your installation folder under 'deployment' (by default for Controller 8.x this is here: C:\Program Files\cognos\c8\deployment):
Controller.zip
This was first introduced in Controller 8.1
- It contains the model used by Controller to generate its 200+ built-in 'Standard Reports' using C8 report service
- Do not modify this - it is not intended to be changed/customised
Ccr82_dm.zip
This was first introduced in Controller 8.2
- It contains the datamart Framework Manager model for Controller published datamarts with 'Cognos 8 BI' target.
Resolving The Problem
Ccr82_dm
IBM Cognos 8 Controller includes a Framework Manager model 'Ccr82_dm.zip' that can be used for reporting and analysis (against a Controller datamart) from a product such as Cognos Report Studio.
- To publish the Controller data in a suitable data-mart database format (so that it can be accessed with the Framework Manager model), when you define your data mart in Controller you would select 'Cognos BI' as the 'Additional Target'.
- You must unzip the Publish to Data Mart Framework Manager model and publish it to IBM Cognos
the Publish to Data Mart model.
In other words, before you can use the Framework Manager model, you must first:
- Create a database for the Controller datamart
- Set the data-mart database connection properties (inside Controller Configuration)
- Create a data source object in Cognos Connection
- Unzip the CCR82_DM.zip file
- Then use Framework Manager to publish the CCR82_DM package to Cognos Connection.
Steps to Extract the Publish to Data Mart Model and Publish It to IBM Cognos Connection
TIP: The following instructions are based on Controller 10.1.
[For more information, see official product documentation].
- Copy the CCR82_DM.zip file from the c10_location/deployment directory to a location that is accessible by Framework Manager.
- Unzip the CCR82_DM.zip file to extract the CCR82_DM.cpf model.
- In IBM Cognos Framework Manager, from the File menu, click Open and go to the location of CCR82_DM.cpf project file and then click Open.
- In the Project Viewer, expand the CCR82_DM folder, under Packages, click CCR82_DM, and from the Actions menu, click Package and then select Publish Packages.
- Click Publish. A message informs you that the model is published under Public Folders CCR82_DM in IBM Cognos Connection.
- Click Finish and then click Close.
- Close Framework Manager.
Related Information
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0;10.1.1;10.1;8.5.1;8.5;8.4;8.3","Edition":"Not Applicable","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1034224
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21347275