dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Just to clarify:
You'll get many aggregated period types in the datamart of course, but only
one period type per data element can be used when looking/searching for raw
data values to put into aggregation calculations during datamart export.

So your monthly data values might be ignored in the datamart export process
if quarterly data values exist for the same data elements. And we use the
dataset period type to know what data values to look for. At least that's
how I've understood this.

Lars, correct me if this is wrong.

Ola
------
On 11 May 2013 09:10, "Ola Hodne Titlestad" <olati@xxxxxxxxxx> wrote:

> Hi Jason,
>
> Are these data elements (with missing monthly vslues in datamart) also
> part of another dataset with e.g. quarterly collection frequency (period
> type)?
>
> Only one period type per data element is supported in datamart and this is
> derived from the dataset's period type. So if the data element is member of
> two data sets with different period types you will only get one of these
> period types in the datamart.
>
> Ola
> ------
> On 9 May 2013 18:02, "Jason Pickering" <jason.p.pickering@xxxxxxxxx>
> wrote:
>
>> Hi devs,
>> I am having some issues with some data elements not appearing in the data
>> visualizer (and other modules which depend on datamart). Using the latest
>> 2.11 file.
>>
>> I get expected results from the analytics pivot tables, but nothing for
>> the "Past twelve months" as a relative period in the DV.
>>
>> Looked at the aggregateddata value table where this should appear, and
>> see a some periods, but no monthly values (this is how the data is
>> collected, by month).
>>
>> SELECT startdate from period where periodid in (SELECT DISTINCT periodid
>> from aggregateddatavalue where dataelementid = 80);
>>  startdate  |  enddate
>> ------------+------------
>>  2012-01-01 | 2012-12-31
>>  2012-01-01 | 2012-03-31
>>  2012-01-01 | 2012-06-30
>>  2012-04-01 | 2012-06-30
>>  2012-07-01 | 2012-09-30
>>  2012-07-01 | 2012-12-31
>>  2012-10-01 | 2012-12-31
>>  2013-01-01 | 2013-06-30
>>  2013-01-01 | 2013-03-31
>>  2013-01-01 | 2013-12-31
>> (10 rows)
>>
>> Looking at the data values table, just to be sure.
>>
>> SELECT startdate,enddate from period where periodid in (SELECT DISTINCT
>> periodid from datavalue where dataelementid = 80) ORDER BY startdate DESC;
>>
>> startdate  |  enddate
>> ------------+------------
>>  2013-03-01 | 2013-03-31
>>  2013-02-01 | 2013-02-28
>>  2013-01-01 | 2013-01-31
>>  2012-12-01 | 2012-12-31
>>  2012-11-01 | 2012-11-30
>>  2012-10-01 | 2012-10-31
>>  2012-09-01 | 2012-09-30
>>  2012-08-01 | 2012-08-31
>>  2012-07-01 | 2012-07-31
>>  2012-06-01 | 2012-06-30
>>  2012-05-01 | 2012-05-31
>>  2012-04-01 | 2012-04-30
>>  2012-03-01 | 2012-03-31
>>  2012-02-01 | 2012-02-29
>>  2012-01-01 | 2012-01-31
>>  2011-12-01 | 2011-12-31
>>  2011-11-01 | 2011-11-30
>> :
>> So, the raw data appears to be there.
>>
>> I see no obvious errors in the logs. I did check the "Monthly" option for
>> the data mart.
>>
>> I find this really strange. Any ideas what may be going on? For other
>> data elements collected in the same form, I do get monthly values.
>>
>> Regards,
>> Jason
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>