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 <[email protected]>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 <[email protected]> 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:* [email protected][mailto: >> [email protected]] *On Behalf Of >> *Mark Spohr >> *Sent:* Tuesday, March 20, 2012 8:00 AM >> *To:* [email protected] >> *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 >> [email protected] >> +1 530 554 2230 >> >> ** >> ****** >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > -- Mark Spohr, MD [email protected] +1 530 554 2230
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
