Olap SSAS Cube SQL Server2005/2008 single data point by UDF to exc

C

CmK

Hi
I have looked every where
I have a question which i thought microsoft would of solved by now
Since All the other major Olap software have it

Like Tm1 which uses a addin and a udf function
to retrive a single data point by using a udf and refering whihc dimensions
on the spreadsheet
And also do writebacks to the SSAS by udf (VBA or .net)

I dont know if I am explaining it properly
Right now all you can do it rretrive the Data and dump the whole thing in a
pivot table

Last question can vba talk to SSAS
I read some where Com cant talkt o .net

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top