Forum Discussion

Ashok's avatar
Ashok
New Contributor III
2 years ago

DataCellDetail method query - how to filter on UD members

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.

 

 

Dashboards
  • kberry's avatar
    kberry
    2 years ago

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

  • kberry's avatar
    kberry
    New Contributor III
    2 years ago

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

    • Ashok's avatar
      Ashok
      New Contributor III
      2 years ago

      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'}