How can I remove empty values from GetDataBuffer and obtain the entity with Text1, Text2, Text3?
Hi Everyone.
I would like to know how I can remove zero values in my GetDataBufferUsingFormula.
Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPARTMENTS:U2#ALL_PRODUCTS:U3#CORP_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None,A#411000)")
And from the result, I would like to obtain the entity, and from that entity, know its Text1, Text2, and Text3. However, for now, I see that I can only obtain the account and the rest of the properties such as the UD
Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPARTMENTS:U2#ALL_PRODUCTS:U3#CORP_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None,A#411000)")
api.Data.FormulaVariables.SetDataBufferVariable("DatabufferCalc", DatabufferCalc, True)
For Each sourceCell As DataBufferCell In DatabufferCalc.DataBufferCells.Values
'I would like to obtain the entity and Texts
Dim account As String = sourceCell.DataBufferCellPk.GetAccountName()
BRApi.ErrorLog.LogMessage(si)
Next
There are two variations of the api.Entity.Text() function. One variant takes no parameters, and will operate on the POV entity. The second version allows you to specify any Entity member. Much the same as all the other api.[DimTypeName].Text() functions do too.
You need to be very careful when getting Cube data from a different entity, of for more than one entity, as the currencies for those entities could differ. And in many instances, those entities may not share the same cube and thus could have different dimensionality. In addition to that, when getting children of an entity, you can find that the sum of the children<>the parent due to things like eliminations unless you consider very carefully what data you get from the cube.