dhis2-devs team mailing list archive

[Mark Spohr <mhspohr@xxxxxxxxx>]

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