DataCellDetail method query - how to filter on UD members

[Ashok]

Hey Experts,

I am trying to read the Datacelldetail line items. thought of using Method query but not able to filter it based on UD filter criteris. does anyone know if it is possible? whats the systax to make it work. In below example I am trying to filter and get all the rows for UD1 DL014. when I run the query it gives me erything for that Entity,Scenario and Time. Appreciate the help.

[kberry · Accepted solution]

It is possible. You are using the UD1 prefix in the UD4 field in your method string example. 

[Ashok]

Thanks Berry. my bad. even then it was giving all rows so tried to use the last field as below and it worked.

{AUM}{E#RevAccComments}{RevAccRecon}{T#2022Q3}{}{}{}{}{}{}{}{}{}{}{}{UD4='DL014'}