excel cube formulas in access

[ApolloID]

Hi, can i use in access formulas from excel cube?
I have this formula :

=CUBEVALUE("192.168.1.10 SeniorBI Aprovizionare","STOC","PIERR","DEPOZIT")

In excel cube, this formula retrieve a number (2649)
Can this formula work the same in access?

Can this be done?
Thanks!

 

[SydneyGeek]

Not that I am aware of. Are you using an Add-in for Excel? What is the cube software?

I would suggest doing any cube analysis in Excel and pushing the results to Access, if you need to manipulate the data there.

Denis

 

[ApolloID]

Hi, sorry for the late reply. Thanks for the answer. I will try with access.

Thanks allot!