dhis2-devs team mailing list archive

[Beatrice Ngatia <bngatia@xxxxxxxxx>]

Hey Jason,

Absolutely wonderful too hearing from you again...How are you keeping?

Thanks for responding so promptly... We finally saw the light & now on
DHIS2:)

I logged onto the Online Kenya Database, and yes I had read through the
MydataMart connection process, I even tried it out some time last week, but
it was taking so so so long to export the data, over 3 hours and yet I had
a good & stable internet connection... or so I think....i eventually gave
up...

Whats the step by step process of using the Mydatamart tool & setting up
the ODBC connection if at all, so I can utilize the pivot tables data from
the Kenya Online database?

Do all the end users out there have to set up the ODBC connections to use
Pivot Tables or can this be automated for the web version?

Thanks a million,

Beatrice
On Sun, Jan 15, 2012 at 3: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
> >
>



-- 
Beatrice
+254 713 213 676
+254 736 148 115