OneStream Community

Tom_R · 06-09-2023

Hello, I have a sub folder that is being populated each month with a variety of files, it is different from month to month. The naming convention of the subfolder is consistent. It is always the fiscal period. However when I try to zip the files in t...

Tom_R · 10-04-2022

Hello, I am trying to create a hierarchy for cubeview reporting that is based on a series of metrics that are extracted from the Journal Line Item application database table. The metric is based on one half of the JE, but it is only applicable if a s...

Tom_R · 09-12-2022

Hello, We are currently trying to create a report to use in parcel service outlining which tasks in task manager are currently complete. We have a sql query being fed into a report, but I am struggling with setting up conditional formatting rules in ...

Tom_R · 07-07-2022

Currently I have a button on a dashboard that will run a business rule that checks if a specific load task is completed. If it is, it will trigger a data management job to run. If the load job is not completed the process ends. I would like to trigge...

Tom_R · 01-17-2022

SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user data are all just the unique identifiers, and not ac...

Tom_R · 09-26-2023

Hello,I see the solution listed above works for Forms. Is there something similar for Journals where workflow, account and all other dimensions are variable?Thanks,

Tom_R · 06-12-2023

Hi Jack, I don't really have code samples. I have been trying to mimic the two samples provided in the Pick-a-csv-file-stored-in-the-DM-Export-in-Filestore-and-covert ticket. Neither option there has worked for me. We don't have Zipfile available as ...

Tom_R · 10-07-2022

Hello, Thanks for the response, but this isn't quite what I am looking for. I am looking to pull items related to specific journal entries, but only one side of the entry. The values I am looking for are not the only values in the accounts retrieved ...

Tom_R · 09-21-2022

Hi Vicent, Thanks for the feedback, but would you have an example of the syntax used with that, or a place I could find it? I have never used that before. Thanks,Tom

Tom_R · 09-21-2022

Is there something similar that can be done with the Args as well? I need to use a ConfirmationRuleArgs value in an Externder rule, but I haven't been able to make it work. Thanks,Tom

OneStream Community

User Statistics

User Activity

Zip All Files in an Application Database Folder

Create Metric Account from Specific SQL database pulls

Conditional Formatting to Dashboard Reports

Open dialog box or dashboard window through business rule

Join Framework table data to Application table data using SQL

Re: Requiring a document to be attached to a workflow step

Re: Zip All Files in an Application Database Folder

Re: Create Metric Account from Specific SQL database pulls

Re: Use a Finance Rule in a Data Management

Re: Use a Finance Rule in a Data Management