To run the datamart manually, you go to Services, Reports and to the left you see Datamart for version 2.10 or Analytic Datamart for version 2.11.
Click on it, and make the fields as you desire then period and run Dayo Sent from my BlackBerry® smartphone from Etisalat. Enjoy high speed mobile broadband on our easyblaze and plans for BlackBerry. Visit www.etisalat.com.ng for details. -----Original Message----- From: Orvalho Augusto <[email protected]> Date: Tue, 14 May 2013 09:44:10 To: Ocaya Stephen<[email protected]> Cc: Dayo Adeyomoye<[email protected]>; Dhis2-users<[email protected]>; dhis1-users<[email protected]>; DHIS 2 developers<[email protected]> Subject: Re: [Dhis2-users] Troubles running datamart Thank you! The dataset report does not bring any data that I see on dataentry. For other reports the fields are numeric. For the datamart. Pardon my ignorance. How do I run it mannualy? Orvalho On Tue, May 14, 2013 at 9:36 AM, Ocaya Stephen <[email protected]> wrote: > What are the properties of the Fields for the Data Elements used for > reporting? > > Could you try manually generating the datamart and send us the complete > LOG from where the error start upto where you can see Caused by: .... > > That kind of gives a clear picture of what is causing the problem > Waiting ... > > > > > On Tue, May 14, 2013 at 10:33 AM, Orvalho Augusto <[email protected]>wrote: > >> Dears! >> >> Thank you for the answers. >> >> I have no text on value field according to this >> >> dhis2=# select * from datavalue where value is NULL; >> dataelementid | periodid | sourceid | categoryoptioncomboid | value | >> storedby | lastupdated | comment | followup >> >> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >> (0 rows) >> >> dhis2=# select * from datavalue where trim(value) = ''; >> dataelementid | periodid | sourceid | categoryoptioncomboid | value | >> storedby | lastupdated | comment | followup >> >> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >> (0 rows) >> >> dhis2=# select * from datavalue where trim(value) ~ '[A-Za-z]'; >> dataelementid | periodid | sourceid | categoryoptioncomboid | value | >> storedby | lastupdated | comment | followup >> >> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >> (0 rows) >> >> dhis2=# select * from datavalue where trim(value) !~ '[0-9]'; >> dataelementid | periodid | sourceid | categoryoptioncomboid | value | >> storedby | lastupdated | comment | followup >> >> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >> (0 rows) >> >> Orvalho >> >> >> >> On Tue, May 14, 2013 at 9:30 AM, <[email protected]> wrote: >> >>> I think the value type for the data elements are not properly set >>> because if you set the value to be α number and an integer and also specify >>> to or not to allow zeros plus your validation rules then I don't think you >>> would these issues. >>> >>> The values are probably set to be text or so. >>> Sent from my BlackBerry(R) smartphone from Etisalat. Enjoy high speed >>> mobile broadband on our easyblaze and plans for BlackBerry. Visit >>> www.etisalat.com.ng for details. >>> >>> -----Original Message----- >>> From: Ocaya Stephen <[email protected]> >>> Sender: "Dhis2-users" >>> <[email protected]> >>> Date: Tue, 14 May 2013 10:22:45 >>> To: Orvalho Augusto<[email protected]> >>> Cc: dhis1-users<[email protected]>; DHIS 2 developers< >>> [email protected]> >>> Subject: Re: [Dhis2-users] Troubles running datamart >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> > > > -- > > *You can do anything, but not everything.* > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
