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,
you can separate each filter condition of them in an independent filter, and at the end all existing filters will be applied.
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..
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.