Implicit Joins in Framework Manager

[Viswa]

There is already build framework is in my office. In that there is a date dimension and created short cut for date dimension(accounting Period) in the physical layer
And in the business layer when I edit the accounting period definition I saw like
below

here not "Account_Period_DATE_DIM"."FINANCIAL_445_YEAR" is null and "DATE_DIM"."FINANCIAL_445_YEAR"="Account_Period_DAT E_DIM"."FINANCIAL_445_YEAR" and "DATE_DIM"."FINANCIAL_445_MONTH_NUMBER"="Account_Pe riod_DATE_DIM"."FINANCIAL_445_MONTH_NUMBER" and to_char("Account_Period_DATE_DIM"."CALENDAR_DATE" - 2, 'DD/MM/YYYY')=to_char(sysdate)

I saw only one expression in filter like [Business Layer].[Accounting Period].[FINANCIAL_445_YEAR] is not null did not see other conditions .i think there is a hidden implicit join which I am not able to see


My question where can I find that join in the framework manager?

Please help me

Thanks,

[Heba El-Desouky]

you can separate each filter condition of them in an independent filter, and at the end all existing filters will be applied.

[blom0344]

Explicits joins in SQL query Subjects will not represent themselves in Explorer. You can however very easily scan the model.xml of the Framework to detect them. Use a good text editor like Notepad++ or Ultraedit..

[RAJKASSEN]

It's staring right at you. The one filter is at a database layer (namespace) and the other at the business layer. Look at the full path that tells where to look.