dhis2-users team mailing list archive

[Kabango Malewezi <kmalewezi@xxxxxxxxxxx>]

Thank u so much. I'll come back to u.
Sent from my BlackBerry® smartphone
________________________________
From: Jason Pickering <jason.p.pickering@xxxxxxxxx>
Date: Fri, 20 Jul 2012 12:33:55 -0400
To: Ola Hodne Titlestad<olati@xxxxxxxxxx>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx<dhis2-users@xxxxxxxxxxxxxxxxxxx>; Kabango Malewezi<kmalewezi@xxxxxxxxxxx>
Subject: Re: [Dhis2-users] Datamart


It is possible actually using custom SQL. We have developed such views for MyDatamart in Zambia. The general approach we used is to use UNION statements to bring data elements and indicators together into a single view. If you need more specifics, let me know.

--
Sent from my mobile

On Jul 20, 2012 7:04 AM, "Ola Hodne Titlestad" <olati@xxxxxxxxxx<mailto:olati@xxxxxxxxxx>> wrote:

Hi Kabango,

That is not possible.

You can do it with report tables and standard reports.

Ola
-------

On Jul 20, 2012 10:49 AM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx>> wrote:
Gentle People,



I'd like to have Elements and indicators in one excel pivot table. How do I do that? The available views I have have either Pivot_Indicator or Pivot_Routinedata.



Kabango Malewezi

SSDI Services

2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410<tel:%2B265%20%2801%29%20776%20410> | Mobile: +265 (0) 88 4 245 431<tel:%2B265%20%280%29%2088%204%20245%20431>

kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx> <mailto:kmalewezi@xxxxxxxxxxx<mailto:kmalewezi@xxxxxxxxxxx> > |  www.jhpiego.org<http://www.jhpiego.org><http://www.jhpiego.org/>

Skype: kabango.malewezi | Twitter: kabangoM

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp