If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Implicit Joins in Framework Manager

Started by Viswa, 10 Sep 2010 03:21:01 PM

Previous topic - Next topic

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_elfaid

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.