Rules

We are still in the development stage of our OneStream implementation.  We are currently running 7.4.  When v8.0 came out, I started doing some research on .NET6 (and 7).  It appears that Microsoft is more focused on CSharp than they are on Visual Basic.  I believe, eventually, Visual Basic will be deprecated.  With this in mind, and since we are still in development, I was thinking about converting our VB business rules to CSharp and using that language going forward.I would like the feedback of the OneStream Community before I take this project on. Thank you.

Hi everyone! I have two entity hierarchies, one in currency EUR, and one in USD. I need to create a cube view to retrieve the FX rates based on the parent’s currency. I’ve created an account, for example ClosingRate, as a DynamicCalc. I am using this formula to retrieve the rate: api.FxRates.GetCalculatedFxRate(rateType, cubeId, timeId, sourceCurrId, destCurrId)   For the destination currency, it’s straightforward: Dim destCurrId As Integer = api.Pov.Cons.MemberPk.MemberId But I am unsure how to set the source currency as variable, I usually either set it to EUR, or USD. Dim sourceCurrId As Integer = Currency.EUR.Id Is there a way to get a parent’s currency? Or, I had another idea. To create a Text1 property at the level of each entity base member, to specify the Parent’s currency. I can retrieve it in the script as a string, but after that I don’t know how to get the Id. Appreciate your help! Thank you!

hi,Two account A and B needs to be subtracted in the source applicaiton and assigned to the third account on destination application  in the transformation rule for App2App copy process . Below is my Composite but its throwing error for one-one transformaton mapping.  TR Composite Rule:Validaiton error:  

Hi guyswe frequently work with data buffer (or sometimes even with setcell) and there's a problem for which I coudn't find a solution. E.g. we have an allocation setting the values to certain intersections in the target data buffer. If among all cells to write some of them are invalid intersection (not within the constraints of the account for one or more Flow/Ud element), there's no error and they are simply not written. From here: is there a function to test an intersection and check whether it's valid or not? Is there a function to do that for the whole databuffer without loops and get the list of invalid records?Even worse, sometimes the target members don't exist and we just get an error. But I need to log the data buffer and investigate each single row to identify where the problem is. Is there a function or a best practice to get a log with the rows in error in case the target members don't exist?We found this function(s) api.Account.IsFlowICOrUDMemberWithinConstraintM

I am debugging some business rules.  I would like to add a Console.WriteLine, but I am not sure where that gets written to.  I would like to avoid clogging up "Error Logs" and a simple MsgBox is not enough. Any suggestions on where to look? Thank you.

Hoping someone in the community might have a solution for this and is willing to share a snippet of code that will enable us to properly 'clear' any data (including zero) from a specific intersection so that we can delete a metadata member.The DM step "Clear Data" is simply too all-encompassing to use in this case and we need to be more surgical in our approach.Thanks in advance for any assistance.

Hi,I need to create an account to calculate two values multiply together.I had set formulapass2 and set the formula as below:api.Data.ClearCalculatedData("A#COG762D:U1#None",True,True,True)api.data.calculate("A#COG762D:U1#None = A#COG931:U1#ALLDEPT * A#KPI142:U1#1520")It shows zeros while A#COG931:U1#ALLDEPT is 100 and A#KPI142:U1#1520 is 25.May I know why? Thank you.

Hi All, I want to seed the data from below source, please help me how to write a code for the below data copy. Target:- api.Data.Calculate("V#PERIODIC:O#Import:U3#" & UD3 & ":U8#UND_UD8:U4#" & CurrWk & "= Source:- RemoveZeros(S#Actual:U4#TOP:T#" & Priortime & " - S#Weekly_Processes:U4#Week_1:T#" & Priortime & " - S#Weekly_Processes:U4#Week_2:T#" & Priortime & " - S#Weekly_Processes:U4#Week_3:T#" & Priortime & " - S#Weekly_Processes:U4#Week_4:T#" & Priortime & ")","A#KPI_PPV_MONTHLY,A#KPI_TOT_PURCH_DPO",,,,,,,,,,,"U8#Top",,,True)

Hi all,I'm currently developing a dashboard for a client and I need to assign a literal value to a dashboard parameter from the BR code. I'll try to explain the issue better:I created the following parameter "test" within a dashboard group: within the BR, I entered the following: In this case, I'm trying to assign the text "SampleText" to the parameter "test".I then created a combo box, I assigned the parameter "test" as a bound parameter, and placed the combo box in the dashboard: My goal is that, once triggered the BR, I will be able to see "SampleText" in the dashboard. Once the BR is triggered, though, no value is assigned to the parameter, and the combo box remains empty. What am I doing wrong? 

Hi - Is there an BRAPI to get the current form name from WF Profile ? I was able to get the list of Forms using the below code but I looking for when a user select the form it should return. Let me know if there any BRAPI functions  Thanks  Dim objBRApiForms As XFFormsForWorkflow = BRApi.Forms.Metadata.GetForms(si,si.WorkflowClusterPk) 'Get the List of Required Forms Dim listfrm As List (Of XFFormSummaryInfo) = objBRApiForms.OptionalForms 

Hello Team,I am trying to extract Dashboard specific items using the ExtractDashboardsXml.I can only make it work when I use the Options ExtractAllItems = True.I am running OS 7.4.2I can not find any information on this formula. I would like to have an example on how we should the extractItems. Can you please provide an example? Especially on what is expected in the extractItems. ExtractDashboardsXml(_ ByVal si As SessionInfo, _ ByVal isSystemLevel As Boolean, _ ByVal options As XmlExtractOptions, _ ByVal extractItems As Dictionary(Of XmlExtractItemPk, Boolean) _ )   Thanks!

Is it possible to pass a bound/delimited list parameter or an XFBR through a dynamic calc? I know you can pass a literal parameter through the calc but was wondering if anyone has passed through another kind of parameter?

Hi Community, Do we have a method for adding Finance Business Rule for Cube view Report.Any solution to this would be very helpful and appreciated.Thank you.

We want to make some forecast periods read only ( Data seeded periods from Actuals) in a Data submission cube view by referencing the period count submitted in another Cube View. Basically, this is to deal forecast data submission.Trying to achieve this by Dashboard XFBR string and that string is referenced into the Form template -> CubeView to make certain periods as readonly, so that they cannot submit the forecast data for those periods.Below is the script that we are using the get the Period count submitted in a specific POV( to start with, hard coded all the POV members)----------------------------------------------------Dim strActMonths As String = api.data.GetDataCell("E#FC_Seed_Entry:P#:C#Local:S#FC11:T#2023M12:V#Periodic:A#FC_Seeding:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#Text3:U6#None:U7#None:U8#None").CellAmountDim iActMonths As Decimal = 0iActMonths = strActMonths.XFConvertToInt----------------------------------------------------We have called this into

hi,I have created the custom table and loaded the records into it using the Finance BR. Finance BR is called by the DM step and now i have to read the custom table records and render  into the import step of the workflow on clicking the load and transform button . Any steps on this is appreciated. Thanks  

hi,I have an calculated form data stored in UD8 as shown below. Its not showing up in the quickview retrieval. Is that because of the status code . Below are the screenshots from database and quickview. Am expecting the Value 12 to be retrieved in the quickview. Data record Cell POV: Cb#*****:E#*****:C#CLP:S#Forecast_Working:T#2024:V#YTD:A#TOTAL_VENTAS_NETAS:F#None:O#Forms:I#None:U1#0082:U2#None:U3#Other_LMD_3P_Platform:U4#Base:U5#Comparable:U6#None:U7#None:U8#LRP_AllocatedAmount   Quick view POV: Cb#****:E#********:P#?:C#CLP:S#Forecast_Working:T#2024:V#YTD:A#TOTAL_VENTAS_NETAS:F#None:O#Forms:I#None:U1#0082:U2#None:U3#Other_LMD_3P_Platform:U4#Base:U5#Comparable:U6#None:U7#None:U8#LRP_AllocatedAmount  

hi, I  have  custom table created with records  using the finance BR. Second step is to send the data from the custom table to another applicaiton using the connector rule. Is there an option to call the above two rules in single datasource in the above order or it has to be two individual workflow steps.  Thanks

Hi community, For one of my clients I need to do the following:In cube 1 data is entered on an extended account dimension and extended UD1 dimension. Account dimension         RootAccountDimension                DetailedAccounts (members :10100) linked to cube 2                       GLAccounts (members : 100001, 100002, 100003) linked to cube 1 UD1 Dimensions           RootUD1Dim                   SummaryUD1 (members :None) linked to cube 2                           DetailedUD1 (members :Prop1, Prop2, Prop3, Prop4) linked to cube 1 Account Example is 100001, 100002, 100003 roll up to 10010 which is therefor a parent in cube 1 and is a base account in cube 2. Same for UD1 which has deta

If (uiItem.uiItemType = XFReportUIItemType.PageFooterDate) ThenDim combinedText As String ' Get the current date and timeDim currentDateTimecurrentDateTime = NowcombinedText = "Date & Time: " & FormatDateTime(currentDateTime, vbLongDate) & " " & FormatDateTime(currentDateTime, vbShortTime) ' Get the local time zoneDim timeZonetimeZone = "Time Zone: " & TimeZoneInfo.Local.Id ' Combine date/time and time zonecombinedText = combinedText & " | " & timeZone ' Set the text in the report footeruiItem.Text = combinedText ' Calculate the left position for the combined text to be right-aligneduiItem.Left = args.Report.CurrentPageInfo.RightPosition - uiItem.WidthEnd If  This is my code to display date/time and time zone in the report footer but the code is not pulling the time zone. My question is, is it possible to pull the time zone?? If yes please provide a sample code  Thanks in advance!

 I'm trying to figure out where I can access the Key related to this error. I created a series of new accounts and member formulas by extracting an existing set of accounts from our application.I opened the extracted file in Notepad and performed a find/replace on account names and formula members, saved my changes and uploaded the modified file.When I try to consolidate, I get the same error as above for every account I added this way. is there are way to fix this, short of deleting the new accounts and adding manually within the application? 

Hi there, thankful for immense contribution from community that has made life easier as a system admin. Currently working on a requirement to query stage data for specific Entity, Account, Scenario, UD1 through UD5 and reseed it back to a intersection that got changed by user input to allow admin to revert any changes done by users. I tried using the below:   Dim criteria As New Text.StringBuilder criteria.Append("U1T = '" & ud1_seeded & "' ") criteria.Append("And U2T = '" & ud2_seeded & "' ") criteria.Append("And U3T = '" & ud3_seeded & "' ") criteria.Append("And U4T = '" & ud4_seeded & "' ") criteria.Append("And U5T = '" & ud5_seeded & "' ") Dim dValue As Decimal = api.Functions.GetStageBlendNumber("TestCube", "TestEntity", _ "TestScenario", "2024M1", "TestAccount", BlendCacheLevelTypes.Custom, "Test", _ "TestWorkflowProfileName", "U1T,U2T,U3T,U4T,U5T", criteria.ToString, "Amount", _ BlendNumericOperationTypes.FirstValue) &nb

I want to read a list of members from a excel file which is store in OS file system and store that list of member ID in a list to perform further calculation

hi,Cell data for the below intersection has been saved into the cube.  Error logs  shows the percentage value getting saved into the intersection. But its not showing up while reteieivng with the Quickview with the same intersection. Any property needs to be updated. UD8 member LRP_Percentage  has been used to store the percentage value.  Thanks 

Mocking up a Prototype using the new Assembly feature in 7.4, I would like to be able to reference an Extender Business Rule within a Dashboard Assembly file. The scenario is, that I have a custom class (POCRunner) in an Extender file, and want to be able to call functions on that class object, when hitting a button in a Dashboard. I can't seem to find the right combination of assembly name and/or dependencies. The argument to have the custom class in an Extender, is also to be able to utilize a Data Management Sequence to trigger a job, calling the POCRunner class.Otherwise open for any other suggestion / approach.Thanks

Is it possible to show the task progress dialog (see picture below) of a DM task started in a BR. Dim task As TaskActivityItem = BRApi.Utilities.ExecuteDataMgmtSequence(...) ' Do something with task to show dialog? Or is there another way to consolidate from a BR, where it automatically shows the progress dialog?Context: Button -> Dashboard Extender BR to change params -> DM sequence -> Consolidate. I need the Dashboard Extender API on same button press to change params, so can't call the DM/consol directly from button press.