[Mondrian] Excel error when Internal Properties are discovered viaXMLA

Julian Hyde jhyde at pentaho.com
Fri Feb 26 18:52:46 EST 2010


Fixed in change 13409.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Calum Miller
Sent: Monday, February 22, 2010 2:47 PM
To: Mondrian developer mailing list
Subject: [Mondrian] Excel error when Internal Properties are discovered
viaXMLA


Hi

I've added a new bug and a fix http://jira.pentaho.com/browse/MONDRIAN-704
The following test can be used to validate the fix

Calum

    <TestCase name="test99">
        <Resource name="request">
            <![CDATA[
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <Header />
  <Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
           <RequestType>MDSCHEMA_PROPERTIES</RequestType>
           <Restrictions>
               <RestrictionList>
                   <CUBE_NAME>HR</CUBE_NAME>
               </RestrictionList>
           </Restrictions>
           <Properties>
               <PropertyList>
                   <LocaleIdentifier>1033</LocaleIdentifier>
                   <Content>SchemaData</Content>
                   <Format>Tabular</Format>
                   <DataSourceInfo>MondrianFoodMart</DataSourceInfo>
                   <Catalog>FoodMart</Catalog>
               </PropertyList>
           </Properties>
       </Discover>
  </Body>
</Envelope>
]]>
        </Resource>
        <Resource name="response">
            <![CDATA[<?xml version="1.0"?>
<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: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">
                    <xsd:schema elementFormDefault="qualified"
 
targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
 
xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
                        xmlns:sql="urn:schemas-microsoft-com:xml-sql"
                        xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                        <xsd:element name="root">
                            <xsd:complexType>
                                <xsd:sequence>
                                    <xsd:element maxOccurs="unbounded"
                                    minOccurs="0" name="row" type="row"/>
                                </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:restriction>
                        </xsd:simpleType>
                        <xsd:complexType name="row">
                            <xsd:sequence>
                                <xsd:element minOccurs="0"
                                    name="CATALOG_NAME"
                                    sql:field="CATALOG_NAME"
type="xsd:string"/>
                                <xsd:element minOccurs="0"
                                    name="SCHEMA_NAME"
                                    sql:field="SCHEMA_NAME"
type="xsd:string"/>
                                <xsd:element minOccurs="0"
                                    name="CUBE_NAME"
                                    sql:field="CUBE_NAME"
type="xsd:string"/>
                                <xsd:element minOccurs="0"
                                    name="DIMENSION_UNIQUE_NAME"
                                    sql:field="DIMENSION_UNIQUE_NAME"
type="xsd:string"/>
                                <xsd:element minOccurs="0"
                                    name="HIERARCHY_UNIQUE_NAME"
                                    sql:field="HIERARCHY_UNIQUE_NAME"
type="xsd:string"/>
                                <xsd:element minOccurs="0"
                                    name="LEVEL_UNIQUE_NAME"
                                    sql:field="LEVEL_UNIQUE_NAME"
type="xsd:string"/>
                                <xsd:element minOccurs="0"
                                    name="MEMBER_UNIQUE_NAME"
                                    sql:field="MEMBER_UNIQUE_NAME"
type="xsd:string"/>
                                <xsd:element name="PROPERTY_NAME"
                                    sql:field="PROPERTY_NAME"
type="xsd:string"/>
                                <xsd:element name="PROPERTY_CAPTION"
                                    sql:field="PROPERTY_CAPTION"
type="xsd:string"/>
                                <xsd:element name="PROPERTY_TYPE"
                                    sql:field="PROPERTY_TYPE"
type="xsd:short"/>
                                <xsd:element name="DATA_TYPE"
                                    sql:field="DATA_TYPE"
type="xsd:unsignedShort"/>
                                <xsd:element minOccurs="0"
                                    name="PROPERTY_CONTENT_TYPE"
                                    sql:field="PROPERTY_CONTENT_TYPE"
type="xsd:short"/>
                                <xsd:element minOccurs="0"
                                    name="DESCRIPTION"
                                    sql:field="DESCRIPTION"
type="xsd:string"/>
                            </xsd:sequence>
                        </xsd:complexType>
                    </xsd:schema>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Store Type</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Store Type</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Store Type Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Store Manager</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Store Manager</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Store Manager
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Store Sqft</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Store Sqft</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>5</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Store Sqft Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Grocery Sqft</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Grocery Sqft</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>5</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Grocery Sqft Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Frozen Sqft</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Frozen Sqft</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>5</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Frozen Sqft Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Meat Sqft</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Meat Sqft</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>5</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Meat Sqft Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Has coffee bar</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Has coffee bar</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>11</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Has coffee bar
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Store]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Store]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Store].[Store
Name]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Street address</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Street address</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Store Hierarchy - Store
                            Name Level - Street address
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Employees]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Employees]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Employees].[Employee
Id]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Marital Status</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Marital Status</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Employees Hierarchy -
                            Employee Id Level - Marital Status
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Employees]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Employees]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Employees].[Employee
Id]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Position Title</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Position Title</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Employees Hierarchy -
                            Employee Id Level - Position Title
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Employees]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Employees]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Employees].[Employee
Id]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Gender</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Gender</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Employees Hierarchy -
                            Employee Id Level - Gender
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Employees]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Employees]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Employees].[Employee
Id]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Salary</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Salary</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Employees Hierarchy -
                            Employee Id Level - Salary
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Employees]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Employees]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Employees].[Employee
Id]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Education Level</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Education Level</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Employees Hierarchy -
                            Employee Id Level - Education Level
Property</DESCRIPTION>
                    </row>
                    <row>
                        <CATALOG_NAME>FoodMart</CATALOG_NAME>
                        <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
                        <CUBE_NAME>HR</CUBE_NAME>
 
<DIMENSION_UNIQUE_NAME>[Employees]</DIMENSION_UNIQUE_NAME>
 
<HIERARCHY_UNIQUE_NAME>[Employees]</HIERARCHY_UNIQUE_NAME>
                        <LEVEL_UNIQUE_NAME>[Employees].[Employee
Id]</LEVEL_UNIQUE_NAME>
                        <PROPERTY_NAME>Management Role</PROPERTY_NAME>
                        <PROPERTY_CAPTION>Management Role</PROPERTY_CAPTION>
                        <PROPERTY_TYPE>1</PROPERTY_TYPE>
                        <DATA_TYPE>130</DATA_TYPE>
                        <PROPERTY_CONTENT_TYPE>0</PROPERTY_CONTENT_TYPE>
                        <DESCRIPTION>HR Cube - Employees Hierarchy -
                            Employee Id Level - Management Role
Property</DESCRIPTION>
                    </row>
                </root>
            </cxmla:return>
        </cxmla:DiscoverResponse>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
]]>
        </Resource>
    </TestCase>





Calum Miller
Business Intelligence Specialist
calum at millersoft.ltd.uk
http://www.millersoft.ltd.uk
Address: Conference House, 152 Morrison Street, The Exchange, Edinburgh,
United Kingdom, EH3 8EB 
Location: http://bit.ly/dmDiTr
Telephone: +44 (0) 131 208 0202
Fax: +44 (0) 131 608 0037
Mobile: +44 (0) 7973 249 621
Skype: calummiller


 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100226/628b0924/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2982 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20100226/628b0924/attachment.jpe 


More information about the Mondrian mailing list