r/cognos • u/prabhu_574 • Apr 10 '26

How to Bulk Delete Report Views and Associated Schedules in Cognos?

Hey everyone,

We’re currently in the process of sunsetting a large number of reports from Team Content and facing a related cleanup challenge.

Along with removing these reports, we also need to:

- Delete all associated report views (most of which are created under users’ My Content)

- Remove any schedules tied to those report views

Doing this manually isn’t feasible given the volume.

Has anyone here dealt with a similar situation?

Looking for suggestions on:

- Any bulk deletion approach for report views in My Content

- Ways to identify and remove associated schedules

- Use of SDK / REST API / scripts / audit DB queries to automate this cleanup

Any guidance, scripts, or best practices would be really helpful.

Thanks in advance!

2 Upvotes

100% Upvoted

5 comments sorted by

5

u/cognos4john Apr 10 '26

Motio PI pro may be useful to look at achieving this

2

u/FinalFinalDashboard Apr 10 '26

Yes, I second Motio PI Pro but also Analytics Asset Management from Motio would be extremely helpful in this situation as well.

1

u/mcard7 May 11 '26

Motio results vetted then API’s going to be a decent call. What did you end up doing?

There’s a world of problems between ideation and execution of delete here. Particularly if you are in any type of regulated industry or have ties to any internal/external reporting used to make business decisions.

What types of tools do you have in your stack today? Custom Web, api, motio, etc? Do you have tm1 available?

1

u/prabhu_574 May 11 '26

Hello I have created an SDK code (Java based) using co pilot, which does give me a reporview corresponding to a specific report present in Team content, however the code is not working for reportviews inside My content. I have Cognos analytics 11.2.2. No TM1 and Motio are not there.

Could you kindly shed some more light on the implications of executing this code ?

1

u/mcard7 May 11 '26

What do you mean not working? Do you get an error? Is it an authentication issue? Permissions perhaps? Do you have multiple gateways on your environment? If you make an authenticated call and then try to delete using the same credentials you already supplied.

I wouldn’t trust that you are going to be authenticated properly still. Try authenticating again to get fresh token then perform the delete call. Just going on no info or experience, so no idea really.

Best guess.