Rules

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

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.  

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 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...!

How do you consolidate currency overrides using alternative currencies e.g. Base Entity and immediate parent are in EUR and ultimate parent is in USD. Client wants to view consolidated view of immediate parent in USD including the currency overrides. The same reverse is required for USD entity rolling up to EUR. We have created alternate flow members but the aggregation is a challenge.

Hi I have got a list of member info and trying to do a simple loop through the list to get the member and it's parent using the following code, however ParentMemberId is always coming back as -1. Dim UD1DimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "CostCentre") Dim listMI As List(Of MemberInfo) = BRApi.Finance.Members.GetMembersUsingFilter(si, UD1DimPk, "U1#Root.TreeDescendants", False) For Each item In listMI BRApi.ErrorLog.LogMessage(si, item.Member.Name & " | " & item.ParentMemberId) Next I've also tried to include DimDisplayOptions and MemberDisplayOptions using following but I have had no luck Dim cubeID As Integer = BRApi.Finance.Cubes.GetCubeInfo(si, "MY_CUBE").Cube.CubeId Dim scenarioID As Integer = ScenarioDimHelper.GetIdFromName(si, "Actual") Dim dimDisplay As DimDisplayOptions = New DimDisplayOptions(cubeID, scenarioID) Dim memberDisplay As MemberDisplayOptions = New MemberDisplayOptions(True, CultureInfo.CurrentCulture.Name, True, True, True, True, True, 0

Hi Everyone. I am performing a conversion in a SQL query using currencies; I relied on this other post for now. Where is stored the Currency Name ?  The problem I have is that I have some SourceCurrencyId in the FXrates table that don't appear there, so I want to know if there's a way to get all possible currency names through a business rule.

Hi, is there a standard IRR calculation that can be shared? thanks, Greg

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.

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}',

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

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

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.

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. 

Dear community. I have a use case where I need to sul up data from 2 different entities and apply a ratio on it. For this, I would like to use a data buffer. However, the data buffer typically only run on a data unit hence 1 entity at a time. So I created a data management job dat would run on these 2 entites, and I wanted to use a Globals object along with this data buffer so that I could store data from these 2 entities into a single data buffer. However, I'm not sure if it's the right way to do it ? Is there a way for a data buffer to take data from 2 entities ? Or, if I use a globals object with a data management sequence, is the Globals object persisting when running on 2 different entities ? Many thanks for your anticipated feedbacks ! Regards,

When i tried copying the data from one cube to another cube using Eval function with Buffer [Calculate(formula, onEvalDataBuffer, userState)], the data got copied at the base level but as soon as i consolidated it, the data got cleared from the same destination intersections.On checking the cell status of the destination cell (intersection), i found that the storage type is Calculation Whereas, if we use api.Data.Calculate(formula, isDurableCalculatedData), the storage type is DurableCalculation, and consolidation works fine after using this Calculate function.We do we have a boolean parameter to set the DurableCalc as True or False in the api.Data.Calculate(formula, isDurableCalculatedData) function, but i didn't see any such parameter or setting for Buffers [Calculate(formula, onEvalDataBuffer, userState)].How can i make the StorageType as Calculation to DurableCalculation for Buffers, so that the values doesn't disappear after consolidation ?   

Hi All,I am trying to extract data from cube view using FdxExecuteCubeView function and load the result back to cube through a connector. However, when I execute the workflow dataload, a "No valid DataKeys (Scenario / Time)" error occurred. I checked the log, it pointed out to be "Non-Numeric Amount ..................... 4" error On the log, I am able to see the data I extracted as this :4: Cube1, 568123, , Local, Budget, 2023, Periodic, 702151, None, BeforeAdj, None, 500100, None, None, None, None, None, None, None, 959.799999996It seems that the data was pulled right, but just the amount cannot be recognized as numeric dataOn Data Source, I did map "Amount" to the "Amount" column. I am not sure why 959.799999996 is not considered as an amount? Here is the mapping.   Here is the Rule itself. Case Is = ConnectorActionTypes.GetFieldList'Return Field Name ListDim timeMemfilter As String = "T#2023"Dim isTimePivot As Boolean = FalseDim useGenericTimeColNames A

We are currently using something like this to pull in the Global Time on the email we send out after the automationDim gTime As String = BRApi.Workflow.General.GetGlobalTime(si) This works just fine, however we would like to also have the option to load by wf which works we just cant get the wf time to show up on the email. I cant find the syntax like I did Global TimeThoughts? Thanks!

I need to be able to write a confirmation rule that checks for nodata vs a value of zero.   Can someone help with the syntax I have this - Dim cellstatus As DataCellStatus = api.Data.GetDataCell("Cb#CimpressConsol:P#TotCimpress:C#Local:S#Actual:V#YTD:A#BS_NoMap:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#None:U8#None").cellstatusbut I dont know how to build the If to check on the result.