Forum Discussion

WillVitale's avatar
WillVitale
Contributor
10 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
tuhler's avatar
tuhler
New Contributor III
10 months ago

I agree with you that using a cell reference might not be ideal as it limits your ability to change your cube view around without a lot of maintenance.

You could setup a UD8 member that returns the info that you are looking for. For example - I used a UD8 member that returns the account description by just having a dynamic calc:

Return (api.Pov.Account.Description)