This issue actually has to do with some Security Update from Microsoft.... take a look at:

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8d7f3b6a-6a23-4c25-a9ae-846d1391bf9e/[/url]

Has anyone heard about a fix for this item?

Also.... will you continue to add data without an archive strategy? Some years of data are likely to no longer be used at some point.

Have you checked the security for the Home folder?

You need to bring back the raw values and then let SSRS average then by your selected groups.

You can also use the SQL Agent.

You can process each cube within a Solution/Database individually.... also by having more than one cube within a database you can share common dimensions between them.

An iPad for Christmas would be such a generous gift. Working for a large owner of hospitals throughout the United States, I can definitely see the advantage of using...

You could also generate the create scripts in Excel using the concatenate function. Then copy the formula down the column and cut and paste the commands from Excel to...

You can also use the User!UserID

Have you tried putting the table within a rectangle?

We actually use both cubes and SSRS reports against our RDMS (plus some adhoc queries here and there). The cubes and dimensions give our power users the ability to...

You can use Report Builder to allow for dynamic report creation. A few different versions exist depending on what version of SQL Server you are using, but this link...

Go ahead and add all the columns you would need on the layout tab in BIDS. Then for each column use a Switch function or an Iif statement in...

You could include all the columns in your report definition and then hide (visibility property) the unneeded ones based on the criteria for which columns to display.