COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: DTV12345 on 08 Oct 2007 11:15:18 AM

Title: Content database: list of datasources?
Post by: DTV12345 on 08 Oct 2007 11:15:18 AM
Greetings!

I need to create a list of the datasources that are created on our production server and publish that list to  our developers.

I created a FM project that points to my content store db and from that, a simple tabular report. Problem is that the tables from the content store db I thought of using (NC*) are empty...???

Do you have any suggestions on how to do that? Has anyone do anything similar to that??  :-\

I am open to any ideas....etc.

TIA,

Al.
Title: Re: Content database: list of datasources?
Post by: bpeterson on 10 Oct 2007 02:48:14 PM
Trying to manually dig through the CS is futile, becuase of the lack of information regarding the structure. The SDK provides methods to build a very simple app to pull the datasources, there is a KB document on support.cognos.com that deals with this issue.

The knowledge document #1008149.2.

Let me know if that helps
Title: Re: Content database: list of datasources?
Post by: megatrack67 on 18 Mar 2008 02:31:07 PM
If you are using Oracle as content store, here a select to find all the datasources with there english name

SELECT cmobjnames_base.cmid, cmobjects.pcmid, UPPER (cmobjnames_base.NAME),
          cmobjects.created, cmobjects.modified, cmobjects.disabled,
          cmobjnames_base.isdefault
     FROM cmobjects, cmobjnames_base
    WHERE cmobjects.classid = 12
      AND cmobjects.pcmid = 49
      AND cmobjnames_base.mapdlocaleid = 24   <=====remove this line to see all names
      AND cmobjects.cmid = cmobjnames_base.cmid

regards

PC
Title: Re: Content database: list of datasources?
Post by: DTV12345 on 19 Mar 2008 11:26:32 AM
Quote from: bpeterson on 10 Oct 2007 02:48:14 PM
Trying to manually dig through the CS is futile, becuase of the lack of information regarding the structure. The SDK provides methods to build a very simple app to pull the datasources, there is a KB document on support.cognos.com that deals with this issue.

The knowledge document #1008149.2.

Let me know if that helps

You are correct...this was a waste of time. We contracted a Java developer. The rest took care of itself.
Title: Re: Content database: list of datasources?
Post by: mrcool on 11 Sep 2014 07:04:30 AM
Quote from: megatrack67 on 18 Mar 2008 02:31:07 PM
If you are using Oracle as content store, here a select to find all the datasources with there english name

SELECT cmobjnames_base.cmid, cmobjects.pcmid, UPPER (cmobjnames_base.NAME),
          cmobjects.created, cmobjects.modified, cmobjects.disabled,
          cmobjnames_base.isdefault
     FROM cmobjects, cmobjnames_base
    WHERE cmobjects.classid = 12
      AND cmobjects.pcmid = 49
      AND cmobjnames_base.mapdlocaleid = 24   <=====remove this line to see all names
      AND cmobjects.cmid = cmobjnames_base.cmid

regards

PC

Hi,
Is it possible to link this with package to find the dependency?