Forum Discussion

SHS's avatar
SHS
Resolver I
5 years ago
Solved

Contiguous Selection - Date Column Comes from a Table on the 1-side of a Bi-directional Relationship

Hello,  After searching and reading multiple articles regarding this, and yet to find a solution, I hope that some can come to my rescue. Before start explaning, let me just note, that this approac...
Need Help
  • SHS's avatar
    SHS
    5 years ago

    HI HashamNiaz ,

     

    The filter is only 1-way (DateTable --> SalesTable) - Sorry if misexplained. But it didn't solve. 

     

    What I meant in relation to the page-level filter is that from the DateTable I made a statement saying that if the Date in DateTable was before the first date or after the last date in my SalesTable it should be excluded from the overview, due to using the DateTable Dimensions as Axes in my visuals on the page. 

     

    I have not been able to create a calendar only from the SalesTable as I have other Fact Tables related to other Sales Figures (Order Intake, Backlog, Pipeline etc.).

     

    However, I solved the issue by changing my Exclusion Statement from FIRSTDATE/LASTDATE to MIN/MAX - Though this does not sound logical to me, as the first worked fine before, it seemed to fixe the issue

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi SHS !

Please elaborate why you are using bidirectional filter for this relationship. Once you changed the filter to single. It will resolve the issue. 

 

It seems the Sales table is trying to filter out Date dimension table and Page level filter not able to find specific rows used in filter expression.

 

Regards,

Hasham

  • SHS's avatar
    SHS
    Resolver I
    5 years ago

    HI HashamNiaz ,

     

    The filter is only 1-way (DateTable --> SalesTable) - Sorry if misexplained. But it didn't solve. 

     

    What I meant in relation to the page-level filter is that from the DateTable I made a statement saying that if the Date in DateTable was before the first date or after the last date in my SalesTable it should be excluded from the overview, due to using the DateTable Dimensions as Axes in my visuals on the page. 

     

    I have not been able to create a calendar only from the SalesTable as I have other Fact Tables related to other Sales Figures (Order Intake, Backlog, Pipeline etc.).

     

    However, I solved the issue by changing my Exclusion Statement from FIRSTDATE/LASTDATE to MIN/MAX - Though this does not sound logical to me, as the first worked fine before, it seemed to fixe the issue