dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #03478
Re: Testing DHIS2 - Problem while retrieving data
Do your data show up in GIS, PIvot Tables or Data Visualizer?
On Sun, Dec 8, 2013 at 7:00 PM, Ilias Dine <ilias.dine@xxxxxxxxx> wrote:
> 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 <larshelge@xxxxxxxxx>
>
>> 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.dine@xxxxxxxxx> 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 <knutst@xxxxxxxxx>
>>>
>>>> The data will be in datavalues
>>>> 7. des. 2013 14:02 skrev "Ilias Dine" <ilias.dine@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help : https://help.launchpad.net/ListHelp
>>>
>>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp
>
>
--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
Follow ups
References