We have two fact tables and 9 dimension tables. Fact1 have all 9 dimensions and other measures columns. Fact2 has 3 out of 9 dimensions and other related measures.
Now I want to connect all Fact and dimension tables such a way when I use Fact 2 dimension and measures in pivot table, I should be able to apply filter from all the 9 dimensions. It is not working here, the data is duplicating or filter not getting applied. I am trying in latest version of Sisense (v7).
This was working fine earlier in one of our Qlikview implementation. Please let how can we achieve this requirement in Sisense.
Please sign in to leave a comment.