[Mondrian] Re: Excel + refresh
Julian Hyde
jhyde at pentaho.com
Fri May 21 13:49:35 EDT 2010
The error
parentExp != null || nullParentValue == null
means that in your schema, you have specified nullParentValue on a Level
where you have not specified parentExp. You can only specify nullParentValue
in a parent-child level.
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Manuel Darveau
Sent: Friday, May 21, 2010 9:34 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Re: Excel + refresh
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:22
8)
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
<http://db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir>
&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.xm
l
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
<http://db.duo.8d.com:3306/mdarveau_bss_ftk_dms?user=cloud&password=yessir>
&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.xm
l
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/9894a82a/attachment.html
More information about the Mondrian
mailing list