Microsoft.AnalysisServices.AdomdClient.CellSet MEMBER_TYPE problem -
08-26-2004
, 04:42 AM
Hi NG
Im currently experiencing a problem when requesting Member.Type from a
CellSet object.
All is well when no crossjoin is involved, but as soon as a crossjoin
is requested I get this errormessage:
"The operation is not valid because of the current state of the
object. You can use the FetchAllProperties method to retrieve the data
necessary from the server to enable this operation."
The FetchAllProperties method is *NOT* supported, so I can't go that
way.
Example MDX Statement:
SELECT [Product].[Product Family].MEMBERS ON COLUMNS,
NON EMPTY {CROSSJOIN([Customers].[City].MEMBERS,
[Time].[Quarter].MEMBERS)} DIMENSION PROPERTIES MEMBER_TYPE ON ROWS
FROM [Sales]
WHERE (Measures.[Unit Sales])
This looks fine in MDX Sample Application, but not when using dotnet
Microsoft.AnalysisServices.AdomdClient.CellSet
Anyone have any clue as to how this is solved ?
Best regards
- Jens |