Write 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.
Member 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 youExternal/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, Will
Read Source Data for Summary Function
Hello, I'm working on a rule that drills back into source stage data from the target summary table. I'm receiving an error on the ReadSourceDataForSummaryRow line that the method or operation is not implemented. I've verified that the parameters I'm passing are correct and in the correct format. Dim importTable As List(Of TargetDataInfo) = BRApi.Import.Data.ReadSummaryTargetData(si, si.WorkflowClusterPk, Nothing) If importTable.Count > 0 For Each importLine As TargetDataInfo In importTable Dim summaryRowID As Guid = importLine.SummaryRowID api.LogMessage("before, summaryRowID: " & summaryRowID.ToString) Dim sourceLinesForSummaryID As List(Of SourceDataInfo) = BRApi.Import.Data.ReadSourceDataForSummaryRow(si, summaryRowId) api.LogMessage("after") Next End If Has anyone else encountered this issue before? I'm working in OS version 8.2.3, but didn't see anything relevant in subsequent release notes. Thank you!
FDXExecuteCubeView
Hi, I am working on extracting data from a Cube view to a flat file. I am using FDXExecuteCubeView query to extract. The extract file is executed to run for one year. I am seeing for each Entity, Scenario, Time (DU) a log entry is created in Task Activity. The Task Activity is getting flooded with cube view log entries. Is there a way to stop the Cube view entries for each Page (Entity, Scenario, Time).? On the Cube view I have the log setting set to False and also in the FDXExecuteCubeView setting I have the logStatistics setting set to False. Is there a way to not log the entry for each time cube view is run for (Entity, Scenario, Period)? Appreciate your inputs!Beginning Balance Formula
Our beginning balance formula is as follows: 'Check to see if we are in period 1 If api.Time.IsFirstPeriodInYear() Then ......... Else ............... This formula worked perfectly rolling from 2023 into 2024, but now in 2025 we are having issues. EX: In Feb 2025, the beginning balance is reverting back to Dec 24 instead of Jan 25. Any insight into where I might start in figuring out this error? I tried looking at our business rules for api.time and didn't see anything that stood out. Thanks!
