COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: abboudi1982 on 26 Nov 2017 05:20:01 AM

Title: Disable a report using SQL command executed against Cognos Content Store
Post by: abboudi1982 on 26 Nov 2017 05:20:01 AM
Hi everybody,

I may need to Enable / disable a folder (or package) everyday at the same hour.
I tried to find information about that in Content Store but I must have missed something.

I found 2 tables :
CMOBJECTS which contains the flag Disabled 1/NULL
CMOBJPROPS55 which contains the flag hidden 1/0

If I update the hidden flag in CMOBJPROPS55 by SQL, after refreshing the browser the entry is now hidden correclty.

But I dot the same with CMOBJECTS on disabled flag, the folder don't apear disabled and the disable Icon is not there too.

I tried to search in others CM tables but in vain.
Title: Re: Disable a report using SQL command executed against Cognos Content Store
Post by: dougp on 27 Nov 2017 10:18:37 AM
This task sounds like a good candidate for the Cognos SDK.
Title: Re: Disable a report using SQL command executed against Cognos Content Store
Post by: komoshon on 24 Apr 2019 04:27:24 AM
Hi Sorry to raise this post from the dead but i have the same issue.  Did you find out where the disabled flag should be set as it seems that the disabled flag on cmobjects is no longer used.....
Title: Re: Disable a report using SQL command executed against Cognos Content Store
Post by: dougp on 24 Apr 2019 03:54:19 PM
CMOBJECTS hold all objects in Cognos.  The DISABLED field is probably only meaningful for objects that can be enabled and disabled.  Schedules can be.  Folders can't.

A package can be hidden.  "Disabling" a package is more complex than flipping a switch.  It involves setting Permissions and/or Capabilities, depending on the precise desired outcome.  To enable/disable a package on a schedule, you'll probably want to use the SDK to write a program that is called by the Windows Task Scheduler, cron, or whatever other scheduling software you may have on your system.