dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Devs,
I am trying to get some data from the analytics API, but running into some
conceptual challenges I think. Here is the basic request

http://localhost:8080/dhis/api/analytics.xml?dimension=dx:EpkTS0PpUcd;ec2OE0NY0kp;YUQ5C7adVF4;JvQI5pknk5g;crfET066vWt;kOtCKrGhIgc;apH1D8RRoRW;hGYnVYquaaq;dS4aPkM4oPe;r4QXthzMIKe;cppU5xf9uaN;Ua5k0OjE08z;mytGJmQ1w9S;dZFsIFFpncs;e9ngG0Hydka;LamweRCLRCW;iFJ7wFgfrJB;nvWsTc2cwh8;RjZzPr2swK8;NrT7XMFRdqE;ePiFDUQ6buf;oq5ZbscH3wz;UXafjnLhfYt;jL5ybWARRzf;mcplaq7cMwz;zs6XMzE1OTv;LyCsXbryff3;XZ27rp4Q4i0;cfvFxYyATtu;F4srgCgdqRH;sYClaae1ZdS;S5fakEDQKLJ;ZadGDLyyu28;Onb0wiYGAit;a9ffeImRMo7;Ykkqv58aEfM;ilvdUOXLdsR;b3Ahd82CwKH;CGPjVxvQSVq;MqGmwTnyi7H;keuAhg8E1eK;AstyowWpwhp;w9x1oWNmve9;WhF6siECUP7;XQEuWn7ZFDE;KkYiGM7Exxr;WXMorZ4yKsi;UkFJsUrmmLZ;LM2SXCSqGoj;G5vOWCzuoz9;MTC3rfRrQnq;C6ajbjMlDA3;KGZR00ccKaz;J0CGjGCwW88;PbnCJTUFzIJ;QfksRSvzbBD;lGrPN3URJDL;Kac6byVa1Fk;FVY88gSfco1&dimension=pe:201407&filter=ou:LEVEL-5;s5DPBsdoE8b


So, basically, we have about 60 data elements, a single time period
(201407), for all level 5 orgunits (about 40,000 of them). None of the
orgunits at level 5 (except for 1) actually has any data. So, what comes
back from the analytics, when it works, is a huge map of orgunits, with of
course no data.

The SQL (not produced by DHIS2) which gives me what I want (SELECT
de,uidlevel5,monthly,value from analytics_2014\n            where de in
('EpkTS0PpUcd','ec2OE0NY0kp','YUQ5C7adVF4','JvQI5pknk5g','crfET066vWt','kOtCKrGhIgc','apH1D8RRoRW','hGYnVYquaaq','dS4aPkM4oPe','r4QXthzMIKe','cppU5xf9uaN','Ua5k0OjE08z','mytGJmQ1w9S','dZFsIFFpncs','e9ngG0Hydka','LamweRCLRCW','iFJ7wFgfrJB','nvWsTc2cwh8','RjZzPr2swK8','NrT7XMFRdqE','ePiFDUQ6buf','oq5ZbscH3wz','UXafjnLhfYt','jL5ybWARRzf','mcplaq7cMwz','zs6XMzE1OTv','LyCsXbryff3','XZ27rp4Q4i0','cfvFxYyATtu','F4srgCgdqRH','sYClaae1ZdS','S5fakEDQKLJ','ZadGDLyyu28','Onb0wiYGAit','a9ffeImRMo7','Ykkqv58aEfM','ilvdUOXLdsR','b3Ahd82CwKH','CGPjVxvQSVq','MqGmwTnyi7H','keuAhg8E1eK','AstyowWpwhp','w9x1oWNmve9','WhF6siECUP7','XQEuWn7ZFDE','KkYiGM7Exxr','WXMorZ4yKsi','UkFJsUrmmLZ','LM2SXCSqGoj','G5vOWCzuoz9','MTC3rfRrQnq','C6ajbjMlDA3','KGZR00ccKaz','J0CGjGCwW88','PbnCJTUFzIJ','QfksRSvzbBD','lGrPN3URJDL','Kac6byVa1Fk','FVY88gSfco1')
and monthly = '201407';)

returns of course data for only orguntis which actually have data.

Is there a similar method for the analytics, to return only data for where
it exists, but not to return the entire list of orgunits at level 5?

Regards,
Jason


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049