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.
Dear all, I'm also having the same issue as vmanojrc30, stating that a comma is missing when using "U1#[XX].Base.Options(cube = AA , ScenarioType = Operational)" in a databufferUsingFormula call. Should it work or it isn't defined yet in the databufferUsingFormula?
Thank you
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.
Thank you Rhankey!
That works! A follow-up question:
There's a scenario A with summary members (scenario Type 7) and a scenario B with extended members (scenario Type 2). I can recover a 1st databuffer using :
api.data.getDataBufferUsingFormula("FilterMembers(S#ScenarioA, [U1#[XX].Base.Options(cube = AA , ScenarioType = ScenarioType7)]")
but when using
api.data.getDataBufferUsingFormula("FilterMembers(S#ScenarioB, [U1#[XX].Base.Options(cube = AA , ScenarioType = ScenarioType7)]")
this last databuffer is empty (I guess because the base data belongs to one level below). Would it be possible to get this 2nd data buffer at a summary level just as the 1st Data Buffer?
Thank you
I can't imagine why you would need the UD1 filter you are showing when retrieving a data buffer. Just remove the UD1 filter. When obtaining a data buffer, you are getting stored data, however it was written for that Scenario/Entity. The UD1 filter is one you might use for reporting.
