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?
Data Source Loading all rows to an account specified in one cell
Trying to create a Data Source. I have multiple spreadsheets of the same format with the account name I need to load to in cell B1. Each .csv file is for a different account that is specified in B1. How can I make all subsequent rows use the account is in that one cell B1 on each spreadsheet?
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.
Accessing Azure File Storage from OneStream
Hi, I am trying to access a file stored in Azure File Storage to import in the cube, but I need help to do that if I try using the REST API as the namespace Microsoft.Azure or any other Azure related namespace, as they are not available in the OneStream library. Has anyone encountered the same ? Any better approach to achieve the desired outcome ? Thank you for your help