Hello All,
I have two fact tables with 2 conformed dimensions and 1 non-conformed dimension. I have created start schema grouping for these two Facts.
In report studio, I've added data items from both conformed & non conformed dimensions and included a filter to eg: [Revenue]>0.
However, the filter doesn't seem to work as this gets applied to the subquery of the stitched query.
What is the best way to handle these null values so that filter is applied to the overall query.
Appreciate your thoughts and help !!
Thanks & Regards
Raj