Disable a report using SQL command executed against Cognos Content Store

[abboudi1982]

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.

[dougp]

This task sounds like a good candidate for the Cognos SDK.

[komoshon]

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.....

[dougp]

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.