Error : Time Filter to two dimension (Time*Lineitem)

CommunityMember125605
edited November 2022 in Modeling

Hi, I want to filter this table by Time in UX.

The point is this table has two dimension(Time and Lineitems) in columns.

 

Table A

CommunityMember125605_0-1669603869393.png

I prepare Time Filter Lineitem dimensioned by time(Quarter and Users)

CommunityMember125605_1-1669603948671.png

 

After I filtered Columns(Time,Lineitems) in UX, but I can't see any Time and Lineitems.

CommunityMember125605_4-1669604105543.png

 

 

Table A (Filtered)

CommunityMember125605_3-1669604048119.png

 

If I filtered to module views, I can correctly filtered.

Is there any way to resolve this proplem?

 

If I set the columns to Time (not Time * Lineitems), I could get correct table.

 

CommunityMember125605_0-1669604880695.png

 

Tagged:

Answers

  • ManjunathKN
    edited November 2022

    Hi @CommunityMember125605,

    It will throw error because your filter module does not have Line items. but you are trying to put a filter on columns with 2 dimensions. 

    if you want the filter to be applied with 2 dimensions on target, create the filter module by LISS(source module), users and time.

    if you apply new filter module on time, it will work.

    Thanks,
    Manjunath

  • CommunityMember125605
    edited November 2022

    Thanks, @ManjunathKN !

    I could do it!

     

    I wonder why it correctly filtered in Module View, but doesn't filtered in UX custom views.

    ■Module view

    CommunityMember125605_1-1669625916771.png

     

    ■Custom view

    Before

    CommunityMember125605_3-1669626195002.png

     

    After

    CommunityMember125605_2-1669626050967.png

     

     

     

  • CommunityMember125605
    edited November 2022

    Hi, I tried to create Filter Module(dimensioned by Time,Users).

    And I could filtered to this table by start and end time.

    CommunityMember125605_1-1669710905127.png

    CommunityMember125605_0-1669710848760.png

     

    I filtered same condition again, But Time Dimension was disappeared.

    CommunityMember125605_2-1669711107771.png

     

     

    Why did this happened?