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!
Change 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, Carlos
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!
Requirement to Translate different entities at different rates in Budget.
Hello Experts, I am wondering if any one has worked on requirement where 2 entities need to be translated at 2 different rates for Budget scenario. I know how we can translate entire scenario by historical rate. I am not sure having entity filters will work in this case or I should be looking at different approach? Thanks, MP
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 youExecuteCustomCalculateBusinessRule ... but in workspaces
Hi, I came across an update function in the business rules for ExecuteCustomCalculateBusinessRule Previous function (still in use) : BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule(si, brName, functionName, nameValuePairs, timeType) New function for workspaces : BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule(si, workspaceID, brName, functionName, nameValuePairs, timeType) We can indeed at least in version 8.5 create Finance Custom Calculate Services : However, these don't use any business rule name, hence my confusion ? How do we execute a custom calculate service which is currently within my workspace assembly services ? Or should it be used in a different way ? Regards,
