Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-14 Thread Jason Pickering
Hi Lars, Thanks for the answer. I suppose this is really something I never noticed. We have had data for a long time in the system for legacy data elements which was collected on a quarterly basis, and then later on on a monthly basis. It seemed to work fine, but this could have just been a fluke.

Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-14 Thread Lars Helge Ă˜verland
Hi Jason On Sat, May 11, 2013 at 8:16 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Lars, > This has never been an issue before. It has only recently ( I think in > 2.11) been noticed. Perhaps it has just gone undetected until now. > > I guess what is really puzzling is that it

Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-11 Thread Jason Pickering
Hi Lars, This has never been an issue before. It has only recently ( I think in 2.11) been noticed. Perhaps it has just gone undetected until now. I guess what is really puzzling is that it "seems" work fine for the new PivotTables. Anything which depends on the datamart does not work, so the logi

Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-11 Thread Lars Helge Ă˜verland
Hi Jason, the issue here is that "dis-aggregation" of data elements is not allowed. So for a "monthly" data element, weekly or daily data is ignored (data with higher frequency). The frequency/period type of a data element is derived from the period type of the data sets which it is assigned to.

Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-11 Thread Jason Pickering
OK, so let me get this straight. Lets say I have a data element which belongs to a weekly and to a monthly dataset. Some orgunits report it weekly, others monthly. This is what is happening here in Zambia. Which one wins? The weekly or the monthly? It would seem that we would need to aggregate al

Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-11 Thread Ola Hodne Titlestad
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 data

Re: [Dhis2-devs] Puzzling problem with datamart

2013-05-11 Thread Ola Hodne Titlestad
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 elemen

[Dhis2-devs] Puzzling problem with datamart

2013-05-09 Thread Jason Pickering
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.