Rules

Text1 in workflow has two entity seprated by "/"   Text1 parameter Entity1/Entity2   I'm trying to achive rule   If entity=entity1   calc1   else if entity = entity2   calc2        end if  end if     How do i retrive entities in text1 seprated by "/"

I need to create a business rule that will move a file from a user's folder in File Explorer to the server's File Share. I am using the BRApi.FileSystem.GetFile method to successfully read the file, but I am unable to write the file to the server. I believe my issue is with the XFFileInfo parameters. I am not sure how many parameters to provide and what the value to provide for the folderFullName parameter. Here is my current code: 'Get the file Dim sourceXFFileEx As New XFFileEx sourceXFFileEx = BRApi.FileSystem.GetFile(si, FileSystemLocation.ApplicationDatabase, sourceDir & "/" & sourceFile,True,True) 'Save the file but this part is not working Dim targetFileDataInfo As New XFFileInfo(FileSystemLocation.FileShare, fileName, ??) Dim targetFileData As New XFFile(targetFileDataInfo, String.Empty, sourceXFFileEx.XFFile.ContentFileBytes) BRApi.FileSystem.InsertOrUpdateFile(si, targetFileData)  

Hi ! I'm looking for a way to change a value of an input value parameter type using a business rule. The use case is quite simple : the user will input a value in order to calculate a data. However, using a button I would like to "reset" the input value with another value. I can easily change the value of a "litteral parameter" with a business rule, but I dont know how to change the value of a "input value" parameter type (needless to say, a litteral parameter will not allow my user to input a value !)  ... so what would be the best way to achieve this ?   Regards,

Hi,While we copy from Scenario S#Bud1 to S#Bud2, Annotations are not getting copied.Understand from related posts, it can be achieved using api.Data.SetDataAttachmentText(). Any tried approach using this syntax.Any leads would be appreciated.Thanks

Hi All, I am aware of various options available for copying scenario data in OneStream. These options (data management or custom calculate) usually copy only periodic data across scenarios. Any idea how annotation data can be copied from sceanario1 to scenario2 in OneStream? Any leads would be appreciated. Thanks Bharti

Hello ,I am currently developing my Cash Flow Statement  and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement  variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement? Thank you for your help .

We would like to get the POV that a user set in a Dashboard (through Form Templates) and apply it to each other dashboards that they go into. We use to call this a "Sticky POV". Currently, dashboards will hold the POV from the last time a user was in each dashboard. We want to carry the most recent POV into all dashboards. Does anyone have examples or know how to set this up / use it / access it...? Thanks in advance.  

I trying to bind a combo box with bound list type parameter. The bound list parameter is using Command Type - Method and Method Type - Business Rule please see below screen shots. When I test the parameter it is showing results but combo box is not loading values on dashboard. Any help is appreciated. Sorry not able to attach images.

Hi All, We have alert configuration if a workflow step failed. Similarly, can we configure alert IF DM sequence failed? -Asish

Hi All - I have the below rule, which calculating 30% on NI and Copying it to the InvestmentinSub account from one entity to another. The rule is executing without any issues, but data is not copying to the target entity. Any Help would be appreciated.  I was able to see the correct value in the log Buffer, but the data is not writing to the DB.     Select Case api.FunctionType Case Is = FinanceFunctionType.Calculate 'api.Data.Calculate("A#Profit = A#Sales - A#Costs") Dim resultDataBuffer As DataBuffer = New DataBuffer() 'Data will be written to the Destination. Dim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("") 'Consol Member Dim parentCurrencyName As String = "Local" 'Source Data POV Dim sourcePOV As String = "V#YTD:C#" & parentCurrencyName & ":F#EndBalInput:O#Top:U1#No_CostCenter:U2#10:U3#No_Projects:U5#OracleDataLoad:U8#No_UD8" 'Filter for BalanceSheet Accounts which has text1 as Investments. Dim filter

Hi everyone,   I'm having issues when launching the consolidation process after loading data on the cube. Below you can see the calculation that is triggered when the consolidation process is launched:   api.Data.ClearCalculatedData(True, False, False,"A#2A900A01","F#CHI","I#None") api.Data.Calculate("A#2A900A01:U1#None:U3#None:U5#None:I#None:F#CHI=A#3ABCDEF0:U1#TotProduct:U3#TotMarket:U5#TotCostCenter:I#Top:F#None") The 3ABCDEF0 account is the top node of the PL account hierarchy, and the intersection is correctly populated. The 2A900A01 is the balance sheet account that should be populated as a result of the consolidation process, nevertheless it doesn't get populated. I have already verified the intersections, and they are correct. Does anyone have any suggestion on why the 2A900A01 account does not get populated? I know the question is a bit vague but I'm really struggling to understand what the issue might be Thanks in advance for any help!

I am trying to post an adjustment to OwnerPostAdj member using FinanceFunctionType.Calcture function, is it possible to do that. If so could you please share some reference or if there are any cube level setting that I need to make. Currently I am getting the following error, even if I specify the OwnerPostAdj as a part of my data unit, but same works fine for Local member: 

Hello All, Anyone knows how we can achieve Consolidation- NCI, Equity pick up, GW calculation in OneStream?

Hello, I'm trying to get all the stored items of Entity relationship properties, but w/o success. Any idea what I'm doing wrong? Dim oVMProperties As New VaryingMemberProperties(DimType.Entity.Id, iChild, iParent) Dim oVMPropertiesStoredItemsList As List(Of VaryingMemberPropertyItem) = oVMProperties.GetEntityRelationshipProperties().PercentConsolidation.GetStoredPropertyItems() I'm expecting the list (row #2) for some use cases (relationships) should return > 0, and it seems to be always 0: {sChild} under {sParent}: {oVMPropertiesStoredItemsList.Count} | {oVMProperties.GetEntityRelationshipProperties().PercentConsolidation.GetNumStoredPropertyItems()} | {oVMProperties.GetEntityRelationshipProperties().PercentConsolidation.HasStoredPropertyItems()} None under Root: 0 | 0 | False CONSOLID under Root: 0 | 0 | False INACTIVE under Root: 0 | 0 | False Global under Root: 0 | 0 | False TOTAL_LE under CONSOLID: 0 | 0 | False

I'm struggling to understand how exactly to calculate what I need, a confirmation of direction and a little guidance would be great!  I need to calculate an account value (Factored account)  from a Driver account * a Percent account.  The Driver account data contains many different dimension attributes (product, region, customer, etc).  The percent account is at the 'None' member of those different dimensions.  The calculated Factor accounts need to be at the same level (members) as the Driver account.  I'm sure (i think, lol) I need to use the data.calculate, but I'm struggling on the syntax of the function to calculate using data at 2 different account POVs, and the results residing at the same level as the Driver account.  Whether I'll need to create data buffers and manipulate / save or simple filters within the data.calculate.  I do have multiple Drivers for some Factored account (i.e F1 = (D1*Pct) + (D2*Pct) + (D3*Pct)), and multiple Factor

Using the below rule it seems my derived Zeros are being copied as real data zeros as a result of my Forecast Seeding data calculate.  This is causing a problem with my "isrealdata" check in my override rules.  I can do a work around on my Actual data by copying the already calced amounts and then suppress the calc rules, but then if the users have forecasted override changes they won't work.  I guess my question is can you use a Data Calculate that will result in derived zeroes for the copied Actual periods? Case "FC_Sep" Select Case curMonth Case "M1","M2","M3","M4","M5","M6","M7","M8" api.Data.Calculate("S#" & curScenario & ":O#Import:V#Periodic = S#" & actScenario & ":V#Periodic", "A#Balance.Base",,,,,,,"U4#Top_Srce.Base.Remove(Calc)",) api.Data.Calculate("S#" & curScenario & ":O#Import:V#Periodic = S#" & actScenario & ":V#Periodic", "A#Nat_Net_Ctrl_Income.Base, A#S_Dozens, A#S_NCIpct",,,,,,,"U4#Top_Srce.Base.Remove(Cal

Hi Experts,I have to eliminate Equity and write elimination portion to NCI account. as part of this firstly i am testing with one of the equity accounts i.e "Sharecapital". For this i have written a rule as below and when i execute no errors as well no results. i do not see any reversal entry in C#Elimination.O#Elimination of source buffer value.Kindly evaluate and help me if i am missing anything in the rule. even i do not see any record in the source buffer log. but there are records at C#Share for A#Sharecapital account. Rule >>>>Case Is = FinanceFunctionType.ConsolidateShareDim entity As String = api.pov.entity.NameDim entityID As String = api.pov.entity.MemberIDDim Pown As Decimal = api.entity.percentOwnership(entityID)Dim Pcon As Decimal = api.entity.PercentConsolidation(entityID)Dim pmin As Decimal = Pcon-PownDim vMethod As OwnershipType = api.Entity.OwnershipType(entityID)If Pown > 50.0 And Pown < 100.0 AndAlso vMethod.ToString = "FullConsolidation"

Hi Team,I am wondering is that posible to export Error Logs or Task Activity with business rule? I know we can extract data from cubes or dimensions using BRApi methods, but is there a similar approach that allows us to export Error Logs or Task Activity? If so, what methods or steps are needed to achieve this?

When loading data, all of our accounts from source match the names of the account in OneStream so we've always used a *:* rule for the account maps. However, we have a new dataset coming in and we need to flip the sign for those accounts that are of account type Revenue in OneStream: not assets or anything else, just revenue. I have working code that will conditionally do something if it's a revenue account else pass through... but I don't know what that something should be to flip the sign. Other people have posted questions about how to do a sign flip in a complex expression but there are no answers. I definitely do not want to maintain a manual list of 1,500 1:1 rules that do nothing but flip the sign. The complex expression feels like the only scalable solution but this detail is missing.

I'm curious about these four finance function types and whether anyone has worked on them: CalcDrillDownMemberFormula ConfirmationRule DynamicCalcAccount ReadSourceDataRecords If someone has worked on these, how do we call and use them? Any insights?

Does anyone know how to write a formula that calculates an average based on the POV's number of days? Thanks

Hi Team,I need to parameterize my Cubeview where I need to sum two flow member data and show it in my Cubeview , For which i need to write a rule in that rule I have to create a temporary variable member (Total) which doesn't exist in our flow hierarchy which will contain sum of our flow member (RFX_Input + UFX_Input) data, and this Total variable member we have to parameterize and so that when Cubeview runs it'll show me the total value of (RFX_input + UFX_input) into my Cubeview. Please help me to guide how to write this rule logic. We have tried creating it as a parameter with getcelldata but the cubeview does not render and timesout.  

Hi, I have a requirement where I need to compare a member in list of members (listOfmem) and see if the member exists in list. How to best handle this as it seems like I can't use "Contains" function?  Dim listOfmem As list(Of memberinfo) = BRApi.Finance.Members.GetMembersUsingFilter(si, U2DimPk, U2DimMem, True)   Thank you in advance, Mikki

Does anyone have experience leveraging GitHub or any other code version control tool to manage Business Rules with OneStream? Assuming we have a remote Git repository on GitHub that keep track of all of our business rules. How do we push the code from remote repository to OneStream? Or in other words how do we run git command to push/pull. In this context, we want to assume there is file system on cloud store all the business rules in file format.  If there is no file system on OneStream, how are the Business Rules managed on cloud? Any pointers will be appreciated. We found a way to update the Business Rule table: xml_data in Application Database. But we are seeking for better options.    

I feel like an idiot asking this question but I can't find anything on google. Where do all of the 'Helper' classes come from? TimeDimHelper, StringHelper, ApplicationZipFileHelper, ScenarioDimHelper  Are these all OneStream specific? Is there any documentation or good posts about their use? Thanks, Scott