Button Action to Apply Filter using Set Analysis

[luis_dgl]

I tried using a Concat function to filter the values I needed, however we hit a maximum char limitation, I was wondering if it was possible to apply a filter using a Set Analysis expression.

[Anil_Babu_Samineni]

@luis_dgl I guess so, can you please explain more?

[luis_dgl]

Alright, so I have two different tables that contains the same products, one of which connects to a single Sales table, I need to select all the products from table 1, filtered from one Sale, on table 2.

I tried concatenating all the products currently filtered by the selected Sale, however when there are too many products the character maximum is reached, and no product is selected.

I was wondering if I can use a set analysis with a P operator to get all products from the sale and select them on table 2

[NellyAcko]

HI can you post example data and a screen shot of both tables, it sounds like it should be a fairly simple task to complete

[luis_dgl]

Good morning,
Below is the data model from the tables. FATO_VENDAS is the total sales table, DIM_PROMOCOES is the promotions/special sales (SCD), DIM_PRODUTOS is the normal products dimension. Now, NOTA_FORNECEDOR and FORNECEDOR_SELECAO are second products table, they are a copy of DIM_PRODUTOS, which I use to filter the products which are sold together in the normal products table. What I need to do is basically select on FORNECEDOR_SELECAO the products of the same name in DIM_PRODUTOS that are filtered by DIM_PROMOCOES

[Anil_Babu_Samineni]

@luis_dgl Data model won't help this case because you need something in UI, Will you able to create sample app and send it to us to look? 

[luis_dgl · Accepted solution]

Just to give this thread a conclusion, we found it better to just solve it using the data model, creating a new Promotions table copy (SELECAO_PROMOCAO) to link to NOTA_FORNECEDOR (Sales table copy). This way we filter all the products by simply having a selection on this table.