OneStream Platform Forums

Hi,   ParamA will be a multiselect combo box and the same should be passed to business rule as well. May I know how it can be done? I'm passing the parameter in calculate button, then DM step and then to BR. Calc button : {seq_name}{ParamCC = |!ParamA!|} DM step: {|!ParamCC!|} BR: Get value of ParamCC Need suggestion on how should it be passed if parameter is multiselect. thanks

OS Version 7.3.3My files are stored in a Named Workspace, "Finance WS"I want to open a file stored in Finance WS.  How do I get the workspace guid to accces the file? Dim guidWs as Guid = ???BRApi.Dashboards.FileResources.GetFileResource(si, False, guidWs, strFilename)

Hi, I have a matrix data source matrixed on Account.  Sample below.  One of the Account fields is a Date that I need to convert to a Long to store.  I can do the conversion but not sure how to target the value to convert when in a matrixed data source. If it were a delimited data source I would use: Dim sDateField As String = api.Parser.DelimitedParsedValues(6).  Is there a way to identify the value in a matrixed data source? thanks Greg Code1 Entity Account1 Account2 Account3 Test1 Entity1 1/1/24 0.025 0.5 Test2 Entity2 5/1/24 0.025 0.5 Test3 Entity3 3/1/25 0.025 0.5

If an API and a BRAPI accomplish the same action, like returning a text field from an account, a developer can use either without consequence in a Finance Business Rule. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

I am trying to create a Cube View that has 2 GetDataCell formulas.  The formulas work separately but if I add them both to the same Cube View, one will not work.  I am using XFBR in Columns (Time) and GetDataCell in Rows (Accounts).  Is there a way both formulas will work in the same Cube View?      

I'm trying to load a file that has data in multiple columns like below.I have created the data source with a Data Type as Matrix DataKey and created source Time Dimensions for 12 months as stated in the screenshot. But when I try to load the data, I get the below error every time. I have already created transformation rules for Scenario and time as below and not sure what else I'm missing here. Can someone please help with this one?Error Message: Thanks...!!!

Hello, I am getting this error when trying to access FileShare under FileExplorer:   The path is not of a legal form. .Source code: WcfRetryManager.cs, line 299, method ExecuteRetries..Source code: WcfRetryManager.cs, line 369, method ExecuteRetriesStartingWithPreferredAppServerIndex..Source code: WcfRetryManager.cs, line 497, method TryExecuteAction..Source code: FileSystemWcf.cs, line 198, method EnumFoldersInFolder..Source code: FileSystemWcf.cs, line 853, method GetFolder..Source code: FileSystemOS.cs, line 185, method GetFolder.The path is not of a legal form.   Has anyone encountered this error previously? To me it seems like an application error but I am not sure where I can check further. Thank you.

I’ve noticed in working with the newer versions (that have Workspaces), that the SetLiteralParameterValue seems to only work on literal parameters in the default workspace.  However, I’m unsure if this is a bug or if this is by design.   My understanding from I saw at the Wave Conference was that Workspaces were intended to be used for better grouping of solutions, versioning, and development.  Currently, they support the creation of identically named parameters in multiple workspaces.  If you’re attempting to update a literal param in a specific workspace… is that even possible?  If not, are all active solutions intended to be in the Default workspace only?  Could someone please advise on the intended usage of Workspaces?

I am trying to use a dashboard button to Select All and Unselect All values in a Multiselect Combo-box which I am passing to a Spreadsheet (TableView) business rule. I have tried to run a Data Extender rule from a button that clears the data using the code below:  Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedCustomSubstVars.Add("lv_BusinessChannel", string.Empty)selectionChangedTaskResult.ChangeCustomSubstVarsInDashboard = True ' Set the Return valueselectionChangedTaskResult.IsOK = TrueReturn selectionChangedTaskResult

We are in cloud OneStream environment and our retention policy for Non Production is 7 days and Production 365 days ( I think ). Restore from backup does whole environment restore and not application by application. We have multiple application including PLP and I was wondering if anybody has figure out way to restore application.Any help or procedure or steps are apricated.Saurin Patel*migrated from champions

Has anyone worked yet with workspaces (loading/ extracting) using a .xfproj file?  I am trying to moved a dashboard maintenance unit (DMU) out of the default workspace into a new one.  However, when I export my .xfproj file (pre-7.3), remove the DMU from default, and load the .xfproj file back in I do not see it loading to the new workspace I created.  Is there something in the .xfproj file that needs added to accumadate workpsaces in 7.3?

SourceA10000_0TargetA10000How can we achieve it in different ways?1. Connector SQL query -> Using this in the sql query Select left(Account, len(Account)-2) leaves blank rows in the import step.2. Data Source ?     2.a. Logical expression             Return args.Value.Replace("_0", String.Empty) - This works fine.     2.b. What about Text Fill settings or Substitution settings?3. Transformation Rule ? 

    Base entities can be assigned to more than one Base Input Workflow. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

I'm loading a Fixed Width data file to Stage for Transaction matching. This file has:HEADER record that has the transaction_date in it.multiple DETAIL records with transaction type and amounts (but no dates).TRAILER record (Ignore for this sample)Goal - Load the DATE from header record on every detail record.Sample FileHDR01122023DTL0088351000000572975A000000018DTL0088351000000123456A000000018TRL000000What I want to load into OneStreamRecord_1:Date: 01122023Tran Type:  100Amount: 572975Record_2:Date: 01122023Tran Type:  100Amount:  123456 

Hi Community, We have a few scheduled calcs and consolidations running on an hourly basis, and sometimes these start queuing up and cause other DM jobs to fail/get cancelled by the system. Is there any good way to monitor or alert the admins via email if there are more than a few DM jobs getting queued up? We already have a scheduled task which queries the TaskActivity table for any failed jobs periodically and then sends out an email to the admins to address them. But this idea doesn't work for the Queued Jobs as this DM also gets "Queued" along with the others.   Thanks, Sudarshan

I am trying to figure out how to share a structure between OS BR files. In an Extender BR file named ExtenderBR I have:   Public Structure MyStruct Public Element1 As String Public Element2 As Boolean Public Element3 As Integer End Structure Public Function MyFunct1() As String Return "" End Function Public Function MyFunct2() As MyStruct Return New MyStruct End Function   In my Finance BR file, I include the BR\ExtenderBR from above and include a line   Dim ExtenderBR As New OneStream.BusinessRule.Extender.ExtenderBR.MainClass Dim xx As String=ExtenderBR.MyFunct1() 'This works ExtenderBR.MyFunct2() 'Generates error, as the Finance rule doesn't know about the custom Structure   Any thoughts how to share MyStruct across multiple OS Business Rules files?

How do others manage User Names in their applications? We were advised to use FirstName LastName as the user name, the Description field is not used (screen shot below). We have single sign on enabled which uses AzureSSO and the employees 5 digit number assigned by IT.   We have several name changes that we have held off on making in our application.  Our application includes a custom compensation model that also leverages the User Name and a separate security model within that module.  We can replicate the name change in the comp model and test;  however we are concerned about other implications that we have not considered. Our implementation partner highly cautioned us from renaming metadata.    I fully appreciate the complexities with Entity or Account metadata name changes;  however in this User Name metadata, the implications seem small (historical logs will have the old name pre change and new name post change, possibly an impact to their f

Hello, I am trying to create a FX Scenario - Acutuals at Prior Year Rate. I know i can use Constant Year For FX Rate and assign the year from which OneStream will pick Actuals rate in this case. But i dont want the user to be changing this property every year. My approach is to set "Translation Algorithm Type" to "Standard Using Business Rules For FX Rates" and create a custom translation for that specific scenario "Actuals at Prior Year Rate".  Does anyone has the logic to translate the scenario using Actual Exchange rate tables switching one year back from the POV being translated?

Hello - we would like to move specific Forms and Adj data from one application to another - data are extracted via Data Export in DM, does anyone have an example of the Extensibility Rule (BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile) to load the extract data? Many thanks - Wei

Hi, I have an application DB table with a date column and I am using the LoadCustomTableUsingDelimitedFile function to load a CSV file to the table. The xfDateTime# token is assigned to the column in the LoadCustomTableUsingDelimitedFile  function. The dates in the CSV file are in the dd-mm-yyyy format. However, the LoadCustomTableUsingDelimitedFile function assume the dates are in the mm-dd-yyyy format. Data is loaded but when querying the table using the Month() SQL function for example, the day is return instead. Is there a way to make sure LoadCustomTableUsingDelimitedFile  knows the date column in the data file is in the dd-mm-yyyy format? Thank you

  If you’re using a dimension for only dynamic calculation members, it needs to be enabled on the cube where you want to use that dimension. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi, I have a data management step/data management sequence that use member dialog parameters, which means users are prompted for the parameters selection when running them. I have attached the data management sequence to a Pre-process step of a workflow (via calculation definition, setting the filter value equal to the data management sequence name and using a DataQualityEventHandler rule). However, when running the Pre-process step the data management sequence runs using the default values for the parameters and users are not prompted for the parameters selection. How do I make so that users are prompted for the parameters selection when running the Pre-process step?

Hi,  I'm trying to look up values from a VLookUp table (previously made in the Transformation Rules) within a Complex Rule in my Data Source, MMomentoff how could I this? Thank you very much in advanced.   Best, Nieves

I am trying to create a form template using all base and Origin as form.When I am running the form through WF,i get a light green shade in the fields where I need to key in data.Any suggestion as to why I am unable to see the white cells?

Hi, We have a cascade entity structure, where one of the sub-elements consolidates up to a certain period, and after that period the other begins to consolidate. Entity A1 has an investment in Entity B11. Consolidating 2019M12, the application calculates an elimination of consolidated reserves in both parents Entity B1 & Entity B2, regardless of the fact that Entity B2 does not consolidate until 2022M8. I would like to know if anyone else has had a similar problem and has been able to solve it. Thank you, Sara