COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cognos8 on 13 Aug 2012 01:13:20 PM

Title: Live stock value in Cognos10
Post by: Cognos8 on 13 Aug 2012 01:13:20 PM
I want to display the live stock market value in cognos 10.1.1 report studio.  any suggestion is welcome
Title: Re: Live stock value in Cognos10
Post by: HalfBloodPrince on 14 Aug 2012 01:12:51 AM
I found this Link
http://www.inergex.com/blogs/business-intelligence/2011/06/07/use-javascript-ajax-cognos-reports-access-real-time-data-and-

Not sure how they done it. I am still searching.
Title: Re: Live stock value in Cognos10
Post by: Cognos8 on 14 Aug 2012 03:04:20 PM
Cant we do without any JAVA script?
Title: Live stock value in Cognos10
Post by: MFGF on 15 Aug 2012 10:47:28 AM
You could use Virtual View Manager to link to a web service to consume the live stock data (assuming you can find a provider offering access via a web service). You can then connect to VVM via its ODBC from Cognos 10.

Regards,

MF.

Sent from my iPad using Tapatalk HD
Title: Re: Live stock value in Cognos10
Post by: Cognos8 on 16 Aug 2012 10:04:02 AM
hi,

Virtual view manager is a separate installation ?
will it  act add on in report studio reports?
do u have more details abot VVM?
Title: Re: Live stock value in Cognos10
Post by: hardstep on 16 Aug 2012 11:58:20 AM
VVM is a seperate installation - but is included as part of your IBM Administrator license.
It will allow you to model a web service that returns your live stock value feed.
Once modeled you can expose the data as a 'Virtual Database' that you can model via FM.
Title: Re: Live stock value in Cognos10
Post by: Cognos8 on 16 Aug 2012 12:32:25 PM
thinking in another way also.. pls help if u have an idea..
is thr a way to bring RSS feed or RSS viewer in report studio as add on or HTML?

If i take any stock market website, should i able to find some java coding to include it in cognos? some codings are there but will it be helpful ?

Title: Re: Live stock value in Cognos10
Post by: hardstep on 16 Aug 2012 03:32:03 PM
RSS feed is just XML data - so long as you wrap this with appropriate HTML tags / scrip then yes !.