Global Health Observatory

Bug #496539
Comment #5

Comment 5 for bug 496539

Revision history for this message

Knut Staring (knutst) wrote on 2009-12-15:

Two observations:

1) For the particular case Emily cited (Select MDG 6, HIV prevalence: Metadata is OK for 'Prevalence of HIV among adults aged >=15 years (per 100 000 population)'), I get "No data found" in IE6, though it works fine in other browsers.

2) After selecting "WHO Regions" as alternative view, I get the whole cube def file as output in the Metadata popup:

(mx.messaging.messages::AcknowledgeMessage)#0
  body = "<?xml version="1.0" encoding="UTF-8"?><discover><root name="DBSCHEMA_CATALOGS"><root name="MDSCHEMA_CUBES">n="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
  <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <row>

<CUBE_NAME>All Country Yearly Core Levels</CUBE_NAME>
<CUBE_TYPE>VIRTUAL CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - All Country Yearly Core Levels Cube</DS>
</row>
<row>

<CUBE_NAME>All GHO Country Yearly Indicators</CUBE_NAME>
<CUBE_TYPE>VIRTUAL CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - All GHO Country Yearly Indicators Cube</DS>
</row>
<row>

<CUBE_NAME>Core Health Sum Indicators</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Core Health Sum Indicators Cube</DS>
</row>
<row>

<CUBE_NAME>Core Health Unit Indicators</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Core Health Unit Indicators Cube</DS>
</row>
<row>

<CUBE_NAME>Country Yearly GBD Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Country Yearly GBD Measures Cube</DS>
</row>
<row>

<CUBE_NAME>Country Yearly Infect Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Country Yearly Infect Measures Cube</DS>
</row>
<row>

<CUBE_NAME>Country Yearly Life Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Country Yearly Life Measures Cube</DS>
</row>
<row>

<CUBE_NAME>Country Yearly Mortality Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Country Yearly Mortality Measures Cube</DS>
</row>
<row>

<CUBE_NAME>Global Yearly Core Sums</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Global Yearly Core Sums Cube</DS>
</row>
<row>

<CUBE_NAME>Income Yearly Core Sums</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Income Yearly Core Sums Cube</DS>
</row>
<row>

<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Regional Yearly Core Sums Cube</DS>
</row>
<row>

<CUBE_NAME>Regional Yearly GBD Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Regional Yearly GBD Measures Cube</DS>
</row>
<row>

<CUBE_NAME>Regional Yearly Life Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Regional Yearly Life Measures Cube</DS>
      </row>
    </root></discover> "
  clientId = "DirectHTTPChannel0"
  correlationId = "3E51814D-F6FA-7C0A-5D9A-91EE598A9941"
  destination = ""
  headers = (Object)#1
  messageId = "123E96F0-8643-B976-08F7-91EE59D86C85"
  timestamp = 0
  timeToLive = 0

Two observations:

2) After selecting "WHO Regions" as alternative view, I get the whole cube def file as output in the Metadata popup:

<CUBE_NAME>Regional Yearly Life Measures</CUBE_NAME>
<CUBE_TYPE>CUBE</CUBE_TYPE>
<LAST_SCHEMA_UPDATE>2009-12-11T15:02:56</LAST_SCHEMA_UPDATE>
<IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>
<IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>
<IS_LINKABLE>false</IS_LINKABLE>
<IS_SQL_ENABLED>false</IS_SQL_ENABLED>
<DS>GlobalHealthObservatory Schema - Regional Yearly Life Measures Cube</DS>
      </row>
    </root></discover>          "
  clientId = "DirectHTTPChannel0"
  correlationId = "3E51814D-F6FA-7C0A-5D9A-91EE598A9941"
  destination = ""
  headers = (Object)#1
  messageId = "123E96F0-8643-B976-08F7-91EE59D86C85"
  timestamp = 0
  timeToLive = 0