[Mondrian] Re: Excel + refresh
Manuel Darveau
manueldarveau at gmail.com
Fri May 21 12:33:56 EDT 2010
I tried downgrading to 3.2.13343 and I get:
2010.05.21;12:32:36.409 ERROR Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results
error
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2836)
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:548)
at
mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:426)
at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:330)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
assert failed: parentExp != null || nullParentValue == null
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813)
at mondrian.olap.Util.newInternal(Util.java:1492)
at mondrian.olap.Util.assertTrue(Util.java:1484)
at mondrian.olap.Util.assertPrecondition(Util.java:1554)
at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:162)
at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:314)
at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:255)
at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:122)
at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:732)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:172)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:203)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:424)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:308)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:219)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:53)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:958)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:74)
at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2907)
at
mondrian.xmla.RowsetDefinition$MdschemaCubesRowset.populate(RowsetDefinition.java:3740)
at mondrian.xmla.Rowset.unparse(Rowset.java:167)
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2831)
... 18 more
Manuel Darveau
On Fri, May 21, 2010 at 10:51 AM, Manuel Darveau <manueldarveau at gmail.com>wrote:
> Hi,
>
> 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.
> I didn't saw anything special in mondrian's log so I configured log4j in
> DEBUG and got this:
>
> 2010.05.21;10:39:52.405 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.406 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.408 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Body>
> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
> <RequestType>DISCOVER_DATASOURCES</RequestType>
> <Restrictions>
> <RestrictionList/>
> </Restrictions>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
> <Content>SchemaData</Content>
> <Format>Tabular</Format>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Discover>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.408 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.408 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.408 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
> key="Content", value="SchemaData"
> 2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
> key="Format", value="Tabular"
> 2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: time = 0
> 2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: FREE_MEMORY: 131433kb
> 26.69%
> 2010.05.21;10:39:52.409 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.410 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> </SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:DiscoverResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> elementFormDefault="qualified">
> <xsd:element name="root">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="row" type="row" minOccurs="0"
> maxOccurs="unbounded"/>
> </xsd: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 sql:field="DataSourceName" name="DataSourceName"
> type="xsd:string"/>
> <xsd:element sql:field="DataSourceDescription"
> name="DataSourceDescription" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="URL" name="URL" type="xsd:string"
> minOccurs="0"/>
> <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="ProviderName" name="ProviderName"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="ProviderType" name="ProviderType"
> type="xsd:string" maxOccurs="unbounded"/>
> <xsd:element sql:field="AuthenticationMode"
> name="AuthenticationMode" type="xsd:string"/>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
> <row>
> <DataSourceName>Provider=Mondrian;DataSource=cube;</DataSourceName>
> <DataSourceDescription>Data Warehouse</DataSourceDescription>
> <URL>http://localhost:8082/datawarehouse/xmla</URL>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <ProviderName>Mondrian</ProviderName>
> <ProviderType>MDP</ProviderType>
> <AuthenticationMode>Unauthenticated</AuthenticationMode>
> </row>
> </root>
> </cxmla:return>
> </cxmla:DiscoverResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.417 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.418 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.420 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
> mustUnderstand="1"/>
> </Header>
> <Body>
> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
> <Command>
> <Statement/>
> </Command>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Execute>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.421 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.421 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.422 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.423 DEBUG mdx: ""
> 2010.05.21;10:39:52.423 DEBUG XmlaHandler.process: time = 0
> 2010.05.21;10:39:52.424 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
> 26.21%
> 2010.05.21;10:39:52.424 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.424 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:ExecuteResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> elementFormDefault="qualified">
> <xsd:element name="root"/>
> </xsd:schema>
> </root>
> </cxmla:return>
> </cxmla:ExecuteResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.429 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.429 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.431 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
> mustUnderstand="1"/>
> </Header>
> <Body>
> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
> <Command>
> <Statement/>
> </Command>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Execute>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.431 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.431 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.432 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.432 DEBUG mdx: ""
> 2010.05.21;10:39:52.432 DEBUG XmlaHandler.process: time = 0
> 2010.05.21;10:39:52.433 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
> 26.21%
> 2010.05.21;10:39:52.433 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.433 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:ExecuteResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> elementFormDefault="qualified">
> <xsd:element name="root"/>
> </xsd:schema>
> </root>
> </cxmla:return>
> </cxmla:ExecuteResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.435 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.435 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.437 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <Session xmlns="urn:schemas-microsoft-com:xml-analysis"
> SessionId="" mustUnderstand="1"/>
> </Header>
> <Body>
> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
> <RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType>
> <Restrictions>
> <RestrictionList/>
> </Restrictions>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
> <Content>SchemaData</Content>
> <Format>Tabular</Format>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Discover>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.437 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.438 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.438 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
> key="Content", value="SchemaData"
> 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
> key="Format", value="Tabular"
> 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.440 DEBUG XmlaHandler.process: time = 1
> 2010.05.21;10:39:52.442 DEBUG XmlaHandler.process: FREE_MEMORY: 126748kb
> 25.74%
> 2010.05.21;10:39:52.442 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.442 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:DiscoverResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> elementFormDefault="qualified">
> <xsd:element name="root">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="row" type="row" minOccurs="0"
> maxOccurs="unbounded"/>
> </xsd: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 sql:field="SchemaName" name="SchemaName"
> type="xsd:string"/>
> <xsd:element sql:field="SchemaGuid" name="SchemaGuid"
> type="uuid" minOccurs="0"/>
> <xsd:element sql:field="Restrictions" name="Restrictions"
> minOccurs="0" maxOccurs="unbounded">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="Name" type="xsd:string"
> sql:field="Name"/>
> <xsd:element name="Type" type="xsd:string"
> sql:field="Type"/>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:element>
> <xsd:element sql:field="Description" name="Description"
> type="xsd:string"/>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
> <row>
> <SchemaName>DBSCHEMA_CATALOGS</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns information about literals supported by the
> provider.</Description>
> </row>
> <row>
> <SchemaName>DBSCHEMA_COLUMNS</SchemaName>
> <Restrictions>
> <Name>TABLE_CATALOG</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_SCHEMA</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>COLUMN_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>DBSCHEMA_PROVIDER_TYPES</SchemaName>
> <Restrictions>
> <Name>DATA_TYPE</Name>
> <Type>xsd:unsignedShort</Type>
> </Restrictions>
> <Restrictions>
> <Name>BEST_MATCH</Name>
> <Type>xsd:boolean</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>DBSCHEMA_SCHEMATA</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_OWNER</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>DBSCHEMA_TABLES</SchemaName>
> <Restrictions>
> <Name>TABLE_CATALOG</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_SCHEMA</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_TYPE</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>DBSCHEMA_TABLES_INFO</SchemaName>
> <Restrictions>
> <Name>TABLE_CATALOG</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_SCHEMA</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TABLE_TYPE</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>DISCOVER_DATASOURCES</SchemaName>
> <Restrictions>
> <Name>DataSourceName</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>URL</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>ProviderName</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>ProviderType</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>AuthenticationMode</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns a list of XML for Analysis data sources
> available on the server or Web Service.</Description>
> </row>
> <row>
> <SchemaName>DISCOVER_ENUMERATORS</SchemaName>
> <Restrictions>
> <Name>EnumName</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns a list of names, data types, and enumeration
> values for enumerators supported by the provider of a specific data
> source.</Description>
> </row>
> <row>
> <SchemaName>DISCOVER_KEYWORDS</SchemaName>
> <Restrictions>
> <Name>Keyword</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns an XML list of keywords reserved by the
> provider.</Description>
> </row>
> <row>
> <SchemaName>DISCOVER_LITERALS</SchemaName>
> <Restrictions>
> <Name>LiteralName</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns information about literals supported by the
> provider.</Description>
> </row>
> <row>
> <SchemaName>DISCOVER_PROPERTIES</SchemaName>
> <Restrictions>
> <Name>PropertyName</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns a list of information and values about the
> requested properties that are supported by the specified data source
> provider.</Description>
> </row>
> <row>
> <SchemaName>DISCOVER_SCHEMA_ROWSETS</SchemaName>
> <Restrictions>
> <Name>SchemaName</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description>Returns the names, values, and other information of
> all supported RequestType enumeration values.</Description>
> </row>
> <row>
> <SchemaName>MDSCHEMA_ACTIONS</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>ACTION_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>COORDINATE</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>COORDINATE_TYPE</Name>
> <Type>xsd:int</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_CUBES</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_TYPE</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_DIMENSIONS</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>DIMENSION_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>DIMENSION_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_FUNCTIONS</SchemaName>
> <Restrictions>
> <Name>FUNCTION_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>ORIGIN</Name>
> <Type>xsd:int</Type>
> </Restrictions>
> <Restrictions>
> <Name>INTERFACE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>LIBRARY_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_HIERARCHIES</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>DIMENSION_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>HIERARCHY_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>HIERARCHY_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_LEVELS</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>DIMENSION_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>HIERARCHY_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>LEVEL_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>LEVEL_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_MEASURES</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEASURE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEASURE_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_MEMBERS</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>DIMENSION_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>HIERARCHY_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>LEVEL_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>LEVEL_NUMBER</Name>
> <Type>xsd:unsignedInt</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEMBER_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEMBER_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEMBER_TYPE</Name>
> <Type>xsd:int</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEMBER_CAPTION</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>TREE_OP</Name>
> <Type>xsd:int</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_PROPERTIES</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>DIMENSION_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>HIERARCHY_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>LEVEL_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>MEMBER_UNIQUE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>PROPERTY_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>PROPERTY_TYPE</Name>
> <Type>xsd:short</Type>
> </Restrictions>
> <Restrictions>
> <Name>PROPERTY_CONTENT_TYPE</Name>
> <Type>xsd:short</Type>
> </Restrictions>
> <Description/>
> </row>
> <row>
> <SchemaName>MDSCHEMA_SETS</SchemaName>
> <Restrictions>
> <Name>CATALOG_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCHEMA_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>CUBE_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SET_NAME</Name>
> <Type>xsd:string</Type>
> </Restrictions>
> <Restrictions>
> <Name>SCOPE</Name>
> <Type>xsd:int</Type>
> </Restrictions>
> <Description/>
> </row>
> </root>
> </cxmla:return>
> </cxmla:DiscoverResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.451 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.451 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.454 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <Session xmlns="urn:schemas-microsoft-com:xml-analysis"
> SessionId="" mustUnderstand="1"/>
> </Header>
> <Body>
> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
> <RequestType>DISCOVER_PROPERTIES</RequestType>
> <Restrictions>
> <RestrictionList/>
> </Restrictions>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
> <Content>SchemaData</Content>
> <Format>Tabular</Format>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Discover>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.454 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.454 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.454 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.454 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.454 DEBUG DefaultXmlaRequest.initProperties:
> key="Content", value="SchemaData"
> 2010.05.21;10:39:52.454 DEBUG DefaultXmlaRequest.initProperties:
> key="Format", value="Tabular"
> 2010.05.21;10:39:52.455 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.455 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.456 DEBUG XmlaHandler.process: time = 1
> 2010.05.21;10:39:52.456 DEBUG XmlaHandler.process: FREE_MEMORY: 125219kb
> 25.42%
> 2010.05.21;10:39:52.456 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.456 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:DiscoverResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> elementFormDefault="qualified">
> <xsd:element name="root">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="row" type="row" minOccurs="0"
> maxOccurs="unbounded"/>
> </xsd: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 sql:field="PropertyName" name="PropertyName"
> type="xsd:string"/>
> <xsd:element sql:field="PropertyDescription"
> name="PropertyDescription" type="xsd:string"/>
> <xsd:element sql:field="PropertyType" name="PropertyType"
> type="xsd:string"/>
> <xsd:element sql:field="PropertyAccessType"
> name="PropertyAccessType" type="xsd:string"/>
> <xsd:element sql:field="IsRequired" name="IsRequired"
> type="xsd:boolean"/>
> <xsd:element sql:field="Value" name="Value" type="xsd:string"/>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
> <row>
> <PropertyName>AxisFormat</PropertyName>
> <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>
> <PropertyType>Enumeration</PropertyType>
> <PropertyAccessType>Write</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>BeginRange</PropertyName>
> <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.) 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. The default value for this property
> is -1.</PropertyDescription>
> <PropertyType>Integer</PropertyType>
> <PropertyAccessType>Write</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>-1</Value>
> </row>
> <row>
> <PropertyName>Catalog</PropertyName>
> <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. 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. The default value for this property is an empty
> string.</PropertyDescription>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>Content</PropertyName>
> <PropertyDescription>An enumerator that specifies what type of data
> is returned in the result set. None: Allows the structure of the command
> to be verified, but not executed. Analogous to using Prepare to check
> syntax, and so on. Schema: Contains the XML schema (which indicates
> column information, and so on) that relates to the requested
> query. Data: Contains only the data that was requested. SchemaData:
> Returns both the schema information as well as the
> data.</PropertyDescription>
> <PropertyType>EnumString</PropertyType>
> <PropertyAccessType>Write</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>SchemaData</Value>
> </row>
> <row>
> <PropertyName>Cube</PropertyName>
> <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>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>DataSourceInfo</PropertyName>
> <PropertyDescription>A string containing provider specific
> information, required to access the data source.</PropertyDescription>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>Deep</PropertyName>
> <PropertyDescription>In an MDSCHEMA_CUBES request, whether to
> include sub-elements (dimensions, hierarchies, levels, measures, named sets)
> of each cube.</PropertyDescription>
> <PropertyType>Boolean</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>EndRange</PropertyName>
> <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>
> <PropertyType>Integer</PropertyType>
> <PropertyAccessType>Write</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>-1</Value>
> </row>
> <row>
> <PropertyName>Format</PropertyName>
> <PropertyDescription>Enumerator that determines the format of the
> returned result set. Values include: 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. Multidimensional:
> Indicates that the result set will use the MDDataSet format (Execute method
> only). 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>
> <PropertyType>EnumString</PropertyType>
> <PropertyAccessType>Write</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>Native</Value>
> </row>
> <row>
> <PropertyName>LocaleIdentifier</PropertyName>
> <PropertyDescription>Use this to read or set the numeric locale
> identifier for this request. The default is provider-specific. For the
> complete hexadecimal list of language identifiers, search on "Language
> Identifiers" in the MSDN Library at http://www.msdn.microsoft.com
> .</PropertyDescription>
> <PropertyType>UnsignedInteger</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>None</Value>
> </row>
> <row>
> <PropertyName>MDXSupport</PropertyName>
> <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>
> <PropertyType>EnumString</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>Core</Value>
> </row>
> <row>
> <PropertyName>Password</PropertyName>
> <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>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>ProviderName</PropertyName>
> <PropertyDescription>The XML for Analysis Provider
> name.</PropertyDescription>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>Mondrian XML for Analysis Provider</Value>
> </row>
> <row>
> <PropertyName>ProviderVersion</PropertyName>
> <PropertyDescription>The version of the Mondrian XMLA
> Provider</PropertyDescription>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>3.2.0.13583</Value>
> </row>
> <row>
> <PropertyName>ResponseMimeType</PropertyName>
> <PropertyDescription>Accepted mime type for RPC response; accepted
> are 'text/xml' (default), 'application/xml' (equivalent to
> 'text/xml'), or 'application/json'. If not specified, value
> in the 'Accept' header of the HTTP request is
> used.</PropertyDescription>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>None</Value>
> </row>
> <row>
> <PropertyName>StateSupport</PropertyName>
> <PropertyDescription>Property that specifies the degree of support
> in the provider for state. For information about state in XML for Analysis,
> see "Support for Statefulness in XML for Analysis." Minimum
> enumeration values are as follows: None - No support for sessions or
> stateful operations. Sessions - Provider supports
> sessions.</PropertyDescription>
> <PropertyType>EnumString</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>None</Value>
> </row>
> <row>
> <PropertyName>Timeout</PropertyName>
> <PropertyDescription>A numeric time-out specifying in seconds the
> amount of time to wait for a request to be successful.</PropertyDescription>
> <PropertyType>UnsignedInteger</PropertyType>
> <PropertyAccessType>ReadWrite</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>Undefined</Value>
> </row>
> <row>
> <PropertyName>UserName</PropertyName>
> <PropertyDescription>Returns the UserName the server associates
> with the command. 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>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>VisualMode</PropertyName>
> <PropertyDescription>This property is equivalent to the OLE DB
> property, MDPROP_VISUALMODE. The default value for this property is zero
> (0), equivalent to DBPROPVAL_VISUAL_MODE_DEFAULT.</PropertyDescription>
> <PropertyType>Enumeration</PropertyType>
> <PropertyAccessType>Write</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>1</Value>
> </row>
> <row>
> <PropertyName>TableFields</PropertyName>
> <PropertyDescription>List of fields to return for
> drill-through. The default value of this property is the empty string,in
> which case, all fields are returned.</PropertyDescription>
> <PropertyType>string</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value/>
> </row>
> <row>
> <PropertyName>AdvancedFlag</PropertyName>
> <PropertyDescription/>
> <PropertyType>Boolean</PropertyType>
> <PropertyAccessType>Read</PropertyAccessType>
> <IsRequired>false</IsRequired>
> <Value>false</Value>
> </row>
> </root>
> </cxmla:return>
> </cxmla:DiscoverResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.554 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.555 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.605 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
> mustUnderstand="1"/>
> </Header>
> <Body>
> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
> <Command>
> <Statement/>
> </Command>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Execute>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.606 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.606 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.606 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.607 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.607 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.607 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.608 DEBUG mdx: ""
> 2010.05.21;10:39:52.608 DEBUG XmlaHandler.process: time = 0
> 2010.05.21;10:39:52.608 DEBUG XmlaHandler.process: FREE_MEMORY: 411408kb
> 83.45%
> 2010.05.21;10:39:52.608 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.609 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:ExecuteResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> elementFormDefault="qualified">
> <xsd:element name="root"/>
> </xsd:schema>
> </root>
> </cxmla:return>
> </cxmla:ExecuteResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.611 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.612 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.616 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <Session xmlns="urn:schemas-microsoft-com:xml-analysis"
> SessionId="" mustUnderstand="1"/>
> </Header>
> <Body>
> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
> <RequestType>MDSCHEMA_PROPERTIES</RequestType>
> <Restrictions>
> <RestrictionList>
> <CUBE_NAME>This restriction should never
> match</CUBE_NAME>
> </RestrictionList>
> </Restrictions>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
> <Content>SchemaData</Content>
> <Format>Tabular</Format>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Discover>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.616 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.616 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.616 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.616 DEBUG DefaultXmlaRequest.initRestrictions:
> key="CUBE_NAME", value="This restriction should never match"
> 2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties:
> key="Content", value="SchemaData"
> 2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties:
> key="Format", value="Tabular"
> 2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.617 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.617 DEBUG Rowset<init>: restrictedColumn="CUBE_NAME"
> 2010.05.21;10:39:52.618 DEBUG XmlaHandler.getDataSource:
> dataSourceInfo=Provider=Mondrian;DataSource=cube;
> 2010.05.21;10:39:52.618 DEBUG XmlaHandler.getDataSource:
> ds.dataSourceInfo=Provider=Mondrian; Jdbc=jdbc:mysql://
> db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir;
> JdbcDrivers=com.mysql.jdbc.Driver
> 2010.05.21;10:39:52.618 DEBUG XmlaHandler.getConnection:
> catalogUrl=/Users/mdarveau/workspace/ftk/ftk-dist/ftk-dist-dev/./cfg/cube.xml
> 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
> 2010.05.21;10:39:52.618 DEBUG XmlaHandler.getConnection: returning
> connection not null
> 2010.05.21;10:39:52.618 DEBUG XmlaHandler.process: time = 1
> 2010.05.21;10:39:52.619 DEBUG XmlaHandler.process: FREE_MEMORY: 411408kb
> 83.45%
> 2010.05.21;10:39:52.619 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.619 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:DiscoverResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> elementFormDefault="qualified">
> <xsd:element name="root">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="row" type="row" minOccurs="0"
> maxOccurs="unbounded"/>
> </xsd: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 sql:field="CATALOG_NAME" name="CATALOG_NAME"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="DIMENSION_UNIQUE_NAME"
> name="DIMENSION_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="HIERARCHY_UNIQUE_NAME"
> name="HIERARCHY_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="LEVEL_UNIQUE_NAME"
> name="LEVEL_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="MEMBER_UNIQUE_NAME"
> name="MEMBER_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="PROPERTY_NAME" name="PROPERTY_NAME"
> type="xsd:string"/>
> <xsd:element sql:field="PROPERTY_CAPTION"
> name="PROPERTY_CAPTION" type="xsd:string"/>
> <xsd:element sql:field="PROPERTY_TYPE" name="PROPERTY_TYPE"
> type="xsd:short"/>
> <xsd:element sql:field="DATA_TYPE" name="DATA_TYPE"
> type="xsd:unsignedShort"/>
> <xsd:element sql:field="PROPERTY_CONTENT_TYPE"
> name="PROPERTY_CONTENT_TYPE" type="xsd:short" minOccurs="0"/>
> <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION"
> type="xsd:string" minOccurs="0"/>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
> </root>
> </cxmla:return>
> </cxmla:DiscoverResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.622 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.622 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.624 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <Session xmlns="urn:schemas-microsoft-com:xml-analysis"
> SessionId="" mustUnderstand="1"/>
> </Header>
> <Body>
> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
> <RequestType>MDSCHEMA_PROPERTIES</RequestType>
> <Restrictions>
> <RestrictionList>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> </RestrictionList>
> </Restrictions>
> <Properties>
> <PropertyList>
> <LocaleIdentifier>1033</LocaleIdentifier>
> <Content>SchemaData</Content>
> <Format>Tabular</Format>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <Catalog>cube</Catalog>
> </PropertyList>
> </Properties>
> </Discover>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.625 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.625 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.625 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.625 DEBUG DefaultXmlaRequest.initRestrictions:
> key="PROPERTY_TYPE", value="2"
> 2010.05.21;10:39:52.625 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.625 DEBUG DefaultXmlaRequest.initProperties:
> key="Content", value="SchemaData"
> 2010.05.21;10:39:52.626 DEBUG DefaultXmlaRequest.initProperties:
> key="Format", value="Tabular"
> 2010.05.21;10:39:52.626 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.626 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.626 DEBUG Rowset<init>:
> restrictedColumn="PROPERTY_TYPE"
> 2010.05.21;10:39:52.627 DEBUG XmlaHandler.process: time = 1
> 2010.05.21;10:39:52.627 DEBUG XmlaHandler.process: FREE_MEMORY: 408256kb
> 82.81%
> 2010.05.21;10:39:52.627 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.627 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:DiscoverResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
> elementFormDefault="qualified">
> <xsd:element name="root">
> <xsd:complexType>
> <xsd:sequence>
> <xsd:element name="row" type="row" minOccurs="0"
> maxOccurs="unbounded"/>
> </xsd: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 sql:field="CATALOG_NAME" name="CATALOG_NAME"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME"
> type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="DIMENSION_UNIQUE_NAME"
> name="DIMENSION_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="HIERARCHY_UNIQUE_NAME"
> name="HIERARCHY_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="LEVEL_UNIQUE_NAME"
> name="LEVEL_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="MEMBER_UNIQUE_NAME"
> name="MEMBER_UNIQUE_NAME" type="xsd:string" minOccurs="0"/>
> <xsd:element sql:field="PROPERTY_NAME" name="PROPERTY_NAME"
> type="xsd:string"/>
> <xsd:element sql:field="PROPERTY_CAPTION"
> name="PROPERTY_CAPTION" type="xsd:string"/>
> <xsd:element sql:field="PROPERTY_TYPE" name="PROPERTY_TYPE"
> type="xsd:short"/>
> <xsd:element sql:field="DATA_TYPE" name="DATA_TYPE"
> type="xsd:unsignedShort"/>
> <xsd:element sql:field="PROPERTY_CONTENT_TYPE"
> name="PROPERTY_CONTENT_TYPE" type="xsd:short" minOccurs="0"/>
> <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION"
> type="xsd:string" minOccurs="0"/>
> </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
> <row>
> <PROPERTY_NAME>BACK_COLOR</PROPERTY_NAME>
> <PROPERTY_CAPTION>BACK_COLOR</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>CELL_EVALUATION_LIST</PROPERTY_NAME>
> <PROPERTY_CAPTION>CELL_EVALUATION_LIST</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>CELL_ORDINAL</PROPERTY_NAME>
> <PROPERTY_CAPTION>CELL_ORDINAL</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>19</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>FORE_COLOR</PROPERTY_NAME>
> <PROPERTY_CAPTION>FORE_COLOR</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>FONT_NAME</PROPERTY_NAME>
> <PROPERTY_CAPTION>FONT_NAME</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>FONT_SIZE</PROPERTY_NAME>
> <PROPERTY_CAPTION>FONT_SIZE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>FONT_FLAGS</PROPERTY_NAME>
> <PROPERTY_CAPTION>FONT_FLAGS</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>19</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>FORMATTED_VALUE</PROPERTY_NAME>
> <PROPERTY_CAPTION>FORMATTED_VALUE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>FORMAT_STRING</PROPERTY_NAME>
> <PROPERTY_CAPTION>FORMAT_STRING</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>NON_EMPTY_BEHAVIOR</PROPERTY_NAME>
> <PROPERTY_CAPTION>NON_EMPTY_BEHAVIOR</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>SOLVE_ORDER</PROPERTY_NAME>
> <PROPERTY_CAPTION>SOLVE_ORDER</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>3</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>VALUE</PROPERTY_NAME>
> <PROPERTY_CAPTION>VALUE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>12</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>DATATYPE</PROPERTY_NAME>
> <PROPERTY_CAPTION>DATATYPE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>130</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>LANGUAGE</PROPERTY_NAME>
> <PROPERTY_CAPTION>LANGUAGE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>19</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>ACTION_TYPE</PROPERTY_NAME>
> <PROPERTY_CAPTION>ACTION_TYPE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>19</DATA_TYPE>
> </row>
> <row>
> <PROPERTY_NAME>UPDATEABLE</PROPERTY_NAME>
> <PROPERTY_CAPTION>UPDATEABLE</PROPERTY_CAPTION>
> <PROPERTY_TYPE>2</PROPERTY_TYPE>
> <DATA_TYPE>19</DATA_TYPE>
> </row>
> </root>
> </cxmla:return>
> </cxmla:DiscoverResponse>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
>
> 2010.05.21;10:39:52.640 DEBUG Invoking validate http header callbacks
> 2010.05.21;10:39:52.641 DEBUG Unmarshalling SOAP message
> 2010.05.21;10:39:52.644 DEBUG XML/A request content
> <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
> http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance">
> <Header>
> <Session xmlns="urn:schemas-microsoft-com:xml-analysis"
> SessionId="" mustUnderstand="1"/>
> </Header>
> <Body>
> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
> <Command>
> <Statement>SELECT FROM [Station] WHERE
> ([Measures].[MinNbBikes]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE,
> BACK_COLOR, FORE_COLOR, FONT_FLAGS</Statement>
> </Command>
> <Properties>
> <PropertyList>
> <Format>Multidimensional</Format>
> <AxisFormat>TupleFormat</AxisFormat>
>
> <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
> <LocaleIdentifier>1033</LocaleIdentifier>
> <Catalog>cube</Catalog>
> <VisualMode>1</VisualMode>
> </PropertyList>
> </Properties>
> </Execute>
> </Body>
> </Envelope>
> 2010.05.21;10:39:52.645 DEBUG Handling XML/A message header
> 2010.05.21;10:39:52.645 DEBUG Invoking callbacks preAction
> 2010.05.21;10:39:52.645 DEBUG Handling XML/A message body
> 2010.05.21;10:39:52.645 DEBUG DefaultXmlaRequest.initProperties:
> key="Format", value="Multidimensional"
> 2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties:
> key="AxisFormat", value="TupleFormat"
> 2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties:
> key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
> 2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties:
> key="LocaleIdentifier", value="1033"
> 2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties:
> key="Catalog", value="cube"
> 2010.05.21;10:39:52.646 DEBUG DefaultXmlaRequest.initProperties:
> key="VisualMode", value="1"
> 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"
> 2010.05.21;10:39:52.647 DEBUG XmlaHandler.getDataSource:
> dataSourceInfo=Provider=Mondrian;DataSource=cube;
> 2010.05.21;10:39:52.647 DEBUG XmlaHandler.getDataSource:
> ds.dataSourceInfo=Provider=Mondrian; Jdbc=jdbc:mysql://
> db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir;
> JdbcDrivers=com.mysql.jdbc.Driver
> 2010.05.21;10:39:52.647 DEBUG XmlaHandler.getConnection:
> catalogUrl=/Users/mdarveau/workspace/ftk/ftk-dist/ftk-dist-dev/./cfg/cube.xml
> 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
> 2010.05.21;10:39:52.648 DEBUG XmlaHandler.getConnection: returning
> connection not null
> 2010.05.21;10:39:52.648 DEBUG
> SELECT FROM [Station] WHERE ([Measures].[MinNbBikes]) CELL PROPERTIES
> VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS
> 2010.05.21;10:39:52.648 DEBUG Util.lookupCompound: parent.name=Station,
> category=unknown, names=[Measures].[MinNbBikes]
> 2010.05.21;10:39:52.649 DEBUG RolapCube.lookupChild: name=Station,
> childname=[Measures] returning elementname=Measures
> 2010.05.21;10:39:52.649 DEBUG HierarchyBase.lookupChild: name=Measures,
> childname=[MinNbBikes] returning elementname=MinNbBikes
> 2010.05.21;10:39:52.650 DEBUG DimensionBase.lookupChild: name=Measures,
> childname=[MinNbBikes] returning elementname=MinNbBikes
> 2010.05.21;10:39:52.650 DEBUG Util.lookupCompound: found child.name=MinNbBikes,
> child.class=mondrian.rolap.RolapBaseCubeMeasure
> 2010.05.21;10:39:52.650 DEBUG RolapCube.getUsages: name=Measures
> 2010.05.21;10:39:52.651 DEBUG select from [Station]
> where [Measures].[MinNbBikes]
>
> 2010.05.21;10:39:52.651 DEBUG 23: select from [Station]
> where [Measures].[MinNbBikes]
>
> 2010.05.21;10:39:52.651 DEBUG RolapCube.getUsages: name=Measures
> 2010.05.21;10:39:52.652 DEBUG FastBatchingCellReader:
> bitkey=0x0000000000000000000000000000000000000000000000000000000000000000
>
> 2010.05.21;10:39:52.652 DEBUG RolapCube.getUsages: name=Measures
> 2010.05.21;10:39:52.654 DEBUG NO MATCH: BikeStationFact
>
> foreign=0x0000000000000000000000000000000000000000000000000000000000000000
>
> measure=0x0000000000000000000000000000000000000000100000000000000000000000
>
> 2010.05.21;10:39:52.654 DEBUG generateSqlQuery: sql=select
> min(`BikeStationFact`.`nbBike`) as `m0` from `BikeStationFact` as
> `BikeStationFact`
> 2010.05.21;10:39:52.656 DEBUG 170: Segment.load: executing sql [select
> min(`BikeStationFact`.`nbBike`) as `m0` from `BikeStationFact` as
> `BikeStationFact`]
> 2010.05.21;10:39:52.666 DEBUG 170: , exec 9 ms
> 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
> 2010.05.21;10:39:52.673 DEBUG 170: , exec+fetch 16 ms, 0 rows
> 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
> 2010.05.21;10:39:52.674 DEBUG Batch.loadAggregation (millis) 22
> 2010.05.21;10:39:52.674 DEBUG loadAggregation (millis): 22
> 2010.05.21;10:39:52.675 DEBUG RolapResult<init>: FREE_MEMORY: 405113kb
> 82.17%
> 2010.05.21;10:39:52.675 DEBUG 23: exec: 24 ms
> 2010.05.21;10:39:52.676 DEBUG RolapCube.getUsages: name=Measures
> 2010.05.21;10:39:52.676 DEBUG XmlaHandler.process: time = 30
> 2010.05.21;10:39:52.676 DEBUG XmlaHandler.process: FREE_MEMORY: 405113kb
> 82.17%
> 2010.05.21;10:39:52.677 DEBUG Invoking callbacks postAction
> 2010.05.21;10:39:52.677 DEBUG XML/A response content
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <SOAP-ENV:Envelope xmlns:SOAP-ENV="
> http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
> http://schemas.xmlsoap.org/soap/encoding/" >
> <SOAP-ENV:Header>
> <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
> /></SOAP-ENV:Header>
> <SOAP-ENV:Body>
> <cxmla:ExecuteResponse
> xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
> <cxmla:return>
> <root xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
> http://www.w3.org/2001/XMLSchema"
> xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> targetNamespace="urn:schemas-microsoft-com:xml-analysis:mddataset"
> xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="
> http://www.w3.org/2001/XMLSchema-instance"
> xmlns:sql="urn:schemas-microsoft-com:xml-sql"
> elementFormDefault="qualified">
> <xsd:complexType name="MemberType">
> <xsd:sequence>
> <xsd:element name="UName" type="xsd:string"/>
> <xsd:element name="Caption" type="xsd:string"/>
> <xsd:element name="LName" type="xsd:string"/>
> <xsd:element name="LNum" type="xsd:unsignedInt"/>
> <xsd:element name="DisplayInfo" type="xsd:unsignedInt"/>
> <xsd:sequence maxOccurs="unbounded" minOccurs="0">
> <xsd:any processContents="lax" maxOccurs="unbounded"/>
> </xsd:sequence>
> </xsd:sequence>
> <xsd:attribute name="Hierarchy" type="xsd:string"/>
> </xsd:complexType>
> <xsd:complexType name="PropType">
> <xsd:attribute name="name" type="xsd:string"/>
> </xsd:complexType>
> <xsd:complexType name="TupleType">
> <xsd:sequence maxOccurs="unbounded">
> <xsd:element name="Member" type="MemberType"/>
> </xsd:sequence>
> </xsd:complexType>
> <xsd:complexType name="MembersType">
> <xsd:sequence maxOccurs="unbounded">
> <xsd:element name="Member" type="MemberType"/>
> </xsd:sequence>
> <xsd:attribute name="Hierarchy" type="xsd:string"/>
> </xsd:complexType>
> <xsd:complexType name="TuplesType">
> <xsd:sequence maxOccurs="unbounded">
> <xsd:element name="Tuple" type="TupleType"/>
> </xsd:sequence>
> </xsd:complexType>
> <xsd:complexType name="CrossProductType">
> <xsd:sequence>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100521/a01e2845/attachment.html
More information about the Mondrian
mailing list