Hi Did it but still nothing on report. If this can help figure out what's going on: - In data administrator -- data browser, when selecting period daily, begin and end dates covering the entry periods, browse by __organization unit___ then selecting the root organization unit, I can see the values appearing on the result page - But when browsing by __data sets__, there is no result I note also that : when selecting organization unit in browser type, a contextual select menu for organization units appears; no contextual select menu for data sets appears when choosing to browse by data set. Is this normal ?
2013/12/8 Lars Helge Øverland <larshe...@gmail.com> > Hi there, > > go to data admin, resource tables and generate the resource tables there. > > Then run analytics again, and verify that the process completes > successfully. > > The first step happens automatically for scheduled analytics processes, > but not for ad-hoc. I think we could include a check in the first situation > and generate them if not existing at all. > > Lars > On Dec 7, 2013 2:47 PM, "Ilias Dine" <ilias.d...@gmail.com> wrote: > >> OK. >> Here is the result of the query to the database >> >> dhis2=> select dataelementid, periodid, sourceid, value from datavalue; >> >> dataelementid | periodid | sourceid | value >> ---------------+----------+----------+------- >> 49 | 51 | 48 | 1 >> 49 | 52 | 48 | 2 >> 49 | 53 | 48 | 5 >> (3 rows) >> >> The values correspond to what has been set with data entry. But they >> still don't appear in the dataset report... >> >> >> >> >> >> 2013/12/7 Knut Staring <knu...@gmail.com> >> >>> The data will be in datavalues >>> 7. des. 2013 14:02 skrev "Ilias Dine" <ilias.d...@gmail.com> følgende: >>> >>> Hi >>>> >>>> I'm testing DHIS2, the installation on ubuntu following the guide was >>>> ok. I then tried to add data elements and visualize them with the >>>> reports but couldn't get this work. I even tried to add one simple data >>>> element (named element A, value type: number, aggregation operator: sum >>>> - as default), then defined a data set (named collect, frequency: daily) >>>> and associated the data element A to it. An organization unit named root >>>> has been created and associated to this data set. Through the data entry >>>> form I added some values for 4 days. I can see them when selecting back >>>> the periods. But when I go to reports - dataset reports, there is no >>>> value linked to this data element A... >>>> >>>> I tried with several examples, this last one were the simplest, but I >>>> still can not get any value with the report tools. A look at the >>>> catalina.out log is showing me this line dealing with my report query: >>>> "nested exception in org.postgresql.util.PSQLException: ERROR: Relation >>>> "analytics_2013" doesn't exist" >>>> >>>> I've just run Analytics and datasmart -- start exporting, as suggested >>>> by Knut (thanks to him) but the situation is the same. I shall also mention >>>> that when doing a reporting rate summary, I'm getting correct rates >>>> corresponding to the number of data I added. >>>> >>>> I'm using version 2.13. Any idea of what is going wrong ? Where can I >>>> check in the postgresql database (which table to look in?) ? >>>> >>>> Thanks for the help. >>>> >>>> Regards >>>> Ilias >>>> >>> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
