Dear All users,
By the way, do you know myDataMart is still working or not?
Because i tried many time through DHIS2 documentation guide. do step by step how to use myDataMart. but i got blank database connection in excel…
Thank you.
CHANNARA
Hi Channara
Mydatamart is not being actively maintained currently and I don’t think has been tested against current dhis2 version. The current recommended way of getting data out of dhis2 is via the web based analytics api.
Regards
Bob
···
On 19 March 2014 09:29, channara rin rin.channara@gmail.com wrote:
Dear All users,
By the way, do you know myDataMart is still working or not?
Because i tried many time through DHIS2 documentation guide. do step by step how to use myDataMart. but i got blank database connection in excel…
Thank you.
CHANNARA
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Hi,
Just to add to what Bob writes:
To get an “ad-hoc” pivot table in Excel for offline data analysis you can do the following:
-
You go to Services->Pivot Table and select the data you need.
-
When you are happy with the table you go to Download and select Plain data source->Microsoft Excel.
That will give you an excel file that can easily be converted into a pivot table using the Pivot Table Wizard in Excel.
- In Excel 2007 you click on Insert->Pivot Table, let Excel auto-select all the data and then click OK.
Make sure to drop the “value” field in the Values/Data area, and then the other fields (dimensions) on either row, column, or filter areas.
Note that this works fine for one-off pivot tables, but is not a solution where you can update existing pivot tables in Excel against a DHIS 2 data source.
Ola
···
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
On 20 March 2014 10:42, Bob Jolliffe bobjolliffe@gmail.com wrote:
Hi Channara
Mydatamart is not being actively maintained currently and I don’t think has been tested against current dhis2 version. The current recommended way of getting data out of dhis2 is via the web based analytics api.
Regards
Bob
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
On 19 March 2014 09:29, channara rin rin.channara@gmail.com wrote:
Dear All users,
By the way, do you know myDataMart is still working or not?
Because i tried many time through DHIS2 documentation guide. do step by step how to use myDataMart. but i got blank database connection in excel…
Thank you.
CHANNARA
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp