PivotTable Using MyDatamart

Hi John, a bit update, and bob and zeferino, maybe better include the
DHIS users group everytime discussing things of general interest.


---------- Forwarded message ----------
From: Bob Jolliffe <bobjolliffe@gmail.com>
Date: 2011/7/28
Subject: Re: PivotTable Using MyDatamart
To: Zeferino Saugene <zsaugene@gmail.com>
Cc: Jørn Braa <jornbraa@gmail.com>, Ola Hodne Titlestad
<olatitle@gmail.com>, Lars Helge Øverland <larshelge@gmail.com>

On 28 July 2011 14:35, Zeferino Saugene <zsaugene@gmail.com> wrote:

Hi Bob,
This is my first time using this feature. I was first exposed during the
implementer workshop held in Dar-es-Salaam in June this year. To setup I
have tried to follow the manual available at
In the manual is not mentioned the link with the datamart feature in dhis2.
So i dont know what you mean by updating the datamart on dhis2. If it means
rebuilding the data mart index i have done BUT if it means creating a
datamart export file i did not.

OK that is a fair point you make. We should update the manual to
indicate this - thank you for the feedback. To be clear, all the
mydatamart tool does is synch data from the datamart on dhis2. So if
no data has been exported to the datamart then you will receive no
data locally. Please do a datamart export on dhis, try again and let
me know.

One of the reasons this has been overlooked in the manual is that the
mydatamart tool was first developed and tested in Kenya, where the
generation of datamart on dhis2 has been automated.



On Thu, Jul 28, 2011 at 3:05 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Hi Zeferino

It looks from the second screenshot that no values were downloaded
(counts are all zero). Have you updated the datamart on dhis2?


On 28 July 2011 13:31, Jørn Braa <jornbraa@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Zeferino Saugene <zsaugene@gmail.com>
> Date: 2011/7/28
> Subject: PivotTable Using MyDatamart
> To: "Edem K. KOSSI" <ekossi@gmail.com>, Ola Hodne Titlestad
> <olatitle@gmail.com>, Lars Helge Øverland <larshelge@gmail.com>
> Cc: Jørn Braa <jornbraa@gmail.com>, Sundeep Sahay
> <sundeep.sahay@yahoo.com>
> Hi,
> Hope you are all doing well.
> I am trying to setup a pivot table using mydatamart but it doesn't
> bring the data in excel.
> I don't know what is happening.
> You can take a look the attached file to see some of the screen-shots.
> Regards,
> ZSaugene