Metadata link does not seem to work after selecting 'alternate' view option for WHO region

[Emily]

eg.. Firefox, IE6:
Select MDG 6, HIV prevalence: Metadata is OK for 'Prevalence of HIV among adults aged >=15 years (per 100 000 population)' indicator.
However, select WHO Regions or World Bank Income Group under Alternate Views, and metadata no longer appears when selecting same indicator link.

[Philippe Boucher (boucherp)]

From the other bug report also filed by Emily, Firefox and IE6:
- After selecting 'Alternate View', it is not possible to select another data view from the menu. The yellow error box 'The website is loading content, please try this action again.' appears, and need to go back to 'Home' to be able to access data again.
I think it's the same underlying problem -

If you look in the HTML source, the div containing the alternate view and filter selects as well as the export buttons (olap-buttons) is actually there but marked as display:none - if you change the display to block, the controls reappear, but it still does not work - I've tried regressing to older versions of Home.jsp, Navigation.js and older stylesheets from a version that works (the current gho on hqswproteus) but the problem remains. I dont see any entries in the log files when this problem is triggered

[Philippe Boucher (boucherp)]

There is a simple workaround when this issue is encountered, click on the "Home" link or on the browser's Reload button so setting importance to medium

[moores (moores)]

I can see metadata in Alternate View using my localhost install so this is likely a configuration issue..

[moores (moores)]

Can also select other menu items after Alternative View is selected.

[Knut Staring (knutst)]

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 - ...

[Knut Staring (knutst)]

When I select an alternative view in the GUI, the following shows up in the log:

where [Measures].[CHSI Indicator Value (String)]

[gho] 15 12 18:21:15 DEBUG mondrian.mdx execute - 0: exec: 355 ms
[gho] 15 12 18:21:34 ERROR mondrian.xmla.XmlaServlet doPost - Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error
        at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2666)
        at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:545)
        at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:410)
        at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:303)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while counting members of level '[Clinic Visit].[Clinic Visit]; sql=[select
 count(*) as `c0` from (select distinct `CLINIC_VISIT_CODES`.`TYPE_NAME` as `c0` from `CLINIC_VISIT_CODES` as `CLINIC_VISIT_CODES` where (CLINIC_VISIT
_CODES.type_code <> 'NOA')) as `init`]
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
        at mondrian.olap.Util.newInternal(Util.java:1435)
        at mondrian.olap.Util.newError(Util.java:1451)
        at mondrian.rolap.SqlStatement.handle(SqlStatement.java:211)
        at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142)
        at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:243)
        at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:204)
        at mondrian.rolap.SqlMemberSource.getMemberCount(SqlMemberSource.java:98)
        at mondrian.rolap.SqlMemberSource.getLevelMemberCount(SqlMemberSource.java:92)
        at mondrian.rolap.SmartMemberReader.getLevelMemberCount(SmartMemberReader.java:150)
        at mondrian.rolap.RolapSchemaReader.getLevelCardinality(RolapSchemaReader.java:268)
        at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateDimension(RowsetDefi...

[Philippe Boucher (boucherp)]

This problem was fixed by updating the GlobalHealthObservatory.xml file (provided by Steve). Discrepencies in the OLAP cube ultimately cause the user interface to fail because flags like isFlexReady do not get set back to what is required for the UI to run correcly. If these flags are forced, then the UI works - we probably need to look at how the UI code handles error conditions in a future release.
xml file is in the repo, setting to fix-committed.