DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message

Joined: 19 Apr 2007
Posts: 527
Location: Melbourne
Points: 3924

Post Posted: Mon May 09, 2011 6:33 pm Reply with quote    Back to top    

It's not much: all I want for Christmas is a reporting environment to allow for custom creation of IA reports. And by "custom creation" I don't mean "thoughtfully allow me a tick box to return optional notes". Rolling Eyes

I understand why they obfuscate the repository, but it makes for reports that no one likes.

I have tried in the past to get IA results out and in a format that doesn't mean getting laughed at by my clients (2000 page PDF for Summary Statistics alone?), but it's a lot of work to manually cut out the useful bits just for some results.
And the TXT and XLS reports are a joke. 'Nuf said.

Keep it obfuscated at the physical level: I don't care.
But some sort of abstracted model or a report builder that allows me a little more freedom to create reports that people actually want to look at would be lovely.

Group memberships:
Premium Members

Joined: 28 Oct 2004
Posts: 120

Points: 1153

Post Posted: Mon May 09, 2011 8:35 pm Reply with quote    Back to top    

Well I am sorry to hear you think the xml files are a joke.
I use them, have been using them for 10 years.

I wrote a series of jobs which parse all the xml files and loads the data into tables, relational of course. I then use a reporting tool like Report Builder in this case since the tables are in SQL server, and build my various reports.
The ones I send to management and the ones that I use to evaluate performance and such.

And I suppose you could use Information server but I can't speak to that, I have not used it. Pretty satisfied with the system I built.

"Don't let the bull between you and the fence"

Gregg J Knight

"Never Never Never Quit"
Winston Churchill
Rate this response:  
Not yet rated

Premium Poster

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3592
Location: Australia, Melbourne
Points: 28128

Post Posted: Tue May 10, 2011 4:50 am Reply with quote    Back to top    

Have a look at the HTTP API interface, you can query things like column analysis results using HTTP API calls and display them in your own reporting tool or in Cognos using GET commands.

Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours