You can use multiple groups in the same tablix that aren't nested within each other. That way your 3 month average doesn't need to be in a second tablix.

You...

31 million rows is large but not huge.

If the stored proc is taking 30 minutes to filter on the date then it sounds like you need to add an index...

Chris Webb did a good article on this for something similar a while back which might help:

http://cwebbbi.wordpress.com/2011/12/22/replacing-cell-security-with-dimension-security/[/url]

I'm not sure that a dimension mapping every single user to services will be...

It sounds like you've added permissions on the report server website appropriately, so my first thought is about the datasource connection.

When you are in visual studio (BIDS) you create a...

Firstly, can you provide more information?

E.g. How long is the timeout, what is the query (provide SQL), how many rows, an example of the data and the purpose of...

Name the cells so they are easy to remember e.g. MonthTotal and then refer to those cells directly in an expression:

=ReportItems!MonthTotal.value

I think that should have been convert, not cast. I'm sure just a typo. 120 also...

The way I usually do this is to create a linked server object on the SQL server database, and then in the query you can do something like this

select a.column,...

This is a problem with IE.

SSRS uses the <Title> tag in the generated html for tooltips, which is subject to a setting on your machine. It's not a setting...

I've done this many times by creating a linked server in SQL server that connects to the SSAS instance.

Stacia has a good brief article about this

There are, however,...

If you are able to edit the SQL then do as robert says. If you aren't good with SQL or are unable to edit the SQL for some reason then...

Great article, I think it will really help people new to data mining models in SSAS.

An important point: you said in the beginning "we need a lot of data to...

I can see why you might not want to use the @StartDate and @EndDate suggestion because you probably only want your users to have to pick one date and have...

This is an eternal debate.

My own experience is that fresh out of uni with no work experience, I thought I was awesome but no-one would hire me because most...

I showed this thread to the Business Consultant I mentioned and these are her comments. I've posted them here with permission. Note this is an accredited expert in the field,...