← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Reports - where's the data?

 

That's great.
Mydatamart is a tool that allows the users to have local copies of the
server's datamart with all the relevant local data stored on the user's
machine. This data can then be used in offline data analysis tools like the
Exel PivotTable.
Ola
On Mar 21, 2012 12:06 AM, "Mark Spohr" <mhspohr@xxxxxxxxx> wrote:

> We've got data!!
>
> Thanks everyone for your help.  I was confused and thought the Datamart
> utility was for the external program MyDatamart.  I ran it and now my
> reports have actual data in them.  This is a big improvement.  I've set up
> scheduling to keep it up to date.
>
> I also love the Data Visualizer... quite posh!
>
> Thanks again,
> Mark
>
> On Tue, Mar 20, 2012 at 3:02 AM, Ola Hodne Titlestad <olati@xxxxxxxxxx>wrote:
>
>> HI Mark,
>>
>> (copying dev list also since many people ask about this)
>>
>> Here are datamart instructions for version 2.7:
>>
>> *Automatic datamart:*
>> (2.6 and 2.7)
>> For servers we recommend you use the automatic scheduled datamart (runs
>> at midnight every day).
>> This can be configured in Data Administration-Scheduling. (see user
>> manual section 19.19)
>> It is correctly set up when it says "Scheduling is running" - which means
>> that DHIS is scheduled to run a datamart export the next (and every)
>> midnight. No need to click on Execute now (that starts the datamart process
>> immediately, but this is sometimes needed as well)
>> Note that this scheduled datamart will export maximum data for 12 months
>> back in time, (but will not delete older data). If you have an empty
>> datamart and have data older than 12 months you should use the manual
>> approach (see below) for those months that are older than 1 year.
>> How fast this scheduled datamart export process is will really depend on
>> your CPU and Memory, but it will most likely take a while. In the tomcat
>> log you can follow progress and CPU and memory use etc.
>>
>> *Manual datamart:*
>> (this is or 2.7)
>> If you need to do manual datamart exports these are now possible from
>> Reports->Datamart, but this is more simple now, it takes all data within
>> the period you specify. This has been made much easier now.
>> (see section 13.2.1 in the user manual, it has been updated to this new
>> datamart window).
>>
>> (2.6)
>> A bit more complicated UI for datamart export accessed under
>> Services->Datamart
>> Here you can select exactly what you want to export. Note that this
>> export (2.6 and earlier) does not rebuild indexes on the datamart tables.
>> After an export, go to Maintenance->Data Administration->Maintenance: and
>> tick Rebuild datamart indexes. Without that last step the reports will be a
>> lot slower, especially on a multi-user environment.
>>
>> Ola
>> -------
>>
>> ----------------------------------
>> Ola Hodne Titlestad (Mr)
>> HISP
>> Department of Informatics
>> University of Oslo
>>
>> Mobile: +47 48069736
>> Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>>
>>
>> On 20 March 2012 09:49, Shinichi Suzuki <shin461@xxxxxxxxx> wrote:
>>
>>> Report data will generate from entered data by nightly batch job,
>>> usually.****
>>>
>>> You must go to data administration module, then "Scheduling". It should
>>> be on automatically. But it might run out of memory as it uses a lot of
>>> resources.****
>>>
>>> Please try this.****
>>>
>>>              Suzuki****
>>>
>>> *From:* dhis2-users-bounces+shin461=gmail.com@xxxxxxxxxxxxxxxxxxx[mailto:
>>> dhis2-users-bounces+shin461=gmail.com@xxxxxxxxxxxxxxxxxxx] *On Behalf
>>> Of *Mark Spohr
>>> *Sent:* Tuesday, March 20, 2012 8:00 AM
>>> *To:* dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> *Subject:* [Dhis2-users] Reports - where's the data?****
>>>
>>> ** **
>>>
>>> Ok, I'm feeling quite stupid here.
>>> We've been entering monthly data for 2011 with a form and we can view
>>> this using the "Dataset" report and it aggregates for province and for
>>> quarters and years.
>>> Now, I want to put together some reports.
>>> I try the Standard report... this requires a Table.
>>> I put together a Table report and run it... nice table with data
>>> elements, org units and periods... but no data! (blank, nada).
>>> I look at the web Pivot tables and run a few... nice pivot tables, rows,
>>> columns, periods... no data!... blanks... not even a single number anywhere!
>>>
>>> What am I missing here?
>>>
>>> .Mark
>>>
>>>
>>> --
>>> Mark Spohr, MD
>>> mhspohr@xxxxxxxxx
>>> +1 530 554 2230
>>>
>>> **
>>> ******
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
>
> --
> Mark Spohr, MD
> mhspohr@xxxxxxxxx
> +1 530 554 2230
>
>
>
>

Follow ups

References