Filter performance on dimension type

Ideas (en)
,
1

A query such as:

select count(*) 
from   GeneralLedgerDetailsV3@tfd
where  fin_trs_line_dim1type = 'Pxx'

runs quite long since the Dim1type does not get forwarded to Twinfield. Is there a way to optimize such queries?

2

Twinfield does not support filtering on the “fin.trs.line.dim1type” field. This makes it impossible to forward that filter.

I would suggest to do a feature request with Twinfield.