Hi Christian, Thanks for your response!!! OBI generates two sqls for me, one with F1 and D and the other with F2 and other conformed dimensions. As long as I do not filter on dashboard prompt from the column of D, OBI uses a full outer join between the 2 sqls, but when I apply any filter on column from D, it uses an inner…

Hi Christian, Thanks , It now worked for me.. The issue it did not work last time was the logical column had multiple mappings. It set the content level on both and was able to get that to work now. Thanks Shravan

Hi Christian, Thank you for the response. I have implemented the below steps: Created a new physical alias of the dimension Configured a physical join between the revenue fact and the new alias on the key column Created a new logical dimension table with the help of the new physical alias Configured logical joins between…