How to prevent journals on wrong entity
We have a workflow structure such that each entity has it's own workflow, with a number of steps for Import, Forms and Journals. We had an issue recently where one entity (e.g. E123) accidentally posted a journal to the wrong entity (e.g. E321). I can't see any way in the workflow settings to prevent this. I know in the Import workflow steps there is the option 'Can Load Unrelated Entities', but I can't see anything similar on the Adjustment workflow step.11Views0likes0Comments"In Use" property: Time and Scenario Dependent maintenance
Hello All, for our project, we are using the In Use property in UD2 with the Time/Scenario dependency option. Seems to work but the problem for us and also raised by customer is the maintenance part of it. We showed them how to use Grid View but with that we are not able to see how this In Use property is configured by scenario and time. Grid View only shows In Use ticked box everywhere even if we set it to False for some scenario/time combinations. This is really a drawback for us now in implementation phase and for them in the future to administer this application. Does anybody that used scenario/time dependant set up (whether for in use property or for any text attributes, that would be same problem) had a good way to maintain this property without having to go one by one in each member to see what is configured and update it ? Or did you achieve differently the requirement to handle the fact to activate/inactivate some members over time without using the In Use property ? Thank you in advance for your support and feedbacks on that!11Views0likes1CommentDefault values on Parameter in Dashboard
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.Solved27Views0likes1CommentSyntax for calling a Finance Custom Calculate Service
Hello, I am working in an 8.5 application and want to utilize Finance Custom Calculate services within a dashboard. My service factory is enabled at the Dashboard Maintenance Unit level of detail. I am trying to launch the custom calculate function via a dashboard button. Does anyone have example syntax for this? I figured OneStream would release documentation externally for this but was unable to locate any. Thanks!Solved45Views0likes2CommentsXFTreeView
I've got a Tree View component which is populated via code in an Assembly. It currently displays all the members for a selected dimension but will can only show those members that a user has access to. The tool that is a part of is indented for cross group use so it would be useful for users to see all the members available, not just the ones that they have access to. It's purely a visual aid, not for data viewing. Can anyone advise if this is possible and what I'd have to do to enable it? Thank you in advance :-) Craig5Views0likes0CommentsSql Table Editor - save nulls
Hi, I have a SQL table with a decimal column that allows nulls, and I want to differentiate between an actual 0 and a null value. I seem unable to configure the SQL Table Editor in a way that enables me to save a null value. When I press Insert new row, it defaults to an amount of 0.0, instead of null. I am aware that I can do a dashboard extender and override the save operation but in this case the column value could be either 0 or null and I wouldn't know how to differentiate between the two. Any ideas?30Views0likes1CommentExcel Add-in not working for one user
Dear Users: I had just one user who was not able to get their instance of Excel Add-in 8.4 for various workbooks. However, if the very same workbook was emailed or shared with another users it worked just fine. The main issue is that the user could not "REFRESH" the sheet. Eventually, the Excel add-in started to work. Has anyone experienced this in the past? What was the solution? This is the error message: Description: Object reference not set to an instance of an object. Error Time: 1/17/2025 5:49:51 PM Error Level: Error Tier: AppServer User: xxxxxx Application: OneStream_Prod App Server: vmPRD1int000001 App Server Version: 8.4.0.16413 App Server OS Version: Microsoft Windows NT28Views0likes0Comments