FX Data Feed - Actual & RE-BP Rates - Automate from Onestream to another source like GCP
Hi, we are looking for guidance and experience on automating the process of exporting fx rate data from OneStream to Google Cloud Platform (GCP). What is the best approach to automate this data flow from OneStream to GCP? Are there recommended methods (API, connectors, data pipelines) for this integration? Any best practices or examples for handling FX data in this setup? Thank you!
Extract Related components for Dashboard
Hi OneStream experts, Lets say a dashboard has 10 components in DEV and in PROD. Added 11th component in DEV and want to move it to PROD by Extract and Load. Is there any easy way to collect all related components of a dashboard? Manually collecting components is painful. What is the best secured way to collecting objects to move it to PROD? Thanks //SureshBackward compatibility in client software
Hi Onestream experts, We need to install client software 9.1.0 for accessing Environment 1, which is running on version 9.1 We could not use the client software 9.1.0 for accessing Environment 2, which is running on version 8.4 Why is the client not backward compatible? This is a very normal situation for any customer, to have different environment in different version. How to solve this? Thanks Suresh
UD or attribute to flag past restatements (Budget pot swaps)
Hello, we are about to start our work on next year budget and we already know that, following a recent restructuration, there will be a lot of pot swaps between departments (e.g. Licence costs used to sit in the department using the software but will now all sit under IT). Some of the them will be just moving a cost center and its history from one department to the next so that will be easy. Our issue is when we do a "pot swap" that moves part of a cost center. In this case we will have a disconnect when we compare actual and forecast unless we restate actual (i.e. also move the cost in actual). My question is on how best to tag/flag the "pot swap" in the actual data so that in reporting we can do like of like comparison (i.e. with past data restated) but also keep the original data. I have 2 potentials solutions: Flag the restatement using an UD: do the restatement of past periods under a specific UD so that we have the ability to see past periods with or without pot swap adjustments Use attributes: I think attributes would work but we have not used attributes in the past so not sure whether it is the best way Does anyone have the same issue and came up with an alternative solution? or has a view on the above options? Many thanks!
SetDataCell on AdjInput & OwnPreAdj
Hi All - I have a question on the SetDataCell Does the below work? I am trying to write 1 to an account. api.Data.SetDataCell("S#UltOwnShipConsolTracker:V#YTD:A#DirectOwnership:F#None:O#AdjInput:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None", 1, False) My Origin is AdjInput & Consol is OwnerPreAdj Thanks Krishna
Replace not working
Hi all, I'm experiencing an issue with the connector in one of the cubes. Although everything is set to "replace," the stage is not being cleared, and old data is being loaded together with the new data. As a result, I have to manually clear the stage to resolve it. The log, is says replace Data keys are 2025M10,2025M11,2025M12,2026M1, but if i check th estage after the import i have periods outiside this range The log indicates 9,261 lines, exacly the same amount of rows that the query produces. But the import shows 248 pages. With 50 rows per page, that would be around 12,400 rows loaded, which is quite different from what the log reports. I'm not sure if I'm missing something here, but I haven’t noticed this happening in other data loads. I still need to replicate the issue in a different app. Has anyone seen this before? Thanks in advance!Clear Error Log
Hi everyone, I need to delete all records from the error log, it became very slow and heavy to use. I tried the buttons above but they do not clear everything from it. I found some discussions partially covering the topic, they suggest to manipulate the table 'ErrorLog' via query, but it seems like that table does not exist. Is there an easy way to do it? Thank you
Default Form Template on Workflow Profile Load
I've created a form template and assigned it to a workflow profile. However, each time I access that workflow profile, I have to manually click on the form to open it. Is there a way to set a default form template so that it opens automatically when a user navigates to that specific workflow profile?
