OneStream Platform Forums

Is there a non-admin role in onestream for health/performance monitoring, without any admin rights? Else is there a REST API to auto-export the "tasks" and "errors" logs on a recurring basis?     FYI, Since our recent v8 upgrade, my REST api calls to the onestream service are failing with intermittent and unexplainable issues.  The api never returns anything helpful in the way of an error message.  I only get 5xx codes with no content bodies.  I'm assuming that any information that may be relevant is found only by digging into the nullreferenceexception's (in the adminstrative tools found in the front-end U/I below)       ... while software developers should not be able to administer a production environment, we should be able to at least investigate these random and unpredictable errors (internal server errors).  I'm hoping there is some sort of read-only role for that, or at least an API to export the information that would otherwise be f

Happy Wednesday,  I'm trying to automate our account recs module. I have been successful in automating the data load.  But I'm trying to figure how to call that "process" within my extensibility rule.  I tried to trace back the rule that executes the process recons. What I found was a DB Extender rule (RCM_SolutionHelper), that is been referenced within a button component. Wondering if there is a way to call that function.   Would appreciate any ideas.   Best, Mustafa A   

Hi Team, Please help us if any possible way for below requirement. I have multiple rows and columns. here, If my three columns "Time 3(D2), Time 4(E2) & Time 5(F2) are have zero data, then Row "Entity 1(A2)" should get hide. i have tried CV suppression setting but it is suppressing the row when the entire row have zero or No data. Kindly let me know if any other setting needs to apply.    

Hi All,   I need some assistance in printing the to dimensionally get the parent name of the Child member. Code populating the base member into the table is completed without any error. Can someone please help.   Thanks   

Hey, I am working on rule to allocate cost to product. It worked when one side of buffer is unbalanced but I do have both. Here is the example. Not sure how can we do? My rate are by Product and NO COP while Cost is by Country of production, by account, by function. I want to store cost where we Cost are and allocate to product.    

How to create a financial report? What tools do i need to create one in the platform

Hi everyone, We have a cube view with three rows structured as follows: Row1: E#Parent1.Children:U1#Member1 Row2: E#Parent1.Children:U1#Member2 Row3: Variance between two columns. To handle this, I created an XFBR that dynamically generates a string based on the number of children for the user-selected parent (Parent1 as a parameter). The generated string will look something like this: GetDataCell(CVR(Row1,1) - CVR(Row2,1)), GetDataCell(CVR(Row1,2) - CVR(Row2,2)), and so on. We have three columns in the same cube view: two data columns and one text column. The text column uses the U8 member as a dynamic calc member, which returns a string. In the variance row for the text column, I'm getting a blank instead of a string. I’ve tried different row override methods using XFBR and XFCell, but haven’t had any success. I suspect that GetDataCell might be causing the issue, but I wanted to ask for some guidance. Has anyone encountered this problem, or does anyone have any suggestions? Your inp

delete button/icon is greyed out to delete assemblies. how can an assembly be deleted?

I am building a UD8 dynamic calc to bypass the limit of 4 cube view overrides. The calculation will read the referenced member (e.g. A#Net_Income:S#Actual) and return a different member intersection (A#Net_Income:S#Plan2024) In order to return the correct plan scenario, The UD8 member must read the time parameter used in the cube view. This functionality exists, but is throwing an unexpected error. My parameter exists in the default workspace. To pull my literal parameter value, I have the following code: TimeParameter = "Param_Time_LitValue" Dim TimeMbr As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(Si, False, Guid.Empty, TimeParameter) TimeMbr returns the value "Unknown". From my research, this error occurs when you reference a parameter that is defined in a different workspace, which is not the case here. I would appreciate advice on what I am doing wrong. The sample code I am following is found within BRAPI>Dashboards>Parameters. The sample says that the Tim

Does any know if its possible to create a dashboard label with vertical orientation where the text is rotated 90 degress and the letters from the bottom up?

Hi Team, Is there a way to set the No Input period property for Scenario dimension using XFBR/Parameter dynamically through DM Jobs. for ex: a new scenario test2, needs to be copied with test1 scenario data across all years (Closed periods + Open periods).The requirement is to have "No Input Period" property as 0 during coping the data and later during consolidation thorough DM step set it to Current actual close period value (i.e for may close it should be 5).   Thank you in Advance.  

Hi, is there an BrApi command that returns the Application Currencies, ideally as a list of strings? I would like to use the output, i.e. the list of currencies, in an Extender business rule, where I need to loop through them. Thank you  

Hi all, We have experienced that in our application, at specific times of high workload where many processes are executed simultaneously, some tasks in the workflow that involve loading data into the cube remain in the ‘Running’ state for hours. I wonder how to find the cause of this issue, which seems to be a performance problem during periods of high workload. Thank you.

  When I do a keep only on this quickview below, it causes all rows to disappear.  only way to get around it is to choose the entity I want in the parameter/member filter builder.   Why would keep only cause all rows to disappear?    

Does anyone know how to display Workflow status in a Cube View or a Dashboard? I would like to create a report that would show the status of a particular step within a subset of workflows. I am thinking of a more formatted presentation of the information available in the "Dependent Status" grid available in the "parent" workflow "Certify" grid. More specifically I would like to create a report showing the status of all "Flash Report" steps in the attached screenshot. Thank you in advance and best regards. Yan

Hi All,   I have trying to get the Combobox type of drop down in the custom created data table . SQL Table Editor Searchable Drop-Down List (onestream.com) The above link the documentation to achieve that requirement however it does not work even tough i follow the instruction given in the document. Below are the screenshot of my datatable and parameters.    Kindly help me to achieve this requirement .   Thank You     

I have a CV with a row definition A#A111:U1#XYZ:U2#ABC:U3#LMN, A#A111:U1#XYZ:U2#ABC:U3#OPQ Please note U3 is LMN and then OPQ.  This definition is generated by a BR.I am trying to color a row in the CV if the U3 member is say "OPQ".I was able to format the color based on U3(using RowE1MemberName conditional formatting) but had to make U3 the first Row Header by saying "Use Default Row Headers" false and setting U3 as Header1. Want to see if there is some way of saying that without making the U3 as the first row header.  Thanks, JS     

I keep getting this error I checked the time and scenarios rules it looks right.

Hello community, We have a Custom Calculate DM job that clears data by account and flow via parameter selection that works well. Our client wants to know if it is possible to select multiple base accounts at once to clear the data. The parameter options such as member filter does not allow selecting more than one account so I'm hoping, if this is possible, that maybe someone has used multiple NameValuePairs to achieve this via two parameters of the same dimension somehow. Throwing ideas that may or may not be good out here. Thanks in advance!    

Hi Team, Is there a way to lock and unlock the scenarios through Dashboards?Followed to the above question, can we load FX rates through Dashboards? Best RegardsLucky

Has anyone figured out a way to use an XFBR to determine the Bound Parameter on a Combo Box? It seems like a no-brainer that this should be possible but I've not been able to figure out how. Hoping someone has figured out what the syntax on the XFBR has to be to make this work or can confirm that this isn't possible.  Thanks

I am trying to create a small POC for using a SQL Table Editor tool.  However, I am unable to edit a table row on the SQL Table Editor even after it is in a Dashboard with all of the settings to do so.  What is the typical reason for this?  I have Default For Allow Column Updates = True and my OneStream Database Server Maintenance Group for Ancillary Tables is set to Administrators (I am an Admin).  I tried setting that to Everyone and that didn't work either.  I am confused on way the basic functionality of this to to edit SQL data is not working.  Any help appreciated!   Thank you!  

Hi, We have a service account setup in our EntraID IdP that is used to call the API. Now that we've enabled OIS, we're having difficulty setting up a PAT for the service account since typically nobody logs into the service account and accesses OneStream, so the account is unable to provision a PAT for themselves. Would anybody have any suggestions as to how to proceed? Thanks!

I want to create a table and columns in SIC, but only the table name is being created. I want to know how to fix this problem. Below is my sample query and code. Dim sql as new text.stringbuilder  Sql.appendline(“Create Table employee(Name varchar(255) not null ,age int null);” using dbconnap as dbconninfo = brapi.database.createexternaldbconninfo(si,”SICconnectionname”) Brapi.database.executesql(dbconnapp,sql.tostring,true) end using

Hello, I have created an extensibility rule to extract values from the FileBytes column in the XFW_UTM_SupportDoc table, then convert the FileBytes to a file and save in the file share. See below for code snippet:   'Execute query and save attachment to file share folder Using dt As DataTable = BRAPi.Database.ExecuteSql(dbConnApp, fileBytesQuery, True) If Not dt Is Nothing Then For Each dr As DataRow In dt.Rows 'Process rows Dim fileBytesValue As Byte() = dr("FileBytes") Dim fileNameValue = dr("FileName") Dim taskNameValue = dr("TaskName") Dim fullFileName As String = fileNameValue 'Create file in file share, and store folder name Dim fileInfo As XFFileInfo = New XFFileInfo(FileSystemLocation.FileShare, fullFileName.toString) fileInfo.FolderFullName = "Applications/" & applicationName & "/Batch/Harvest/TaskManager_Exports" 'Convert fileBytes to file, and save in folder path Dim fileFile As XFFile = New XFFile(fi