dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

On Mon, Jun 1, 2009 at 5:15 AM, Orvalho Joaquim Augusto
<orvaquim@xxxxxxxxx>wrote:

> We are recovering data from a system not related to dhis and we want to put
> such information on dhis.
>
> The problem is some part of that information has data from level 4, some on
> level 3 and other only from level 2.
>
> How do I place all these data on dhis2? On datavalue?
>
> Thanks
> Caveman
>
>
Hi Orvalho,

DHIS2 supports data entry/registration at any orgunit level, and in data
value there is no reference to the orgunit level, just the orgunit (source)
which means notting is stopping you from importing data to orgunits at
different levels.
Of course you need to make sure your data are consistent and that there are
no duplication. E.g. if you import data for province A then you would not
want to import the same data (data element + period) for Districts AA and AB
which are orgunit children of Province A, unless you specifically want to
add these together.

When using data in reports you should always use the datamart service, and
there you can query data by orgunit level. The datamart process will then
aggregate together all values from a specific orgunit and all its children
for a given data element/indicator and period. So e.g. if you import data
for orgunit level 2,3,4 into data value manually, you can later create
reports for orgunit level 2 with all the data for ou level 2,3,4 aggregated
together if you use the datamart service.

The datavalue object/table is for storing raw data and the datamart (incl
report tables) is for creating any kind of output and therefore supports
aggregated data, indicator data and more.

Creating ouput directly from the data value table is not recomnmended.

Ola
---------