Footnotes not working

Bug #490404 reported by moores
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Global Health Observatory
Fix Committed
High
moores

Bug Description

Footnotes are not available in the new version of GHO.

Logs show that footnote members are retrieved but notes data - specifically the parameters for "cols" and "rows" - are not generated.

This is a typical log result....

[gho] 30 11 17:16:08 DEBUG intl.who.oh2.olapPrinter.metadata.manager.OlapMetadataManager getMembers - Members : [Location].[All Locations].[EMR].[AFG],[Time Period].[All Time Periods].[2007];[Location].[All Locations].[EUR].[ALB],[Time Period].[All Time Periods].[2006];[Location].[All Locations].[AFR].[DZA],[Time Period].[All Time Periods].[2004];[Location].[All Locations].[EUR].[AND],[Time Period].[All Time Periods].[2007];[Location].[All Locations].[AFR].[AGO],[Time Period].[All Time Periods].[2005];[Location].[All Locations].[AMR].[ATG],[Time Period].[All Time Periods].[2007];[Location].[All Locations].[AMR].[ARG],[Time Period].[All Time Periods].[2000];[Location].[All Locations].[EUR].[ARM],[Time Period].[All Time Periods].[2007];

[gho] 30 11 17:16:08 DEBUG intl.who.oh2.base.servlet.OlapMetadataProxyServlet serviceHttpClient - Request received from: http://localhost:8090/ghodata/OlapMetadata encoding : null
[gho] 30 11 17:16:08 DEBUG intl.who.oh2.base.servlet.OlapMetadataProxyServlet serviceHttpClient - Parameter=cube value=Core Health Sum Indicators
[gho] 30 11 17:16:08 DEBUG intl.who.oh2.base.servlet.OlapMetadataProxyServlet serviceHttpClient - Request sent back successfully.
[gho] 30 11 17:16:08 DEBUG intl.who.oh2.olapPrinter.metadata.manager.OlapMetadataManager getMetadata - <error>
<external><![CDATA[
Missed cols and rows parameters for the metadata
 ]]></external>
<internal><![CDATA[
This is metadata server query formating error
 ]]></internal>
</error>

[gho] 30 11 17:16:08 INFO intl.who.oh2.olapPrinter.metadata.manager.OlapMetadataManager getMetadata - Request for metadata received.
[gho] 30 11 17:16:08 DEBUG intl.who.oh2.base.servlet.OlapPrintProxyServlet serviceHttpClient - Request sent back successfully.

Revision history for this message
Jiri Dvorak (jiri-dvorak) wrote :

This should be fixed now - please pay attention to the file applicationContext.xml; the following entry should be (in the template):

  <property name="services">
   <list>
    <value>/{_CONF_WAR_NAME}</value>
    <value>/OlapMetadataServlet</value>
   </list>
  </property>

Changed in gho:
milestone: none → 1.0
Revision history for this message
Philippe Boucher (boucherp) wrote :

The current version now on gva1sucreon.who.it displays footnotes in the data tables - setting this to fix-commited - I used the table
WHS -> Health Expenditures ->Health Expenditure ratios to check

Changed in gho:
status: New → Fix Committed
Revision history for this message
Jessica (hoj-who) wrote :

However they do not download on excel which is a big omission and should be a priority add.

The excel and PDF are also missing the disclaimer (something to the tune used in WHOSIS:
© World Health Organization
The information in this database is provided as a service to our users.
The responsibility for the interpretation and use of the material lies with the user.
In no event shall the World Health Organization be liable for any damages
arising from the use of the information linked to in this section.
For explanatory notes, please refer to the latest version of the World Health Statistics
publication available at http://www.who.int/whosis/.

The PDF has footnotes but they are not fully listed (stops at footnote 21, test on health expenditures ratios). Certain characters like "-" also seem to be an issue and are not displayed correctly in the footnote text.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.