Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
1 year ago
Solved

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
  • rhankey's avatar
    rhankey
    1 year ago

    If a member filter contains commas, you will need to wrap the member filter with [].  Eg "[U1#[XX].Base.Options(cube = AA , ScenarioType = Operational)]" so that the FilterMembers() function does not get confused when parsing the filters.

DanielWillis's avatar
DanielWillis
Valued Contributor
1 year ago

Hi vmanojrc30 

Check out the examples page where it combines GetDataBufferUsingFormula with FilterMembers @ https://documentation.onestream.com/1375907/Content/Design%20and%20Reference/Financial%20Model%20Guides/Examples%20of%20Key%20Functions.html?Highlight=GetDataBufferUsingFormula

 

 

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hi

Daniel's solution is correct. There is also a RemoveMembers function. 

Cheers