Search found 3835 matches

by eostic
Tue Jul 31, 2012 5:34 am
Forum: Cognos (IBM BI)
Topic: Anyone know how to harvest/export Cognos tool tip defs?
Replies: 8
Views: 12496

Hi Ray... Thanks......though I'm not certain that bi2bg picks up all of the possible description properties that may have originated in FrameWorker Manager for a particular Package that you've imported.... can you confirm which of the properties you are successfully getting for each query item? Desc...
by eostic
Fri Jul 27, 2012 11:55 am
Forum:
Topic: Question on odd icon returned with Bus./Data Lineage reports
Replies: 6
Views: 4401

It occurs when the Metadata Workbench has reached a limit (it is sett-able) in terms of the number of objects it can analyze for lineage. This status means that Lineage beyond the object with the "ghostbusters" icon with the red circle is "incomplete". It is documented here: http...
by eostic
Wed Jul 25, 2012 6:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Import JSON files
Replies: 9
Views: 6970

JSON is very much "like" xml, but is not.......it would be nice to use the xml stages for this, but alas, it is not possible. Java has all kinds of libraries to process JSON.....my suggestion would be to start looking at JavaPack and write your own class to decipher this JSON and send it t...
by eostic
Wed Jul 25, 2012 5:51 am
Forum:
Topic: Integrating "other" BI tools for Data Lineage
Replies: 2
Views: 1420

I was given other priorities that got in the way, but I did make some progress. One of the great things about Actuate is that it stores its metadata in XML.... so it was easy to see, easy to access and easy to parse. The keys to exercises such as this are: a) What metadata do you want to see? Names ...
by eostic
Fri Jul 20, 2012 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder Stage
Replies: 5
Views: 2835

Given it's usual function at the source (to pick up a whole file in a single column and row) that would make sense. I have only used it as a target once or twice, and memory is fading, but I may have aggregated all of my rows beforehand with my own delimeter and record terminator.

Ernie
by eostic
Thu Jul 19, 2012 7:38 pm
Forum: Cognos (IBM BI)
Topic: Why Cognos can't find some terms in Business Glossary?
Replies: 9
Views: 13582

I haven't found a way to change the search logic that is inside of cognos.....but some accounts have chosen to write their own search widgets for their browser using the REST API, to customize the search to anything they want.

Ernie
by eostic
Wed Jul 18, 2012 12:26 pm
Forum:
Topic: Why would you restrict access to terms in the Glossary?
Replies: 6
Views: 4656

There are SOOOOO many use cases here. Absolutely there are sites like yours where it will be best for everyone to have access. But there are customers who have specific reasons to isolate terms, as much for "security" reasons as for "complexity" reasons. If you easily want to &qu...
by eostic
Wed Jul 18, 2012 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Wave Generator Stage
Replies: 4
Views: 9881

The wave generator was designed for jobs that are "always on" and it forces a signal to be passed downstream that stages "think" means "end of job". The job keeps running, but most normal stage processing will "finish" as though the job had completed. It is mo...
by eostic
Tue Jul 17, 2012 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML transformation help needed
Replies: 11
Views: 5229

We will assume that this comes in as at least 2 rows, and is turned into twelve...and that the first six have organization code of XYZ and that the next six have organization code of WWW (plus the other attribute values). I can't remember ever seeing the xml stage blatantly "drop" data.......
by eostic
Mon Jul 16, 2012 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML transformation help needed
Replies: 11
Views: 5229

The key to Ravi's explanation is that the change that was made to the xml is that what "used to be" multiple attributes within one single element is now instead a set of "repeating elements" inside one single element. In order for xmloutput to produce such a set of "repeatin...
by eostic
Thu Jun 28, 2012 5:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML input stage issue
Replies: 3
Views: 1327

It looks like you want the quotes? ...but don't want the tag characters (left and right caret < and > ? .... To remove the carets, open the xmlInput Stage, go to the output link and scroll to the Descriptions of the columns on that link...make sure that each of the entries ends with "text()&quo...
by eostic
Wed Jun 27, 2012 3:24 pm
Forum:
Topic: How can we import models from Embarcadero's ER/Studio 9.1 v?
Replies: 3
Views: 1824

I haven't tried ER/studio imports in awhile...don't know at the moment what the latest "documented" release is that we support. Are you trying this via DM1 file? Here's the current list of bridges for 8.7 from my bookmarks...I don't have time to check at the moment, but perhaps it will hel...
by eostic
Wed Jun 27, 2012 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cobol CopyBook to XML
Replies: 5
Views: 2789

....one question for clarification....are you looking for a way to convert the "copybook" into xml? (like into an xsd or representation of the cobol metadata?)..... ...or to convert the "file" described by the Copybook into xml? DataStage can help you with either one, the latter ...
by eostic
Tue Jun 26, 2012 5:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML stage error - OperatorTransitionFailedAtRuntime
Replies: 1
Views: 2270

I haven't seen that one before, so can't exactly suggest what to do...I certainly would have approached it the way that you have so far, but also, since this is your first time trying the new Stage, edit the schema (assuming it is a simple one, which you should try to use for the first time) and mak...
by eostic
Mon Jun 25, 2012 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML output for combination of keys
Replies: 3
Views: 1984

It's important that you separate the problems...first, figure out how to group the rows the way that you want based on those values. For each "combination", create a "set" of rows (using pivots, transformers, and whatever other logic you need).....get the number of rows that you ...