Dashboard Integration
Hi, I have designed a dashboard using SQL adapter and have stitched multiple OS tables.Current ask is to integrate this dashboard data and sent it out to an external db.I can create a table in the external db reflecting the same column structure. What is an efficient way to integrate this data from OS dashboard to external db-FYI- I have SIC in place. Thanks for your time
Workflow error
I have created a workflow profile, and the data source for the workflow is a CSV file with several columns. In this file, the second column contains account numbers. I specified the 'Text Fill Settings -> Lead Fill Value' as 'A' in the data source as I need to append with A Infront of the account. Additionally, I have defined a transformation rule. However, when I execute the workflow, I get the following error message: 'Validation Messages: Invalid member name. Account: 652901.'" Could you please suggest, is there anything that I am missing?
Automating BAI uploads in Workflow
Hello OneStream Community, Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application. 1. BAI Parser & Data Source Configuration - We've installed the BAI Parser dashboard to view and manage all imported BAI files. The BAI data source has been configured and initial tests with sample files have been successful. 2. File Transfer & Business Rules - Plan is to automate the transfer of finalized BAI files from our system via FTP to the OneStream file system. This requires a BR to connect with the FTP site and currently developing a BR to facilitate this connection. Once the files are in OS, they'll be imported into the appropriate bank workflow. 3. SFTP Wrapper and Workflow Integration- After the initial FTP transfer, a separate BR will be implemented to securely retrieve and upload the BAI file into the bank workflows. Question:For those who have set up similar BAI automation processes, are there specific best practices or additional BR configurations that you would recommend? Any insight would be greatly appreciated.
Export Formatted Data Explorer to Excel via code
I have a dashboard that I would like to automate the export of the formatted data explorer to Excel and keep the formatting. The same functionality as is available in the export to Excel button on the data explorer component itself. Am I missing an obvious function or does anyone have a way to replicate that functionality. Thanks, Scott
Extract incremental data from cube
I am looking to implement an incremental data extraction feature for our cube data. Specifically, I need to extract all data from inception and continue to do so on a quarterly basis, including any updates to previous quarters. Any ideas or best practices on how to achieve this effectively would be greatly appreciated.