Forum Discussion
Solved
FilterMembers syntax (: vs ,) and base clearing when using GetDataBufferUsingFormula
I’m working on a custom clear process that clears cube data using GetDataBufferUsingFormula()
The goal is to dynamically clear data for all base members under the current POV (Entity, UD1-UD4) by ...
Hello Saifsafwan,
Long story short, the ":" is used to define the general POV of the get-databuffer you want and the other terms separated by "," are the detail you want. Also, the entity dimensin belongs to the data unit so it's better not to mention it explicitly in the calculation.
In the example below, the common members are defined and fixed (O#Top:I#Top:U3#Top:U4#Top), then you ask for the detail you need (U1#ProfitCenter.Base , U2#Location.Base).
Also, during testing you can log the databuffer to know exactly what you're selecting and try to use the "RemoveZeros" function.
Example: FilterMembers(O#Top:I#Top:U3#Top:U4#Top, U1#ProfitCenter.Base , U2#Location.Base).
Regards
(complement)
Concerning your question 1, check on the extensibility. It could happen that you have other members on the merged dimension so you're not going to the right ".Base" member expansion. You can use
"Base.Options(Cube= cubeName, ScenarioType=ScenarioTypeName, MergeMembersFromReferencedCubes=False)"
to get the right level of "base" you need according to cube and scenarioType.
Regards,
Carlos