Skip to main content
A
Ashok
Contributor
February 6, 2023
Solved

DataCellDetail method query - how to filter on UD members

  • February 6, 2023
  • 1 reply
  • 0 views

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.

 

Ashok_0-1675716868301.png

 

Best answer by KeithBerry

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

1 reply

K
OneStream Employee
KeithBerryOneStream EmployeeAnswer
OneStream Employee
February 6, 2023

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

    A
    AshokAuthor
    Contributor
    February 6, 2023

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

      Terms & ConditionsAccessibility statement