Hi Experts,
I am getting this error when I am trying to put a filter which is not from one of the fact table but from other fact table.
My criteria is as below.
I have columns from fact f1 and fact f2 and 2 dmensions tables. The filters I have for this criteria(which are from dimensions) are common for the both the fact tables.
So when I am trying to use fact f2 column as a filter then I am getting this error of None of the fact sources for Fact table are compatible with the detail filter. Not able to figure out what my approach be to this error.
To make it simple my query is like below.
select
f1.columns,
f2.columns,
d1.columns,
d2.columns
from
(select d1.columns,d2.columns,f1.columns
from d1,d2,f1 where filters from dimension) xy,
(select d1.columns,d2.columns,f2.columns
from d1,d2,f2 where filters from dimension and fact) yz ----so when I am using the fact column filter in the criteria it is having the said error. The applied filter should only be only applied to the second
where -- fact table. But in my case when I am having this error its saying "None of the fact sources for f1 table are compatible with detial filter (which
filters. -- is from f2 columns)
Please suggest how to go about this issue.