There are two really cool chunks of functionality in the RS data extension for analysis services 1) the Aggregate function, which basically says, "just give me what the cube has for this aggregate level", and 2) the Extended Properties of a field, which allows you to grab the background color, formatted value, and other cool properties.
The only problem is that you can't use both of them at the same time!!! In other words, you can get the formatted value (or background color, oetc) for the detail level, but not for higher levels. This is an acknowledged bug, but they won't fix it before Katmai unless a lot of people say it's important. If this is important to you, please go to Connect.Microsoft.Com and either file a new bug or vote for the one I posted. Here's the URL to mine:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=245844
Cheers,
Reed