Call Workspace Extender Rule from Workspace Data Management Sequence
Hi All I am upgrading the MarketPlace app Reporting Compliance (TCR) so that it has its own separate Workspace (V8.1). I have added the Business Rules as assembly files and they all work. The current environment (V6.8) has a Data Management job to run calculations so I am now adding a Data Management job to the WorkSpace Data Management Groups. The only problem is that when I add a step (type Execute Business Rule) to the Workspace Data Management Step, the drop down list only shows Business Rules in the general Business Rules area and not the file assembly area. How do I get the Workspace specific Business Rules in the Workspace specific Data Management Groups? ThanksSolved2.5KViews0likes12CommentsRunning task scheduler on a specific business day each month
Hi all, Can we schedule a task to run on a business day each month, for example, between the 1st and 7th? I know we can set it for specific days and weeks, but is there a way to make it more dynamic? Any suggestion would be appreciated. Thank you. Best, JackySolved188Views0likes4CommentsXBRL Reporting
Hi! we are facing Corporate Sustainability Reporting Directive in Europe, and we need to report in XBRL format since the 1st jan 2026. we are looking for solutions on how to report in this format from Onestream. Is there some tool / connector you may know that can be applied? Do you have any recommendations on the architecture to do that? Thank you!181Views0likes2CommentsView OneStream licenses
Is there a way to see the current OS license that is installed? We have recently had the number of user licences increased and now want to check that this has been applied, I'd hoped this would be in an obvious place like the environment or security but can't see anything that shows the current license (just being able to see the number of enabled users that the license allows would be a good start).6.7KViews0likes12CommentsCube View DatePicker, Time Zone and Custom Calculate
We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone) 2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's local time Is there a way to specify in the Cube View, that when using the Date/DateTime picker, that the component should ignore time-zones? Or are there other usable solutions for this issue? Cheers5.4KViews1like11CommentsRemove Alt Hierarchy Parent-Child account without removing from the original Heirarchy
Hello, I mistakenly added a sub parent along with 3 base accounts to an alternate hierarchy. Is there any way to remove the parent child relationship in the alternate hierarchy without removing it completely from the original hierarchy?114Views0likes1CommentCount ZeroDataCells by Account Dimension Member
Is there a way to determine the number of data cells by account-type dimension member? In our example, we are reviewing an implemented application with millions of ZeroData cells and are trying to identify which account formulas are producing the most zero data cells. System Diagnostics has a "Data Volume Stats" tab that lists data cell status counts (i.e., RealCellCount, ZeroCellCount, etc) by data unit. However, there does not appear to be any reports that display this information by account. Has anyone had success retrieving this information via a different application report or custom SQL query (against the application database)? This is probably unrealistic to retrieve (given the data volumes required), but maybe there is a way I haven't yet considered.Solved354Views0likes4CommentsSaving Offline copy for multiple sheets with XF() functions
I am having XFGetCell formula cells in multiple workbooks (Sheets) within a Spreadsheet. Issue/Problem: When I tried to save a copy of this spreadsheet by selecting (OS Excel Add-in) OneStream/ Save Offline Copy, only the ACTIVE sheet saves an offline copy without the XFSetCell formula (as expected) but the other workbooks (sheets) still shows the XFSetCell formulas. I expected to see all the workbooks (sheets) to save without the XFSetCell formula (offline copy). Please can OneStream release an enhancement to save all the worksheets within a workbook to be saved as an Offline Copy i.e., without the XF() formula functions?218Views0likes1Commentcurrency names of the FX rates or the connection between the FX rates
Hi Everyone. I am running an SQL query, but I am now encountering an issue with currency conversions. The only thing my table contains is the column with the currency name, but it is not very helpful because the FX rates table only contains the ID. I would like to know where I can find the FX rate IDs and names in the query, or if there is an intermediary table to accomplish this. The tables I am currently using are: XFW_PLP_Register and XFW_PLP_Plan.Solved631Views0likes5Comments