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
Henning's avatar
Henning
Valued Contributor II
6 months 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
    6 months 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 

    • 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.