dbTalk Databases Forums  

Microsoft.AnalysisServices.AdomdClient.CellSet MEMBER_TYPE problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Microsoft.AnalysisServices.AdomdClient.CellSet MEMBER_TYPE problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jens
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.