Use filter from a module with different dimensions

Isha
Isha
in Modeling

Hi,

I have a Input module dimensioned by Unique Identifiers. This module has Product list formatted line item 'Product name'. Attributes products module has 'Product Type' filter, 'Budget' filters dimensioned by Product and Users. Now I need Product Type filter, Budget filters to be applied on the Input module dimensioned by UID.

Please advice on how can we achieve this!

😀

Best Answer

  • AjayM
    AjayM
    edited October 23 Answer ✓

    Hi @Isha,

    You need to calculate the final filter for every user and product, and use that final filter against product formatted lineitem in the input module. Then you can use the new filter lineitem upon unique IDs. You may follow below steps to achieve this.

    1. Add a filter lineitem 'Combined filter' in your attributes module, dimension it by users and product list.
    2. Refer both product type filter and budget filter into the 'combined filter' lineitem's formula [Simply like "product type filter and budget filter"].
    3. Add a filter lineitem in input module 'product filter', dimension it by users and UID list
    4. Refer combined filter into this product filter by looking up at the product list formatted lineitem
    5. Now you can use the 'product filter' on UIDs, upon current user

    Cheers!

Answers

  • Isha
    Isha

    Hi @AjayM,

    Great! This worked out well. Appreciate your response and detailed explanation.

    😀

Categories