My team has a set of views (about 40) off of multiple reports (about 7 executables) that take a couple of hours at least to generate, sometimes even more if there is other server activity. To avoid crunch time issues our team likes to run them as soon as the preliminary data becomes available to a hidden folder, then later copy them into a user permissioned folder. This is needed as we are not supposed to release to our final users prior to data signoff by a business owner.

Our solution was to have a staging folder where we run the views that are set to Hidden but have the unique permissions already set, then once we receive the go ahead, we delete the user facing views, copy and paste the stage folder contents and unhide all of the views. This works good with the exception of the "Recent" feature. Users are instructed to go to their Starred Folder to open new reports but some always try to click on the recent reports and since we replaced the views with a new set, the Cognos internal object ID is different, the link broken. This leads to confusion as users click on their recent report view with the same name but because the old one has been deleted, they get the following error:

No access
You don't have access to this asset. It might have been disabled, deleted or your permissions might have been reduced. Verify the state of the asset at its expected source location. You can remove the asset from your recent items by tapping OK.

The problem is really not with their access but the fact that we replaced the original view with another by the same name but from a Cognos perspective the internal Object ID is different.

Does anybody have a better idea how to do sign-off specific report view reveals? Does your team have a better solution?

Any ideas are welcome! Thank you in advance.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

#CognosAnalyticswithWatson

Hi,
I was interested in your comment about automating tasks on the portal.
What script language do you use for these tasks?

Thanks.

------------------------------
Diego Campos
------------------------------

@Diego Campos, I do not understand what portal you are referring to, I do not think I mentioned any. We use Cognos jobs and Events to automate view runs and I also use extensively Motio PI (to un-hide all the views at once with the property distributor, for example).

There was a discussion of how to automate with Events here that might be of interest to you.

Did I misunderstand your question?

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

Original Message:
Sent: Tue February 11, 2020 08:41 AM
From: Diego Campos
Subject: How to release report views to end users at a specific date/time?

Hi,
I was interested in your comment about automating tasks on the portal.
What script language do you use for these tasks?

Thanks.

------------------------------
Diego Campos
------------------------------

You can create a customized Logon Page as View for a role to show a simple web page with Report links. Once assign to default Landing page under customization, this perspective can be default instead of showing IBM Web page with recent Item list.

------------------------------
Buddhi Gupta
------------------------------

Thanks @Buddhi Gupta, that was our solution before moving to Cognos 11. It became cumbersome to have to maintain the custom pages, hence we were trying to find a solution using the system as it was meant to be used. The Recents on the homepage is actually a feature that many users like, given that they keep on using the same reports/views to get their work done.

What I am after is how ​​IBM was thinking of handling these types of issues. I do not think that my team is the only one with such an issue. Releasing final data to end users after a preliminary check period is something universal to businesses, I assume. It would not be a problem if these reports were faster but they are not that fast, hence I need to give users already generated pdf/Excel files so they can click and it opens. Later if they need to, they do further data explorations using relational or dimensional packages.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------

Original Message:
Sent: Tue February 11, 2020 09:42 AM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

You can create a customized Logon Page as View for a role to show a simple web page with Report links. Once assign to default Landing page under customization, this perspective can be default instead of showing IBM Web page with recent Item list.

------------------------------
Buddhi Gupta
------------------------------

If we don't delete and just overwrite contents by copy-paste, Recent link works fine.  

For performance perspective, you can create datasets to make report run faster and probably get rid of report views. 

Have you tried this approach as well?

 


------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Tue February 11, 2020 12:13 PM
From: Adrienne Beronilla
Subject: How to release report views to end users at a specific date/time?

Thanks @Buddhi Gupta, that was our solution before moving to Cognos 11. It became cumbersome to have to maintain the custom pages, hence we were trying to find a solution using the system as it was meant to be used. The Recents on the homepage is actually a feature that many users like, given that they keep on using the same reports/views to get their work done.

What I am after is how ​​IBM was thinking of handling these types of issues. I do not think that my team is the only one with such an issue. Releasing final data to end users after a preliminary check period is something universal to businesses, I assume. It would not be a problem if these reports were faster but they are not that fast, hence I need to give users already generated pdf/Excel files so they can click and it opens. Later if they need to, they do further data explorations using relational or dimensional packages.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton
------------------------------


Original Message:
Sent: Tue February 11, 2020 09:42 AM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

You can create a customized Logon Page as View for a role to show a simple web page with Report links. Once assign to default Landing page under customization, this perspective can be default instead of showing IBM Web page with recent Item list.

------------------------------
Buddhi Gupta

I believe the default Cognos behavior is to create a new ID when overwriting, which removes scheduling and other similar links to reports. We had to do the below operation in 11.1 to update our environment to keep the report ID:

More info can be found here https://www.ibm.com/support/pages/using-configsetter-utility-specify-configuration-settings-cognos-analytics

------------------------------
Nate Landis
------------------------------

Original Message:
Sent: Tue February 11, 2020 12:42 PM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

If we don't delete and just overwrite contents by copy-paste, Recent link works fine.  

For performance perspective, you can create datasets to make report run faster and probably get rid of report views. 

Have you tried this approach as well?

 


------------------------------
Buddhi Gupta
------------------------------


Original Message:
Sent: Tue February 11, 2020 12:13 PM
From: Adrienne Beronilla
Subject: How to release report views to end users at a specific date/time?

Thanks @Buddhi Gupta, that was our solution before moving to Cognos 11. It became cumbersome to have to maintain the custom pages, hence we were trying to find a solution using the system as it was meant to be used. The Recents on the homepage is actually a feature that many users like, given that they keep on using the same reports/views to get their work done.

What I am after is how ​​IBM was thinking of handling these types of issues. I do not think that my team is the only one with such an issue. Releasing final data to end users after a preliminary check period is something universal to businesses, I assume. It would not be a problem if these reports were faster but they are not that fast, hence I need to give users already generated pdf/Excel files so they can click and it opens. Later if they need to, they do further data explorations using relational or dimensional packages.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton


Original Message:
Sent: Tue February 11, 2020 09:42 AM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

You can create a customized Logon Page as View for a role to show a simple web page with Report links. Once assign to default Landing page under customization, this perspective can be default instead of showing IBM Web page with recent Item list.

------------------------------
Buddhi Gupta

We may also check for deployment option... if we can export from stage area and import to User area by keeping id same.. will that not work?

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Tue February 11, 2020 01:20 PM
From: Nate Landis
Subject: How to release report views to end users at a specific date/time?

I believe the default Cognos behavior is to create a new ID when overwriting, which removes scheduling and other similar links to reports. We had to do the below operation in 11.1 to update our environment to keep the report ID:

Cognos>Manage>Configuration>System>Advanced Settings

then type in 'Portal.updateTargetObjectWhenOverwrite' into the key and update the Value to 'True'.

More info can be found here https://www.ibm.com/support/pages/using-configsetter-utility-specify-configuration-settings-cognos-analytics

------------------------------
Nate Landis
------------------------------


Original Message:
Sent: Tue February 11, 2020 12:42 PM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

If we don't delete and just overwrite contents by copy-paste, Recent link works fine.  

For performance perspective, you can create datasets to make report run faster and probably get rid of report views. 

Have you tried this approach as well?

 


------------------------------
Buddhi Gupta


Original Message:
Sent: Tue February 11, 2020 12:13 PM
From: Adrienne Beronilla
Subject: How to release report views to end users at a specific date/time?

Thanks @Buddhi Gupta, that was our solution before moving to Cognos 11. It became cumbersome to have to maintain the custom pages, hence we were trying to find a solution using the system as it was meant to be used. The Recents on the homepage is actually a feature that many users like, given that they keep on using the same reports/views to get their work done.

What I am after is how ​​IBM was thinking of handling these types of issues. I do not think that my team is the only one with such an issue. Releasing final data to end users after a preliminary check period is something universal to businesses, I assume. It would not be a problem if these reports were faster but they are not that fast, hence I need to give users already generated pdf/Excel files so they can click and it opens. Later if they need to, they do further data explorations using relational or dimensional packages.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton


Original Message:
Sent: Tue February 11, 2020 09:42 AM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

You can create a customized Logon Page as View for a role to show a simple web page with Report links. Once assign to default Landing page under customization, this perspective can be default instead of showing IBM Web page with recent Item list.

------------------------------
Buddhi Gupta

I am not sure about your exact requirements. But I am creating a number of report views (for example crating all course views ) from one report using SDK. I run the SDK code ( manually passing parameter the year like 2019) and it will generate report view for all courses.  Then I run the job to generate the report output.

------------------------------
Ramanujam Rajagopal
------------------------------

Original Message:
Sent: Tue February 11, 2020 01:42 PM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

We may also check for deployment option... if we can export from stage area and import to User area by keeping id same.. will that not work?

------------------------------
Buddhi Gupta
------------------------------


Original Message:
Sent: Tue February 11, 2020 01:20 PM
From: Nate Landis
Subject: How to release report views to end users at a specific date/time?

I believe the default Cognos behavior is to create a new ID when overwriting, which removes scheduling and other similar links to reports. We had to do the below operation in 11.1 to update our environment to keep the report ID:

Cognos>Manage>Configuration>System>Advanced Settings

then type in 'Portal.updateTargetObjectWhenOverwrite' into the key and update the Value to 'True'.

More info can be found here https://www.ibm.com/support/pages/using-configsetter-utility-specify-configuration-settings-cognos-analytics

------------------------------
Nate Landis


Original Message:
Sent: Tue February 11, 2020 12:42 PM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

If we don't delete and just overwrite contents by copy-paste, Recent link works fine.  

For performance perspective, you can create datasets to make report run faster and probably get rid of report views. 

Have you tried this approach as well?

 


------------------------------
Buddhi Gupta


Original Message:
Sent: Tue February 11, 2020 12:13 PM
From: Adrienne Beronilla
Subject: How to release report views to end users at a specific date/time?

Thanks @Buddhi Gupta, that was our solution before moving to Cognos 11. It became cumbersome to have to maintain the custom pages, hence we were trying to find a solution using the system as it was meant to be used. The Recents on the homepage is actually a feature that many users like, given that they keep on using the same reports/views to get their work done.

What I am after is how ​​IBM was thinking of handling these types of issues. I do not think that my team is the only one with such an issue. Releasing final data to end users after a preliminary check period is something universal to businesses, I assume. It would not be a problem if these reports were faster but they are not that fast, hence I need to give users already generated pdf/Excel files so they can click and it opens. Later if they need to, they do further data explorations using relational or dimensional packages.

------------------------------
Adrienne Beronilla
Senior Financial Systems Analyst
Franklin Templeton


Original Message:
Sent: Tue February 11, 2020 09:42 AM
From: Buddhi Gupta
Subject: How to release report views to end users at a specific date/time?

You can create a customized Logon Page as View for a role to show a simple web page with Report links. Once assign to default Landing page under customization, this perspective can be default instead of showing IBM Web page with recent Item list.

------------------------------
Buddhi Gupta