Calculate HC in LIM for Mid-Month Start
Is there an ability to calculate HC expenses that account for when in the month an employee starts and prorate accordingly? As an example, if the employee starts on the 15th then their monthly salary would be Salary / 12 * (15/30). The syntax available in the blocks don't clearly identify if this can be done.
Exporting Grid View Filter Results
Hi OneStream Community, I had a question regarding extracting dimension metadata and properties from OneStream. Currently, when we go to the Dimension Library, apply member filters in the grid view, and then right-click and export to CSV, we can download file containing the metadata along with its properties. I’m trying to find out if there is a way to automate this instead of doing it manually. Ideally, I would like to extract the same information (based on member filters or a specific hierarchy) through something like a Dashboard, Data Management step, or Business Rule, so the export can be automated. Has anyone implemented something similar or know of an approach to achieve this?
Tabbed Dashboard
Hi, I have Dashboard with tabbed embedded reports. for example, MainDashboard - Tab1, Tab2, Tab3. Everything works fine when the user clicks on Tab of their choice for the fiscal year 2026. For Historical data I would like to show the same report for with changed tab. for example, MainDashboard - Tab1, Tab2, Tab4 for the he fiscal year 2025. If the user changes the Scenario from 2026 to 2025 or vice versa the dashboard report tab3/tab4 shows/hide based on FY. How can I achieve at the workflow level? Any help will be appreciated. Thanks.
How to read csv file from Documents/users folder?
Hi, I have been trying to read a csv file that is in Documents/Users/userxxxx folder. Not able to make it work. Getting an error. Below is the code Dim FileName As String = args.NameValuePairs.XFGetValue("Param1", String.Empty) Dim sourceFolder As String = $"Documents/Users/{StringHelper.RemoveSystemCharacters(si.UserName,False,False)}" Dim fullPath = sourceFolder & "/" & "abc.csv" Below is the error Could not find file 'P:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\Documents\Users\userxxxx\abc.csv'. Any idea why this is not working? Thank you, MikkiFormat - Header Text alignment
Hello, I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports). It seems there is no option to do that in the format parameters (only in Excel). I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages. Do you know a solution to get a more consistent presentation ? Thank you in advance, Morgane
