Rules

This post is to illustrate how to call a public function of a Finance Rule from within XFBR rule. The Finance Rule has a function called EntityText8 splitter, and I need to call it from within a XFBR rule. To make it work, first need to make the Finance Rule "True" - Contains Global Functions for Formulas (in Rule Properties) and refer to the specific rule assembly in XFBR rule properties (screenshot2). The XFBR rule reads: '-------------------------------------------------------------------------------------------------------------------------------- 'Returns the Entity in Text8 or emtpy '-------------------------------------------------------------------------------------------------------------------------------- 'BRString(SeedingXFBRStrings, Text8Entity, curEntity=|CVEntity|, curScenario=|CVScenario|) 'XFBR(SeedingXFBRStrings, Text8Entity, curEntity=|CVEntity|, curScenario=|CVScenario|)   If args.FunctionName.XFEqualsIgnoreCase("Text8Entity") Then   Dim curEntity

As the subject line writes, is it possible to disable/hide confirmation rules without deleting them?  I'm revising our current budget work flow and changing the confirmation rules required.  I'd like to keep the prior rules in case they are required in the future.

How can I print DataManagement Sequence name? I have Consolidation email BR but within that email I want to print which Sequence consolidation is running for?    Saurin

I have an input sheet in which data can be entered for an override of another number.  The Cell Status "Is Real Data" flag is used in a rule.  If an override is entered in the early part of the monthly year but not later parts a derived amount of 0 is shown and it's "Is Real Data" flag is false.  My problem is when I use the Data Management step Copy Data to copy to a new scenario.  The 0 cells after the initial user input are now "Is Real Data" = True and "Is Derived Data" = False.  My rule now treats these 0s as if they were entered by user and so doesn't work.  This seems very wrong to me that the Copy Data step can't get the details of the Cell Status right.   Can someone explain what to do here to preserve the cell status after a copy?  Thanks.

We are capturing parent entity adjustments, and they are not rolling to C#Share. Any idea what the cause may be or how to enable this.

Could someone please direct me on where I can find documentation or training on how OneStreamEmail works?  How it can be implemented, authentication used, etc.?  I can't find anything when searching Design and reference guide.   

Hi, I am trying to build in an if statement in a cubeview (getdatacell formula) on the cell amounts. In specific: If cellamount of CVC(col 10) > CVC(col 11) then CVC(col1) else CVC(col1).  The reason why I am trying to do this in a cubeview getdatacell is because the col 10 an col 11 are referencing other columns and those other columns are referencing other columns in return. A workaround would be to recreate these column references in BR or create new members with formulas doing similar. But I am trying to avoid recreating this if possible. Hope someone have ideas. 

Hi everyone. I have this error when trying to insert data into my SQL table 'System.OutOfMemoryException'. This occurs when I use .base to retrieve all my departments. The following is how I enter the values of a table into SQL using a loop, so I would like to know what I can do to avoid that error when I want to add many values to that table. For Each isRow As DataRow In dt.Rows Dim sqlInsert As String = $"INSERT INTO AllocationResults (Step, Amount, Annotation, SourceRule, DriverRule, Type, StepDesc, TargetRule, AllocRule, Generation, Cube, Entity, Consolidation, Scenario, Time, [View], Account, Flow, Origin, Ic, UD1, UD2, UD3, UD4, UD5, UD6, UD7, UD8) VALUES " & $"(1, {Amount}, '{Annotation}', '{SourceRule}', '{DriverRule}', '{Type}', '{StepDesc}', '{TargetRule}', '{AllocRule}', {Generation}, '{Cube}', '{Entity}', '{Consolidation}', '{Scenario}', '{Time}', '{View}', '{Account}', '{Flow}', '{Origin}', '{Ic}', '{UD1}', '{UD2}', '{UD3}', '{UD4}', '{UD5}',

Hello All, I am creating a confirmation rule with the following goal: - Read data attachment text from from a V#Annotation field  Due to my unfamiliarity with the DataAttachmentList object, I have been unsuccessful in utilizing this list within my rule. I wanted to reach out to the community and see if anyone could help correct my mistakes. My code for testing is as follows:    

May I ask how to use Case IS = ExtenderFunctionType.ExecuteExternalDimensionSource? It will be great if we have use cases and examples. Thank you

I have a dashboard parameter of type delimited list and I want to get the value from the parameter in a dynamic UD8 member. How do I get the parameter value? If I use the following code I just get the default value of the parameter (because the parameter isn't a literal type): Dim sValue As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "myParameter")brapi.ErrorLog.LogMessage(si, "sValue " & sValue) so I need to use a method other than BRApi.Dashboards.Parameters.GetLiteralParameterValue but have no idea what and don't seem to be able to find any documentation to help find what to use.

Hi - I want capture data cell values from two columns of the cube view and save them as a list and used the list to loop through the calculations. i would appreciate help with a sample code or guidance. Thanks. YM.

I'm trying to create a Dashboard parameter that has the OS Version number of the application. I would have thought that something likeDim osVersion As String = OneStream.Shared.Common.GeneralStrings.OSVersionwould return the value, but this simply returns the string "OS Version". Can someone please point me to the correct function or member to get the application version number?

I want to update the parameter of my dictonary . How can i achieve it? .add adds the value in the dictonary. Is there any update function to update the value of that key in dictonary Dim params2 As New Dictionary(Of String, String) params2.Add("Entity_param_db","E001" ) For Each MemberOfList As MemberInfo In Nonstreamproduct             params2.Add("Entity_param_db",MemberOfList.Member.Name)             BRApi.Utilities.StartDataMgmtSequence(si,dataMgmtSeq2, params2)Next

I am trying to do a calculation for a few specified members (putting to E and U4) but only for base of certain hierarchies under Account and UD1.  Here is the example of what we want to do: api.Data.Calculate("E#NonRolled:O#BeforeElim:F#EndBal:U4#NonRolled_Calc = RemoveZeros(E#1000X:O#BeforeElim:F#EndBal:U4#Reported - E#2000X:O#BeforeElim:F#EndBal:U4#Reported )","A#Management_Income_Statement.base") However, I understand you can not have Entity as part of the left hand side the equation since it would create an invalid data unit. Does anyone know a way around this, or an alternate way to accomplish this?  

I am trying to assign the text field stored value in a variable in Business rule. Here is my code that I am trying- but getting a compilation error.  dim pov_U7text1 as String = api. pov.UD7.Tex1   Please advise  

I need to load a XML file with a Business Rule. Like read the XML in a folder and load it automatic in OS.Is it possible? Thx on advance

I need to update a WFP property through a Business Rule, properties like AccessGroup, WorkflowName, etcIs it possible? Thx on advance

In the extensibility rule, there is a case choice of ExtenderFunctionType.Unknown. I am wondering in which situation we should use this? It would be great if we could have a few use cases with examples. Thank you

Hi,Is there any way to manipulate a workflow profile or create a new one using a business rule? If not, any way to extract / load xml in a BR? Can't find anything that would help me while browsing the api.

Hello,I am running a Business Rule to extract Forecast data using Data Management task. The BR is working fine for Q1 Fcst, Q2 Fcst but when I am running the same BR for Q3 Fcst, it is failing and giving the below error.Error message -*********************************************************************************************************Summary: Error processing Data Management Step 'Export_TAX_PandL'. Unable to execute Business Rule 'extr_TEST_TAX_ExtractPandL'. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL Error Number -2146232060, -2). The wait operation timed outThe process is also running fine in QA without any issues for all the scenarios.Any inputs much appreciated!! Thank you!

Anyway we can copy cell details (Amount, aggregation Weight, Classification and description from period 1 to Period 2 via business rule?  

Hi Everyone. I am creating a CSV file with the information from a datatable. The problem is that it generates the file with the columns but without the datatable information. I wanted to know if there is another way to create a CSV file correctly. Dim strFilePathFull_AllocationDetails As String = strFilePath & "/" & strModelName & "_" & strScenarioName & "_" & strTimeName & "_" & dtAllocationDetails.TableName & ".csv" Dim xfeFile_AllocationDetails As XFFileEx = dtbSH.DataTableToFile(si, dtAllocationDetails, strFilePathFull_AllocationDetails, Nothing) And my function: Public Function DataTableToFile(ByVal si As SessionInfo, ByVal dt As DataTable, ByVal strFilePath As String, ByVal listColToSkip As List(Of String), ByVal Optional strSeparator As String = ",") As XFFileEx Dim strDt As String = Me.PrintDataTable(si, dt, strSeparator, 0, False, listColToSkip, """") Dim bytes() As Byte = System.Text.Encoding.UTF8.GetBytes(strDt) Dim fileinfo As New

Hi All,I am trying to run a business rule through Data Management step but getting attached error. Can anybody help me how to run the business rule from Data Management?I am also disclosing the error message belowError processing Data Management Step 'Data_Buffer_Practice'. User 'Muhammad Zubair' is not a member of the 'Actual' scenario's Manage Data Group. 

Hi,I have a Custom Calc rule called by a data management step and I am experiencing a weird behaviour. I know there is data in Actual 2023M6, and I can get that data when running the data management step from either Actual 2023M12 or MF7 (name of another scenario) 2023M6, changing the GetDataBufferUsingFormula appropriately, but not from MF7 2023M12. I'll post the details below.