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
<html xmlns="urn:schemas-microsoft-comfficeffice"

<meta http-equiv=Content-Type content="text/x-ms-odc; charset=utf-8">
<meta name=ProgId content=ODC.Cube>
<meta name=SourceType content=OLEDB>
<meta name=Catalog content="XXXX">
<meta name=Table content="Demand Planning">
<title>Pre prod </title>
<xml id=docprops><oocumentProperties
<oescription>Pre Prod DP cube</oescription>
<o:Name>XXXX </o:Name>
</xml><xml id=msodc><odc:OfficeDataConnection
<odc:Connection odc:Type="OLEDB">
<odc:ConnectionString>Provider=MSOLAP.3;Pass word=XXXXXXX;Persist Security Info=True;User ID=XXXXXX;Data Source=XXXXXX;Initial Catalog=XXXXX</odc:ConnectionString>
<odc:CommandText>Demand Planning</odc:CommandText>

If someone can guide me how to do this, it would be great.

Himanshu Sharma