Solved

Lookup fields not selectable when adding data selection rule

12 days ago
25 April 2024
4 replies
39 views

Userlevel 2

wouter.goslinga
TimeXtender Xpert
35 replies

I am loading a fact table from a staging table, both are regular data warehouse tables. When I create a data selection rule on the mapping table, I'm unable to select the conditional lookup fields or the system fields from the source table:

TX Version is 6590.1. In legacy TX, it is possible to select the conditional lookup fields and system fields for creating selection rules:

We have implemented a workaround where we create an extra field in the DSA table that has a transformation that fills it with the value of the conditional lookup field. In turn, this extra field does show up in the selection rule fields because it is a regular field. But this is not a very nice or future-proof solution.

Is this an intentional change and if so, can you explain why? Or perhaps this is a bug in TX SAAS?

icon

Best answer by Christian Hauggaard 6 May 2024, 15:12

View original

4 replies

Userlevel 5

rory.smith
TimeXtender Xpert
403 replies
12 days ago
25 April 2024

Hi @wouter.goslinga ,

if you take the field into the MDW table you should be able to select it if you make the Data Selection rule at the table level instead of at the mapping level as another work-around option. If your MDW table is not simple-mode you could consider using raw-only on the field if you only use it for filtering to at least spare the space in the valid table.

I agree this is cumbersome and I'm not sure there is a valid functional reason for this.

Userlevel 2

wouter.goslinga
Author
TimeXtender Xpert
35 replies
12 days ago
25 April 2024

@rory.smith thanks and I agree but the big difference between a filter on the target table and a filter on the mapping is where the filter is applied, i.e. before or after the transfer. In this case I want it to be on the mapping so I can restrict the number of records being transferred.

It feels a bit strange that existing funtionality is being removed, looks like a bug to me.