Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
5 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 / Scenario Type which is setup with a Summary UD1 dimension in the Cube Configuration.The data is loaded to this Scenario at Summary UD1 members.

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.

If this function cannot be used within Finance BR is there another way to get the data from base members of Summary UD1 dimension?

Dimension

    Summary UD1

            Detail UD1

 

Members

Summary UD1

      Top

            CC001

 

Detail UD1

      Top

          CC001

                CC0011