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
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