OneStream Platform Forums

I have a forecast scenario S#AugFcst_7_5 with the following properties:WF Time = 2023M7WF start time = 2023M1WF end time = 2024M12# no input periods = 7I have a Finance business rule function that is being initiated using a dashboard button in the workflow.  The dashboard button calls DM Sequence/step where data units are defined as WFScenario and T#root.WFTimePeriods, business rule = FPA, function name = ttmaverageIn the function (ttmaverage) I am limiting the calculation to only the base periods of 2024 and I want it to calculate V#Periodic by looking at S#Actual, V#Trailing12MonthAvg, T#2023M6I receive the following error when executing it:I believe the error is because I want it to calculate off S#Actual, T#2023M6, V#Trailing12MonthAvg and that includes time periods that fall outside the range of my WF scenario AugFcst_7_5.I tested this by changing the formula to look at S#Actual, T#2023M6, V#Trailing6MonthAvg and the calculation works but obviously does not give me what I nee

Hello, I am wondering if anyone would be will to help me with a business rule for our people planning.  I am not sure how to read these, but I am trying to determine where in the rule it's telling which periods to calculate.  For some reason it's not calculating all the periods. If anyone could help, please send me a message and let me know if you could point me in the right direction.     

I am using a below code to display Intersection Error. The code works perfectly fine- except for one thing. The problem is when the error is - Invalid Member Name.Entity,2010 It only outputs- "Invalid Member Name" (may be because it gets period) Is there a way to update below code to also show Entity ,2010-  instead of just 'Invalid Member Namr' ***************************************************************** Guid gWFid = si.WorkflowClusterPk.ProfileKey;                     int idScenario = si.WorkflowClusterPk.ScenarioKey;                     int idTime = si.WorkflowClusterPk.TimeKey;                       using (DbConnInfoApp dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si))                     {                    

We have lot of workflows by entities, for each entity we need to add another workflow step(Import). and each workflow has different security groups. here, how can i updated the new workflow step at a time at one go. Can you please suggest us some easy ways to update the same. Thank you, Shiva Prasad.

Hi - I am trying to execute the below code but it is not taking the prior month actual data. Could you please let me know what am doing wrong? It is copying only the current month.    Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#YTD:F#EndBalInput:S#Actual:T#2026M11,[A#[BalanceSheet].Base],[U1#[Total_CostCenter].Base])") srcdataBuffer.LogDataBuffer(api, "Results",10) Dim Acct As String = String.Empty Dim UD1 As String = String.Empty Dim UD2 As String = String.Empty Dim UD3 As String = String.Empty Dim UD4 As String = String.Empty Dim UD5 As String = String.Empty Dim UD6 As String = String.Empty Dim UD7 As String = String.Empty Dim UD8 As String = String.Empty Dim f As String = String.Empty Dim Inc As String = String.Empty Dim Org As String = String.Empty Dim ResultDb As New DataBuffer For Each Cell As DataBufferCell In SrcDataBuffer.DataBuf

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.    

Where can I download CPM Express? I checked the Marketplace but couldn’t find it there. Is it available for partners yet?

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!