change your cube

[Fabio D'Ovidio]

I am not able to read XMLA from my new cube definition on different
database respect to dhis2.
From debug I can read that the problem is in executeMDXquery() and
executeXMLAquery();
It seems that XMLA isn't read from OH.....
My new cube definition is:
<Cube name="cubo2">
<Table name="fabiocube" />

<Dimension name="Provincia" foreignKey="ktc">

<Hierarchy hasAll="false" primaryKey="id_distributore">
<Table name="distributori"/>
<Level name="Provincia" uniqueMembers="true"
captionColumn="provincia_res" column="provincia_res" type="String" />
<Level name="Comune" uniqueMembers="true"
captionColumn="comune_res" column="comune_res" type="String" />
</Hierarchy>
</Dimension>

<Measure name="Prenotazioni" aggregator="count" column="id"
datatype="Numeric" />

</Cube>

any help for this ?

[Jiri Dvorak]

Resending (after e-mail glitch).

- Jiri
----------------------------------------------------------------
Jiri Dvorak, T4Bi (www.t4bi.com), cell +1.604.220.0529
#1010-1177 West Hastings Street, Vancouver, BC V6E2K3, Canada


-----Original Message-----
From: Jiri Dvorak [mailto:Jiri....@t4bi.com]
Sent: Thursday, November 13, 2008 9:52 AM
To: 'openh...@googlegroups.com'
Subject: RE: change your cube

This is using the OpenHealthFP code, or the WHOSIS code, on the server?

- Jiri
----------------------------------------------------------------
Jiri Dvorak, T4Bi (www.t4bi.com), cell +1.604.220.0529
#1010-1177 West Hastings Street, Vancouver, BC V6E2K3, Canada

[Knut Staring]

On Thu, Nov 13, 2008 at 7:58 PM, Jiri Dvorak <Jiri....@t4bi.com> wrote:

-----Original Message-----
From: Jiri Dvorak [mailto:Jiri....@t4bi.com]
Sent: Thursday, November 13, 2008 9:52 AM
To: 'openh...@googlegroups.com'
Subject: RE: change your cube

This is using the OpenHealthFP code, or the WHOSIS code, on the server?

It is from the older OpenHealth-fp code. 

What was the name of the Subversion provider you recommended?

Knut

--
Cheers,
Knut Staring

[Knut Staring]

Some more background info to get everyone up to speed:

The code that is available in the current Subversion repo at www.hisp.info/openhealth is the "old" functional prototype (OH-FP) code, both server and client. Some limited improvements have been made by the Oslo team on this code (mostly bugfixing).

There has since been significant work carried out by T4Bi on both the server (OLAP) side, and on a FLEX client for the WHO statistical information system:

http://www.who.int/whosis/data/Search.jsp?indicators=[Indicator].Members

That code has so far not been made available on Subversion, but that can hopefully be taken care of soon, especially as regards the server code. 

On the GIS client side, there is concensus that the current Ext.js + OpenLayers client is not very functional, and is also quite slow. We would therefore have liked to see an alternative client framework, with MapFish/GeoExt as the basis (in addition, there could also be a FLEX GIS client, an example of such can be found here:

http://vitagate.itn.liu.se/GAV/flash/scb/index.html)

An architectural question is where the binding of dynamic data from OLAP to the maps will take place. 

1) In the OH-FP current binding where the dynamic data is used to generate an SLD, which Geoserver then connects to the map layer. The problem with this is that any change in coloring etc requires roundtrips to the database for new SLD generation, and will thus be drastically slower than the MapFish solution, where coloring is taken care of in the browser. Work is required to improve this and make it run on the WHOSIS server code.

2) With the maps in PostGIS, the binding could simply be a database join, and Geoserver would then be able to produce WFS with GeoJSON format for input to the  client.

3) One could send the data (in the simple format created by T4Bi) and maps (as GeoJSON) to the client as separate data streams, which the client would then have to handle/join. This would allow refreshing data on the client without refetching the maps.

Knut 

--
Cheers,
Knut Staring

[Jiri Dvorak]

Knut, regarding Subversion hosting:

 

The one that our other customers are already using, and where we have practical experience, is CVSDude (based in Australia and U.S.A.) - http://cvsdude.com/ .  It is not very “glamorous” – the Web UI of all the tools (TRAC, Bugzilla) is fairly Spartan and technical – but so far, we didn’t hear major complaints about reliability and performance.  Pricing is quite reasonable, too ($30/month for a “reasonable” package for 15 people, or $100/month for a 50GB package with practically no restrictions).  Please note that TRAC contains an integrated Wiki, and may be used as an alternative to mailing lists.

 

There is another provider I found, Code Spaces (seems to be UK-based, contact phone# is +44 (0)2476 792025, but otherwise they are cryptic about their physical location) - http://www.codespaces.com/ .  In addition to basic Subversion, they offer a package of services (Security, Issue Tracking, Project Management, RSS feeds) which should be useful, if implemented properly, and they have a convenient feature of making Subversion items accessible via Web browsers.  The screenshots at http://www.codespaces.com/screenshots look OK.  Their pricing is a little bit higher than CVSDude, but not prohibitively so.

 

Unfortunately, I didn’t find the time yet to test-drive that service, but if you want to give it a try, I will be very much interested in your opinion.

 

- Jiri

----------------------------------------------------------------

Jiri Dvorak, T4Bi (www.t4bi.com), cell +1.604.220.0529

#1010-1177 West Hastings Street, Vancouver, BC V6E2K3, Canada

 

[Fabio D'Ovidio]

I am using the source code that i dowloaded here:
cvs.dhis.hisp.info/home/projects/openhealth/scm

On 13 Nov, 20:54, "Jiri Dvorak" <jdv...@gmail.com> wrote:
> Knut, regarding Subversion hosting:
>

> The one that our other customers are already using, and where we have practical experience, is CVSDude (based in Australia and U.S.A.) -http://cvsdude.com/. It is not very “glamorous” – the Web UI of all the tools (TRAC, Bugzilla) is fairly Spartan and technical – but so far, we didn’t hear major complaints about reliability and performance. Pricing is quite reasonable, too ($30/month for a “reasonable” package for 15 people, or $100/month for a 50GB package with practically no restrictions). Please note that TRAC contains an integrated Wiki, and may be used as an alternative to mailing lists.
>
> There is another provider I found, Code Spaces (seems to be UK-based, contact phone# is+44 (0)2476 792025, but otherwise they are cryptic about their physical location) -http://www.codespaces.com/. In addition to basic Subversion, they offer a package of services (Security, Issue Tracking, Project Management, RSS feeds) which should be useful, if implemented properly, and they have a convenient feature of making Subversion items accessible via Web browsers. The screenshots athttp://www.codespaces.com/screenshotslook OK. Their pricing is a little bit higher than CVSDude, but not prohibitively so.

>
> Unfortunately, I didn’t find the time yet to test-drive that service, but if you want to give it a try, I will be very much interested in your opinion.
>
> - Jiri
>
> ----------------------------------------------------------------
>
> Jiri Dvorak, T4Bi (www.t4bi.com), cell+1.604.220.0529
>
> #1010-1177 West Hastings Street, Vancouver, BC V6E2K3, Canada
>
> From: openh...@googlegroups.com [mailto:openh...@googlegroups.com] On Behalf Of Knut Staring
> Sent: Thursday, November 13, 2008 11:07 AM
> To: openh...@googlegroups.com
> Subject: Re: change your cube
>