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