dhis2-users team mailing list archive

[Muhire Andrew <muhireandrew@xxxxxxxxx>]

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 <larshelge@xxxxxxxxx> 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    : dhis2-users@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-users
More help  : https://help.launchpad.net/ListHelp