Dashboard - frequently changing data

[tim.pigden@optrak.co.uk]

Is the Pentaho Dashboard an appropriate tool to display frequently changing data? We need a mechanism for a visible alert to changes in our underlying data. I can see that we can do this via scheduling some process and emailing alerts with report bursting, but many commercial dashboards have mechanisms for refreshing the picture the user has on his screen. In particular, bars need to go red if things are not going to plan. So is this something that can be achieved via the Pentaho dashboard and if so, any pointers as to which direction I might pursue?

I don't need true real-time - a 5 minute update frequency would be fine.

I am relatively new to any form of web programming so please forgive if the answer is obvious!

Tim Pigden

[PriyankaP]

Hi,

Has anyone found solution to this problem.. "Auto refreshing option for the dashboard objects after certain interval".

Im using community version, and my data keeps on changing..

Please post the solution in forums.

Thanks & Regards

:)

[pmalves]

Since 3.6 both CDF and pentaho Dashboard Designer have a refreshPeriod that does... just that. It's on the documentation and available to all components

[PriyankaP]

Since 3.6 both CDF and pentaho Dashboard Designer have a refreshPeriod that does... just that. It's on the documentation and available to all components

Hello Sir,

Thanks a lot for replying.

Please can you give the urls where I can find that documentation?
I have searched in CDF forums, Gallery and Faqs, but could not get any writeup on 'refreshPeriod'.

Also, in another case, I have 3 dashboards and I want to redirect to the second dashboard from the first one, automatically after 10 mins. Similarly after next 10mins, I want a redirect from second dashboard to the third one. And than from third to the first one.

It should appear like on a browser window, after 10mins the cycle of dashboards repeat.

In plain html we do this using meta tag (<meta http-equiv="refresh" content="2;url=http://webdesign.about.com/">).
Is this possible in CDF? If yes, please let me know how to achieve this.

I am using Pentaho Community Edition, on my Windows machine with mysql.

Thanks & Regards

:)

[PriyankaP]

Hi,

Just as an elaboration, I got how I can change the reports automatically in the browser window.

I have my reports(firstprinter.prpt, secondprinter.prpt) in a folder called 'TEST' under my solution directory.

And I have added the following code in report.html file located at C:\PENTAHO\biserver-ce-3.5.0.stable\biserver-ce\pentaho-solutions\system\reporting\reportviewer

Code:

<META HTTP-EQUIV="REFRESH" CONTENT="30;url=http://localhost:8080/pentaho/content/reporting/reportviewer/printerrepor.html?
solution=TEST&
path=/work/reports/printer&
name=secondprinter.prpt&
paginate=false&
showParameters=false">

When I browse the url:
http://localhost:8080/pentaho/content/reporting/reportviewer/printerrepor.html?
solution=TEST&
path=/work/reports/printer&
name=firstprinter.prpt&
paginate=false&
showParameters=false

This automatically redirects me to the secondprinter.prpt report

Can we get similar working in dashboards?

Thanks & Regards

:)

[pmalves]

bi-developers/cdf/component-reference/...

just add to any component the property refreshPeriod:600 to have it updated every 10 minutes

[PriyankaP]

Hi,

I tried that.. but could not get it working.. dashboards do not refresh.. :confused:

Just want to confirm whether what I'm doing is write...

Here is my template.html code:

<div id="RegionsPieChartObject"></div>

<script language="javascript" type="text/javascript">

RegionsPieChart =
{
name: "RegionsPieChart",
type: "xaction",
solution: "TEST",
path: "research/charts/pentaho",
action: "RegionsPieChart.xaction",
listeners:[],
parameters: [],
htmlObject: "RegionsPieChartObject",
refreshPeriod:30,
executeAtStart: true
}
var components = [RegionsPieChart, RegionVarianceBarChart];

function load(){
Dashboards.init(components);
}

load();

</script>

I have set 30secs as refresh period. Is this correct?
If yes, it does not work for me.. please help..

Thanks & Regards

:)

[pmalves]

are we talking about cdf 3.6? (the one that comes with pentaho 3.6). Cause it's only on that version (and greater)

[PriyankaP]

are we talking about cdf 3.6? (the one that comes with pentaho 3.6). Cause it's only on that version (and greater)


Hey Hi,

Thanks a lot.. that worked.. I was using 3.5.. and now im using 3.6 stable version for cdf.. refreshing dashboards are working now..:)

Now, my next step is to have a cycle of dashboards.

As mentioned earlier, I have 3 dashboards and I want to redirect to the second dashboard from the first one, automatically after 10 mins. Similarly after next 10mins, I want a redirect from second dashboard to the third one. And than from third to the first one.

Is this possible? is there something like 'refreshurl' :confused:. That will allow me to specify where to redirect after the refresh period is completed???

please help...

Thanks & Regards

:)

[pmalves]

That seems a very weird use case. There's no direct way to do that, to do that you need to define your own component that will do that.

You can also use directly javascript's setTimeout

[PriyankaP]

That seems a very weird use case. There's no direct way to do that, to do that you need to define your own component that will do that.

You can also use directly javascript's setTimeout


Hi Pmalves,

Thank you very much.. that was a very good idea.. I got my use case working!!!

All I'm doing now is, just add the following code in my component, and it works... :)

postExecution: function(){setTimeout('location.replace(\'http://localhost:8080/pentaho/content/pentaho-cdf/RenderXCDF?solution=TEST&path=research/charts/barchart&action=barchart.xcdf&template=mantle\')', 10000)}

This redirects the first dashboard to the second one after a period of 10secs.

Thanks & Regards

:)

[Bolek]

I assume if the dashboard component is MDX based then the Mondrian Cache would have to cleared in between the refresh period in order for the data to be affected when the refresh cycle happens ? Or does the refreshPeriod setting automatically not use cached results ?

Thanks.

[pmalves]

for this link of data updates I think standard sql does much more sense. And no, refresh period doesn't clean cache, just updates the component automatically

[PriyankaP]

Hi,

I have used sql component for that, so my changed data is reflected easily...

Thanks & Regards

:)