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

fellow_Ones's avatar
fellow_Ones
New Contributor III
2 years ago

Data Managment Time Filter issue: Unable to execute business rule while passing multiple periods

Hello Community - I am using multi select combo Box to pass periods selected by user back to business rules, receiving the selected periods in the BR but while executing getting error "Error proces...
Data Management
fellow_Ones's avatar
fellow_Ones
New Contributor III
2 years ago

Hi Jack -

Sorry, that was typo on my end, below is the screenshot. Using button to trigger the DM with Business rule.

As mentioned, need to pass selected periods from the muti select combo box, trying to figure out how to bypass time filter while executing the business rule.

 

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

The key is: what does that parameter end up containing? If it's just a year, e.g. "2020", your approach should work (try putting square brackets around it), but if it has multiple periods (e.g. 2020M1,2020M2), you will need some intermediate text processing to turn it into a valid filter (T#2020M1,T#2020M2). That can be a achieved with the .List expansion (e.g. T#2020.Base.List(|!yourparam!|) might work) or an xfbr.