Recent Discussions
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,Using the Trailing3MonthAvg View Member in a Data Buffer Across Years
Hello, I was wondering if anyone has had any success using Trailing3MonthAvg View member within a data buffer when the trailing 3 months cross over years. When I run this for a period like June everything works great, but when I run this in Jan or Feb I get the object reference not set to an instance of an object error. When switching the View member to YTD everything works fine. Below is an example of the code. Thanks!! Dim filter1 As String = "U1#XXXXX.Base" Dim filter2 As String = "U6#XXXXXBase" Dim U2 As String = "XXXXX" Dim test1 As String= "Cb#XXXXXX:T#2023M1:A#Direct_HC:S#Actual:E#XXXXX:F#EndBal_Input:V#Trailing3MonthAvg:O#BeforeAdj:I#None:U3#Top:U4#Top:U5#Total_Adj_Alloc:U2#" _ & U2 & ":U7#Top:U8#None" Dim test As DataBuffer = api.Data.GetDataBufferUsingFormula( _ "RemoveZeros(FilterMembers(" & test1 & ", " & filter1 & ", " & filter2 & "))",,True)
'si' is not declared. It may be inaccessible due to its protection level.
I am receiving this error when writing a business rule, any idea on how I can remove this error? Here is the portion of the business rule where I am using 'si': Dim objXFResult As XFResult = BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile(si, filePath, delimiter, originFilter, targetOriginMember, loadZeros)Slow performances with dynamic accounts export
Hello, We experience performance problems when we try to export Onestream data for insertion into a third-party system. For 100 entities and 12 months, processing takes 20 hours and is often killed by the system. Apparently, it's the dynamic accounts that take up a lot of time during extraction. Do you have the same problem and what are the solutions to optimize the export? ThanksAudit trail for O#Import data
Hi, I've been looking into the audit trails for O#Forms and O#Import data. The audit trail for O#Forms data seems to be in good shape, with changes tracked in tables like DataEntryAuditCell and DataEntryAuditSource. For O#Import data, I've found some audit information in the staging area tables, such as StageArchivesInformation and vStageSummaryTargetData. However, this doesn't cover everything - for example, it doesn't account for data that's been imported but not yet loaded into the cube, or data imported using a business rule. Is there a way to get a more complete audit trail for O#Import data, that focus on the Cube data rather than Stage data?
