[Mondrian] XMLA error in mondrian

Luc Boudreau lucboudreau at gmail.com
Mon May 19 09:42:58 EDT 2014


This isn't an error. It's an empty response.

Try removing your restrictions in your query one by one and see where it
starts returning metadata. This should tell you which restriction isn't
right. It could be either a type, or the presence of the tilde (~) which
doesn't get encoded correctly.

Luc


On Mon, May 19, 2014 at 7:48 AM, <islanis at infomed.sld.cu> wrote:

> Hi people, i got an error that returns an unexpected thing, i need
> that you help with this, in firebug when i see the no error operation,
> in the POST i got this
>
>
> <SOAP-ENV:Envelope
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <RequestType>MDSCHEMA_MEMBERS</RequestType>
> <Restrictions>
> <RestrictionList>
> <CATALOG_NAME>dw_fotovolt</CATALOG_NAME>
> <CUBE_NAME>dw_fotovolt</CUBE_NAME>
> <DIMENSION_UNIQUE_NAME>[Meses del año]</DIMENSION_UNIQUE_NAME>
> <HIERARCHY_UNIQUE_NAME>[Meses del año]</HIERARCHY_UNIQUE_NAME>
> <LEVEL_UNIQUE_NAME>[Meses del año].[mes]</LEVEL_UNIQUE_NAME>
> </RestrictionList>
> </Restrictions>
> <Properties>
> <PropertyList>
> <DataSourceInfo>Provider=Mondrian;DataSource=dw_fotovolt;</DataSourceInfo>
> <Catalog>dw_fotovolt</Catalog>
> </PropertyList>
> </Properties>
> </Discover>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
>
>
> and the return is this
>
>
>
>
> <SOAP-ENV:Envelope
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <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:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> elementFormDefault="qualified">
> <xsd:element name="root">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="row" type="row" minOccurs="0"
> maxOccurs="unbounded"></xsd:element>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:element>
> <xsd:simpleType name="uuid">
> <xsd:restriction base="xsd:string">
> <xsd:pattern
>
> value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"></xsd:pattern>
> </xsd:restriction>
> </xsd:simpleType>
> <xsd:complexType name="row">
> <xsd:sequence>
> <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME"
> type="xsd:string" minOccurs="0"></xsd:element>
> <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME"
> type="xsd:string" minOccurs="0"></xsd:element>
> <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME"
> type="xsd:string"></xsd:element>
> <xsd:element sql:field="DIMENSION_UNIQUE_NAME"
> name="DIMENSION_UNIQUE_NAME" type="xsd:string"></xsd:element>
> <xsd:element sql:field="HIERARCHY_UNIQUE_NAME"
> name="HIERARCHY_UNIQUE_NAME" type="xsd:string"></xsd:element>
> <xsd:element sql:field="LEVEL_UNIQUE_NAME" name="LEVEL_UNIQUE_NAME"
> type="xsd:string"></xsd:element>
> <xsd:element sql:field="LEVEL_NUMBER" name="LEVEL_NUMBER"
> type="xsd:unsignedInt"></xsd:element>
> <xsd:element sql:field="MEMBER_ORDINAL" name="MEMBER_ORDINAL"
> type="xsd:unsignedInt"></xsd:element>
> <xsd:element sql:field="MEMBER_NAME" name="MEMBER_NAME"
> type="xsd:string"></xsd:element>
> <xsd:element sql:field="MEMBER_UNIQUE_NAME" name="MEMBER_UNIQUE_NAME"
> type="xsd:string"></xsd:element>
> <xsd:element sql:field="MEMBER_TYPE" name="MEMBER_TYPE"
> type="xsd:int"></xsd:element>
> <xsd:element sql:field="MEMBER_GUID" name="MEMBER_GUID" type="uuid"
> minOccurs="0"></xsd:element>
> <xsd:element sql:field="MEMBER_CAPTION" name="MEMBER_CAPTION"
> type="xsd:string"></xsd:element>
> <xsd:element sql:field="CHILDREN_CARDINALITY"
> name="CHILDREN_CARDINALITY" type="xsd:unsignedInt"></xsd:element>
> <xsd:element sql:field="PARENT_LEVEL" name="PARENT_LEVEL"
> type="xsd:unsignedInt"></xsd:element>
> <xsd:element sql:field="PARENT_UNIQUE_NAME" name="PARENT_UNIQUE_NAME"
> type="xsd:string" minOccurs="0"></xsd:element>
> <xsd:element sql:field="PARENT_COUNT" name="PARENT_COUNT"
> type="xsd:unsignedInt"></xsd:element>
> <xsd:element sql:field="TREE_OP" name="TREE_OP" type="xsd:string"
> minOccurs="0"></xsd:element>
> <xsd:element sql:field="DEPTH" name="DEPTH" type="xsd:int"
> minOccurs="0"></xsd:element>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
> </root>
> </cxmla:return>
> </cxmla:DiscoverResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
>
> please what means this return.
>
> thanks
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>
>
> --
>
> Este mensaje le ha llegado mediante el servicio de correo electronico que
> ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema
> Nacional de Salud. La persona que envia este correo asume el compromiso de
> usar el servicio a tales fines y cumplir con las regulaciones establecidas
>
> Infomed: http://www.sld.cu/
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140519/718695b0/attachment.html 


More information about the Mondrian mailing list