Hi Jason, I checked the docs, it seems you can do this: ;-)
?skipMeta=true Lars On Nov 5, 2014 11:00 AM, "Jason Pickering" <[email protected]> wrote: > 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: [email protected] > tel:+46764147049 > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
