Rules

Hi, Is there an easy way to get MemberScript from the DataCellPk? I can see a method called 'GetMemberScript' (what a surprise) on DataCellPk object, but it doesn't work (or I cannot figure out how it works) in Extensibility Rule. The goal is to take the details of one DataCell, replace one of the members and process (validate) such created reference to another DataCell. Any tips? Best, Karol

Hi, I'm currently using a FDX query to create an automated Journal. Works basically fine but when the FDX query is completely empty it throws an exception error message. Not a very big deal but the users experience this as a failure of the system. Does someone know a way to avoid this throw or to customize the exception error message in case of an empty datatable? FYI a check on the datatable (f (Not dt Is Nothing) And (dt.Rows.count > 0) Then) still gives the throw.   Thanks!  

You cannot change BiBlend configuration if a Workflow “Blend” step has already been executed Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

I have two questions: ud3 text2 has text which is the entity on where we are going to seed to..  1) I want a memberlist where Text2 is not blank or has no data. I am wondering if Text2 <> '' is the correct way to go? 2) What is the syntax of brapi or api.logmessage to see what is in the memberlist?   'Dim memberFilter_UD3 As String = "Cb#CONCUBE:U3#PCHEAD.Descendants.Where(Text2 DoesNotContain '')" Dim memberFilter_UD3 As String = "Cb#CONCUBE:U3#PCHEAD.Descendants.Where(Text2 <> '')"Dim UD3List As List(Of Memberinfo) = api.Members.GetMembersUsingFilter(api.Pov.UD3Dim.DimPk,memberFilter_UD3)   'api.logmessage("UD3List", String.Join(vbnewline, memberFilter_UD3.Select(Function(x) x.GetType.FullName))) BRAPI.ErrorLog.LogMessage(si,"1_Target_ " & UD3List)   For each UD3 as Memberinfo in UD3List etc. etc. BRAPI.ErrorLog.LogMessage(si,"Test " & UD3.NameAndDescription)' &" " & UD3.Properties.GetUDProperties.Text2.GetValue())

Hello, We need to clear data on the specific intersections of Account, Entity, UD2, UD3, and UD5 members (all members from the remaining dimensions). The data is copied from the Actual to the Forecast scenario. So, I tried to use clearcalculateddata API in the member formula but it is clearing data on that account for all members of UD dimensions. Can you please help with the simplest way to clear the data on a specific intersection?   Ex. We need to clear data for the below intersection. The below line is clearing the data for A#7041 irrespective of other defined UD members. api.Data.ClearCalculatedData(True,True,True,True,"A#7041:O#Import:F#Base:U2#13056:U3#327:U5#01973")  

Hi,   I have an existing extensibility rule which copy some data from a source scenario/period to a target scenario/period.   This is the "core" of the code Dim listDriversDataCellExFilterdForDriversTarget As New List(Of DatacellEx) For Each itemDataCellEx As DataCellEx In listDriversDataCellExFilterdForDrivers   itemDataCellEx.DataCell.DataCellPk.TimeId = TimeTargetId   itemDataCellEx.DataCell.DataCellPk.ScenarioId = ScenarioTargetId   listDriversDataCellExFilterdForDriversTarget.Add(itemDataCellEx)Next itemDataCellEx   Now, I was trying to update this to only copy data where UD3=None, but I am not sure on how to do that. I can see datacells have a function called GetUD3Name, but the function requires a FinanceRulesApi parameter.   Would using the GetUD3Name function work for my scope and what would be an example of valid FinanceRulesApi parameter?   Thank you

How do I call a function that exist in a dashboard extender business rule for another dashboard extender business rule and how do I pass the all the required arguments?

I was looking for a  way to bind a .net list object to a gridview instead of using DataAdapters. Any examples in this direction are appreciated.

How does one write a calculation where the result needs to land at an intersection that includes C#Elimination. Ideally, I'd want to have a function such as:     Public Sub Book(ByVal si As SessionInfo, ByVal api As FinanceRulesApi, ByVal sourceCell As dataBufferCell, ByVal target As String, ByVal factor As Decimal)     And then call it as     Book(si,api,sourceCell,"U4#SOMECALC:C#Elimination",-0.3563523553)    

I want to run a simple calculation setting one account equal to another.  Account A = Account B.  Account A, the account receiving the data in the calculation, is set to at the member level to YTD for No Data Zero View for NonAdjustments.  The account with the data is set to Periodic. The problem is when Account B has data for some months and then has a calculated 0 in later months.  The Account A with the YTD setting just replicates the last period's data in the months with 0 in Account B which causes the two accounts not to be equal.   I am using the following calculation. api.Data.Calculate("A#AccountA = A#AccountB" , True) How is this normally managed?

Hi all We have a process where we update dimensions and their children on a regular basis. This means we need to delete the relationships between parents and children and then reload the new updated dimensions...etc.  This takes a very long time, because we have a lot of dimensions.  Has anyone out here used a script to make this process faster, we we to not have to reload everthing, but only update the changes made to the different hierarchies? Thank you for any suggestions Nouria

hi, I was trying to use a cell format parameter I had stored in an Account Text field in a cube view using an XFBR rule.  Can this work?  My attempt below. thanks, Greg Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As ObjectTry If (args.FunctionName.XFEqualsIgnoreCase("CheckDataForVisibleColumn")) ThenReturn Me.CheckDataForVisibleColumn(si, globals, api, args)ElseIf (args.FunctionName.XFEqualsIgnoreCase("GetAccountFormatFromText")) ThenReturn Me.GetAccountFormatFromText(si, globals, api, args)End If Return NothingCatch ex As ExceptionThrow ErrorHandler.LogWrite(si, New XFException(si, ex))End TryEnd Function#Region "Standard Helper Functions" Public Function GetAccountFormatFromText (ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As StringTryDim AccountID As String = args.SubstVarSourceInfo.PovMembers.Account.MemberI

I am trying to populate 30 months with depreciation. So if an asset value is 300,000 $, and it is to be depreciated to zero in 30 months,  that would mean that I have to fill each month with 10,000$. Seems like standard, simple BR that has already been written. Does anyone know where I can find sample BR code for straight line depreciation?  

Hello team,I am wondering if I can call an UD détail with args.confirmationruleargs.info  ? I need to display and show only the data that fail based on UD.base , is it possible to do that on the info box in the confirm rules or should i do it through BRs and then call it in the conf rule? And do you have an idea what can be the syntax to show the base members of a specific UD that fail ?Thanks in advance , appreciate your help

Hi,Can anyone help in writing a confirmation rule where if Account starts with 4 and U3#00 has a value then the rule fails and the Account name is displayed.I am getting an error in running through the loop for all the account starting with 4, the rule probably stops at first match itself. If anyone could give the rule from scratch would be great!Thanks!

Hello, we renamed some companies adding a space and some text. For example company "64" was renamed in "64 TA" After renaming we started to have issues in the rules like if Onestream does not recognize the space. This is  a sample error message we receive. Summary: Unable to execute Business Rule 'WES_Rules'. Invalid script 'A#4028_02:O#Elimination:F#None:I#64 TA:U1#None:U2#None:U3#IC_Details:U4#INTERCOMPANY:U5#None:U6#None:U7#None:U8#None' near '64'.   Is there some hidden contraint in Onestream that prevents clients to create element with spaces? By the way, do you know if there is any workaround to overcome this issue in the rules? because I belive our custmer will not accept to go back to the simple company code.   Thanks in advance Marcello    

I want to retrieve data from a .csv file from Filestore\Everyone folder and later convert the data in to a a dataTable in an extensibility rule. Does any one has a sample BR.    

Hi - I know the below code is not a good practice but is there is an alternative way to set the data =0 because I want to clear all Origin Base member and UD2 base. Any help would be appreciated ?    api.Data.Calculate("A#ACCT:F#EndBalInput:UD1#" & ud1Member & ":UD3#" & ud3Member & ":I#" & icpMember & ":C#USD:O#All:UD2#All:UD4#None:UD5#None:UD6#None:UD7#None:UD8#None = 0")    

Hi, Is there a way where users can input From and To dates time members in a cube view? Currently, I am using a parameter in the time member field in POV section of cube view. I have a business rule with FROM and TO dates (2022M1 to 2022M4) and then extract all the periods within (2021 M1 M2 M3 and M4) that time frame in a dt.  And now, I want to incorporate this function in the cube view. feel free to drop your inputs.

  In an earlier post a user named Sam helped me find a way to find the value of a variable in a Custom Calculate job using the Parameter field.  Now, how can we access the value of the parameter in a regular Calculate job which does not have the Parameter field?   The variable is |CVYear|.  How can we access it directly in a BR (standard Calculate)?   Thanks, Chris  

Can any one provide me with a rule snippet for updating Entity Percent Ownership. I have tried a few things using the SaveRelationshipInfo but it is not working.

Good Evening, It should be something simple but apparently I am missing something. I am trying to get the Value for the Text1 field for an Account Dimension member using a Business Rule. The Text1 value vary by scenario. I trying to use ".Options()" but can get it to work. Is this the best alternative? Would you know of other alternatives? Is there a BRApi function which already does this? Thank you for the help,  

Hi, How is it possible to update Entity Relationships through Business Rules, including Ownership Type, Percent Consolidation and Percent Ownership? It must be possible since the latest version of the Application Control Manager can also update entity relationship information, however I couldn't find it in the api.

Hi all, I am building a cube view for my end users to tell them the first common parent of two entities based on parameter inputs. However, I am having trouble with the BRApi.Finance.Members.GetFirstCommonParent formula as used in a Dashboard XFBR String. Here is the formula at prompt:  BRApi.Finance.Members.GetFirstCommonParent(si, dimPk, topMostMemberId, memberIdA, memberIdB, dimDisplayOptions)   The input for "topMostMemberId" seems to dominate the return value of the formula. If I put our top most entity hierarchy memberId into the input, the formula will return that value, even if it is not the first common parent. If tried a number of different inputs here, all of them seems to just spit out on the return.   What am I missing? Is there something in the dimDisplayOptions I need to toggle?  Here is my VBA:    If args.FunctionName.XFEqualsIgnoreCase("GFCP") ThenDim EntityInputName1 As String = args.NameValuePairs.XFGetValue("Entity1")Dim EntityInpu

Hi all,   I'm trying to give the end-user the option to enter their forecasts in either 13 week increments (a quarter essentially) or for the full 52 weeks. This specific XFBR will determine the green cells below.   I'm unsure of what line 28 should be or if this XFBR could be easier to define. Week13Column and FullYearColumn are existing parameters that list 13 weeks of scenario and the full 52 weeks of scenario, respectively.   Thanks!