[Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Cintia Marisa
Hi all, I'm trying to build the reports without using the Report Tables tools. When i add new report on dhis it gives a chance to provide another data source different from the report tables ( If selecting no report table, the user is responsible for providing the data source table. ). I just

Re: [Dhis2-devs] weeks calculation

2009-05-13 Thread Bob Jolliffe
Hi 2009/5/12 Saptarshi Purkayastha sun...@gmail.com: 2009/5/12 Bob Jolliffe bobjolli...@gmail.com Hi Saptarshi 2009/5/12 Saptarshi Purkayastha sun...@gmail.com: Its bad to re-invent the wheel, but I think we just keep doing that all the time. The Java API has all these things

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Murodullo Latifov
Hi Cintia, From: Cintia Marisa cintia.ba...@gmail.com To: dhis2-devs@lists.launchpad.net Sent: Wednesday, May 13, 2009 9:22:14 AM Subject: [Dhis2-devs] Providing another source table for reports Hi all, I'm trying to build the reports without using the Report

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Ola Hodne Titlestad
Hi, When using standard reports (BIRT reports in DHIS 2) the only limitation is that you need to use the DHIS 2 database as your source, but within that database you can create BIRT datasets based on any table or view as you like. This is simply because DHIS replaces the database connection

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Ola Hodne Titlestad
HI Cintia, I reply to the list so that we can share this discussion with the rest of the community. The report table concept has been developed in an evolutionary way based on various requirements from different countries. We are happy to further extend it to meet your needs in Mozambique. I am

Re: [Dhis2-devs] weeks calculation

2009-05-13 Thread Murodullo Latifov
Hi, It worth looking if java uses DHIS locale or it uses system locale for Calendar. I think if java is not set to use any locale, it will turn to OS locale, if this is the case two machines running DHIS as server with different locales will end up with two different week calculations, if

[Dhis2-devs] [Bug 375989] [NEW] Aggregate periods not available in datamart or report tables

2009-05-13 Thread Ola Hodne Titlestad
Public bug reported: The system does not pre-generate periods, but instead creates them when they are needed to store a new value, either via data entry or data import. In a system where data is entered or imported monthly only, which is quite common, there would e.g. be no quarterly periods

[Dhis2-devs] DHIS 2 Questions

2009-05-13 Thread Paul Amendola
Hi All, I have three quick questions I'm hoping you could help with. The questions might seem very basic, but I would appreciate your help: * How do you populate the data after data entry into the pivot tables? Data that has been entered and then used in a chart is available in the

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Cintia Marisa
Hi, In attachment one of the reports I need to build, maybe it will help you guys to understand what i need. I used the query below to get the data that i needed. = select a.periodid, a.sourceid, b.week, b.YR , b.startdate,

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 286: Implemented exclusive group set structure resource table, will get the name orgunitgroupsetexclus...

2009-05-13 Thread noreply
revno: 286 committer: Lars Helge Oeverland larshe...@gmail.com branch nick: trunk timestamp: Wed 2009-05-13 17:51:02 +0200 message: Implemented exclusive group set structure resource table, will get the name

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Murodullo Latifov
Hi Caveman, In order to have BIRT do selection you need to add parameters in BIRT design. For this you have to do the following: In outline view of BIRT there is Report Parameters option, create your parameters here first. You can select combobox and use another Data Set to get data, like

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Ola Hodne Titlestad
Hi, The main challenge with designing such a report in BIRT is that you need to know which data element the values belong to as the design is not a straight forward table where you could list the data elements row by row. Normally I would not recommend BIRT at all for this report, but rather

Re: [Dhis2-devs] DHIS 2 Questions

2009-05-13 Thread Ola Hodne Titlestad
On Wed, May 13, 2009 at 4:29 PM, Paul Amendola paul.amend...@theirc.orgwrote: Hi All, Hi Paul, I have three quick questions I’m hoping you could help with. The questions might seem very basic, but I would appreciate your help: · How do you populate the data after data entry

Re: [Dhis2-devs] Providing another source table for reports

2009-05-13 Thread Orvalho Joaquim Augusto
Hi, Ola Hodne Titlestad wrote: Hi, The main challenge with designing such a report in BIRT is that you need to know which data element the values belong to as the design is not a straight forward table where you could list the data elements row by row. Yes you are right but that exercise

Re: [Dhis2-devs] DHIS 2 Questions

2009-05-13 Thread Paul Amendola
Hi Ola, Thank you for the help and the support. I went through the data mart and it worked great, thanks. Just a quick follow-up question, does the datamart need to be used for each individual user? For example, if I perform a datamart as the ‘admin’ is it possible for another user to see

Re: [Dhis2-devs] DHIS 2 Questions

2009-05-13 Thread Paul Amendola
Hi Ola, Great, I got it, and it worked perfectly. Thanks again Paul From: olati...@gmail.com [mailto:olati...@gmail.com] On Behalf Of Ola Hodne Titlestad Sent: Wednesday, May 13, 2009 4:41 PM To: Paul Amendola Cc: Ola Hodne Titlestad; dhis2-devs@lists.launchpad.net Subject: Re:

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 287: DHIS2 Geostat User Documentation added.

2009-05-13 Thread noreply
revno: 287 committer: Jan Henrik Overland janhenrik.overl...@gmail.com branch nick: trunk timestamp: Thu 2009-05-14 01:27:43 +0200 message: DHIS2 Geostat User Documentation added. added: docs/DHIS2 Geostat User Documentation.doc

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 288: Minor fix.

2009-05-13 Thread noreply
revno: 288 committer: Jan Henrik Overland janhenrik.overl...@gmail.com branch nick: trunk timestamp: Thu 2009-05-14 02:33:00 +0200 message: Minor fix. modified: gis/dhis-web-mapping/pom.xml === modified file

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 289: Minor documentation updates.

2009-05-13 Thread noreply
revno: 289 committer: Jan Henrik Overland janhenrik.overl...@gmail.com branch nick: trunk timestamp: Thu 2009-05-14 03:13:14 +0200 message: Minor documentation updates. modified: docs/DHIS2 Geostat User Documentation.doc docs/DHIS2