dhis2-devs team mailing list archive

[Yusuph Kassim <yusuphk@xxxxxxxxx>]

this is the query that doesnt work
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 dhis2_znzmay.public.pivotsource_indicator_ou4 pivotsource_indicator_ou4

and this is the query that works

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 dhis2.public.pivotsource_indicator_ou4 pivotsource_indicator_ou4

On Tue, Sep 29, 2009 at 9:51 AM, Yusuph Kassim <yusuphk@xxxxxxxxx> wrote:

> Hello Jason,
> I did remove in the query but I am getting the same error.
>
> in short I am using the query in two connection, one connection to dhis2
> database and the next to dhis2_znzMay, the dhis2 works though all the
> properties are the same as those in the znzMay. and still getting the error.
>
> and yes I am using 2007
>
>
> On Tue, Sep 29, 2009 at 9:30 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> It appears that the name of the database in the dhis2_zmmay is showing
>> up in the Excel query.  This should not be necessary. You will need to
>> edit the query source directly in Excel, and remove that.
>>
>> It looks like you are using Office 2007? You can do this directly I
>> think, although I have not used Office2007 that much so I do not know
>> the exact procedure. Otherwise, on Office 2003, you can download
>> PivotPlayPlus add-in http://www.contextures.com/xlPivotPlayPLUS01.html
>>
>> Regards,
>> jason
>>
>
>
>
> --
> Yusuph Kassim Kulindwa,
> University of Dar Es Salaam,
> Department of Computer Science,
> System Developer/ Research Assistant.
>
> Cell: +255 713 535648
>



-- 
Yusuph Kassim Kulindwa,
University of Dar Es Salaam,
Department of Computer Science,
System Developer/ Research Assistant.

Cell: +255 713 535648