Forum Discussion
Anonymous
7 years agoNot applicable
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
- AnonymousNot 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- AnonymousNot applicableOne direction doesn't work either