dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

OK, so does this work on both databases (when connected to each on
seperately?) There is no need to reference the database itself (dhis2
or dhis2_znmay) when you are connected to the database itself.

 SELECT pivotsource_indicator_ou4.indicator,
 pivotsource_indicator_ou4.orgunit1, pivotsource_indicator_ou4.ou1,
 pivotsource_indicator_ou4.orgunit2, pivotsource_indicator_ou4.ou2,
 pivotsource_indicator_ou4.orgunit3, pivotsource_indicator_ou4.ou3,
 pivotsource_indicator_ou4.orgunit4, pivotsource_indicator_ou4.ou4,
 pivotsource_indicator_ou4.periodid,
 pivotsource_indicator_ou4.periodtype,
pivotsource_indicator_ou4.year, pivotsource_indicator_ou4.month,
 pivotsource_indicator_ou4.period, pivotsource_indicator_ou4.numxfactor,
 pivotsource_indicator_ou4.factor,
 pivotsource_indicator_ou4.numeratorvalue,
 pivotsource_indicator_ou4.denominatorvalue,
 pivotsource_indicator_ou4.annualized, pivotsource_indicator_ou4.level
 FROM public.pivotsource_indicator_ou4

If not, then it must be an issue with the DB. Otherwise, maybe it is
something with Excel. I do not have enough experience with 2007 to be
able to provide any intelligent response really, but I know with 2003
the ODBC connection had to be explicitly defined as part of the query.
Double check that.

Regards,
Jason