Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
6 days ago

Member Filter Functions in Finance BR

Is it possible to use Member Expansion functions like U1#[Top].Base.Where , U1#[Top].Base.Options within api.Data.GetDataBufferUsingFormula? I want to get data to the buffer from a Scenario / Scenar...
Finance
vmanojrc30's avatar
vmanojrc30
Contributor
2 days ago

Hi DanielWillis ChristianW 

I am particularly having issues when using Base.Option OR Base.Where filter functions.

In the Spreadsheet I am able to pull the data using below member filter function. U1#[XX].Base.Options(cube = AA , ScenarioType = Operational).However when I apply the same function in the api.Data.GetDataBufferUsingFormula , I am getting errors stating need a comma after Options.

So I am not sure if these functions are valid within api.Data.GetDataBufferUsingFormula