OneStream Platform Forums

Hi Everyone,Has anyone worked on establishing an SFTP connection in extensibility rules using a PPK file? I am currently facing an issue where, despite setting the SshPrivateKeyPath property in the session options, I receive the error: "No supported authentication methods available (server sent: publickey)."Any insights or solutions would be greatly appreciated.Thank you,Mithun

I have a custum tree hierarchy with multiselection,  It looks like this  Is there a way to format this component to open like this:  

I am implementing a BR that pulls a file from FTP. The file is encrypted so I need to decrypt it using a third party library. In order to decrypt it, I need to pass in a physical path to the PGP key provided. I uploaded the key to the Public folder share for now but cannot seem to find a way to get the actual physical file. Does anyone know if uploading a file to the share folder results in an actual file being created on the server or is it just stored as a BLOB in the database?  

I have a cubeview with 1 Row = A#NetIncome.TreedescendantsInclusiveR. I would like to have the accounts collapsed, so that the report doesn't have all the accounts/rows expanded.I have set RowExpansionMode = CollapseAll, but it did not change anything and all rows are still expanded. Am I missing some other configurations?

Does anyone know if you can create an Excel spreadsheet from Business Rules? I do not mean a csv file - I need to create multiple sheets. The OpenXMLBuilder object doesn't seem to have anything with writing files. I don't want to use a third-party object as that would require an installation or download. Thanks for any suggestions.

Good DayI would like to know if it is possible to extract a table out of a DEV onestream app and then upload that table in a UAT onestream app? If not, are there any tools on marketplace which can assist in doing so?RegardsRehaan

Hello,I am working in an 8.5 application and want to utilize Finance Custom Calculate services within a dashboard. My service factory is enabled at the Dashboard Maintenance Unit level of detail. I am trying to launch the custom calculate function via a dashboard button.Does anyone have example syntax for this? I figured OneStream would release documentation externally for this but was unable to locate any. Thanks! 

I used data management jobs to extract historical data from a legacy application and they are now sitting in file explorer and are split-out by period. I need to extract these files to load to a new application. I tried holding shift and control on my keyboard to highlight multiple files but I did not have any success. I believe this will need to done via business rule but I am unsure. Please let me know if I can provide any additional information.

We have been running several tests on DM jobs to upload batch files through the Harvest. We have a lot of subfolders created that we don't need anymore. Is there any way to delete? Thanks!

hi experts. i'm trying to use a button on dashboard that calls a DM sequence. in my sequence, i'm calling copy task. Basically, i'm trying to copy data using DM step where i want to pass scenario as parameter. here is the configuration. How to pass parameter to copy task from sequence?    button configuration: Sequence - parameter definition  copy step:  

Hi, I am trying to explore the FDXExecuteStageTargetTimePivot if I can use it to show stage data. Does anyone have the business rule and shareThank you

I am writing a simple api.data.calculate code in C#. Somehow it is not able to recognize Durable data "true" but it does work vb.    

I have an issue that I have seen before I never figured out so want to see if others have encountered this and figure out what I am doing wrong.  I have a data adapter that calls a Dashboard Dataset BR to get populated.  I pass in a parameter like "Parameter1=|!SomeOtherParam!|".  When I use "args.NameValuePairs.XFGetValue" to get the Parameter1 value is returns "|!SomeOtherParam!|".  I expect to see the actual value of SomeOtherParam or nothing but not the literal param with pipe and exclamation mark.  Has anything encountered something like this before?

Hi,I need to use inside my Table View service some parameters that are bound to combo boxes in order to write a query, and execute it when the "SaveTableView" function is called. Unlike the "GetTableView" function, SaveTableView's signature doesn't provide a parameter that contains all substitution variables (Dictionary<string, string> customSubstVars for GetTableView)I also tried setting the customSubstVars dictionary into the BRGlobals from the GetTableView function, but once you try getting the dictionary from the globals, it returns null.Is there no way of getting this customSubstVars dictionary to use it inside SaveTableView?

Hi, I have set all security settings on an entity to "Nobody" and yet when I see a dashboard using a non-admin user I still see data. The same when using a spreadsheet. This does not make sense to me. What am I missing? 

I am trying to create a label which needs to display the gross profit in my dashboard. I have created a data adapter (when running the adapter, it's showing the relevant data) and attached the same in the label. But I am not getting any data in label. Can someone help/suggest what I am missing? 

I've heard about org by period since my first exposure to OneStream but I see nothing in the docs and no clear discussion about how it works or what the limitations/requirements are. Where does this information live?

I have a dashboard where I created Parameter1 using bound list which is referenced in a combo box. A button then passes the data to the business rule. The issue I am having is that it only recognizes the first selected member and ignores all other selected members. How do you pass a multiselect list from combo box in Dashboard in order to loop through the list?

Hello OS Community - We are in process of testing 8.5 version upgrade and running into below error on one of the BR, looking for solution any help is appreciated. Error at line 963:  Overload resolution failed because no accessible 'GetMemberInfo' is most specific for these arguments:    'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.    'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, dimNameOrEmpty As String, includeInheritedDims As Boolean, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.  

What is the default state of IsDurableCalculatedData if left out of an api.data.calculate statement?  I'm assuming it's false but I just want to double check.I'm seeing an api.data.calculate statement which contains an "onEval" statement, then a comma, then False.  If I look at Intellisense, the first field after the "onEval" is userState, followed by the Boolean for IsDurableCalculatedData.  How should I read this statement?  Is the False referring to the userState or to the IsDurableCalculatedData Boolean?Thanks,Bob

Dear all, Could you please advise if in OneStream there is a tool, which we can use to automate preparation of consolidated financial statements in Word format based on OneStream and outside of OneStream data (combination of OneStream numbers from cube views and texts that can be manually corrected)?  

I am trying to automate a yearly load of data from a business rule.  I want the rule to loop through a set of periods and run a specific workflow for that period.  The workflow uses a connector rule in which I get the scenario and period of the workflow being run.  THe issue I am facing is that I can get the WorkflowPK for the workflow/scenario/time that I want to run.  But when I call BRApi.Import.Process.ExecuteParseAndTransform with that key, a workflow starts, but if I happen to be on that workflow in the session I am running it picks up the POV from where I am at.  So if I want my business rule to run 3 periods (Jan - Mar).  If I am on Dec, then it runs December every time.  Below us how I get the WFPK and call the Dim wfClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileInfo.Name, wfScenarioName, wfTimeName) '--------------------------------- ' Parse and Transform: '--------------------

Hello All,Anyone know if it is possible to pass a parameter value into the PLP Register?  I have a method query returning a value based on scenario & year and need that to be the column header in the register.  This is more of a POC than a hard requirement at this point.Any creative suggestions are welcome. 

I'm making a simple event handler rule that sends an email when a workflow is processed. I would like the email to include the datetime when it was processed, the user who did it, the workflow, workflow profile and entity. However I've only been able to include the date and time. My code is structured like this: Main calls the sub XFR_HandleEndProcessCube() Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) As Object Try Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False Select Case args.OperationName Case Is = BREventOperationType.DataQuality.ProcessCube.EndProcessCube Me.XFR_HandleEndProcessCube(si, globals, api, args) End Select Return returnValue Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function XFR_HandleEndProcessCube() sub sends the email, using the help

Hi, My colleagues and I are interested in reviewing pre-transformed data side-by-side with the records from post-transformation data, as we're looking to move our transformation process further upstream and we wanted to validate the accuracy of our new transformation process against OneStream's transformations. I've reviewed the examples in GolfStream in the transformation event handler and I understand how to review the stage data, but I'm unsure how to find the matching transactions after they get transformed. Has anyone done anything similar before and would be able to share insights into how I can review the data at the validate and match them to the records in stage? Thanks! Alex