dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi,

I've discussed this with Lars a couple of times and there doesn't seem to be
an easy fix here. My fix for now is to use charts that require less
aggregation (e.g. reduce either period or orgunit dimension). Things like
national yearly charts are more or less useless in the dashboard at the
moment, but since it is a dashboard the latest month might be good enough
(you can use relative periods to get this).

Lars can add more detail, but what I understood is that since the charts are
generated off on-the-fly data sources using the aggregation service and not
pre-generated values in datamart there is no easy way to persist them
(basically that would be a data mart).

Having charts depend on data mart would make them faster to display on the
dashboard, but then you might run the risk of data not being available in
the datamart, which is why we moved many of the report tools from datamart
to aggregation service some time back. With a more automated and controlled
data mart (coming soon) this becomes a much more attractive option again.

This is part of a more general discussion on on-the-fly data processing
(aggregation service) vs. pre-processed data (data mart) for all our
reporting/presentation tools, and it relates to the type of system that is
deployed, e.g. online servers with many users vs. offline install. We have
talked about making it optional whether to use on-the-fly or datamart for
all report tools as part of a system setting. Going for datamart makes a lot
of sense in multiuser settings with lots of data requests and heavy data
processing needed. We are moving towards a better managed/controlled data
mart where we have scheduled exports that can make sure it is always up to
date (e.g. nightly builds), but still that does not mean instant as in going
directly from data entry to a report/chart.

Ola,


----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>


On 29 November 2010 09:29, Jason Pickering <jason.p.pickering@xxxxxxxxx>wrote:

> Created a blueprint here..
>
> https://blueprints.launchpad.net/dhis2/+spec/cached-dashboard-charts
>
>
>
> On Mon, Nov 29, 2010 at 9:03 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
> > Agree. We should rather add one or more "Refresh" buttons.
> >
> > Knut (from my phone)
> >
> > On Nov 29, 2010 6:17 AM, "Jason Pickering" <jason.p.pickering@xxxxxxxxx>
> > wrote:
> >
> > Not sure if this a bug or feature, but each time I access the
> > Dashboard in 2.0.5, charts that have been added to the dashboard seem
> > to be regenerated. The charts involve a fair a bit of aggregation, so
> > they take several seconds (minutes actually in one case) to generate.
> >
> > Is this the intended behaviour?
> >
> > I would think it would make more sense to use a pre-generated copy for
> > the dashboard?
> >
> >
> > Regards,
> > Jason
> >
> >
> > --
> > Jason P. Pickering
> > email: jason.p.pickering@xxxxxxxxx
> > tel:+260968395190
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>