Author Topic: Real-Time Dashboard  (Read 691 times)

Offline superman99

  • Full Member
  • ***
  • Join Date: Nov 2013
  • Posts: 23
  • Forum Citizenship: +0/-0
Real-Time Dashboard
« on: 02 Jun 2016 10:38:29 am »
Hello Gurus,

I have a requirement for a real-time dashboard using Cognos Analytics. I would like to know the approach from someone who has already implemented this type of solution.


Thanks in advance!!

Offline BigChris

  • Statesman
  • ******
  • Join Date: Apr 2013
  • Posts: 1,004
  • Forum Citizenship: +77/-0
Re: Real-Time Dashboard
« Reply #1 on: 10 Nov 2016 04:18:07 am »
Do you need something as simple as an HTML tag in each element of the dashboard to refresh the data at the required frequency?

Offline psten

  • Full Member
  • ***
  • Join Date: Feb 2014
  • Posts: 15
  • Forum Citizenship: +0/-0
Re: Real-Time Dashboard
« Reply #2 on: 11 Nov 2016 03:05:52 am »
Elements in the dashboard can be updated as frequent as every 5 second from version 11.0.4.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,523
  • Forum Citizenship: +573/-9
  • Cognos Software Muppet
Re: Real-Time Dashboard
« Reply #3 on: 11 Nov 2016 03:07:13 am »
Hello Gurus,

I have a requirement for a real-time dashboard using Cognos Analytics. I would like to know the approach from someone who has already implemented this type of solution.


Thanks in advance!!

In release 4, IBM implemented an auto-refresh property for each widget. Make sure you are in edit mode within the dashboard, select your widget, and open the Properties pane. On the Visualization Details tab you will see a "Refresh automatically" option, with a refresh frequency below it.

Cheers!

MF.
Meep!

Offline superman99

  • Full Member
  • ***
  • Join Date: Nov 2013
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Real-Time Dashboard
« Reply #4 on: 13 Nov 2016 12:48:09 pm »
Thanks everyone for your response.

What am I looking is the real-time solution? I understand that Cognos 11.0.4 has an option to update every 5 second and so one, but I am looking for is the backend, for example, the DWH can not be refreshed every 5 seconds/minutes depending on the data. If I have a huge dataset then it will not be possible to refresh the entire DWH. What backend solution are out there to overcome real-time reporting.
Is it only possible to have real-time reporting when connected to an OLTP?
What are the options for a real-time reporting when connected to a DWH?
Appreciate your feedback!!

Offline johnwilkinson

  • Full Member
  • ***
  • Join Date: Jan 2007
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: Real-Time Dashboard
« Reply #5 on: 14 Nov 2016 12:23:33 am »
IBM provide a product called "RTM" (Real time monitoring) that is designed to do exactly what you describe. It is built from the components of the "Cognos Now" appliance solution that Cognos bought and abandoned some years ago.

Last time I looked at RTM, it was a bit buggy, but that was 3 or 4 years ago. It's certainly worth looking at, but I don't think it's cheap!

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,738
  • Forum Citizenship: +101/-0
Re: Real-Time Dashboard
« Reply #6 on: 14 Nov 2016 09:37:53 am »
I think what you are looking is what is often called "change data capture". There are products to do this, but I hope you (or your client) has plenty of money to spend, because it won't be cheap - at least a few hundred thousand dollars.

Products you can look at:
* IBM Infosphere CDC
* Oracle GoldenGate (or maybe XStreams)
* SQL Server - has some built-in but you'll need to roll up your sleeves. 3rd-party products may be warranted.

There are a number of 3rd party products, google CDC or "change data capture".

I participated in a project for implementation of the IBM product. It did work, but was problematic to resync if a database went down. At least, that is what the DBA told me. Otherwise, no real problems. What you do with the changes you get will be up to you. So for example, if you have currently have transformations in your ETL stream, you may need to re-architect or refactor components so they can be called upon to do incremental updates. This can be very minor or a project itself, depending on your warehouse and ETL. If you lack experienced ETL staff, you may want to bring in some consultants to help.

Offline superman99

  • Full Member
  • ***
  • Join Date: Nov 2013
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Real-Time Dashboard
« Reply #7 on: 19 Nov 2016 04:15:56 am »
Thanks bdbits!!

I will look into CDC.

 



           
Twittear