OneStream Platform Forums

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 want to load OneStream application data to external database. And there is an existing connection to the target external database. But it gives me below error, could you please help? No idea what is wrong. BTW, "FDH_DEV" is SIC external database connection.   'Build a data table with one test line Dim TestTbl As New DataTable TestTbl.Columns.Add("Tmt", Type.GetType("System.String")) TestTbl.Columns.Add("SEnt", Type.GetType("System.String")) TestTbl.Columns.Add("TEnt", Type.GetType("System.String")) TestTbl.Columns.Add("SAct", Type.GetType("System.String")) TestTbl.Columns.Add("SActD", Type.GetType("System.String")) TestTbl.Columns.Add("TAct", Type.GetType("System.String")) TestTbl.Columns.Add("TActD", Type.GetType("System.String")) TestTbl.Columns.Add("SFlw", Type.GetType("System.String")) TestTbl.Columns.Add("TFlw", Type.GetType("System.String")) TestTbl.Columns.Add("SIc", Type.GetType("System.String")) TestTbl.Columns.Add("TIc", Type.GetType("System.String")) TestTbl.Columns.

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?

Hi All,I am trying to create the dashboard where I pass all dimension from combo box to button that triggers the DM sequence that has the Export Data step. I get the following error mentioned below.FYI  please see the screenshot of the export data step mentioned below.Can someone please help? Where I am going wrong?

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

Hi,I am encountering a few issues with dashboard creation. My goal is to display all the reporting dashboards on a single dashboard. Below is a screenshot of my current setup.I have one combo box named "Report Type," which contains a delimited parameter with options like Balance Sheet, Income Statement, and Trial Balance. Additionally, there is a list box that contains a list of report names. I’ve connected a business rule to the list box parameter to dynamically populate the report names based on the selection from the "Report Type" combo box.I also created an embedded dashboard with the main cube view. Could someone please assist me with the cube view part? Specifically, when I select a report from the "Report Name" list box, its cube view should display on the right side.Could you help me understand the changes I need to make in "Consolidated Report_Sub_CV" to pull the corresponding report cube views based on the selection in the report name list box?

Hello, I was wondering if it's possible to have a check figure if the amount equals 0 that it displays "OK" and if it doesn't it says "Check Details". I've tried conditional formatting when the cell amount = 0 then "OK", but I figured I'm missing something or this might just not be possible. Thanks, Will

Has anyone been able to build a waterfall chart in BIViewer? I feel like this is something that I should be able to be done, but I can't find anything on it. Anyone know if this can be done? I know there is an advanced chart for waterfalls.  Thanks

All,I have a form populated with data & I am trying to retrieve the data through the Finance BR under calculate. It is not displaying the data in the error log.Sample Data. I am trying to retrieve the data at Parent Entity with Base ICP intersection. BaseICP - 3000Parent Entity - P10000.2The below is the code If api.Pov.Scenario.Name="Actual" And api.Pov.Cons.Name="Elimination" Then              Dim Entity As String = api.Pov.Entity.Name              Dim Parent As String = api.Pov.Parent.Name              Dim Ownership As Decimal = api.Data.GetDataCell("E#" & Parent & ":C#Local:S#ActualOwnershipCalcs:A#UltimateOwnership:F#None:O#Top:I#" & Entity & ":U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellAmount       &nbs

Hi All,  I create a spreadsheet business rule to refresh the data from external table using Table Views, now our users wants to drop these files into OneStream file share on daily basis so external systems can consume.  Is it possible to use parcel service to refresh these files (using table views with in the spreadsheet) and drop them into file share every time the job trigger ?  Or Is there any alternate approaches to export data from custom table to excel files ? Thank you. 

Is there a way to hardcode a number into a cubeview?

Hi All, Working with a dialog box with 3 parameters that are being used in a business rule later on. I want the parameters on dashboard load to always show the first value in my delimited list. Right now it always saved my previous selection. I have tried to set "Default Value" in the parameter itself, that dosen't work, guess it is only working on first load? I have tried to run a Dashboard extender BR like below to set param values on load of dashboard, but it dosen't overwrite my previous selection.: Only thing that have worked this far is to set a bound parameter with a set value on my button that opens my dialog box. However it seems to only let me add one bound parameter, I have 3.    Anyone having any advice how I can set one value from my delimited list to always appear when loading my dialog box. 

I'm trying to build a label that shows target goals for each entity. Now since each region has different goals. I'm looking for my label to change the value based on the entity selected.  Here is an example (We're still in development so not the most eye catching) Its referencing a parameter --  How can I pass a condition or a rule that reads the POV entity and shows me that specific value.