find better solutions for analytics world
When we use page set, report output in excel will have tab names as page1, pag1_2, page1_3, so on..
If you want to display this tab names by report section names then follow below configuration methods.
In cognos configuration settings at Report service for each dispatcher add below advanced settings
Parameter column, type- RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE
Value column, type- TRUE
We can configure IIS using below video.
to download ARR –
https://www.iis.net/downloads/microsoft/application-request-routing
The announcement states that, On 2018-04-30 IBM will reach End of support for Cognos BI 10.2.x. The link to the announcement can be found here Link at the IBM site.
So if you are one of those shops running Cognos BI 10.2.x, It’s time to start thinking and planning your migration to Cognos Analytics.
I used below query to get cognos user list and associated groups. I got this query for cognos version 10.2.2
If query doesn’t provide any data, change classid and mapdlocaleid values and try.
SELECT v_group.name AS group_name,
v_user.ldap_id AS user_name
, CLASSID
, MAPDLOCALEID
FROM dbo.cmreford1 AS v_group_user
JOIN (SELECT cmid user_id,
UPPER (NAME) ldap_id
FROM dbo.cmobjprops33) v_user
ON v_group_user.refcmid = v_user.user_id
JOIN (SELECT cmobjnames.cmid cmid,
UPPER(cmobjnames.NAME) name
, cmobjects.classid
, cmobjnames.mapdlocaleid
FROM dbo.cmobjects, dbo.cmobjnames
WHERE
cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = 92
AND
cmobjects.cmid = cmobjnames.cmid) v_group
ON v_group.cmid = v_group_user.cmid
order by 1,2
————————————————————————————————————————–
SELECT v_group.name AS group_name,
v_user.ldap_id AS user_name
FROM dbo.cmreford1 AS v_group_user
JOIN (SELECT cmid user_id,
UPPER (NAME) ldap_id
FROM dbo.cmobjprops33) v_user
ON v_group_user.refcmid = v_user.user_id
JOIN (SELECT cmobjnames.cmid cmid,
UPPER(cmobjnames.NAME) name
FROM dbo.cmobjects, dbo.cmobjnames
WHERE cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = 96
AND cmobjects.cmid = cmobjnames.cmid) v_group
ON v_group.cmid = v_group_user.cmid
order by 1,2
Report sometimes shows up old data. This can fixed by clearing the cache.
In Cognos Administration
below is the screenshot. 
In this blog post, I will describe the step-by-step recovery of a corrupted or misplaced IBM Cognos Framework Manager model. These steps will create an XML file, then run a report against the package of the lost Framework Manager model or project. This process may be used when the Framework Manager project directory was deleted or lost. It will only recover the model for selected package. Next, as you create a blank new project, the necessary files that are created with this process can be replaced, and using the CQEConfig.xml file, the lost or corrupted Framework Manager model can be retrieved.
This method will work for Cognos 8 and Cognos 10.
In the current Cognos environment, modify the CQEConfig.xml file as shown here:
f the file does not exist in the location above, you can create an XML file with the following content:
Stop the Cognos services and rename the “RTModels” directory to “Original_RTModels”, as shown here:
Now, restart the Cognos services from Cognos Configuration.
Launch Report Studio from Cognos Connection and create a new report using the package for which the model needs to be recovered.
As the report runs, verify that a new “RTModels” folder has been created, as shown. This folder should also contain an XML file, which needs to be used in the next few steps:
Remove the CQEConfig.xml file created in the first step.
Stop the Cognos services.
Now, move the newly created “RTModels” directory to another location (desktop).
Now, rename the “Original_RTModels” folder back to “RTModels” and re-start Cognos services.
Once these steps have been accomplished, in the metadata modeling tool, Framework Manager, create and save a new empty project.
Close this model.
Explore into the folder containing the newly created empty project and change the model.xml file to model.xml.origin.
Copy the XML file created in the previous step into the Framework Manager project directory and rename it to model.xml (Note: the model.xml.origin will still exist).
This will enable opening the lost Framework Manager model.
**We can also use CM tools to get this information. Will provide steps when I get some time.
Tags:
Recovering Cognos Framework Manager Models From The Content Store
How to get lost Cognos Framework Manager.
How to Recover a Lost Cognos Framework Manager Model
How to recover a corrupted or lost Framework Manager model.
How to recover a Framework Manager model from the content store
Cognos Framework Manager xml file
Source of the article: http://www.performanceg2.com/recovering-framework-manager-from-content-store/
http://www-01.ibm.com/support/docview.wss?uid=swg21505488
Data Engineering and BI BLOG 