Forum Discussion

WillVitale's avatar
WillVitale
Contributor
6 months 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
WillVitale's avatar
WillVitale
Contributor

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 

Henning's avatar
Henning
Valued Contributor II
6 months ago

Hi, no, as far as I know you cannot retrieve parameters with any of the functions. 

If you want to pull time and consolidation, I suggest to create a cube view with C# in the column and T# in the row - add this CV to a (possibly hidden) sheet - and then use the column and row headers as a reference in Excel. You can do the same with other parameters, e.g. by pulling the parameter into a dynamic member in a UD, display as annotation and refer to those cells in Excel.