Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Read Excel 2007 from SSAS

Author  Topic 

inoon_jiffry@hotmail.com
Starting Member

1 Post

Posted - 2010-02-16 : 06:36:38
Hi all,

Please refer my requirement given below,

I have an excel sheet (2007) which have the cube name, Axis name, Specification name, I want to read this xls file and get the cube name and the cube details to generate my MDX query.

Can someone tell me how to do this?

My final aime is I have a standard MDX query which will get the cube elements and produce the results
   

- Advertisement -