for integration purposes its for me absolute necessary to use a Stored
Procedure for
accessing the olap cube.


my 'openquery ' call returns


Server: Nachr.-Nr. 7321, Schweregrad 16, Status 2, Zeile 1
An error occurred while preparing a query for execution against OLE DB
provider 'MSOLAP'.
[OLE/DB provider returned message: Formula error - object type is not
valid - in an <object> base class]
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14].

when i try to use 'descendants( [mydim],3)'

The same query using the 'mdx example app' works fine.

So what can i do ?

Any help would be greatly appreciated :-)

kk

The first parameter to Descendants can be a set or a member, not a dimension.
I tried running a query in MDX Sample App using a dimension as the first parameter and I got the same error message you are receiving.
HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"kk" wrote:

kk wrote on 07/23/2004 08:24 ET :
on
the below location.
http://www.sqllion.com/2011/08/mdx-decendants/
Have a look on it to get more knowledge.