Information détail on Organisation unit

Guy_Martial_EKANI_ND · 5 January 2015 16:01

Hello everyone,

I would like to know if it’s possible besides of Organisation Unit Group Set, to add additional information détail (Town, PO box) to an organisation unit?

And how can i have a report with of all organisation unit and all these information listed (Ownership, Type, region, district, Name, Gps, Contact person, telephone, Email) ?

Sincerely,

Version:
2.16
Build revision:
16262

···

=========================
EKANI Guy

Cameroon

riddy_ndoma · 5 January 2015 16:18

Hi Guy,
You can add them as “Attribute”. Go to Apps>data Administration> Attribut

To view the organizational units uses the SQL Query

regards,

···

2015-01-05 17:01 GMT+01:00 Guy Ekani constyekani@yahoo.fr:

Hello everyone,

I would like to know if it’s possible besides of Organisation Unit Group Set, to add additional information détail (Town, PO box) to an organisation unit?

And how can i have a report with of all organisation unit and all these information listed (Ownership, Type, region, district, Name, Gps, Contact person, telephone, Email) ?

Sincerely,

Version:
2.16
Build revision:
16262

EKANI Guy

Cameroon

=========================

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Riddy NDOMA

Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/
Vous servir est mon désire (Serving you is my desire)

Guy_Martial_EKANI_ND · 5 January 2015 16:33

Thank u very much Riddy, i did it on https://apps.dhis2.org/demo/

Now where do i use SQL Query?

Hi Guy,
You can add them as “Attribute”. Go to Apps>data Administration> Attribut

To view the organizational units uses the SQL Query

regards,

···

Le Lundi 5 janvier 2015 17h18, riddy ndoma riddyndoma@gmail.com a écrit :

2015-01-05 17:01 GMT+01:00 Guy Ekani constyekani@yahoo.fr:

Hello everyone,

I would like to know if it’s possible besides of Organisation Unit Group Set, to add additional information détail (Town, PO box) to an organisation unit?

And how can i have a report with of all organisation unit and all these information listed (Ownership, Type, region, district, Name, Gps, Contact person, telephone, Email) ?

Sincerely,

Version:
2.16
Build revision:
16262

=========================
EKANI Guy

Cameroon

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Riddy NDOMA

Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/
Vous servir est mon désire (Serving you is my desire)

olatitle · 6 January 2015 08:26

Hi Guy,

In addition to the attributes feature you can also add groups to orgunits. Groups can be further organised in group sets which can be used as dimensions in the analytics tools like Pivot Tables and Data Visualizer. The attributes are typically used for more free text descriptions like Address, P.O. Box etc. , information that does not aggregate well.

As Riddy mentioned you will need to create more custom type reports to get the attribute information, e.g. using HTML reports and the Web-API.

You can also try sql view (in Data Administration) to quickly see orgunits and related attribute values joined.

More documentation here:

Orgunits and groups/group sets:

https://www.dhis2.org/doc/snapshot/en/user/html/ch04.html

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch10s02.html

Attributes:

https://www.dhis2.org/doc/snapshot/en/user/html/ch21s15.html

SQL view:

https://www.dhis2.org/doc/snapshot/en/user/html/ch21s06.html

HTML reports:

https://www.dhis2.org/doc/snapshot/en/developer/html/ch03s04.html#d5e4986

On the online demo you can view examples of all of this, inluding SQl views and HMTL reports.

https://apps.dhis2.org/demo/dhis-web-reporting/displayViewReportForm.action

https://apps.dhis2.org/demo/dhis-web-maintenance-dataadmin/sqlView.action

Ola

···

On 5 January 2015 at 17:18, riddy ndoma riddyndoma@gmail.com wrote:

Hi Guy,
You can add them as “Attribute”. Go to Apps>data Administration> Attribut

To view the organizational units uses the SQL Query

regards,

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

2015-01-05 17:01 GMT+01:00 Guy Ekani constyekani@yahoo.fr:

Hello everyone,

I would like to know if it’s possible besides of Organisation Unit Group Set, to add additional information détail (Town, PO box) to an organisation unit?

And how can i have a report with of all organisation unit and all these information listed (Ownership, Type, region, district, Name, Gps, Contact person, telephone, Email) ?

Sincerely,

Version:
2.16
Build revision:
16262

EKANI Guy

Cameroon

=========================

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Riddy NDOMA

Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/
Vous servir est mon désire (Serving you is my desire)

–

Guy_Martial_EKANI_ND · 6 January 2015 09:27

I’m really grateful to you for this recap of these reporting features, i think it will help all of us.

But it’s not easy, for non IT people to get it.

···

=========================

Le Mardi 6 janvier 2015 9h26, Ola Hodne Titlestad olati@ifi.uio.no a écrit :

Hi Guy,

In addition to the attributes feature you can also add groups to orgunits. Groups can be further organised in group sets which can be used as dimensions in the analytics tools like Pivot Tables and Data Visualizer. The attributes are typically used for more free text descriptions like Address, P.O. Box etc. , information that does not aggregate well.

As Riddy mentioned you will need to create more custom type reports to get the attribute information, e.g. using HTML reports and the Web-API.

You can also try sql view (in Data Administration) to quickly see orgunits and related attribute values joined.