Using these posts:

http://social.msdn.microsoft.com/forums/sqlserver/en-US/551dad5d-76d1-4809-bca7-0a9d3aca5cd8/calculate-the-total-of-a-filtered-set-of-data

http://www.purplefrogsystems.com/blog/2009/11/scope-problems-with-mdx-calculated-members/

I finally got it working with the following code:

...

Thank you for the response.

This gives the total of the year, yes, but what if I've filtered to only quarters 1 and 2 in year 2013?

The total is the year,...

Who wants a dropdown for a date? What the users want is a calendar with min (and possibly max) date restrictions. It's just not possible w/in SSRS.

My 2 cents at...

As far as I know. Not possible. 🙁

'Work-around' is to create your own aspx front end to pass the params to the report. boo.

Did you ever find a fix for this? Does it require a server rebuild?

Thanks, Megan

As far as we have found, there is no way to do custom parameter validation within SSRS. If you find an way, please share.

Thanks, Megan

Try something like this:

WITH

MEMBER [Measures].[ParameterCaption] AS '[Geography].CURRENTMEMBER.MEMBER_CAPTION'

MEMBER [Measures].[ParameterValue] AS '[Geography].CURRENTMEMBER.UNIQUENAME'

SELECT

{

[Measures].[Results],[Measures].[ParameterCaption],[Measures].[ParameterValue]

} ON 0,

nonempty([Geography].[Region])

on 1

FROM [MyCube]

still no ideas on how to do this?? 😉

cool. thanks!

Thanks Steve. Do you know if you have to reprocess the entire cube to see this new value? Thanks again. -Megan

It may be a bit overkill, but we have 2 procedures in place:

1. we have a SSRS development sharepoint site and then we have a subsite for each major report.

a)...

Use All member and crossjoining sets.

Thanks to Chris Webb for helping me with this!

The answer is:

WITH

SET [TopCustomers] AS TOPCOUNT(nonempty([Customer].[Customer Geography].[City]),10,[Measures].[Internet Order Count])

MEMBER [Customer].[Customer Geography].[OtherCustomers] AS AGGREGATE({EXCEPT([Customer].[Customer Geography].Members, [TopCustomers])})

SELECT

{

[Measures].[Internet...

I'm relatively new at MDX too, and I've never tried this specifically, but I think you can create a member using the with statement and use the IIF function to...

cool! thanks!

OMG! I glanced right over that function. THANK YOU.

-M