Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

create table visual from multiple facts tables across common dimension table

Hi,

I have the following schema:

 

I use the middle table (dimension) as a filter in my report, as this:

which works fine as long as I display both fact tables (models and data) separately.

But when I combine the fields from both tables into one table, I get:

 

 

How can I go around this to display a filtered (cartesian) table with week | model | data?

Thanks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous

     

    Any particular reason why the cross filter is set to bidirectional ? 

     

    If there is no specific requirement to do so, can you make it one direction ( Weeks to Data  & Weeks to Models) and try?

     

    Thanks
    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      One direction doesn't work either