[Mondrian] XMLA error in mondrian

Andy Grohe agrohe21 at gmail.com
Mon May 19 11:54:31 EDT 2014 

Are you using xmla4js or have you written your own?  I suggest using
xmla4js as a base.  It formulates the proper XML.
On May 19, 2014 9:14 AM, <islanis at infomed.sld.cu> wrote:

> "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/
>
> _______________________________________________
> 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/4cead007/attachment-0001.html

More information about the Mondrian mailing list