Thanks Lars,
Now pivot table is good enough to serve users. But for some specific program
requests, we use sqlviews.
I support the idea, in our settings we don't use Datamart.
On Wednesday, August 26, 2015 1:27 PM, Lars Helge Øverland
<[email protected]> wrote:
Hi,
we are thinking of removing the data mart functionality in DHIS 2. This refers
to the ability to populate the "aggregateddatavalue" and
"aggregatedindicatorvalue" tables with pre-aggregated data.
The data mart is no longer in use by DHIS 2. There might be third-party report
tools out there that connects directly to the data mart tables.
We recommend that you connect reporting tools to the analytics web api for the
sake of performance, accessibility and security. If you need to connect with
JDBC it is possible to create a SQL view to combine all analytics partitions
and perform aggregation using group by statements.
If we do not hear strong objections within a week we will remove data mart for
version 2.21.
regards,
Lars
--
Lars Helge Øverland
Lead developer, DHIS 2University of OsloSkype: larshelgeoverland
http://www.dhis2.org
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
