Hi Experts,
I try to create the relationship between Dimension tables(AGENT/CALENDAR) and Fact tables (DIGL_ORD) in RPD,after I filter data in dimension table in analytics and see the SQL generated by OBIEE Analytics, I find the strange phenonmenon that the value will be filtered twice (Both dimension and fact table will filter the value,Why?)
I think only the dimension table will filter the values,right?
Because the dimension table is inner join the fact table and the filter value is in dimension table.
