B
badlydressedboy
Hi,
I am passing the following MDX to my OWC10 control:
SELECT CROSSJOIN({[date].[year].[2005].[Q3].[September].[week-39]} ,
{[Measures].[Leavers],[Measures].[joiners]}) ON COLUMNS,
{[Club].[ClubName].members} on rows
Which works fine in the MDX sample app - giving me 2 columns, joiners and
leavers, under the dimension member week-39. The measure columns are
populated with data, as they should be - happy days
Giving the same MDX to OWC, the 2 measures are NOWHERE to be seen. Their 2
columns are replaced with another measure which isnt mentioned anywhere in
the code but happens to be to 1st measure in the drop down list of measures
in the data view in AS.
Why are my 2 measures disappearing and being replaced with some kind of
default measure????????????????
TIA
Al
I am passing the following MDX to my OWC10 control:
SELECT CROSSJOIN({[date].[year].[2005].[Q3].[September].[week-39]} ,
{[Measures].[Leavers],[Measures].[joiners]}) ON COLUMNS,
{[Club].[ClubName].members} on rows
Which works fine in the MDX sample app - giving me 2 columns, joiners and
leavers, under the dimension member week-39. The measure columns are
populated with data, as they should be - happy days
Giving the same MDX to OWC, the 2 measures are NOWHERE to be seen. Their 2
columns are replaced with another measure which isnt mentioned anywhere in
the code but happens to be to 1st measure in the drop down list of measures
in the data view in AS.
Why are my 2 measures disappearing and being replaced with some kind of
default measure????????????????
TIA
Al