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) Next20Views0likes3CommentsMap source account to target account member and Ud4 member
Hi Everyone, I have a source file which contains multiple accounts in the columns for one month. These accounts are not there in the cube. I do not have a ud4 dimension in the source file. Each source account should be mapped to an account and Ud4 member. for ex: Account a001 has to be mapped to account A#a1 and Ud4#cost. Similarly Account b001 has to be mapped to account b#b1 and Ud4#sale. A#[a001]=A#[a1]:UD4#[cost] A#[b001]=A#[b1]:UD4#[sale] How can this be achieved in the transformation rule. Also, the data source needs to have ud4 or not. Thanks, Jeevan25Views0likes2CommentsAverage 12 months Account formulas
Hi everyone, I suspect that this is fairly simple, but I haven't been able to find a solution as yet. I need to add formulas for Debtor Days, Creditor Days, and Inventory Days, all of which use 12-month averages in the calculation. The also all use the number of days in the month. Does anyone have an example of the syntax needed to include both of these? Thanks23Views0likes0CommentsWrite an amount
I am having difficulty writing an amount to a prior month via a Finance business rule. Specifically, for forecasting purposes in the last month of a quarter we calculate an excess amount and then want to spread that amount to the last two months in the quarter. I can successfully calculate and write to the last month but cannot seem to write to the prior month. For example, in Q2 as of June calculate the excess amount and then write 50% in May and 50% in June. Has anyone been able to accomplish something like this? Thanks in advance.21Views0likes2CommentsMember expansion on the "Remove" Function Alternative
Hello Community, I'm writing a rule to copy data from one scenario to another using api.data.calculate. However, I would like to exclude some accounts from being copied. Something like the following: api.Data.Calculate("V#YTD:S#ACTUAL=RemoveZeros(V#YTD:S#ACTUAL_TEST)","A#Root.Base.remove(A#CAPEX_ACCOUNTS.Base)") I understand that the Remove function will not accept a member expansion. Members to be removed must be listed in the function as specified in this post: "What is the best approach to “subtract” members in a hierarchy, the following member filter is not returning the expected results. E#Tot_Mgmt.Remove(Houston) | OneStream Community" But is there any alternative to do it without listing accounts to remove one by one ? Any help is appreciated! Thank you101Views0likes4CommentsExternal/Internal Gross Profit Calc
Hello, I'm trying to calculate an External and Internal Gross Profit calculation based off a few conditions. To calculate External/Internal GP, I need to allocate the ExtCGSOther group + OpExp using our UD1 MFGResale between External/Internal using an allocation basis of ExtMLBS and IntMLBS (with the exception of account 6123 which is 100% External). I need this calculation to be on a dept by dept basis. I'm not really sure where to start and I tried looking at Golfstream but couldn't find anything that fits what my company is asking me to build. Thanks, Will10Views0likes0CommentsChange View POV inside Custom Calculate BR
Dear all, We have 2 custom calculate functions (Finance BR) that are executed one after the other. The 1st one uses V#Period as POV and the 2nd uses V#YTD as View POV. These POV are set on the data management steps that use these functions. We'd like to merge both functions into one to simplify maintenance but the fact that they use different View POV creates an issue; if the data management steps uses V#Periodic or V#YTD, one function will work properly but not the other. Do you know how it can be set as a fixed View POV into the functions itself? Maybe there's a way updating the value of the "args" variable that is used as an input into the formula. Thank you for the help and guidance. Best regards, CarlosSolved47Views0likes3CommentsWhat does api.Cons.IsCurrency mean?
I encountered this Boolean today for the first time after writing (and reviewing) code for five years. There is no mention of it that I can find in the documentation. Based on the name itself, I can guess that this is a Boolean to make sure you're not on C#Elimination or any other of the "non-Currency" members of the Cons dimension. Have I guessed correctly?Solved26Views0likes1Comment