Task Scheduler not executing tasks
I have scheduled a data management sequence to run every 120 minutes between a specified time range (7 am to 9 am) -- But the data management sequence is not being executed. There are no parameters needed in the data management sequence, and I have confirmed that manually running the sequence works without error. When I check the grid view in Task Scheduler, I can see the "Next Start Date/Time" column is correct. However, when the system finally reaches that time, the task is not executed, the "Count" column remains as zero, and the"Next Start Date/Time" column updates to 120 minutes later. I receive no system errors on why the task is not executing. I have confirmed the scheduling a one time task, or even a daily task works successfully. Any help on this would be great.9.7KViews3likes14CommentsExporting Data automatically to outside of OneStream
HI I am trying to automate a data extract process to send data from OneStream to another system eg Anaplan. I have a data Mgmt job to Export the data to a CSV on the file share. I now want to move that CSV file from the file share to say my desktop for example (or any other file storage place). Has anyone done any routine like that? If so is there any BR in OneStream that can be used for that. I havent done this before but sure others may have come across this so just wondered what the best approach would be. Thanks! TahirSolved16KViews1like17CommentsHow to back up OneStream Data
We have a requirement to have daily backups for our applications for a period of 15 days. OneStream cloud offers point in time backups up to 7 days and only weekly backups past that period. I know how to back up artifacts/metadata in OneStream but not sure how to back up data. Does anyone have any ideas on the best way to create a data back up?465Views1like2CommentsHow do I delete redundant files from system/file explorer/file share as DELETE Option is Grey ?
Hi, I have a number of files in my export folder that were created using a Data-Management step. However, even though I have system admin rights , the option to delete any or all files is 'greyed out'. So, how do I delete them when I have finished downloading them. Also, how do I then delete the 'date' folder as well ? Thanks Mark6.2KViews1like9CommentsExport data using a Method Query
Hi I have a method query that returns a data table of roughly 300k of records. Is there anyway to export the result of the method query to a csv file? I'm not keen on using a spreadsheet business rule or a grid view on a dashboard given the volume of records that is being returned. Thanks, MarkSolved1.1KViews1like3CommentsClear data using level 1 data unit (rather than level 2) on data load
Hi all I was wondering if it is possible to override the default 'clear and load' settings on a data load step from 'Level 2: Workflow Data Unit' to 'Level 1: Cube Data Unit' Just to give a bit of context: We perform a data copy from a Budget scenario (using Data Management Sequence) to a Forecast scenario to provide a starting data position for divisions to use when they capture their forecast data. Once the data copy is complete, the process for divisions to update their forecasts is to extract an Excel Fixed File Template on which they will make their changes and additions over the copied Budget data, and then to import that file via their Workflow to the cube. However, when wanting to remove an account for instance, the only way to do so it to load zeros to that account. This is because the load clears by account and not entity. Is it possible to change the load so that it deletes all accounts? Thanks, Mark1.1KViews1like3CommentsExtracting Annotations
Hi all, I'm trying to find a way to extract comments and text inputs using a data management job. OS doesn't let me select V#VarianceExplanation member in the dataunit section. Error processing Data Management Step 'ExportComments'. Non-numeric View member 'VarianceExplanation' cannot be used in data filter Any help is appreciated.2.1KViews1like6CommentsDisplay task activity status dialog when executing a Data Management Sequence from a business rule
Hi I am executing a data management sequence from a business rule and I would like to display the task progress dialog box. Is this possible? e.g. When I click run from the Data Management tab I get the following: I would like the user to see the same thing when I run the data management sequence from a business rule. Regards, Mark1.9KViews1like3Comments