OWC 10 Pivot Control/MDX query problem

M

Michael Weiss

Hello,
I posted this a few days ago but have not had any
response so wanted to post it again in hopes someone with
an answer or suggestion will see it - I have the
following MDX statement:
SELECT
{[Call Date].Members} ON COLUMNS,
NON EMPTY CROSSJOIN({[Region Customers].[Customer].
[0100000]
}, {[User IDs].Members}) ON ROWS
FROM
[Billed Call Detail]

When I execute that statement in the MDX Query Sample
Application that is part of Analysis Services, it returns
the proper cellset.
When I set the OWC 10.0 Pivot control's commandtext
property to the same MDX statement I get an empty
cellset. Can anyone explain what may be going on here?
Thank you,
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top