Custom Data Selection in DSA layer in TX v20.x

I would probably just create a custom field with something like below and just add a fixed value to lookups with [Filter = 1] = 1

Alternatively, if your datasource supports managed queries you could do your filtering then as well

Hi,

I would think a bit about whether you might ever need the raw data for future requirements. If so, you can load all the data and stage it to generate the output you need. One way would be to aggregate on FCL and Max YearEnd, lookup up the matching YearFrom.

If you know you will never need the raw data, the possible solutions depend on the version of TimeXtender. In TX Classic you could use a custom Data Selection rule to do more complex filtering source-side, in TDI you could use a new field like ​@nmo suggests.

We are working with TX v20 (Classic). I also need the rest of the fields in the (dim)-table as lookup to the fact-table. So i am affraid that aggregation is not the solution. 

I tried several filtering in the custom Data Selection, but it doesn't work. 
In our BI tool i would use the function  max(YearEnd for FCL) = YearEnd

This didn't work in TX. 

​@roland.peeters did you try ​@nmo suggestion to create a managed query for your data source?

https://legacysupport.timextender.com/hc/en-us/articles/115001357983-How-to-use-the-query-table-tool