Rules

I would like to use a parameter value in a KPI in my API_Calculate business rule. I have a literal value parameter and we will change the default value ahead of time to control which formula runs. I'm trying to pull the current default value with the following: Dim param As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, Nothing, "myFlag") When it gets to that line it throws a "Object reference not set to an instance of an object".  Any ideas?

I'm currently trying to export the account dimension members and their properties through a csv file. I can get all the properties necessary, but I can't get the "Account Type" property through the extender rule.  I'm currently using Account_Type= Brapi.Finance.Members.GetMemberInfo(si,dimTypeId,stkItem.Name,True,Nothing,MemberDisplay).Member.GetType.FullName , to get the account type in columns but it isn't returning the correct account type of the member and instead returning " OneStream.Shared.Common.Member " in the columns.

Hello, I have an account that is calculated via a business rule. I don't want end users to input into the account manually. If I set the account to allow input = false, will my business rule still be able to input data into the account? Or do I need to leave it set to allow input = true, but make sure every cube view that uses the account does not allow manual input? Thank you.  

I using UD8 to call master data of entity. Other master data is work, but there is issue when I call entity parent. Seem like the business rules is not working. Not sure where the missing part. If api.View.IsAnnotationType() Then     ' Dim EntityID As Integer = api.Pov.Entity.MemberId   ' 'Return the Account name setting for this text-based View member '' Return api.Entity.GetLocalCurrency(EntityID).Name ' 'Dim ParentId As Integer = api.Pov.Parent.MemberId '' return api.Entity.par ''Return api.Pov.Parent.MemberId.ToString 'Dim objList As = BRApi.Finance.Members.GetParents(si, dimPk, entity, includeRootMemberInResult, dimDisplayOptions) 'Dim oblist2 = BRApi.Finance.Members.GetParents() 'Dim ParentId As Integer = api.Pov.Parent.MemberId ' Dim ParentName As String = api.Members.GetMemberName(DimType.Entity.Id,ParentId) 'Return ParentName 'Else   '    'Return a NoData Datacell '    Return api.Data.CreateDataCellObject(0.0,True, False) End If

Hi community,I have an issue where i have a member list tied to a bound list. The bound list uses a SQL query to get the top member of a given dimension. I have this bound list tied to a supplied parameter that I have attached to a dashboard. The issue is that when I run the dashboard, it is not triggering the bound list, even though i am using the supplied parameter. If I remove the supplied parameter and run the dashboard, it prompts me with the bound list parameter showing the value i want to return, and thereafter, when i put the supplied parameter back it works. It seems like the system needs to trigger the bound list first, but I haven't found a way to do so yet. Any thoughts? 

I am not sure how to get the OData Link    

Hello,  I already have a data file for cost centers and their Default values, but now I need to include the before and after changed values to the cost center member.  I found this code:  Function GetRelationshipChangesForTimeSpan(ByVal api As Api, ByVal dimensionName As String, ByVal startDate As DateTime, ByVal endDate As DateTime) As List(Of RelationshipChange)    ' Initialize a list to store relationship changes    Dim relationshipChanges As New List(Of RelationshipChange)     ' Use the API to retrieve relationship changes    relationshipChanges = api.Data.GetRelationshipChanges(dimensionName, startDate, endDate)     ' Return the list of changes    Return relationshipChangesEnd Function How can I tell what data it's actually returning, what columns? Is there a better way to do this? Any help is greatly appreciated! Thanks!   

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,

In the example code for the Dynamic Dimension Service there appears to be a subtle bug which will affect refresh of the dimensions.ReadDynamicDimensionInfo(...) returns DateTime.Now:' This api method will build the required object, straight from an SQL query. Return api.ReadDynamicDimensionInfo(si, args, DateTime.Now, numSecondsBeforeCheckTS, _ dbConn, sql.ToString, Nothing, Nothing, _ "Name", "Description", "UniqueID", "Name", "Parent", "ParentID", "Parent", "AggWeight", True)BUT ReadDynamicDimensionContentTimestamp sets the Timestamp as DateTime.UTCNow:'Refresh once per minute (note: frequent refreshes such As one minute could degrade performance). Dim utcNow As DateTime = DateTime.UtcNow Return New DateTime(utcNow.Year, utcNow.Month, utcNow.Day, utcNow.Hour, utcNow.Minute, 0, 0, DateTimeKind.Utc)This will matter if your refresh period is < 13(?) hours AND if your TimeZone is ahead of UTC......It's an easy fix though!Steve

Hi allI'm trying to understand the purpose of the string 'itemName' variable that is available inside the assembly service factories.Does anyone know the intended purpose of the 'itemName'?And does anyone have some best practice guidelines or examples of this variable in use? Thank you very much everyone!Thor 

Hello all, I have a field in my input dataset that I am tracing the mapping for and I can't figure out why One Stream is selecting the mapping rule it is using. The field is a cost center (UD1) value of '1VA' and it is not specifically called out in one-to-one or is it included as a composite range. I really think it should have been falling out as an exception. OneStream however tells me it is applying a Range Rule 'ABC' where the rule expression = '18~21'.  I am flummoxed as to the reason why. I've double checked it a few times.  Any ideas why this range rule was selected, or maybe an idea of other areas to check out to see why the cost center UD1 mapping is behaving the way it is? Thanks in advance. Happy to add add'l details if needed. Regards, DK

Hello. I have a set of Lookup Transformational rules. I have tried to load a mass upload for multiple lines of transformational rules through a trx file. I had a message saying the load has been completed with errors. However when I try to search for one rule I can't find it in the set of rules. When I try creating one of them manually it won't let me create it as it says it exists already, even though it doesn't show in the rule set. How can I undo what I did? How can I sort it out. A lot of people are depending of these rule set as it helps with Data extraction. Please support.

Hi Community, We have a requirement to bypass lines from the source data for each account if the total equals to zero, regardless of the UD1 value. For example if these two lines are in the source data: Account 1, UD1_1, -100 Account 1, UD1_2, 100 we want to bypass account 1. Is there a way to achieve this result? in our case this is happening because we are adding UD1 in the source system and it's triggering a lot of unused accounts to now appear on our staging table because of the different UD1 members.

i have blow code to copy the periodic values from YTD scenario but it didn't work Dim sourceBuffer1a As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ",V#PERIODIC,A#Top.Base,O#AdjInput)", DataApiScriptMethodType.Calculate, False, destination) Dim sourceBuffer1b As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ",V#PERIODIC,A#Top.Base,O#Forms)", DataApiScriptMethodType.Calculate, False, destination)                                Dim sourceBuffer1 As DataBuffer = sourceBuffer1a + sourceBuffer1b                                                                If (Not sourceBuffer1 Is Nothing) Then             

Hi, Can anyone help with a way of creating username folder in Data management Export folder? This is in the File Explorer area. Is there a way to create a folder here through a business rule? Thanks a lot.    

Hi Everyone. I have the following CALCULATE expression, but it’s returning no results. The source values are not zero, so I’m not sure if the way I’m using the DIVIDE function is causing the issue, or if there is another problem Dim DBCInner As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(A#RETBUYBACK:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#COUNTRY_RPT + A#423100:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#COUNTRY_RPT + A#411000:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#COUNTRY_RPT)") api.Data.FormulaVariables.SetDataBufferVariable("DBCInner",DBCInner,False) Dim regionalRpt As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(A#RETBUYBACK:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#REGIONAL_RPT + A#423100:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#REGIONAL_RPT + A#411000:E#" & strEntTx3 & ":C#Local:O#Top:U2#INNER:UD3#REGIONAL_RPT)") api.Data.FormulaVariables.SetDataBufferV

Hello All, Our initial setup had everything copying data files to Application/Batch/Harvest folder.  There has been multiple years of files stored in this location making it unable to open.  I am trying to create something to pull the files and if folders are created to delete the stored files.  I am uable to open the path and the clean up business rule fails to run due to the size.  I spoke with some developers at Nashville Splash and am reaching out on here as well.

Need to copy an IC account data (Is IC Account = True) between scenarios, one way or another, and it seems like I can't.Tried databuffer copy - no worky. Tried api.data.calculate - same, nothing copied. In the end I tried "Copy Data" data management step for the entire data unit and IC account hasn't been copied.I set "Is IC Account = False" in the account settings and the data was copied without any problem, so said IC setting seems to be the only reason.Is this normal behavior? Something I missed in the documentation?

Hi! We’ve developed a custom REST API in our OneStream application to automate user management. So far, the following methods are working successfully: CreateUser – Creates a new user DisableUser – Disables an existing user Now, we are trying to add a new method: EnableUser – This method receives a user name and sets the IsEnabled property to True. The logic is quite simple. We retrieve the existing user using: Public Sub EnableUser()       ' Get user name     Dim username As String = Me._UserProperties("name")       If String.IsNullOrEmpty(username) Then Throw New Exception($"Supplied name is empty")       ' Get user      Dim userToEnable As UserInfo = BRApi.Security.Authorization.GetUser(Me._Si, username)       If userToEnable Is Nothing Then Throw New Exception($"User '{username}' was not found in OneStream")       ' Set IsEnabled = True     userToEnable.User.IsEnabled = T

Hi. I am using the FdxExecuteDataUnitTimePivot to pull data through a Data Adapter. My Setup now is only pulling the Names of the dimension members. Is there any way to get the descriptions as well?  My Code: Public Function ToNexusSalaryBridge(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardDataSetArgs) Dim sScenario As String = args.NameValuePairs.XFGetValue("myScenario", String.Empty) Dim sYear As String = args.NameValuePairs.XFGetValue("myTime", String.Empty) Dim sWorkspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, False, "Default") Dim sRootEntity As String = "MyRootEntity" Dim cubeName As String = "Test" '# data unit dims Dim consName As String = "Aggregated" 'member name only, no dim token Dim scenarioTypeId As Integer = ScenarioType.Budget.Id Dim viewName As String = "Periodic" 'member name only, no dim token Dim entityDimName As String = "E_ELTBU"

Is someone able to assist me with an alternative method for GetCalculatedFxRate on line 14 of the code below?  We just upgraded to 8.5.1 and this is no longer being supported.  In 8.2.3 it was still working.  This is a parser business rule that is being applied to a data source and calculation happening when data is being imported. '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'Purpose: Get Translation rate for To/From currencies on current record. ' Store translation rate in global variable to use with subsequent records for performance improvements. '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Dim time As String = api.CurrentDataClusterKey.TimeName 'Get current time. Dim currencyRate As Decimal = globals.GetDecimalValue(fromCurrency & "-" & toCurrency & "-" & time) 'Check Global variable for current translation rate. If Not currencyRate =

Hi allI currently have a UD8 member to do a simple variance to actuals formula, but I was wondering if it is possible pass parameters to the UD8 member formula that this could be more dynamic? My current code looks something like this: Try 'Declare base and comparison scenario variables Dim currentScenario As String = api.Pov.Scenario.Name Dim comparativeScenario As String = "Actual" 'Define pov filters Dim currentFilter As String = "S#" & currentScenario & ":U8#None" Dim comparisonFiler As String = "S#" & comparativeScenario & ":U8#None" Return api.Data.GetDataCell("BWDiff("& currentFilter & "," & comparisonFiler & ")") Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try However, I'm trying to see if there is a solution where I could have the following: Dim comparativeScenario As String = |!Comparative_Scenario_Parameter!| Thanks,Mark

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?Thanks

I'm trying to change the WF POV via DashboardExtender BR. I noticed there is Enum XFSelectionChangedPovActionType but I don't see any object which can make a use of this. Any tips?

Hi All,I am currently setting up account reconcillations manager (RCM) and import both YTD GL data and Periodic Flow data in the actual scenario. I want to bring in just the YTD GL data into RCM, but it's bringing in both data sets. How can I exclude the Import Flow Data? I know that I can filter on the workflow profile "Import Flow Data" in the Account Rec inventory and delete them, but I'd rather the flow data just not come into RCM in the first place. Thanks for the help!