It's a little ugly and I'd definitely recommend looking at using a subcube context (I didn't have time) instead, but you could use something like...

SELECT

FILTER(FILTER([Products].[Product_Name].MEMBERS, [Measures].[Sales] = 0), ([Measures].[Sales], [Time_Dim].[Range_Other]...

Hey Don,

Could only find where people (msft or not) reference there *not* being a limit t that query size. One thing I did see was that if the linked...

Last time I did dynamic MDX was in the original SSRS release but this article[/url] did basically what we had to do (we didn't take it to the embedded code...

Don,

Can we assume that something is forcing you to use TSQL rather than SSRS which will allow you to use parameters and possibly end-around the requirement for dynamic queries? ...

Basically, the problem is as the error states - you need to initialize the report server.

This is the books online page on initialization.

Glad you got it sorted 🙂

I agree, Slicers are cool. You can use these in 'standard' excel 2010 pivot tables too.

Not sure if you're aware but you can do...

Sorry, missed your 'solved it' post. Glad you got it working. That IIF evaluation isn't nice.

Ugh, forgot about the crappy IIF. According to Bruce Loehle-Conger (post here) your best bet is to move the logic to code behind the report (I'm guessing this is...

The param "SelectedItemList" is definitely a multivalue parm?

What is the datatype of the parameter used in the IIF? If it's an integer, you shouldn't have the "4" quoted right?

Matt,

Hope I'm not telling you things you already know, if so, apologies and I prob need to understand the question better...

Basically, the PowerPivot window is generating a repository that's like...

The meta data toolkit is available

here for 2005

and

here for 2008[/url]

HTH,

Hey Bob,

How exactly are you planning on making the SSRS reports available within your Silverlight app? If you're using something like the Perpetuumsoft control, then you can do either...

Technically, the cube is...

It may be achievable using something like todays date, but using what you gave us. You gave a starting point/constant of 1056915413 == 2010-07-01 01:53

So we're looking for [constant]...