OneStream Platform Forums

Hi All!  We're trying to import form data via excel template, but the load is not validating certain tokens such as WF assigned entities and template name.Is there a way of adding validations/static values to objects of type FormRangeContent, similar to the ones in PLP for registerTableRangeContents ?Thanks! 

I am working with a Dashboard Extender BR and need to get the value of a cell. In another section of the code I am able to get the value of a cell in the V#Annotation but have not been able to figure out how to get the cell value of the V#Periodic. Any thoughts?

Hi Team, 2 users having the same access and same Cube view POV . One of the users is unable to see a total UD1 column while other can see it. Has anyone come across this before?

I am getting error on clicking on any of the artifact inside onestream application after i have logged in. For ex - If i click on dimension under application , it pops out that error. Strangely the error is happening only for me and not other users. Do you know of any Local onestream user data folder which can be deleted?    

Hi All,  I 'm trying to build a cube view report, it has numerous rows in it, However I need only TOP10 results. Could you please help me how do I select only Top10 results based on the total value? Assume that it is sales related information, Report has the details about all location sales. However, I would like to see only TOP10 location results (Based on the total sales)It would be helpful if anyone could assist on this ASAP. Thanks, Bharath

I found a C# code library and I'd like to use this class in VB.Net.  Here are the steps I've taken so far. 1. In my VB.Net Rule I've referenced the C# assemblies. 2. In my VB.Net Rule I've created a new object for the C# class 'Create an object for the class defined in External Assembly (Toolbox) so we can use methods in the classDim XIRRWrapper As New OneStream.BusinessRule.Finance.XIRR.CalculationWrapper 3. Now I'm able to create objects in the C# referenced assemblies in VB.Net Dim cashFlows = New List(Of OneStream.BusinessRule.Finance.XIRR.CashFlowDates ) From {New OneStream.BusinessRule.Finance.XIRR.CashFlowDates(-1000, New DateTime(2017, 1, 1)),New OneStream.BusinessRule.Finance.XIRR.CashFlowDates(500, New DateTime(2017, 7, 1)),New OneStream.BusinessRule.Finance.XIRR.CashFlowDates(507.5, New DateTime(2018, 1, 1))} 4. And finally able to run a function (LINE 55 which produces a warning) api.LogMessage( XIRRWrapper.XIRR(cashFlows, 6).ToString() ) I get the correct result.&nb

Hello OneStream Community,  I am wondering if anyone knows of a way to access the journal name and the user who triggered an action on a journal through a Journal Event Handler Business Rule.   Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False Select Case args.OperationName '1.Submit 2.Approve 3.Reject Case Is = BREventOperationType.Journals.SubmitJournal If (args.IsBeforeEvent) Then si.WorkflowClusterPk.UniqueStringI Dim wfProfileInfo = BRApi.Workflow.Metadata.GetProfile(si, _ si.WorkflowClusterPk.ProfileKey) Me.AddToLog(si, $"WFProfileName = {wfProfileInfo.NameAndDescription} - Journal Submitted") Dim wfGroupType = 6100 'Process wfGroupType Dim wfGroupUsers = BRAPI.Workflow.General.GetUsersInWorkflowGroup(si, _ si.WorkflowClusterPk, wfGroupType, True, String.Empty)      

Does anyone know how to delete Annotations? I have a DM step and no matter how I set it, it clears the numeric data but not the annotations. I see code to set an annotation value but do not see any code that will delete annotations.   Any thoughts?  Thank you, Bill

Hello OneStream Community, I'm seeking guidance on a functionality related to POV selection within the OneStream application and its transmission to Excel. Specifically, I'm curious if it's feasible to automatically capture the user's selected POV from OneStream and populate it into Excel cells using table views once the Excel application is initiated from OneStream. In my current setup, I've created a custom cube view that allows users to select certain POV members. There is also a custom button that exports the cube view in Excel using spreadsheet rules. The goal now is to have the user-selected POV members auto-populate within Excel cells. Has anyone implemented this functionality or does anyone know if this is possible? Any guidance or insights would be greatly appreciated. Thanks in advance for your help!

Hi - I have a dashboard XFBR business rule that calculates totals for members with a specific text value in a cube view. The rule is working as designed, and I have a couple GetDataCell functions in separate columns that reference these totals. However, I also have a UD8 member for variance analysis purposes that need the totals to determine whether or not a value exceeded a threshold - how do I pass what my business rule calculates into my UD8 formula? Here's the business rule for reference: If args.FunctionName.XFEqualsIgnoreCase("CVMath") Then 'Math function used in CV Dim MathFunction As String = "GetDataCell(" 'Suffix for GetDataCell function Dim Suffix As String = "):Name(Total)" 'Get ColNames to use in Math Function Dim ColNametoSum As String = args.NameValuePairs.XFGetValue("ColName") 'Prefix Dim ColMath As String = "CVC(" & ColNametoSum & "," 'Get cube view member filter Dim cvMemberFilter As String = arg

Hello All, Could be a very simple question but need help. I have a calculation F#Flowmember= T#TimeMember1+T#TimeMember2 +T#TimeMember3 in Local which works fine.I want a similar calc in USD as well, so i run the same custom calc through DM Step just changing the Consol Member to USD. Now the problem is, when i run consolidation. the USD Calculated values are overwritten by translation numbers which i dont want to and retain the custom cal which i did in USD. Any idea on this one..THanks in advance..

Is there a way to get a given Workflows JournalProcess, Approval and Submit Security Groups through a Business Rule.  I need to send an email to these users in the security group as these events happen.      

Hello Experts,Is it possible to use Combo Box and let users select value from the list in Cube View Rows (Headers) just like how we do in Excel. I see an option called Cell Type which has Combo Box but when i try it, doesn't work for some reason. Thanks in advance for the suggestions.  

I have a dashboard with a Label component that uses a Cube View as the data adapter. Here's how it's set up: The Cube View (CV) employs an XFBR in the account POV to retrieve one account number. Therefore, I've assigned XFBR(BRName, Function_Name, Account =[|!Param_Account!|]). The XFBR utilizes a Member List parameter from the same dashboard, where I've set the parameter's default value. The error occurs when I open the dashboard. The Label value attempts to run the Cube View, triggering the XFBR rule. However, it fails to capture the default value of the parameter, resulting in an error. My assumption is that the XFBR is unable to transmit the default parameter value. The workaround is to directly open the Cube View section and modify the account POV field to only include |!Param_Account!|, then run it once. This action somehow prompts the system to store the parameter value for that user. Subsequently, when the user runs it from the dashboard, the error is resolved. Do you ha

Has the syntax for Navigation Action changed to include workspace name in .v8? We have buttons that open up cubeviews that have been working fine in the past, but now don't work since we upgraded to .v8.1.  Others actions like open up workflow or other dashboards work fine. Just DataExplorer that's not working. TIA    

Hi All, I'm trying to create conditional formatting based on the scale. I would like to have the number format without decimals when the scale is set to 3 or above and vice versa when the scale is set to zero. Do you have any idea?FYI - The scale is a parameter that the end-user can select in the cube view.  Thanks, Davide

Hi All, Our external auditors are requesting an audit report showing all the changes applied to the cubeviews. I researched in the "application reports" but could not find anything that fits the requirements. Do any of you have insights or know of any potential workarounds?Thank you, Davide

I am hoping someone can point us in the right direction. We are being asked to map from the NetSuite Internal ID to the OneStream Member. What we had proposed was to map from the NetSuite External ID to the OneStream Member. I don't want to pre-empt responses by expanding on why we had suggested using the NetSuite External ID, but would really appreciate any insight from anyone who has done this or has the understanding to explain what good looks like / best practice. Many thanks in advance 

I have a dashboard that pulls Workflow status information.  It is currently hard coded to look at a top level Workflow parent, as it is for Group use only. I want to make this dashboard available for the regions too, and change the hard coded workflow selection in the dashboard to instead run from the Text 1 property in the user's security setup. How can I do that?  I managed to pull Text 1 using a SQL query, but this only seems to work for me when I set the Parameter as a Bound List. The problem with that is that the Bound list pops up as a selection when the dashboard is run, which I don't want to happen. It should be seamless. 

Dear Community,   I'm currently working with event handlers and need to retrieve workflow-related information within the FinalizeValidateIntersect operation. I'm using si.WorkflowClusterPk to access this data, but I'm exploring alternative approaches to avoid relying solely on this method. Thank You.

Can I execute an sql statement against a data table created in a business rule?  I created a table to use in a data set business rule, which returns data to the data adapter.    e.g. if I created dt1 using : Dim dt1 As DataTable = BRApi.Database.ExecuteSql(dbConnApp, strSQL.ToString, True) Can I run a query against dt1, doing something like "select * from dt1" or in other words can I get the tablename for dt1 and then execute a query?

Hi Team, We have 2 similar processes under one member in workflow. I need to lock process A, when B is completed. Could you please advise what method to use?  Many thanks!

New to OS and I have requirement to automate fx rates in OS. Is it possible? We have FX repository in Oracle so, thinking to pull from there but not sure how can we load to central FX repository.    

When I have a BR, and need to pull in a parameter, I use the following statement or one similar, I create the parameter in a Dashboard. 'Dim scenario As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "Forecast_Scenario") How do you bring a parameter into SQL ?  I tried the above and it doesn't work.  I would like to set a parameter such as date, and then bring the parameter inside SQL, the same way I do as a BR. Thanks for your help in advance. Tom

When loading data into OneStream, our longest workflow takes ~40 minutes to load. We would like to try to kick off the 5 direct connect loads within this workflow to start simultaneously instead of sequentially. Have any of you organized your loads similarly and do you have tips or recommendations please?