The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

kumar's avatar
kumar
New Contributor II
3 years ago

View in Data Management

Is it possible to use MTD & YTD in View filter for a Data Management job. It does not work if I use -  V#MTD, Y#YTD, but this format seems to work for other filters like for time if I sue T#2021,T#2...
Data Management
kumar's avatar
kumar
New Contributor II
3 years ago

Hello Sam; 

When I use - V#MTD, Y#YTD in the Data management Step it does not work properly. So I used a Parameter in the Data management Step - |!View_Param!| and after that created 2 Data management Sequence and Passed the values for the View_Param as MTD on one Sequence and YTD in the other Sequence, and this works without the need to create duplicate Steps just to solve the MTD & YTD issue.

Problem with this workaround is that, when assigning the 2 Data management Sequence to Task Scheduler I am not able to make them run sequentially. 

Hope this explains. 

thanks very much!

  • SamRichards's avatar
    SamRichards
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    Hey Kumar,

    That does help thank you. I am just throwing out ideas, but can you create two Steps one MTD and one YTD and assign both steps to a single sequence that way they would run sequentially?

    This might be a good idea to throw out under IdeaStream as well to have this functionality or submit a ticket with support to see if this is the intended way OS should work when trying to use two views in a DM job.

    Thanks,

    Sam