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)?
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
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.
