Recent Discussions
Metadata Automation
Hi there, I'm looking to automate dimension uploads in that I want the dimension to be "replaced" with the new one that I am loading. I want to reduce the burden of having to add or remove members from dimension and just automate that process. How can this be done and where should I start? Thank you in advance, Joesef
Loading Amount and Annotations together
Hi, not sure if anyone came across with this one but thought it was interesting to share If you have a file which has in the same line amount and annotation you can set View to YTD (or periodic), then in the text value complex expression use this api prop: api.Parser.TextValueRowViewMember = "Annotation" That will make the parser to automatically generate the line(s) with the annotation if text value have a value. HTH
Setting up Cube Data Manager Solution: Add New Environment
Hello, I am trying to set up the Cube Data Manager solution from Open Place in my working production application. Currently it is all loaded up, but I need a little help figuring out how to add the environment to it containing the applications that I want to work with. Please see pictured below. Thank you, Jeremy MorganSIC outage SSL error
Hi all we have this error with our SIC connection to SAP he SSL connection could not be established, see inner exception.) The SSL connection could not be established, see inner exception. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. An existing connection was forcibly closed by the remote host. (Socket Error Number 10054) Anyone seen this before and knows how we can resolve? Nouria
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.
Loading Workflow using Excel Template
I'm trying to load a workflow using an Excel template and need to set the *WorkflowName* as one of the following: Import, Validate, Load, Process, Workspace, Confirm. Currently, I'm using the highlighted value in the *Workflow* column for this purpose. Similarly, if I need to set the *WorkflowName* to Workspace, Direct, Process, Confirm, Certify using the template, what value should I use? Is there a reference list for this, or where can I find it?
