Offline Reporting with SSAS Cube and Excel 2007 or Above

This link would help for Implement the offline reporting using Microsoft BI Capabilities. There are cases Sales Reps will be working in Remote locations where they would not have access to the Internet.
So Its a common requirement to access the data and create self service report with offline.

http://office.microsoft.com/en-in/excel-help/work-with-offline-cube-files-HP010087040.aspx

SSAS OLAP Cube - Role Based Data Security

In my case there was a Scenario to link the Store Dimension with Domain Users and provide the data security in Excel, PPS Dashboard for the users who has the access only to the Stores.

This article was quite helpful.

http://www.rdacorp.com/2009/01/advanced-dimension-data-security-with-sql-server-2008/

Here the Key thing is pass the Application Domain user name into Cube as follows..

NONEMPTY([Store].[StoreName].MEMBERS,
(STRTOMEMBER("[User].[User Name].&[" + USERNAME+ "]"), 
[Measures].[User Store Count]
))

Note: This script should be entered in Role -> Dimension Data(Cube Dimension not the OLAP Database Dimension) -> Advance tab.

In case you specify this script in Dimension Data tab under Cube Dimension then you will get this error.

"The browser is disabled because custom MDX expressions defined in the Advanced tab were not validated due to the following problem:

A connection cannot be made. Ensure that the server is running."