dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi Beatrice,
I think you might have selected too much data for download. If you are
downloading data for the Kenya orgunit you should not select facility as
the analysis level, it will be way too much to download. Try to use
district or county level instead. Or if you need facility level, first
select e.g. a district as your orgunit to narrow down the amount of data.
Also try just a few months as Jason suggests. If it doesn't work out there
is a great team of pivot and mydatamart experts at the HMIS division if you
are still in Nairobi.
Ola
On Jan 15, 2012 2:36 PM, "Jason Pickering" <jason.p.pickering@xxxxxxxxx>
wrote:

> Hi Beatrice,
>
> Nice to hear from you again. :)
>
> The better solution would be to use the MyDatamart tool described here
>
> http://dhis2.org/doc/snapshot/en/user/html/apb.html
>
>
> This tool will provide you with a normal pivot table, which can be
> manipulated as per normal by users.
>
>
> Best regards,
> Jason
>
>
> On Sun, Jan 15, 2012 at 2:27 PM, Beatrice Ngatia <bngatia@xxxxxxxxx>
> wrote:
> > Hi All,
> >
> > I am trying to use the DHIS2 Pivot Tables and encountering some
> challenges.
> >
> > The challenge lies with the End-Product i.e. the Excel sheet produced
> once I
> > follow the  "select Data > Pivot > Download to Excel" process.  While
> > I successfully select my pivoting parameters and the table produced on
> DHIS
> > seems excellent, My problem is that the resultant Pivot table (once I
> click
> > "download to Excel" exports each month to its own separate worksheet and
> not
> > onto one combined worksheet where I can then proceed to pivot the data as
> > desired.
> >
> > Is this the current set-up within DHIS2 or am I missing a step?
> >
> > It seems to make sense to me to have all the data exported into one
> > worksheet, and then pivoted by users as need be.
> >
> > Please Advise.
> >
> > Thanks,
> >
> > Beatrice
> >
> >
> >
> >
> > _______________________________________________
> > 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
> >
>
> _______________________________________________
> 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
>