OneStream Platform Forums

I am getting the error “Object reference not set to an instance of an object.” with the code below in a connector business rule.  I feel like I’ve used this code a ton but never had this issue before.  Anyone have any thoughts on what I might be doing wrong this time?WorkflowUnitPk wfPk = api.WorkflowUnitPk;string wfTime = TimeDimHelper.GetNameFromId(wfPk.TimeKey);TimeMemberSubComponents objTimeCmpnts = BRApi.Finance.Time.GetSubComponentsFromName(si, wfTime);int wfFiscalYr = objTimeCmpnts.Year;int wfFiscalPer = objTimeCmpnts.Month;Thanks,Scott 

What is the difference between execute retransform and start retransform?  Thank you!  

Hi everyone,I am building a SQL Table Editor workflow where the client wants a custom Edit button that opens a popup edit form rather than editing inline in the table.The issue I am seeing is that the popup sometimes loads the previous row on the first click, even though the backend logic is returning the correct row and the correct values. If I click Edit again on the same row, it loads correctly.I have already verified the following:the selected row is being captured correctly, session state is being updated correctly, the backend query is returning the correct record, the popup fields are bound to the correct parameters, and the values are being populated before the Business Rule returns.Has anyone run into this type of one click behind behavior with a SQL Table Editor + Open Dialog setup?Is this a known limitation of the SQL Table Editor, or is there a better pattern for a customizable Edit button that opens a popup and always loads the currently selected row?If this pattern is bet

We complete variance explanations each quarter, and each business unit has different thresholds that require explanation. Is there a way to apply different thresholds within the report based on the selected business unit using the conditional formatting? I would like to flag it red only but I can’t figure out how to do by business unit using the same report.Users are prompted to select their business unit when they run the variance report.This is what I currently have, but it applies the same threshold to all companies:If (CellAmount > 50000) Then    ExcelTextColor = Red, ReportTextColor = Red, TextColor = RedElse If (CellAmount < -50000) Then    ExcelTextColor = Red, ReportTextColor = Red, TextColor = RedEnd If

We have an excel export item that loops through several entities and uses the entity names through Loop1Variable as the output.Unfortunately, some entity names are longer than the 30 characters excel tab names are limited to.Is there a function/formula that can be used to limit the Loop1Variable to 30 characters? 

Hi,I’ve had an issue trying to use parameters to retrieve both names and descriptions of entities in Excel using a parameter.I use a Member List parameter with a filter of entities.In Excel, if I tick ‘Description’, sometimes I get only descriptions; and sometimes I get both names and descriptions, which is the desired behavior (the client wants to be able to choose entity by their names, and I need the code in the parameter to make the XFGetCell formulas work).Is there any option here I’m not aware of?I’ve found a solution, which is to create a XFBR rule that feeds a Delimited List parameter with strings including both name and description. It works fine. But I’d like to make sure I didn’t miss something obvious here.

Hello, I am trying to run a Business Rule located in a specific Workspace (VentaNeta) from a Data Management Step that lives in the Default Workspace.According to the OneStream documentation for cross-workspace references, the syntax should be:Workspace.MyWorkspaceNameOrNSPrefix.MyWsAssemblyName.MyShortBRNameIn my case, I configured it as:Workspace.VentaNeta.VN_Cube.ExtenderHelperHowever, when running the Data Management Sequence from the Default Workspace, it fails with this error:"Error processing Data Management Step 'GenerateUnassignedClientes'. Business Rule 'Workspace.VentaNeta.VN_Cube.ExtenderHelper' is invalid."Here is the strange part: If I move this exact same Data Management Step inside the VentaNeta Workspace and change the syntax to use Workspace.Current, it executes perfectly:Workspace.Current.VN_Cube.ExtenderHelperConfiguration details for the VentaNeta Workspace:Workspace Name: VentaNetaNamespace Prefix: VentaNetaIs Shareable Workspace: TrueMy goal is to keep this DM St

Hi all, Is it possible to exclude certain register columns for specific Groups?  For example, not requiring input or displaying an “Hourly Rate” column for full time salaried employees.  In this case an Employee Type is a separate register column identifying employees as full time, part time, or contract. Filter groups are set up by Employee Type and calculations only run for the relevant groups.In the case above, the Hourly Rate column could just be left blank, but how are others handling cases where there is a control list attached to a register column, but that register column is only applicable to some employee groups?  I would rather not have an “N/A” or similar option in the control list, which would allow this as a selection for employees who should have a “real” control list value assigned to them. TIA

Hi,I’m writing a custom calculate business rule for an Account which is planned like this - Look at the same intersections 12 months prior and see if there is data. If there is, use that value to set the value for current time period. If there is no data in that intersection 12 months ago, look for a value 24 months ago.I need to do this for just 1 account but different UD1 and UD2 intersections.I tried to use GetDataBufferUsingFormula and thought of looping through all intersections but DataBuffers give only those intersections where there is data.How should I go about this? 

Hi Team,Is there any update on enabling dropdown menus for multiple fields within the Table View?For example, if a user clicks a cell in the "Payment Type" field, it should display a relevant list for selection. Similarly, in the same table, the "Payment Card" field should display its own relevant list.Prior to LIM, I believe this list option was limited to a single field, achieved via the EnableStatus column functionality. However, when reviewing the LIM Tableview via Spread, it appears there is now a way to enable dropdowns for multiple fields.Could you please explain how this is achieved in LIM? Additionally, is there any documentation available on how to configure this for a user-defined tableview?Best regards,Sudhakar S

Hi there,I am programming validation accounts, where I compare various data points in my application.For example:Depreciation Balance Sheet - Depreciation P&L = 0I am using now the “Formula for Calculation Drill Down” to visualize the different data points which are used in the formula - so far so good.BUT - I would like to include the “plus” and “minus” signs to make it obvious how the system is calculating the different arguments of the formula.Do you have an idea how I could get that? It could be a text string in the field “calculation script” for what I care, but it would be fantastic to have the signs line by line.  

Hey Community!The other day I was troubleshooting a data import against a set of Cubes that were created in a v9.3 environment, where my Quick View was returning no records even after verifying intersections and confirming the “Load Complete” status on the import. Naturally I went to use the Data Records tool to confirm if the data was truly loaded but no records were returned in the Tool (which led me on a wild goose chase). Lo and behold, even in cases where there were definitely records in the Cube, the Data Records Tool returned no records. So maybe I missed it in the release notes, or maybe it’s just this environment, but is the Data Records Tool meant to work with the new VLWDataRecord tables?Thanks! 

Hi Team,I am facing an issue with Certify. if you notice in the first screen shot Fixed Asset function(workflow) is already certified. but when i input data at any other input form. after saving the form, then will click on Complete form. when we clicked on Complete Form system was Uncertified the Fixed Asset workflow Example:- Costing function (Workflow) for Non_Baan_Costing input form i have entered data and then clicked on Complete Form. Fixed asset got uncertified. Can you please check and advise on this issue   

I'm on OneStream 9.3. I'm trying to drive the contents of a Dynamic Grid from a Combo Box selection, using a delimited (piped) parameter to modify the grid's output. The parameter doesn't seem to resolve correctly once it reaches the grid.What I've tried so far:Template Parameter / Text1 / Text2: the piped parameter never resolves. The grid renders the Default Value instead. If there's no default value, or if the default value is itself a piped value, I get either the raw default or the literal token with the pipes intact, e.g. |!Parameter!|.Bound Parameter: I can retrieve the parameter's name via args.Component.BoundParameterName, but I can't find a way to get the value assigned to it, so I have nothing to filter my list against.Question: in 9.3, what's the correct way to read the selected value of a delimited parameter inside a Dynamic Grid business rule so I can use the value to manipulate my dynamic grid? Is there a step I'm missing in how the parameter needs to be defined or refer

Hello,I have an XFBR rule written in an assembly file in a dashboard maintenance unit that is under the default workspace, but not in the default maintenance unit.  When I try to call it using XFBR(workspace.Default.AssemblyName.BusinessRule, FunctionName,) I get an error.  If I build the same rule in a XFBR string rule under Business Rules it runs fine when called by XFBR(RuleName, FunctionName,).  Furthermore, I am not experiencing this issue for any XFBR dashboard string rule housed in an assembly in any other workspace.Is there a different syntax that is needed to call dashboard string rules that are in an assembly in default?As a note, the rule does not need any input parameters.Thanks,

I'm being asked to schedule an extract of the OneStream metadata.  I'm under the impression that this cannot be done using the Task Scheduler since an extract of metadata is not an option in Data Management.  Is this an accurate statement?  If this can be schedule, how so? Thanks!

Hi Community, Does anyone have guidance on the parameterization of date based on the workflow that is selected. It seems that below works for only upto Sep. Wondering if there is any other parameter I can leverage off to get two digit period code. Thanks,Thomas

I have an accountant that mistakenly sent out a few packets to our JV partners. Is it possible to recall these emails? 

Hi everyone, We need to automate user creation and security group assignments in OneStream using data from an external Identity system. I have two main questions: Is it feasible to fully automate this without manual intervention? What is the best way to implement it simply (avoiding heavy middleware)? We are considering two solutions: Just-in-Time (JIT) via OIS, and SCIM. Does anyone know how we can set these up? What is the recommended "standard" approach for this? Thanks for your help! Madiha

Our RCM Admin (not local) doesn’t have permission to update the reconciliation attributes. I read that it depends on her workflow access. Is this correct? Will she need to be a member of all of the workflow maintenance groups since she needs to be able to update any reconciliation attributes? If so, is there an easy way to add RCM Admin to all workflow maintenance groups?Thanks! 

What I think might be a useful setup option would be to have the ability to right-click any existing Workflow Profile and have OneStream build a Workflow Template from that Workflow.Often we’ll build out one Workflow and test it the way we want it to work, which is more difficult to do with the current Template process.  Being able to “go the other way” and create a Workflow Profile that we like and turn it into a Template would save a lot of time.

Hi, We are currently attempting to exclude a specific entity from the main consolidation process for reporting purposes. This entity is no longer within scope, but we would like to keep it in its current position in the hierarchy to preserve historical data. We also need to continue importing data into this entity for reporting purposes. Our objective is to set the consolidation percentage to 0% so that it no longer consolidates going forward. After updating the Percent Consolidation to 0%, we are not seeing any impact. The entity continues to consolidate in the application. For context, the Ownership Type is set to Full Consolidation and the Consolidation Algorithm Type is set to Custom. Is this expected behavior? If so would you have any workaround solution ?Thank you for the feedback and help!

Hi folks,My suppression in my cubeview doesn't work. If I turn on any suppression (including 'invalid') the cubeview returns blank (no rows at all). It's a cube that's been loaded with dynamic data services and the data is showing as NotStored. I wonder if that could be the cause? Anyone else observe this or have any tricks? I've tried every combo of suppression option I can think of... I'm surprised it would return nothing even with only 'suppress invalid' checked..

Hello all,I have setup a dynamic cube that sources data from a table and creates dynamic dimensions as well.Works like a charm, but I have been playing around with the refresh times. In our use case, the users would input in a register → review data from dynamic cube in cube view (Using filters, etc) → back to register to make changes. Some pros/cons in this caseSetting a time for when the data and dimensions are updated would mean they had to wait for updates.Letting it run for every time the user updates the cube view, means that every filter change etc. would also trigger. Meaning a lot of unnecessary updates. Anyone has come up with a way where a user can push a button that then triggers a rerun of dimensions and data? This way, I can rely on cache when they are navigating the cube view, but they can actively request an update, when they have made changes.​@JackLacava, Thank you for a great presentation on the tech talk, really good stuff. There you also mention that there are solu

Hi all, I am working on the Extensibility Rule to automate the Import/Validate/Load/etc. steps of a workflow, so that when the rule is called from a data management step it executes all workflow steps for a given workflow.The first step of the workflow is a Workspace containing a dashboard, and the second is an Import step (we are using a direct connection).The rule works generally fine, but the Import step randomly throws the following error:"Cannot execute step because the prior workflow step is not completed...Source code: line 0, method ParseAndTransform"This happens maybe less than 10% of the times, but it is annoying because I cannot understand the reason for it, since the Workspace step which precedes the Import step should always be completed since it is completed by the Extensibility rule itself.These is an extract from the rule of how I complete and immediately after process the Import:Dim CompleteWorkspaceWFInfo As WorkflowInfo = BRApi.Workflow.Status.SetWorkflowStatus(si, w