I have requirement to performance test the SQL Server Analysis services cube. We are uisng SQL server 2008 R2.
We have Loadrunner 9.5
The requirements is that user will connect directly to the cube from deskptop excel and extract the data.
Using option in
Menu>Data>From Other Sources>Analysis services. ( excel version 2003 and 2007)
My first concern is - How to establsh connection?
as Sql 2005 onwards doesn't use ODBC connection and I am not able to creat a DNS in the system for that
When I connect to the cube from Excel, a connectio file is created. Extract from the file looks like