Help Again:

I posted yesterday and I seemed to have resolved the local cube
problems by using AS2005...

However I have a new question today...

I have this situation where I am trying to divide by the number of
members in a dimension. I am using this code as a calculated member
(from MDX Solutions).

count(crossjoin({[Measures].[Base]}, descendants([Media Date
Cub].[media Date].currentmember,[Media Date Cub].[Media Date].[Media
Date])),excludeempty)

The media date dimension contains 7 days...

The problem is this code only works if I select all the days or just
one of the days...if I select two or three of the days in the browser I
get an error...

Any Ideas?

Willy

I assume you are trying to select multiple members in the page filter,
Mosha has written an extensive article here on how to make your MDX
multiselect friendly here:

http://sqljunkies.com/WebLog/mosha/a...iselect_friend
ly_mdx.aspx

Something like the following should work:


Count(
NonEmpty(
EXISTING [Media Date Cub].[media Date]
,([Measures].[Base])
)
)


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1149885353.049567.23870 (AT) i39g2000cwa (DOT) googlegroups.com>,
willrich33 (AT) yahoo (DOT) com says...

Thanks Darren:

That did exactly what I needed to do...the link was great too.

Willy