← Back to team overview

dhis2-devs team mailing list archive

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

 

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
>
>

Follow ups