I am doing a load using the following script and would like to do further filtering based on one of the fields in the load. I am trying to only show data where the Time_Month_Key is equal to the Current Month
The Time_Month_Key is formatted as 'YYYYMM'
How would I write the filter to do this? (See Section in Red Below)
HierarchyLookup: Load 'Business_Unit', 'Director', 'Manager', 'Rep', 'Reporting_Team', 'Time_Month_Key', 'VP' Resident vw_EOM_Sales_Leads_Metrics_Detai where Time_Month_Key = date(Now());