dhis2-users team mailing list archive

Thread
Date

Problem with MyDataMart

To: <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: <duttas@xxxxxxxxxxxx>
Date: Mon, 29 Apr 2013 22:05:33 +0000
Accept-language: en-GB, en-US
Thread-index: Ac5FI/p2ptiB4BMDTXG6e6PmRY9YQQ==
Thread-topic: Problem with MyDataMart

Hi everyone,

I am having a slight problem importing the database values into mydatamart.

When I create the pivot table I want the values do not much up with the aggregated totals that are stored either in a dataset report or report table.

Here is the pivot table:

[cid:image002.png@01CE4581.A76E6250]

And here are the values from the dataset report:

[cid:image003.png@01CE4581.A76E6250]

I have tried updating the dmart file several times, however when I create the pivot tables my values are still not equal. I am interested in doing some things at the health facility level and find this a bit easier using the pivot tables, but until the values match up I am unable to do this. Any suggestions would be most helpful.

Thanks,
Nick












====================================================
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and  GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific.  However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.