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
OneStream EmployeeHi, 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.
