1 Reply Latest reply: Jan 16, 2014 10:03 PM by Ibag RSS

Filter on the same logical table source on two logical tables is not working properly

kennyguru Newbie
Currently Being Moderated

Hi,

 

In the RPD, assume that I have a physical table named Employee_fact, created an Alias called D0 Employee Fact

In the BMM I've two logical tables called Employee_fact_Type1 and Employee_fact_Type2

Each of these logical tables has the same Logical table source - D0 Employee

 

But in each logical table source, I've a filter in where clause

such as, for Employee_fact_Type1  employee_type = 'XXX'

             for Employee_fact_Type2 employee_type='YYY'

 

These two facts are present in the same BMM and each of them are connected to two dimensions

such as

 

Dept_type1 <- Employee_fact_type_1 -> Tenure_type1

Dept_type2 <- Employee_fact_type_2 -> Tenure_type2

 

In analysis, When I query the columns from Dept_type1 and Tenure_type1, the database query generated shows the condition employee_type='YYY' instead of employee_type='XXX' .

But, adding the columns from Dept_Type1, Employee_fact_type_1, Tenure_type1 it shows proper filter.

 

I checked the relationships, presentation layer for the sources of presentation tables and everything looks good.

Can anybody tell me what goes wrong here?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points