|
I am trying to match existing reporting functionality while building up a new cube for a Proof of Concept. Can I retrieve data from my cube using an MDX query and put it into a recordset so I can then populate an Excel Sheet with the data?
(comments are locked)
|
|
You may be better getting Excel to connect to the cube directly. But otherwise, sure... use ADOMD.Net. I was meaning that you could use C# or VB.Net to connect to your cube using ADOMD.Net, and then dump the results to an Excel file. But as an alternative, you could just use Excel's ability to connect directly (which is also supported in Excel 2003).
Nov 19 '09 at 03:34 AM
Rob Farley
(comments are locked)
|
Your answer
