COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: eknight on 25 May 2012 04:41:12 AM

Title: Is there any was to drill up in DS?
Post by: eknight on 25 May 2012 04:41:12 AM
For a given build or function, is there any easy way to find out in which jobs they are used?
Title: Re: Is there any was to drill up in DS?
Post by: MFGF on 11 Jun 2012 11:37:37 AM
I think this is available in the "Document Catalog" feature.

Regards,

MF.
Title: Re: Is there any was to drill up in DS?
Post by: eknight on 15 Jun 2012 02:44:12 AM
Ooo, that sounds promising.

What is the "Document Catalog" feature? I can't seem to find anything in the documentation we have about it, although the term "catalog" is used often. Which version of DS has this feature?
Title: Re: Is there any was to drill up in DS?
Post by: MFGF on 15 Jun 2012 04:05:23 AM
Hi,

All of the versions have this feature - right back to DecisionStream 6.0. Go to the File menu and select the "Document Catalog" option. Choose Full Documentation and provide a name. This will then create an HTML document of your work saved in the catalog. For each build you will find a Usage Summary, which details the jobstreams it is used in (look for "Build Node nn in JobStream Component xxxxx" - you will get one entry like this for each jobstream node the build is referenced from)

Cheers!

MF.
Title: Re: Is there any was to drill up in DS?
Post by: eknight on 21 Jun 2012 02:29:45 AM
Thanks again for the help.  :D

That's exactly the info I need. Although it isn't exactly easy to get at. Creating the catalog takes about 10 minutes on my machine and the resulting HTML file is 15 MB. Do you if it is possible to trigger the Document Catalog creation from the command line?
Title: Re: Is there any was to drill up in DS?
Post by: MFGF on 21 Jun 2012 03:01:08 AM
Quote from: eknight on 21 Jun 2012 02:29:45 AM
Thanks again for the help.  :D

That's exactly the info I need. Although it isn't exactly easy to get at. Creating the catalog takes about 10 minutes on my machine and the resulting HTML file is 15 MB. Do you if it is possible to trigger the Document Catalog creation from the command line?

Yes - there is a 'catdoc' command to do exactly this. The syntax is covered in the Data Manager User Guide:

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_ds.10.1.0.doc%2Fug_ds_id27284catdoc.html

Cheers!

MF.
Title: Re: Is there any was to drill up in DS?
Post by: eknight on 25 Jun 2012 02:46:09 AM
Oh, perfect. It's a sub optimal solution (I'd prefer being able to have this built in the application) but I can autogenerate new docs overnight and auto publish them to a webserver.

Thanks again,
Title: Re: Is there any was to drill up in DS?
Post by: MFGF on 25 Jun 2012 05:23:36 AM
In theory, you could extract this information from the catalog database - it will be held somewhere in the table schema. It's probably not an easy task to find the relevant tables and columns to interrogate, but if the Document Catalog option proves too clunky, it might be something you could look at. It's not a supported technique, though - IBM don't want you messing around in the catalog tables, and of course they reserve the right to change the schema between versions without telling you :)

Cheers!

MF.
Title: Re: Is there any was to drill up in DS?
Post by: eknight on 26 Jun 2012 03:24:25 AM
I've taken a look at the database  :o . There are much better things I could do then go messing around in there. It seems like it wouldn't be too hard to add a context menu option on builds called "jobs..." which uses a similar query to the "Document Catalog" option and displays a clickable list of jobs that use this build.

Title: Re: Is there any was to drill up in DS?
Post by: ROBER82167 on 11 Jul 2012 02:15:56 AM
Another option is to select the Build you are interested in, and use the View/Navigate menu (or click the "Open the Navigator window" icon. In the Navigator you'll see the Build nodes in the JobStreams where that build is used; click on one to take you there in the main tree.
Title: Re: Is there any was to drill up in DS?
Post by: MFGF on 11 Jul 2012 04:25:20 AM
This links from a jobstream node to a build, but not the other way around - it doesn't allow you to select a build and see which jobstreams it is used in, sadly. The only way I know of to get that info is in the Document Catalog feature.

Cheers

MF.
Title: Re: Is there any was to drill up in DS?
Post by: ROBER82167 on 11 Jul 2012 07:50:57 AM
With the Navigator open, when I select a fact build in the tree, the navigator DOES show details of all the builds nodes in the catalog that use that fact build. The details include the name of the JobStream.

Isn't that what was wanted?
Title: Re: Is there any was to drill up in DS?
Post by: eknight on 11 Jul 2012 08:54:37 AM
Quote from: ROBER82167 on 11 Jul 2012 02:15:56 AM
Another option is to select the Build you are interested in, and use the View/Navigate menu (or click the "Open the Navigator window" icon. In the Navigator you'll see the Build nodes in the JobStreams where that build is used; click on one to take you there in the main tree.

Yes! That is exactly what I was looking for! Thank you    ;D
Title: Re: Is there any was to drill up in DS?
Post by: MFGF on 11 Jul 2012 09:04:48 AM
Quote from: ROBER82167 on 11 Jul 2012 07:50:57 AM
With the Navigator open, when I select a fact build in the tree, the navigator DOES show details of all the builds nodes in the catalog that use that fact build. The details include the name of the JobStream.

Isn't that what was wanted?

Hmmmmm. Not doing it on mine! It works for you and eknight though, so that's great news!! I wonder why mine doesn't?

Oh... Wait a minute. I think I know.

Cheers!

MF.
Title: Re: Is there any was to drill up in DS?
Post by: eknight on 11 Jul 2012 10:49:50 AM
Quote from: MFGF on 11 Jul 2012 09:04:48 AM
Oh... Wait a minute. I think I know.

Cheers!

MF.

You can't just leave us hanging dude! Why doesn't it work for you? Or did you get it working? FYI I'm using DecisionStream 7.1  :-\