[Mondrian] XMLA error in mondrian

islanis at infomed.sld.cu islanis at infomed.sld.cu
Mon May 19 10:13:47 EDT 2014


"Luc Boudreau" <lucboudreau at gmail.com> escribió:

> 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
>
Ok Luc, but i use a jscript library that generate the query  
automaticly, but here i sent you my xml and you'll please get a little  
review , i have 4 dimensions, and by intersecting with direct mdx  
queries it work fine, and never get an errors, but when in the jscript  
framework i try to filter some dimensions like the first dimension it  
get empty like you say, but in bd have data, and in the xml i dont see  
any problem,

thanks


<Schema name="dw_fotovolt">
   <Cube name="dw_fotovolt" cache="true" enabled="true">
     <Table name="ft_potencial" schema="public">
     </Table>
     <Dimension foreignKey="id_dw_mes" name="Meses del a&#241;o">
       <Hierarchy name="Meses del a&#241;o" hasAll="true"  
allMemberName="All meses del a&#241;o" primaryKey="id_dw_mes">
         <Table name="dm_mes" schema="public">
         </Table>
         <Level name="mes" table="dm_mes" column="nombre_mes"  
type="String" uniqueMembers="false" levelType="Regular"  
hideMemberIf="Never" caption="Mes">
         </Level>
       </Hierarchy>
     </Dimension>
     <Dimension foreignKey="id_dw_tipo" name="Tipo de potencial">
       <Hierarchy name="Tipo de potencial" hasAll="true"  
allMemberName="All tipo de potencial" primaryKey="id_dw_tipo">
         <Table name="dm_tipo" schema="public">
         </Table>
         <Level name="Tipo de potencial" table="dm_tipo"  
column="nombre_tipo" type="String" uniqueMembers="false"  
levelType="Regular" hideMemberIf="Never">
         </Level>
       </Hierarchy>
     </Dimension>
     <Dimension foreignKey="id_dw_date" name="Tiempo de actualizaci&#243;n">
       <Hierarchy name="Tiempo de actualizaci&#243;n" hasAll="true"  
allMemberName="All tiempo de actualizaci&#243;n"  
primaryKey="id_dw_date">
         <Table name="dm_update_date" schema="public">
         </Table>
         <Level name="a&#241;o" table="dm_update_date" column="year"  
type="Integer" uniqueMembers="false" levelType="Regular"  
hideMemberIf="Never">
         </Level>
       </Hierarchy>
     </Dimension>
     <Dimension foreignKey="id_dw_muni" name="Localizaci&#243;n">
       <Hierarchy name="municipios" hasAll="false"  
primaryKey="id_dw_muni" primaryKeyTable="dm_municipio">
         <Join leftAlias="dm_municipio" leftKey="id_dw_prov"  
rightAlias="dm_provincia" rightKey="id_dw_prov">
           <Table name="dm_municipio" schema="public">
           </Table>
           <Table name="dm_provincia" schema="public">
           </Table>
         </Join>
         <Level name="municipio" table="dm_municipio" column="nombre"  
type="String" uniqueMembers="false" levelType="Regular"  
hideMemberIf="Never" caption="Municipios">
           <Property name="the_geom" column="the_geom" type="Geometry">
           </Property>
         </Level>
		<Level name="provincia" table="dm_provincia"  
column="nombre_provincia" type="String" uniqueMembers="false"  
levelType="Regular" hideMemberIf="Never" caption="Provincias">
           <Property name="the_geom" column="the_geom" type="Geometry">
           </Property>
         </Level>
       </Hierarchy>
     </Dimension>
     <Measure name="sumatoriaP" column="potencial" datatype="Integer"  
formatString="#.##0" aggregator="sum" caption="Potencial">
     </Measure>
     <Measure name="promedioP" column="potencial" datatype="Numeric"  
formatString="#.##0" aggregator="avg" caption="Promedio potencial"  
visible="true">
     </Measure>
	<Measure name="area" column="area" datatype="Integer"  
formatString="#.##0" aggregator="sum" caption="&#193;rea">
     </Measure>
   </Cube>
</Schema>



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



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



More information about the Mondrian mailing list