I am attempting to use StrToMember inside of the Descendants function and I get an error. Here is an example of the query I would like to run using the FoodMart 2000 Cube. Keep in mind, I will be using other data and the StrToMember is being used to allow dynamic selection in another application

SELEC
{ [Measures].[Unit Sales] } on Rows
Descendants( StrToMember("[Time].[1998]"), [Time].[Day of Month]) on Column
From [Sales

This is the error I receive

Unable to open cellse
Formula error - object type is not valid - in an <object> base clas

If I just run the query without the StrToMember..
SELEC
{ [Measures].[Unit Sales] } on Rows
Descendants( [Time].[1998], [Time].[Day of Month]) on Column
From [Sales

It works fine. Any help would be greatly appreciated

-Bria

There appears to be some inconsistent behavior with the StrToMember
function. If you replace it with the Members function, the query works.

SELECT
{ [Measures].[Unit Sales] } on Rows,
Descendants( Members("[Time].[1998]"), [Time].[Day of Month]) on Columns
From [Sales]

HTH,
Martin

"US-A Brian" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the FoodMart 2000 Cube. Keep in mind, I will be using other data and the
StrToMember is being used to allow dynamic selection in another application.