Olap SSAS from excess

[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(cognos) 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

 

[Howard007]

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(cognos) 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 ina
pivot table

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

Thanks in advance

Have a look at www.OlapOffice.com. There are some new approaches
around as well.