MDX and OWC

[asaintonge]

I have a problem when executing MDX query on a cube.

I simplify the problem using a test cube with one
dimension and one measure.
I set the OWC.PivotTable Member proprety to the cube
name : cbSejourAdmissionTest.
I also set the OWC.PivotTable CommandText to one of the
following MDX query string.

I do not understand why some queries are accepted by OWC
and other are rejected.


MDX QUERY ACCEPTED BY OWC
SELECT FROM [cbSejourAdmissionTest]
SELECT {[Measures].[AdmissionNb]} ON COLUMNS FROM
[cbSejourAdmissionTest]
SELECT {[AnnéeTB].[Année].MEMBERS} ON COLUMNS FROM
[cbSejourAdmissionTest]


MDX QUERY REJECTED BY OWC
SELECT {[Measures].[AdmissionNb]} ON COLUMNS, {[AnnéeTB].
[Année].MEMBERS} ON ROWS FROM [cbSejourAdmissionTest]
SELECT {[Measures].[AdmissionNb]} ON AXIS(0), {[AnnéeTB].
[Année].MEMBERS} ON AXIS(1) FROM [cbSejourAdmissionTest]


All queries are valid when I use MdxSample.

The OWC version is 10.
The connection string is Provider=MSOLAP.2;Integrated
Security=SSPI;Persist Security Info= False;Data
Source=MyServer;Location=MyCatalog;Initial
Catalog=MyCatalog;Client Cache Size= 25;Auto
SynchPeriod=10000;PASSWORD=;

Is the problem coming from OWC bug ?

To capture the OWC MDX query, I added in my connection
string, the following ";Log File=c:\owc.log".
In the OWC log file, for the first case rejected I got
only the two following lines :
prjOWC:2536 2003-09-19 14:42:59 MDX
select filter([Measures].members,
[Measures].currentmember.member_caption <>
[Measures].currentmember.member_caption) on columns from
[cbSejourAdmissionTest]
prjOWC:2536 2003-09-19 14:42:59 MDX
SELECT {[Measures].[AdmissionNb]} ON COLUMNS,
{[AnnéeTB].[Année].MEMBERS} ON ROWS FROM
[cbSejourAdmissionTest]


Could I get some explanation of this behaviour ?

Thanks