Hi,<br><br>I've just updated to mondrian 3.2.0.13583 and now excel gives me "the query did not run, or the database table could not be opened." error when I refresh.<br>I didn't saw anything special in mondrian's log so I configured log4j in DEBUG and got this:<br>
<br>2010.05.21;10:39:52.405 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.406 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.408 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Body><br> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"><br> <RequestType>DISCOVER_DATASOURCES</RequestType><br> <Restrictions><br> <RestrictionList/><br>
</Restrictions><br> <Properties><br> <PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br> <Content>SchemaData</Content><br>
<Format>Tabular</Format><br> <Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br> </Discover><br>
</Body><br></Envelope><br>2010.05.21;10:39:52.408 DEBUG Handling XML/A message header<br>2010.05.21;10:39:52.408 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.408 DEBUG Handling XML/A message body<br>
2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties: key="Content", value="SchemaData"<br>
2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties: key="Format", value="Tabular"<br>2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>
2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: time = 0<br>2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: FREE_MEMORY: 131433kb 26.69%<br>2010.05.21;10:39:52.409 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.410 DEBUG XML/A response content<br>
<?xml version="1.0" encoding="ISO-8859-1"?><br><SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br> <cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified"><br>
<xsd:element name="root"><br> <xsd:complexType><br> <xsd:sequence><br> <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:simpleType name="uuid"><br> <xsd:restriction base="xsd:string"><br>
<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}"/><br> </xsd:restriction><br> </xsd:simpleType><br> <xsd:complexType name="row"><br>
<xsd:sequence><br> <xsd:element sql:field="DataSourceName" name="DataSourceName" type="xsd:string"/><br> <xsd:element sql:field="DataSourceDescription" name="DataSourceDescription" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="URL" name="URL" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="ProviderName" name="ProviderName" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="ProviderType" name="ProviderType" type="xsd:string" maxOccurs="unbounded"/><br>
<xsd:element sql:field="AuthenticationMode" name="AuthenticationMode" type="xsd:string"/><br> </xsd:sequence><br> </xsd:complexType><br> </xsd:schema><br>
<row><br> <DataSourceName>Provider=Mondrian;DataSource=cube;</DataSourceName><br> <DataSourceDescription>Data Warehouse</DataSourceDescription><br> <URL><a href="http://localhost:8082/datawarehouse/xmla">http://localhost:8082/datawarehouse/xmla</a></URL><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <ProviderName>Mondrian</ProviderName><br> <ProviderType>MDP</ProviderType><br> <AuthenticationMode>Unauthenticated</AuthenticationMode><br>
</row><br> </root><br> </cxmla:return><br></cxmla:DiscoverResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br><br>2010.05.21;10:39:52.417 DEBUG Invoking validate http header callbacks<br>
2010.05.21;10:39:52.418 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.420 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis" mustUnderstand="1"/><br> </Header><br> <Body><br> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<Command><br> <Statement/><br> </Command><br> <Properties><br> <PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br>
</Execute><br> </Body><br></Envelope><br>2010.05.21;10:39:52.421 DEBUG Handling XML/A message header<br>2010.05.21;10:39:52.421 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.422 DEBUG Handling XML/A message body<br>
2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.423 DEBUG mdx: ""<br>2010.05.21;10:39:52.423 DEBUG XmlaHandler.process: time = 0<br>
2010.05.21;10:39:52.424 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb 26.21%<br>2010.05.21;10:39:52.424 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.424 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified"><br>
<xsd:element name="root"/><br> </xsd:schema><br> </root><br> </cxmla:return><br></cxmla:ExecuteResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br>
<br>2010.05.21;10:39:52.429 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.429 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.431 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis" mustUnderstand="1"/><br> </Header><br> <Body><br> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<Command><br> <Statement/><br> </Command><br> <Properties><br> <PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br>
</Execute><br> </Body><br></Envelope><br>2010.05.21;10:39:52.431 DEBUG Handling XML/A message header<br>2010.05.21;10:39:52.431 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.432 DEBUG Handling XML/A message body<br>
2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.432 DEBUG mdx: ""<br>2010.05.21;10:39:52.432 DEBUG XmlaHandler.process: time = 0<br>
2010.05.21;10:39:52.433 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb 26.21%<br>2010.05.21;10:39:52.433 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.433 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified"><br>
<xsd:element name="root"/><br> </xsd:schema><br> </root><br> </cxmla:return><br></cxmla:ExecuteResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br>
<br>2010.05.21;10:39:52.435 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.435 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.437 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="" mustUnderstand="1"/><br> </Header><br> <Body><br> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType><br> <Restrictions><br> <RestrictionList/><br> </Restrictions><br> <Properties><br>
<PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br> <Content>SchemaData</Content><br> <Format>Tabular</Format><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br>
</Discover><br> </Body><br></Envelope><br>2010.05.21;10:39:52.437 DEBUG Handling XML/A message header<br>2010.05.21;10:39:52.438 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.438 DEBUG Handling XML/A message body<br>
2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties: key="Content", value="SchemaData"<br>
2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties: key="Format", value="Tabular"<br>2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.440 DEBUG XmlaHandler.process: time = 1<br>2010.05.21;10:39:52.442 DEBUG XmlaHandler.process: FREE_MEMORY: 126748kb 25.74%<br>
2010.05.21;10:39:52.442 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.442 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br><SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified"><br>
<xsd:element name="root"><br> <xsd:complexType><br> <xsd:sequence><br> <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:simpleType name="uuid"><br> <xsd:restriction base="xsd:string"><br>
<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}"/><br> </xsd:restriction><br> </xsd:simpleType><br> <xsd:complexType name="row"><br>
<xsd:sequence><br> <xsd:element sql:field="SchemaName" name="SchemaName" type="xsd:string"/><br> <xsd:element sql:field="SchemaGuid" name="SchemaGuid" type="uuid" minOccurs="0"/><br>
<xsd:element sql:field="Restrictions" name="Restrictions" minOccurs="0" maxOccurs="unbounded"><br> <xsd:complexType><br> <xsd:sequence><br>
<xsd:element name="Name" type="xsd:string" sql:field="Name"/><br> <xsd:element name="Type" type="xsd:string" sql:field="Type"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:element sql:field="Description" name="Description" type="xsd:string"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:schema><br> <row><br> <SchemaName>DBSCHEMA_CATALOGS</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Description>Returns information about literals supported by the provider.</Description><br> </row><br> <row><br>
<SchemaName>DBSCHEMA_COLUMNS</SchemaName><br> <Restrictions><br> <Name>TABLE_CATALOG</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>TABLE_SCHEMA</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>TABLE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>COLUMN_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Description/><br> </row><br> <row><br> <SchemaName>DBSCHEMA_PROVIDER_TYPES</SchemaName><br> <Restrictions><br> <Name>DATA_TYPE</Name><br>
<Type>xsd:unsignedShort</Type><br> </Restrictions><br> <Restrictions><br> <Name>BEST_MATCH</Name><br> <Type>xsd:boolean</Type><br> </Restrictions><br>
<Description/><br> </row><br> <row><br> <SchemaName>DBSCHEMA_SCHEMATA</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>SCHEMA_OWNER</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br>
<SchemaName>DBSCHEMA_TABLES</SchemaName><br> <Restrictions><br> <Name>TABLE_CATALOG</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>TABLE_SCHEMA</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>TABLE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>TABLE_TYPE</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Description/><br> </row><br> <row><br> <SchemaName>DBSCHEMA_TABLES_INFO</SchemaName><br> <Restrictions><br> <Name>TABLE_CATALOG</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>TABLE_SCHEMA</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>TABLE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>TABLE_TYPE</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br> <SchemaName>DISCOVER_DATASOURCES</SchemaName><br>
<Restrictions><br> <Name>DataSourceName</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>URL</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>ProviderName</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>ProviderType</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>AuthenticationMode</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Description>Returns a list of XML for Analysis data sources available on the server or Web Service.</Description><br> </row><br>
<row><br> <SchemaName>DISCOVER_ENUMERATORS</SchemaName><br> <Restrictions><br> <Name>EnumName</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Description>Returns a list of names, data types, and enumeration values for enumerators supported by the provider of a specific data source.</Description><br> </row><br> <row><br>
<SchemaName>DISCOVER_KEYWORDS</SchemaName><br> <Restrictions><br> <Name>Keyword</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Description>Returns an XML list of keywords reserved by the provider.</Description><br> </row><br> <row><br> <SchemaName>DISCOVER_LITERALS</SchemaName><br> <Restrictions><br>
<Name>LiteralName</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description>Returns information about literals supported by the provider.</Description><br>
</row><br> <row><br> <SchemaName>DISCOVER_PROPERTIES</SchemaName><br> <Restrictions><br> <Name>PropertyName</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Description>Returns a list of information and values about the requested properties that are supported by the specified data source provider.</Description><br> </row><br>
<row><br> <SchemaName>DISCOVER_SCHEMA_ROWSETS</SchemaName><br> <Restrictions><br> <Name>SchemaName</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Description>Returns the names, values, and other information of all supported RequestType enumeration values.</Description><br> </row><br> <row><br>
<SchemaName>MDSCHEMA_ACTIONS</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>ACTION_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>COORDINATE</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>COORDINATE_TYPE</Name><br>
<Type>xsd:int</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br> <SchemaName>MDSCHEMA_CUBES</SchemaName><br> <Restrictions><br>
<Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br>
<Name>CUBE_TYPE</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br> <SchemaName>MDSCHEMA_DIMENSIONS</SchemaName><br>
<Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>SCHEMA_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>DIMENSION_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>DIMENSION_UNIQUE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br> <SchemaName>MDSCHEMA_FUNCTIONS</SchemaName><br>
<Restrictions><br> <Name>FUNCTION_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>ORIGIN</Name><br>
<Type>xsd:int</Type><br> </Restrictions><br> <Restrictions><br> <Name>INTERFACE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>LIBRARY_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br>
<SchemaName>MDSCHEMA_HIERARCHIES</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>DIMENSION_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Restrictions><br> <Name>HIERARCHY_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br>
<Name>HIERARCHY_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br> <SchemaName>MDSCHEMA_LEVELS</SchemaName><br>
<Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>SCHEMA_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>DIMENSION_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>HIERARCHY_UNIQUE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>LEVEL_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>LEVEL_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br>
<row><br> <SchemaName>MDSCHEMA_MEASURES</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>MEASURE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>MEASURE_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Description/><br> </row><br>
<row><br> <SchemaName>MDSCHEMA_MEMBERS</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>DIMENSION_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Restrictions><br> <Name>HIERARCHY_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br>
<Name>LEVEL_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>LEVEL_NUMBER</Name><br>
<Type>xsd:unsignedInt</Type><br> </Restrictions><br> <Restrictions><br> <Name>MEMBER_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>MEMBER_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>MEMBER_TYPE</Name><br>
<Type>xsd:int</Type><br> </Restrictions><br> <Restrictions><br> <Name>MEMBER_CAPTION</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>TREE_OP</Name><br> <Type>xsd:int</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br>
<SchemaName>MDSCHEMA_PROPERTIES</SchemaName><br> <Restrictions><br> <Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>DIMENSION_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Restrictions><br> <Name>HIERARCHY_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br>
<Name>LEVEL_UNIQUE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>MEMBER_UNIQUE_NAME</Name><br>
<Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>PROPERTY_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br>
<Restrictions><br> <Name>PROPERTY_TYPE</Name><br> <Type>xsd:short</Type><br> </Restrictions><br> <Restrictions><br> <Name>PROPERTY_CONTENT_TYPE</Name><br>
<Type>xsd:short</Type><br> </Restrictions><br> <Description/><br> </row><br> <row><br> <SchemaName>MDSCHEMA_SETS</SchemaName><br> <Restrictions><br>
<Name>CATALOG_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>SCHEMA_NAME</Name><br> <Type>xsd:string</Type><br>
</Restrictions><br> <Restrictions><br> <Name>CUBE_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br>
<Name>SET_NAME</Name><br> <Type>xsd:string</Type><br> </Restrictions><br> <Restrictions><br> <Name>SCOPE</Name><br> <Type>xsd:int</Type><br>
</Restrictions><br> <Description/><br> </row><br> </root><br> </cxmla:return><br></cxmla:DiscoverResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br>
<br>2010.05.21;10:39:52.451 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.451 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.454 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="" mustUnderstand="1"/><br> </Header><br> <Body><br> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<RequestType>DISCOVER_PROPERTIES</RequestType><br> <Restrictions><br> <RestrictionList/><br> </Restrictions><br> <Properties><br>
<PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br> <Content>SchemaData</Content><br> <Format>Tabular</Format><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br>
</Discover><br> </Body><br></Envelope><br>2010.05.21;10:39:52.454 DEBUG Handling XML/A message header<br>2010.05.21;10:39:52.454 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.454 DEBUG Handling XML/A message body<br>
2010.05.21;10:39:52.454 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.454 DEBUG DefaultXmlaRequest.initProperties: key="Content", value="SchemaData"<br>
2010.05.21;10:39:52.454 DEBUG DefaultXmlaRequest.initProperties: key="Format", value="Tabular"<br>2010.05.21;10:39:52.455 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.455 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.456 DEBUG XmlaHandler.process: time = 1<br>2010.05.21;10:39:52.456 DEBUG XmlaHandler.process: FREE_MEMORY: 125219kb 25.42%<br>
2010.05.21;10:39:52.456 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.456 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br><SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified"><br>
<xsd:element name="root"><br> <xsd:complexType><br> <xsd:sequence><br> <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:simpleType name="uuid"><br> <xsd:restriction base="xsd:string"><br>
<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}"/><br> </xsd:restriction><br> </xsd:simpleType><br> <xsd:complexType name="row"><br>
<xsd:sequence><br> <xsd:element sql:field="PropertyName" name="PropertyName" type="xsd:string"/><br> <xsd:element sql:field="PropertyDescription" name="PropertyDescription" type="xsd:string"/><br>
<xsd:element sql:field="PropertyType" name="PropertyType" type="xsd:string"/><br> <xsd:element sql:field="PropertyAccessType" name="PropertyAccessType" type="xsd:string"/><br>
<xsd:element sql:field="IsRequired" name="IsRequired" type="xsd:boolean"/><br> <xsd:element sql:field="Value" name="Value" type="xsd:string"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:schema><br> <row><br> <PropertyName>AxisFormat</PropertyName><br> <PropertyDescription>Determines the format used within an MDDataSet result set to describe the axes of the multidimensional dataset. This property can have the values listed in the following table: TupleFormat (default), ClusterFormat, CustomFormat.</PropertyDescription><br>
<PropertyType>Enumeration</PropertyType><br> <PropertyAccessType>Write</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>BeginRange</PropertyName><br> <PropertyDescription>Contains a zero-based integer value corresponding to a CellOrdinal attribute value. (The CellOrdinal attribute is part of the Cell element in the CellData section of MDDataSet.)&#10;Used together with the EndRange property, the client application can use this property to restrict an OLAP dataset returned by a command to a specific range of cells. If -1 is specified, all cells up to the cell specified in the EndRange property are returned.&#10;The default value for this property is -1.</PropertyDescription><br>
<PropertyType>Integer</PropertyType><br> <PropertyAccessType>Write</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>-1</Value><br>
</row><br> <row><br> <PropertyName>Catalog</PropertyName><br> <PropertyDescription>When establishing a session with an Analysis Services instance to send an XMLA command, this property is equivalent to the OLE DB property, DBPROP_INIT_CATALOG.&#10;When you set this property during a session to change the current database for the session, this property is equivalent to the OLE DB property, DBPROP_CURRENTCATALOG.&#10;The default value for this property is an empty string.</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>Content</PropertyName><br> <PropertyDescription>An enumerator that specifies what type of data is returned in the result set.&#10;None: Allows the structure of the command to be verified, but not executed. Analogous to using Prepare to check syntax, and so on.&#10;Schema: Contains the XML schema (which indicates column information, and so on) that relates to the requested query.&#10;Data: Contains only the data that was requested.&#10;SchemaData: Returns both the schema information as well as the data.</PropertyDescription><br>
<PropertyType>EnumString</PropertyType><br> <PropertyAccessType>Write</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>SchemaData</Value><br>
</row><br> <row><br> <PropertyName>Cube</PropertyName><br> <PropertyDescription>The cube context for the Command parameter. If the command contains a cube name (such as an MDX FROM clause) the setting of this property is ignored.</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>DataSourceInfo</PropertyName><br> <PropertyDescription>A string containing provider specific information, required to access the data source.</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>Deep</PropertyName><br> <PropertyDescription>In an MDSCHEMA_CUBES request, whether to include sub-elements (dimensions, hierarchies, levels, measures, named sets) of each cube.</PropertyDescription><br>
<PropertyType>Boolean</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>EndRange</PropertyName><br> <PropertyDescription>An integer value corresponding to a CellOrdinal used to restrict an MDDataSet returned by a command to a specific range of cells. Used in conjunction with the BeginRange property. If unspecified, all cells are returned in the rowset. The value -1 means unspecified.</PropertyDescription><br>
<PropertyType>Integer</PropertyType><br> <PropertyAccessType>Write</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>-1</Value><br>
</row><br> <row><br> <PropertyName>Format</PropertyName><br> <PropertyDescription>Enumerator that determines the format of the returned result set. Values include:&#10;Tabular: a flat or hierarchical rowset. Similar to the XML RAW format in SQL. The Format property should be set to Tabular for OLE DB for Data Mining commands.&#10;Multidimensional: Indicates that the result set will use the MDDataSet format (Execute method only).&#10;Native: The client does not request a specific format, so the provider may return the format appropriate to the query. (The actual result type is identified by namespace of the result.)</PropertyDescription><br>
<PropertyType>EnumString</PropertyType><br> <PropertyAccessType>Write</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>Native</Value><br>
</row><br> <row><br> <PropertyName>LocaleIdentifier</PropertyName><br> <PropertyDescription>Use this to read or set the numeric locale identifier for this request. The default is provider-specific.&#10;For the complete hexadecimal list of language identifiers, search on &#34;Language Identifiers&#34; in the MSDN Library at <a href="http://www.msdn.microsoft.com">http://www.msdn.microsoft.com</a>.</PropertyDescription><br>
<PropertyType>UnsignedInteger</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>None</Value><br>
</row><br> <row><br> <PropertyName>MDXSupport</PropertyName><br> <PropertyDescription>Enumeration that describes the degree of MDX support. At initial release Core is the only value in the enumeration. In future releases, other values will be defined for this enumeration.</PropertyDescription><br>
<PropertyType>EnumString</PropertyType><br> <PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>Core</Value><br>
</row><br> <row><br> <PropertyName>Password</PropertyName><br> <PropertyDescription>This property is deprecated in XMLA 1.1. To support legacy applications, the provider accepts but ignores the Password property setting when it is used with the Discover and Execute method</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>ProviderName</PropertyName><br> <PropertyDescription>The XML for Analysis Provider name.</PropertyDescription><br> <PropertyType>string</PropertyType><br>
<PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>Mondrian XML for Analysis Provider</Value><br> </row><br> <row><br>
<PropertyName>ProviderVersion</PropertyName><br> <PropertyDescription>The version of the Mondrian XMLA Provider</PropertyDescription><br> <PropertyType>string</PropertyType><br>
<PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>3.2.0.13583</Value><br> </row><br> <row><br> <PropertyName>ResponseMimeType</PropertyName><br>
<PropertyDescription>Accepted mime type for RPC response; accepted are &#39;text/xml&#39; (default), &#39;application/xml&#39; (equivalent to &#39;text/xml&#39;), or &#39;application/json&#39;. If not specified, value in the &#39;Accept&#39; header of the HTTP request is used.</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>None</Value><br>
</row><br> <row><br> <PropertyName>StateSupport</PropertyName><br> <PropertyDescription>Property that specifies the degree of support in the provider for state. For information about state in XML for Analysis, see &#34;Support for Statefulness in XML for Analysis.&#34; Minimum enumeration values are as follows:&#10;None - No support for sessions or stateful operations.&#10;Sessions - Provider supports sessions.</PropertyDescription><br>
<PropertyType>EnumString</PropertyType><br> <PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>None</Value><br>
</row><br> <row><br> <PropertyName>Timeout</PropertyName><br> <PropertyDescription>A numeric time-out specifying in seconds the amount of time to wait for a request to be successful.</PropertyDescription><br>
<PropertyType>UnsignedInteger</PropertyType><br> <PropertyAccessType>ReadWrite</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>Undefined</Value><br>
</row><br> <row><br> <PropertyName>UserName</PropertyName><br> <PropertyDescription>Returns the UserName the server associates with the command.&#10;This property is deprecated as writeable in XMLA 1.1. To support legacy applications, servers accept but ignore the password setting when it is used with the Execute method.</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>VisualMode</PropertyName><br> <PropertyDescription>This property is equivalent to the OLE DB property, MDPROP_VISUALMODE.&#10;The default value for this property is zero (0), equivalent to DBPROPVAL_VISUAL_MODE_DEFAULT.</PropertyDescription><br>
<PropertyType>Enumeration</PropertyType><br> <PropertyAccessType>Write</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value>1</Value><br>
</row><br> <row><br> <PropertyName>TableFields</PropertyName><br> <PropertyDescription>List of fields to return for drill-through.&#10;The default value of this property is the empty string,in which case, all fields are returned.</PropertyDescription><br>
<PropertyType>string</PropertyType><br> <PropertyAccessType>Read</PropertyAccessType><br> <IsRequired>false</IsRequired><br> <Value/><br> </row><br>
<row><br> <PropertyName>AdvancedFlag</PropertyName><br> <PropertyDescription/><br> <PropertyType>Boolean</PropertyType><br> <PropertyAccessType>Read</PropertyAccessType><br>
<IsRequired>false</IsRequired><br> <Value>false</Value><br> </row><br> </root><br> </cxmla:return><br></cxmla:DiscoverResponse><br></SOAP-ENV:Body><br>
</SOAP-ENV:Envelope><br><br>2010.05.21;10:39:52.554 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.555 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.605 DEBUG XML/A request content<br>
<?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis" mustUnderstand="1"/><br> </Header><br> <Body><br> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<Command><br> <Statement/><br> </Command><br> <Properties><br> <PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br>
</Execute><br> </Body><br></Envelope><br>2010.05.21;10:39:52.606 DEBUG Handling XML/A message header<br>2010.05.21;10:39:52.606 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.606 DEBUG Handling XML/A message body<br>
2010.05.21;10:39:52.607 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.607 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.607 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.608 DEBUG mdx: ""<br>2010.05.21;10:39:52.608 DEBUG XmlaHandler.process: time = 0<br>
2010.05.21;10:39:52.608 DEBUG XmlaHandler.process: FREE_MEMORY: 411408kb 83.45%<br>2010.05.21;10:39:52.608 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.609 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified"><br>
<xsd:element name="root"/><br> </xsd:schema><br> </root><br> </cxmla:return><br></cxmla:ExecuteResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br>
<br>2010.05.21;10:39:52.611 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.612 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.616 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="" mustUnderstand="1"/><br> </Header><br> <Body><br> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<RequestType>MDSCHEMA_PROPERTIES</RequestType><br> <Restrictions><br> <RestrictionList><br> <CUBE_NAME>This restriction should never match</CUBE_NAME><br>
</RestrictionList><br> </Restrictions><br> <Properties><br> <PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br>
<Content>SchemaData</Content><br> <Format>Tabular</Format><br> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br>
<Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br> </Discover><br> </Body><br></Envelope><br>2010.05.21;10:39:52.616 DEBUG Handling XML/A message header<br>
2010.05.21;10:39:52.616 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.616 DEBUG Handling XML/A message body<br>2010.05.21;10:39:52.616 DEBUG DefaultXmlaRequest.initRestrictions: key="CUBE_NAME", value="This restriction should never match"<br>
2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties: key="Content", value="SchemaData"<br>
2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties: key="Format", value="Tabular"<br>2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.617 DEBUG Rowset<init>: restrictedColumn="CUBE_NAME"<br>2010.05.21;10:39:52.618 DEBUG XmlaHandler.getDataSource: dataSourceInfo=Provider=Mondrian;DataSource=cube;<br>
2010.05.21;10:39:52.618 DEBUG XmlaHandler.getDataSource: ds.dataSourceInfo=Provider=Mondrian; Jdbc=jdbc:mysql://<a href="http://db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir">db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir</a>; JdbcDrivers=com.mysql.jdbc.Driver<br>
2010.05.21;10:39:52.618 DEBUG XmlaHandler.getConnection: catalogUrl=/Users/mdarveau/workspace/ftk/ftk-dist/ftk-dist-dev/./cfg/cube.xml<br>2010.05.21;10:39:52.618 DEBUG Pool.get: schema "/Users/mdarveau/workspace/ftk/ftk-dist/ftk-dist-dev/./cfg/cube.xml" exists already <br>
2010.05.21;10:39:52.618 DEBUG XmlaHandler.getConnection: returning connection not null<br>2010.05.21;10:39:52.618 DEBUG XmlaHandler.process: time = 1<br>2010.05.21;10:39:52.619 DEBUG XmlaHandler.process: FREE_MEMORY: 411408kb 83.45%<br>
2010.05.21;10:39:52.619 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.619 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br><SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified"><br>
<xsd:element name="root"><br> <xsd:complexType><br> <xsd:sequence><br> <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:simpleType name="uuid"><br> <xsd:restriction base="xsd:string"><br>
<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}"/><br> </xsd:restriction><br> </xsd:simpleType><br> <xsd:complexType name="row"><br>
<xsd:sequence><br> <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="DIMENSION_UNIQUE_NAME" name="DIMENSION_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="HIERARCHY_UNIQUE_NAME" name="HIERARCHY_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="LEVEL_UNIQUE_NAME" name="LEVEL_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="MEMBER_UNIQUE_NAME" name="MEMBER_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="PROPERTY_NAME" name="PROPERTY_NAME" type="xsd:string"/><br>
<xsd:element sql:field="PROPERTY_CAPTION" name="PROPERTY_CAPTION" type="xsd:string"/><br> <xsd:element sql:field="PROPERTY_TYPE" name="PROPERTY_TYPE" type="xsd:short"/><br>
<xsd:element sql:field="DATA_TYPE" name="DATA_TYPE" type="xsd:unsignedShort"/><br> <xsd:element sql:field="PROPERTY_CONTENT_TYPE" name="PROPERTY_CONTENT_TYPE" type="xsd:short" minOccurs="0"/><br>
<xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0"/><br> </xsd:sequence><br> </xsd:complexType><br>
</xsd:schema><br> </root><br> </cxmla:return><br></cxmla:DiscoverResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br><br>2010.05.21;10:39:52.622 DEBUG Invoking validate http header callbacks<br>
2010.05.21;10:39:52.622 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.624 DEBUG XML/A request content<br><?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="" mustUnderstand="1"/><br> </Header><br> <Body><br> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<RequestType>MDSCHEMA_PROPERTIES</RequestType><br> <Restrictions><br> <RestrictionList><br> <PROPERTY_TYPE>2</PROPERTY_TYPE><br>
</RestrictionList><br> </Restrictions><br> <Properties><br> <PropertyList><br> <LocaleIdentifier>1033</LocaleIdentifier><br>
<Content>SchemaData</Content><br> <Format>Tabular</Format><br> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br>
<Catalog>cube</Catalog><br> </PropertyList><br> </Properties><br> </Discover><br> </Body><br></Envelope><br>2010.05.21;10:39:52.625 DEBUG Handling XML/A message header<br>
2010.05.21;10:39:52.625 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.625 DEBUG Handling XML/A message body<br>2010.05.21;10:39:52.625 DEBUG DefaultXmlaRequest.initRestrictions: key="PROPERTY_TYPE", value="2"<br>
2010.05.21;10:39:52.625 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.625 DEBUG DefaultXmlaRequest.initProperties: key="Content", value="SchemaData"<br>
2010.05.21;10:39:52.626 DEBUG DefaultXmlaRequest.initProperties: key="Format", value="Tabular"<br>2010.05.21;10:39:52.626 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.626 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>2010.05.21;10:39:52.626 DEBUG Rowset<init>: restrictedColumn="PROPERTY_TYPE"<br>2010.05.21;10:39:52.627 DEBUG XmlaHandler.process: time = 1<br>
2010.05.21;10:39:52.627 DEBUG XmlaHandler.process: FREE_MEMORY: 408256kb 82.81%<br>2010.05.21;10:39:52.627 DEBUG Invoking callbacks postAction<br>2010.05.21;10:39:52.627 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified"><br>
<xsd:element name="root"><br> <xsd:complexType><br> <xsd:sequence><br> <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:simpleType name="uuid"><br> <xsd:restriction base="xsd:string"><br>
<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}"/><br> </xsd:restriction><br> </xsd:simpleType><br> <xsd:complexType name="row"><br>
<xsd:sequence><br> <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="DIMENSION_UNIQUE_NAME" name="DIMENSION_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="HIERARCHY_UNIQUE_NAME" name="HIERARCHY_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="LEVEL_UNIQUE_NAME" name="LEVEL_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br>
<xsd:element sql:field="MEMBER_UNIQUE_NAME" name="MEMBER_UNIQUE_NAME" type="xsd:string" minOccurs="0"/><br> <xsd:element sql:field="PROPERTY_NAME" name="PROPERTY_NAME" type="xsd:string"/><br>
<xsd:element sql:field="PROPERTY_CAPTION" name="PROPERTY_CAPTION" type="xsd:string"/><br> <xsd:element sql:field="PROPERTY_TYPE" name="PROPERTY_TYPE" type="xsd:short"/><br>
<xsd:element sql:field="DATA_TYPE" name="DATA_TYPE" type="xsd:unsignedShort"/><br> <xsd:element sql:field="PROPERTY_CONTENT_TYPE" name="PROPERTY_CONTENT_TYPE" type="xsd:short" minOccurs="0"/><br>
<xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0"/><br> </xsd:sequence><br> </xsd:complexType><br>
</xsd:schema><br> <row><br> <PROPERTY_NAME>BACK_COLOR</PROPERTY_NAME><br> <PROPERTY_CAPTION>BACK_COLOR</PROPERTY_CAPTION><br> <PROPERTY_TYPE>2</PROPERTY_TYPE><br>
<DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>CELL_EVALUATION_LIST</PROPERTY_NAME><br> <PROPERTY_CAPTION>CELL_EVALUATION_LIST</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>CELL_ORDINAL</PROPERTY_NAME><br> <PROPERTY_CAPTION>CELL_ORDINAL</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>19</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>FORE_COLOR</PROPERTY_NAME><br> <PROPERTY_CAPTION>FORE_COLOR</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>FONT_NAME</PROPERTY_NAME><br> <PROPERTY_CAPTION>FONT_NAME</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>FONT_SIZE</PROPERTY_NAME><br> <PROPERTY_CAPTION>FONT_SIZE</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>FONT_FLAGS</PROPERTY_NAME><br> <PROPERTY_CAPTION>FONT_FLAGS</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>19</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>FORMATTED_VALUE</PROPERTY_NAME><br> <PROPERTY_CAPTION>FORMATTED_VALUE</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>FORMAT_STRING</PROPERTY_NAME><br> <PROPERTY_CAPTION>FORMAT_STRING</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>NON_EMPTY_BEHAVIOR</PROPERTY_NAME><br>
<PROPERTY_CAPTION>NON_EMPTY_BEHAVIOR</PROPERTY_CAPTION><br> <PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br>
<PROPERTY_NAME>SOLVE_ORDER</PROPERTY_NAME><br> <PROPERTY_CAPTION>SOLVE_ORDER</PROPERTY_CAPTION><br> <PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>3</DATA_TYPE><br>
</row><br> <row><br> <PROPERTY_NAME>VALUE</PROPERTY_NAME><br> <PROPERTY_CAPTION>VALUE</PROPERTY_CAPTION><br> <PROPERTY_TYPE>2</PROPERTY_TYPE><br>
<DATA_TYPE>12</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>DATATYPE</PROPERTY_NAME><br> <PROPERTY_CAPTION>DATATYPE</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>130</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>LANGUAGE</PROPERTY_NAME><br> <PROPERTY_CAPTION>LANGUAGE</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>19</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>ACTION_TYPE</PROPERTY_NAME><br> <PROPERTY_CAPTION>ACTION_TYPE</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>19</DATA_TYPE><br> </row><br> <row><br> <PROPERTY_NAME>UPDATEABLE</PROPERTY_NAME><br> <PROPERTY_CAPTION>UPDATEABLE</PROPERTY_CAPTION><br>
<PROPERTY_TYPE>2</PROPERTY_TYPE><br> <DATA_TYPE>19</DATA_TYPE><br> </row><br> </root><br> </cxmla:return><br></cxmla:DiscoverResponse><br></SOAP-ENV:Body><br>
</SOAP-ENV:Envelope><br><br>2010.05.21;10:39:52.640 DEBUG Invoking validate http header callbacks<br>2010.05.21;10:39:52.641 DEBUG Unmarshalling SOAP message<br>2010.05.21;10:39:52.644 DEBUG XML/A request content<br>
<?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"><br>
<Header><br> <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="" mustUnderstand="1"/><br> </Header><br> <Body><br> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><br>
<Command><br> <Statement>SELECT FROM [Station] WHERE ([Measures].[MinNbBikes]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS</Statement><br>
</Command><br> <Properties><br> <PropertyList><br> <Format>Multidimensional</Format><br> <AxisFormat>TupleFormat</AxisFormat><br>
<DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo><br> <LocaleIdentifier>1033</LocaleIdentifier><br> <Catalog>cube</Catalog><br>
<VisualMode>1</VisualMode><br> </PropertyList><br> </Properties><br> </Execute><br> </Body><br></Envelope><br>2010.05.21;10:39:52.645 DEBUG Handling XML/A message header<br>
2010.05.21;10:39:52.645 DEBUG Invoking callbacks preAction<br>2010.05.21;10:39:52.645 DEBUG Handling XML/A message body<br>2010.05.21;10:39:52.645 DEBUG DefaultXmlaRequest.initProperties: key="Format", value="Multidimensional"<br>
2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties: key="AxisFormat", value="TupleFormat"<br>2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties: key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"<br>
2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties: key="LocaleIdentifier", value="1033"<br>2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties: key="Catalog", value="cube"<br>
2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties: key="VisualMode", value="1"<br>2010.05.21;10:39:52.647 DEBUG mdx: "SELECT FROM [Station] WHERE ([Measures].[MinNbBikes]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS"<br>
2010.05.21;10:39:52.647 DEBUG XmlaHandler.getDataSource: dataSourceInfo=Provider=Mondrian;DataSource=cube;<br>2010.05.21;10:39:52.647 DEBUG XmlaHandler.getDataSource: ds.dataSourceInfo=Provider=Mondrian; Jdbc=jdbc:mysql://<a href="http://db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir">db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir</a>; JdbcDrivers=com.mysql.jdbc.Driver<br>
2010.05.21;10:39:52.647 DEBUG XmlaHandler.getConnection: catalogUrl=/Users/mdarveau/workspace/ftk/ftk-dist/ftk-dist-dev/./cfg/cube.xml<br>2010.05.21;10:39:52.647 DEBUG Pool.get: schema "/Users/mdarveau/workspace/ftk/ftk-dist/ftk-dist-dev/./cfg/cube.xml" exists already <br>
2010.05.21;10:39:52.648 DEBUG XmlaHandler.getConnection: returning connection not null<br>2010.05.21;10:39:52.648 DEBUG <br>SELECT FROM [Station] WHERE ([Measures].[MinNbBikes]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS<br>
2010.05.21;10:39:52.648 DEBUG Util.lookupCompound: <a href="http://parent.name">parent.name</a>=Station, category=unknown, names=[Measures].[MinNbBikes]<br>2010.05.21;10:39:52.649 DEBUG RolapCube.lookupChild: name=Station, childname=[Measures] returning elementname=Measures<br>
2010.05.21;10:39:52.649 DEBUG HierarchyBase.lookupChild: name=Measures, childname=[MinNbBikes] returning elementname=MinNbBikes<br>2010.05.21;10:39:52.650 DEBUG DimensionBase.lookupChild: name=Measures, childname=[MinNbBikes] returning elementname=MinNbBikes<br>
2010.05.21;10:39:52.650 DEBUG Util.lookupCompound: found <a href="http://child.name">child.name</a>=MinNbBikes, child.class=mondrian.rolap.RolapBaseCubeMeasure<br>2010.05.21;10:39:52.650 DEBUG RolapCube.getUsages: name=Measures<br>
2010.05.21;10:39:52.651 DEBUG select from [Station]<br>where [Measures].[MinNbBikes]<br><br>2010.05.21;10:39:52.651 DEBUG 23: select from [Station]<br>where [Measures].[MinNbBikes]<br><br>2010.05.21;10:39:52.651 DEBUG RolapCube.getUsages: name=Measures<br>
2010.05.21;10:39:52.652 DEBUG FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000000000000000000<br><br>2010.05.21;10:39:52.652 DEBUG RolapCube.getUsages: name=Measures<br>2010.05.21;10:39:52.654 DEBUG NO MATCH: BikeStationFact<br>
foreign=0x0000000000000000000000000000000000000000000000000000000000000000<br> measure=0x0000000000000000000000000000000000000000100000000000000000000000<br><br>2010.05.21;10:39:52.654 DEBUG generateSqlQuery: sql=select min(`BikeStationFact`.`nbBike`) as `m0` from `BikeStationFact` as `BikeStationFact`<br>
2010.05.21;10:39:52.656 DEBUG 170: Segment.load: executing sql [select min(`BikeStationFact`.`nbBike`) as `m0` from `BikeStationFact` as `BikeStationFact`]<br>2010.05.21;10:39:52.666 DEBUG 170: , exec 9 ms<br>2010.05.21;10:39:52.666 DEBUG Segment.load: executing sql [select min(`BikeStationFact`.`nbBike`) as `m0` from `BikeStationFact` as `BikeStationFact`], exec 9 ms<br>
2010.05.21;10:39:52.673 DEBUG 170: , exec+fetch 16 ms, 0 rows<br>2010.05.21;10:39:52.674 DEBUG Segment.load: done executing sql [select min(`BikeStationFact`.`nbBike`) as `m0` from `BikeStationFact` as `BikeStationFact`], exec+fetch 16 ms, 0 rows<br>
2010.05.21;10:39:52.674 DEBUG Batch.loadAggregation (millis) 22<br>2010.05.21;10:39:52.674 DEBUG loadAggregation (millis): 22<br>2010.05.21;10:39:52.675 DEBUG RolapResult<init>: FREE_MEMORY: 405113kb 82.17%<br>2010.05.21;10:39:52.675 DEBUG 23: exec: 24 ms<br>
2010.05.21;10:39:52.676 DEBUG RolapCube.getUsages: name=Measures<br>2010.05.21;10:39:52.676 DEBUG XmlaHandler.process: time = 30<br>2010.05.21;10:39:52.676 DEBUG XmlaHandler.process: FREE_MEMORY: 405113kb 82.17%<br>2010.05.21;10:39:52.677 DEBUG Invoking callbacks postAction<br>
2010.05.21;10:39:52.677 DEBUG XML/A response content<br><?xml version="1.0" encoding="ISO-8859-1"?><br><SOAP-ENV:Envelope xmlns:SOAP-ENV="<a href="http://schemas.xmlsoap.org/soap/envelope/">http://schemas.xmlsoap.org/soap/envelope/</a>" SOAP-ENV:encodingStyle="<a href="http://schemas.xmlsoap.org/soap/encoding/">http://schemas.xmlsoap.org/soap/encoding/</a>" ><br>
<SOAP-ENV:Header><br><Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis" /></SOAP-ENV:Header><br><SOAP-ENV:Body><br><cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"><br>
<cxmla:return><br> <root xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"><br>
<xsd:schema xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" targetNamespace="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified"><br>
<xsd:complexType name="MemberType"><br> <xsd:sequence><br> <xsd:element name="UName" type="xsd:string"/><br> <xsd:element name="Caption" type="xsd:string"/><br>
<xsd:element name="LName" type="xsd:string"/><br> <xsd:element name="LNum" type="xsd:unsignedInt"/><br> <xsd:element name="DisplayInfo" type="xsd:unsignedInt"/><br>
<xsd:sequence maxOccurs="unbounded" minOccurs="0"><br> <xsd:any processContents="lax" maxOccurs="unbounded"/><br> </xsd:sequence><br>
</xsd:sequence><br> <xsd:attribute name="Hierarchy" type="xsd:string"/><br> </xsd:complexType><br> <xsd:complexType name="PropType"><br>
<xsd:attribute name="name" type="xsd:string"/><br> </xsd:complexType><br> <xsd:complexType name="TupleType"><br> <xsd:sequence maxOccurs="unbounded"><br>
<xsd:element name="Member" type="MemberType"/><br> </xsd:sequence><br> </xsd:complexType><br> <xsd:complexType name="MembersType"><br>
<xsd:sequence maxOccurs="unbounded"><br> <xsd:element name="Member" type="MemberType"/><br> </xsd:sequence><br> <xsd:attribute name="Hierarchy" type="xsd:string"/><br>
</xsd:complexType><br> <xsd:complexType name="TuplesType"><br> <xsd:sequence maxOccurs="unbounded"><br> <xsd:element name="Tuple" type="TupleType"/><br>
</xsd:sequence><br> </xsd:complexType><br> <xsd:complexType name="CrossProductType"><br> <xsd:sequence><br> <xsd:choice minOccurs="0" maxOccurs="unbounded"><br>
<xsd:element name="Members" type="MembersType"/><br> <xsd:element name="Tuples" type="TuplesType"/><br> </xsd:choice><br> </xsd:sequence><br>
<xsd:attribute name="Size" type="xsd:unsignedInt"/><br> </xsd:complexType><br> <xsd:complexType name="OlapInfo"><br> <xsd:sequence><br>
<xsd:element name="CubeInfo"><br> <xsd:complexType><br> <xsd:sequence><br> <xsd:element name="Cube" maxOccurs="unbounded"><br>
<xsd:complexType><br> <xsd:sequence><br> <xsd:element name="CubeName" type="xsd:string"/><br> </xsd:sequence><br>
</xsd:complexType><br> </xsd:element><br> </xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:element name="AxesInfo"><br>
<xsd:complexType><br> <xsd:sequence><br> <xsd:element name="AxisInfo" maxOccurs="unbounded"><br> <xsd:complexType><br>
<xsd:sequence><br> <xsd:element name="HierarchyInfo" minOccurs="0" maxOccurs="unbounded"><br> <xsd:complexType><br>
<xsd:sequence><br> <xsd:sequence maxOccurs="unbounded"><br> <xsd:element name="UName" type="PropType"/><br>
<xsd:element name="Caption" type="PropType"/><br> <xsd:element name="LName" type="PropType"/><br> <xsd:element name="LNum" type="PropType"/><br>
<xsd:element name="DisplayInfo" type="PropType" minOccurs="0" maxOccurs="unbounded"/><br> </xsd:sequence><br>
<xsd:sequence><br> <xsd:any processContents="lax" minOccurs="0" maxOccurs="unbounded"/><br> </xsd:sequence><br>
</xsd:sequence><br> <xsd:attribute name="name" type="xsd:string" use="required"/><br> </xsd:complexType><br>
</xsd:element><br> </xsd:sequence><br> <xsd:attribute name="name" type="xsd:string"/><br> </xsd:complexType><br>
</xsd:element><br> </xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> <xsd:element name="CellInfo"><br>
<xsd:complexType><br> <xsd:sequence><br> <xsd:sequence minOccurs="0" maxOccurs="unbounded"><br> <xsd:choice><br>
<xsd:element name="Value" type="PropType"/><br> <xsd:element name="FmtValue" type="PropType"/><br> <xsd:element name="BackColor" type="PropType"/><br>
<xsd:element name="ForeColor" type="PropType"/><br> <xsd:element name="FontName" type="PropType"/><br> <xsd:element name="FontSize" type="PropType"/><br>
<xsd:element name="FontFlags" type="PropType"/><br> <xsd:element name="FormatString" type="PropType"/><br> <xsd:element name="NonEmptyBehavior" type="PropType"/><br>
<xsd:element name="SolveOrder" type="PropType"/><br> <xsd:element name="Updateable" type="PropType"/><br> <xsd:element name="Visible" type="PropType"/><br>
<xsd:element name="Expression" type="PropType"/><br> </xsd:choice><br> </xsd:sequence><br> <xsd:sequence maxOccurs="unbounded" minOccurs="0"><br>
<xsd:any processContents="lax" maxOccurs="unbounded"/><br> </xsd:sequence><br> </xsd:sequence><br> </xsd:complexType><br>
</xsd:element><br> </xsd:sequence><br> </xsd:complexType><br> <xsd:complexType name="Axes"><br> <xsd:sequence maxOccurs="unbounded"><br>
<xsd:element name="Axis"><br> <xsd:complexType><br> <xsd:choice minOccurs="0" maxOccurs="unbounded"><br> <xsd:element name="CrossProduct" type="CrossProductType"/><br>
<xsd:element name="Tuples" type="TuplesType"/><br> <xsd:element name="Members" type="MembersType"/><br> </xsd:choice><br>
<xsd:attribute name="name" type="xsd:string"/><br> </xsd:complexType><br> </xsd:element><br> </xsd:sequence><br> </xsd:complexType><br>
<xsd:complexType name="CellData"><br> <xsd:sequence><br> <xsd:element name="Cell" minOccurs="0" maxOccurs="unbounded"><br> <xsd:complexType><br>
<xsd:sequence maxOccurs="unbounded"><br> <xsd:choice><br> <xsd:element name="Value"/><br> <xsd:element name="FmtValue" type="xsd:string"/><br>
<xsd:element name="BackColor" type="xsd:unsignedInt"/><br> <xsd:element name="ForeColor" type="xsd:unsignedInt"/><br> <xsd:element name="FontName" type="xsd:string"/><br>
<xsd:element name="FontSize" type="xsd:unsignedShort"/><br> <xsd:element name="FontFlags" type="xsd:unsignedInt"/><br> <xsd:element name="FormatString" type="xsd:string"/><br>
<xsd:element name="NonEmptyBehavior" type="xsd:unsignedShort"/><br> <xsd:element name="SolveOrder" type="xsd:unsignedInt"/><br> <xsd:element name="Updateable" type="xsd:unsignedInt"/><br>
<xsd:element name="Visible" type="xsd:unsignedInt"/><br> <xsd:element name="Expression" type="xsd:string"/><br> </xsd:choice><br>
</xsd:sequence><br> <xsd:attribute name="CellOrdinal" type="xsd:unsignedInt" use="required"/><br> </xsd:complexType><br> </xsd:element><br>
</xsd:sequence><br> </xsd:complexType><br> <xsd:element name="root"><br> <xsd:complexType><br> <xsd:sequence maxOccurs="unbounded"><br>
<xsd:element name="OlapInfo" type="OlapInfo"/><br> <xsd:element name="Axes" type="Axes"/><br> <xsd:element name="CellData" type="CellData"/><br>
</xsd:sequence><br> </xsd:complexType><br> </xsd:element><br> </xsd:schema><br> <OlapInfo><br> <CubeInfo><br> <Cube><br> <CubeName>Station</CubeName><br>
</Cube><br> </CubeInfo><br> <AxesInfo><br> <AxisInfo name="SlicerAxis"><br> <HierarchyInfo name="Measures"><br> <UName name="[Measures].[MEMBER_UNIQUE_NAME]"/><br>
<Caption name="[Measures].[MEMBER_CAPTION]"/><br> <LName name="[Measures].[LEVEL_UNIQUE_NAME]"/><br> <LNum name="[Measures].[LEVEL_NUMBER]"/><br>
<DisplayInfo name="[Measures].[DISPLAY_INFO]"/><br> </HierarchyInfo><br> </AxisInfo><br> </AxesInfo><br> <CellInfo><br> <Value name="VALUE"/><br>
<FormatString name="FORMAT_STRING"/><br> </CellInfo><br> </OlapInfo><br> <Axes><br> <Axis name="SlicerAxis"><br> <Tuples><br>
<Tuple><br> <Member Hierarchy="Measures"><br> <UName>[Measures].[MinNbBikes]</UName><br> <Caption>Min Nb Bikes</Caption><br>
<LName>[Measures].[MeasuresLevel]</LName><br> <LNum>0</LNum><br> <DisplayInfo>0</DisplayInfo><br> </Member><br> </Tuple><br>
</Tuples><br> </Axis><br> </Axes><br> <CellData><br> <Cell CellOrdinal="0"><br> <Value xsi:type="xsd:double">0</Value><br>
<FormatString/><br> </Cell><br> </CellData><br> </root><br> </cxmla:return><br></cxmla:ExecuteResponse><br></SOAP-ENV:Body><br></SOAP-ENV:Envelope><br>
<br>The weirdest thing is some cubes are working well and then all of a student I start getting this error.<br><br>Any help would be greatly appreciated.<br><br>Manuel Darveau<br>