Run Excel from Windows Credential to Connect SSAS Cube

Option 1:

Create batch file using these below script

@echo off
SET /P username=Please enter the your username:  

runas /netonly /user:DAS\%username% "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE"

Step 1- Copy the above script in notepad and modify as per your Domain name and Path of Excel exe.

Step 2- Save as batch file e.g "Run_Excel.bat"

Step 3 - now double click the batch file to run the excel and provide the name and password

Option 2:

Also you can run the script directly in Powershell

runas /netonly /user:DAS\Liyas "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE"


by doing this you can run the excel in Windows credentials and connect the Analysis Service Cube.

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."