Error while applying user based filters

saiteja2246
saiteja2246
in Modeling

Hi All,

I have 3 modules, let's say A, B and SYS Filter

A module has dimensions - Stagging list, custom versions.

B module has dimensions - Stagging list, subset custom versions.

SYS Filter Module has dimensions - Stagging list, custom versions and Subset Users.

while applying same filter from Sys filter module, A Module picking current user but B module not picking current user instead showing list of users.

A module

image.png

B module

image.png

Can anyone please help me to understand the issue and how can i fix it.

Best Answer

  • saiteja2246
    saiteja2246
    Answer ✓

    Thanks AjayM!

    It worked after I have created intermediate module without subsets instead added Users and Custom versions as dimensions.

Answers

  • AjayM
    AjayM

    Hi @saiteja2246 ,

    I have a slightly different observation and understanding.
    Even if you take a simple example without users in the picture:
    Mod A with stagging list, custom versions
    Mod B with stagging list, SS custom versions,
    SYS module with stagging list, custom versions:

    Apply filter in Mod A: no dimension drop-down, all good
    Apply filter in Mod B: custom version dimension opens up, defaulting to first list item.

    So basically if the dimensions are different (having a subset in one of the modules), the filter rule opens up.

    While I understand your requirement here, I should say that this is the behaviour even when we have subset of users Vs full users list in the filter module (where you define filtering conditions).
    As a workaround, you may want to build an intermediate SYS module with full users list, fetch the filtering rule from original sys module, and then apply filtering condition in the target module from intermediate SYS module.

    Cheers!

Categories