Forum Discussion

kumar's avatar
kumar
New Contributor II
2 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
2 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
    Contributor
    2 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