Forum Discussion

WillVitale's avatar
WillVitale
Contributor II
2 years ago

OS Excel Function that pulls data from a Cube View Connection

Hello, I was wondering if there's a way to use one of the OneStream Excel functions (i.e. =xfgetmemberinfo) to grab data from a Cube View Connection? I know I could pull this data from the headers,...
Cube View
Excel Add In
Reports
Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi Will,

As you are probably already aware, the available functions can be found here in Excel:

Also for the wider audience, the documentation is here:

Retrieve Functions (onestream.com)

 

What are you trying to achieve exactly? Do you mean you have a cube view in your Excel open and then your users wish to pull data from that open connection? Do you mean real "data", or do you mean something else as your mentioning of xfgetmemberinfo suggests (as this is used to pull the description from a metadata member)?

WillVitale's avatar
WillVitale
Contributor II
2 years ago

Hi Henning,

Yes, I know XFGetMemberInfo, but whenever I refresh the Cube View Connection or change to a different entity the formula becomes a #REF error, also is there a way where I can pull a value set up in the POV that's physically on the excel tab? In this example, I have time and Currency (consolidation) as a parameter. Is it possible to pull those with an excel formula?

Thanks,

Will 

Related Content