Rules

Hello again, it seems that the error was not completely corrected, so I have the same problem as my previous post. Scenario 'Forecast 2023M10’s workflow settings do not allow input for Time member ‘2023M9’. I know this is a bit strange, but I need to modify values from the previous month. For example, now that I’m in November, I want to affect September. In February, it allows me to make these modifications because it’s still possible, but I want to do the same for the following months. The function value gives me as a form and I believe it is necessary to pass it to import, but I have no idea how to do it. For Each strItem As String In ({"Amount", "Annotation"}) Dim listTargetDC As New List(Of DataCellEx) For Each drResult As DataRow In dtResult.Rows Dim dcpkTarget As DataCellPk = drResult("DataCellPk") If strItem.Equals("Annotation") Then dcpkTarget.ViewId = BRApi.Finance.View.GetIdFromName(si, "Annotation") End If

Hai Everyone! Does any one know business rule to create a new member in a dimension using business rule by extender.If anyone knows please let me know and Share me the VB.net code.

Hi everyone. I have a problem with setdatacells, and it sends the following error: Scenario 'Forecast 2023M10’s workflow settings do not allow input for Time member ‘2023M9’. I know this is a bit strange, but I need to modify values from the previous month. For example, now that I’m in November, I want to affect September. In February, it allows me to make these modifications because it’s still possible, but I want to do the same for the following months. The function value gives me as a form and I believe it is necessary to pass it to import, but I have no idea how to do it. For Each strItem As String In ({"Amount", "Annotation"}) Dim listTargetDC As New List(Of DataCellEx) For Each drResult As DataRow In dtResult.Rows Dim dcpkTarget As DataCellPk = drResult("DataCellPk") If strItem.Equals("Annotation") Then dcpkTarget.ViewId = BRApi.Finance.View.GetIdFromName(si, "Annotation") End If Dim dcTarget As New DataCell(dcpk

Hi all, I'm bit new in developing rules in one stream and I have a simple question. I'm trying to retrieve the accountId member name from a member formula on the account itself. I'm using the below code but it seems api.Pov.Account.Name is not working, if I replace it with the account name it works. Dim AcctName As String = api.Pov.Account.NameDim AcctId As Integer = api.Members.GetMember(DimType.Account.Id,AcctName).MemberId Any suggestion?

Im trying to create a formula for one of our Statistical Cal accounts.  Its a derivation of of a calc we already have.  However the line will no compile even when I copy the existing formula completely. Return api.Data.GetDataCell("(Divide(A#1200:I#None,A#TTM_Net_Sales_wo_IC)) * 365)") I can compile the existing account without issue, but when I copy this formula into the new account I get an error  

Dear Community, I am using FdxExecuteDataUnitTimePivot for getting my data in Time column wise manner. I need to display it in Time columns under which account columns should be created. Is there any way to create sub columns . I will attach screenshot for reference.  

Hi, I have a (.csv) file in my File Share Folder that I want to read and load into the cube using a Workflow Profile. I have written an extensibility rule for getting that file and reading the file contents and creating a Data Table. now what should I do next? Is this the right approach or is there any other way to accomplish this? Below is the code of the Extensibility rule. Thanks

Hi all I accidentally deleted a Business Rule by loading a XML file with an older version on top of it. Is there any way to recover it? Cheers

Hi Community...! Here I'm getting Zero but instead of this I want to get  accounts data for that...Can you please share me some insights or some reference for this...?I'm using FDXExecuteDataunit method for this  

Hey folks, Just wondering if we can automate IIS reset in the task scheduler. I don't see any Snippets or related BRApis in the Extensibility Business Rules. Surfed through various Community posts but, didn't help much. Any guidance here will be helpful.  

Dear Community, How to get multiple time period data in FDX ?  We have data's in row manner. We need it in column wise. The data is imported into a table using FdxExecuteDataUnit function. 

I have an issue with the member formula with the below condition. It checks for Account Type Revenue or Expense. However if the Account Type is Revenue or Expense, still the condition is not met. Is there any issue with the way the condition is written? If api.Account.GetAccountType(api.pov.account.memberid).Equals("Expense") _Or api.Account.GetAccountType(api.pov.account.memberid).Equals("Revenue") Then   Return 1 End If

Hello There, Is there a way to get the 'Integer' behind each Account Type based on a 'String' ?Context: I am trying to create new Account Members with pre-defined properties, all properties were straightforward except for the account type. Below a code portion for modifying a property & a hardcoded solution: myaccountMember = BRApi.Finance.Metadata.GetMember(si, DimTypeId, accountID, True) Dim AccProperties As AccountVMProperties = myaccountMember.GetAccountProperties() 'Add AccountProperties '*** Text123 *** AccProperties.Text1.SetStoredValue(ScenarioType.Unknown.Id,DimConstants.Unknown, mytxt1) AccProperties.Text2.SetStoredValue(ScenarioType.Unknown.Id,DimConstants.Unknown, mytxt2) AccProperties.Text3.SetStoredValue(ScenarioType.Unknown.Id,DimConstants.Unknown, mytxt3) '*** AllowInput *** AccProperties.AllowInput.SetStoredValue(Boolean.Parse(isAllowInput)) '*** Account Type *** Dim accTypeInt As I

Dear Community , Is it possible to use a business rule to download a file from the file explorer to the local system? Thank You

Hi Everyone. I have the following section of code. 'Search for values for the DataBufferCellPK, they are not empty. Dim dbcpk As New DataBufferCellPk( mbrRefIdAcc, mbrRefIdFlow, intOriginId, mbrRefIdIC, mbrRefIdUd1, mbrRefIdUd2, mbrRefIdUd3, mbrRefIdUd4, mbrRefIdUd5, mbrRefIdUd6, mbrRefIdUd7, mbrRefIdUd8 ) 'BRApi.ErrorLog.LogMessage(si, $"values of DataBufferCellPk: MbrRefIdAcc: {mbrRefIdAcc}, MbrRefIdFlow: {mbrRefIdFlow}, IntOriginId: {intOriginId}, MbrRefIdIC: {mbrRefIdIC}, MbrRefIdUd1: {mbrRefIdUd1}, MbrRefIdUd2: {mbrRefIdUd2}, MbrRefIdUd3: {mbrRefIdUd3}, MbrRefIdUd4: {mbrRefIdUd4}, MbrRefIdUd5: {mbrRefIdUd5}, MbrRefIdUd6: {mbrRefIdUd6}, MbrRefIdUd7: {mbrRefIdUd7}, MbrRefIdUd8: {mbrRefIdUd8}") 'BRApi.ErrorLog.LogMessage(si, "Parameters bufferdatacell: " & dupk.ToString & " * " & intViewId) Using dbConnFW As DBConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si) Using dbConnApp As DBConnInfo = BRApi.Datab

Hi Community members, Need your help on the below business rule, as i am unable to identify the errors. The rule wrote for to get the value from combobox value and run Data managment sequence to clear the data. Namespace OneStream.BusinessRule.Finance.BOYD_Clear_Data_2 Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As FinanceRulesApi, ByVal args As FinanceRulesArgs) As Object Try Select Case api.FunctionType Case Is = FinanceFunctionType.CustomCalculate If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("ClearSeeding") Then '{Clear_Seeding}{Param=[|!ParamWFProfileEntities!|],Time=T#2023.BASE} 'Dim objList = api.Workflow.GetWFProfileEntities() Dim wfClusterPk As WorkflowUnitClusterPk = si.WorkflowClusterPk Dim intScenarioId As Integer = wfClusterPk.ScenarioKey Dim myWorkflowUnitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim intYear As Integer = BRAp

Hello,   I am trying to set up a business rule that seeds the forecast from actuals to the forecast. This works easily when I am not using all entities to seed. However, I need to somehow take the actual data from each base entity and copy it all into 1 entity for the forecast. The client only needs to forecast at 1 entity but wants to include the actuals from every base. Is this possible to do in 1 rule? I know you can't have the entity on the left side of the calculation so I'm not sure how to solve.   Thanks!

Good morning all! I'm hoping somebody can put me on the right path...! I'm writing a rule with a data buffer. I want to filter the data buffer so it only runs where needed. I put in the following filter relating to the Text6 field. This syntax works in a cube view (I've tested this) but it doesn't seem to work in the vb.net rule. Can anyone tell me what I should use here instead to return only when text 6 is not blank? Many thanks,Richard

Hello, I am trying to seed data from Actual to Forecast scenario. I am running the Business Rule through a DM step, whose data unit contains the forecast scenario, so that it picks this forecast scenario in the destination string. My Actual (Detail level accounts) are on more granular level and extend my planning accounts (plan and forecast accounts). The planning accounts are on top level.  Now, when i try to seed the data, it picks the Planning Accounts (since i have Forecast Account in my DM step), due to which my  Actual accounts are not picked up by the process. and the data copy is partial. I am trying this by using DataBuffer. Please let me know if there are any suggestions or solution to this. Thanks

Dear community, we have requirement of pulling level 2 parent for a member in writing UD8 Dynamic calc, do we have any method of pulling it in writing business rule. Any solution to this will be very helpful and appreciated.    

Hi Everyone.I have a DataCell that ends with a comma, and I wanted to know how I can remove it. Example Etc. UD6Id: -999, UD7Id: -999, UD8Id: -999, My issue is similar to the example, where after the UD8Id there is a comma with nothing following.  

Hello Community...       I can get only one cell data from using FdxExecuteDataUnit. But After that i want to get all data including Rows and Columns. So, For that any sample code...? or what format i need to use..?

Hi, I have the following code that gives me an error: Object reference not set to an instance of an object. Dim listMbrEntityD As New List(Of Member) Dim dimpkEntityD As New DimPk(mbrEntityD.DimTypeId, mbrEntityD.DimId) listMbrEntityD.AddRange(BRApi.Finance.Members.GetBaseMembers(si, dimpkEntityD, mbrEntityD.MemberId)) I have debugged with errorlog but it doesn’t manage to print anything to see the values, any idea how to solve it?

Hi Everyone,I have requirement to run 4 data management steps in parallel, is there a way to run 4 data management steps same time? Thanks in advance.  

Hi Community... I'm trying to extract data from CV using FdxExecuteCubeView method..So, if anyone give sample code for that with respected method query means... It'll be very helpful to refer...     I want to know how we are passing values in this method...By CV POV...?Thank You...!