Author Topic: Error message establishing outer join relationship between Dimension &Fact table  (Read 751 times)

Offline vincydza@gmail.com

  • Senior Member
  • ****
  • Join Date: Apr 2014
  • Posts: 63
  • Forum Citizenship: +0/-0
Hi,

The funder is not a mandatory column in the KPI Fact table. The requirements for this project are to include all KPI values therefore an outer join relationship has to be established between the Dim_Funders(0) and KPI_Fact(n) table.

When I try to establish an outer join, Dynamic cube designer highlights it as an issue with the error message.

"One or more attributes that are used as level keys or the caption in the level Province reference column(s)
in table DIM_FUNDERS. The outer join allows empty rows to be returned from it when the dimension is populated during cube startup which will result in null members being created."

The levels defined for funders are

Province
Category
Funders.

The "Outer Join" relationship is available in the Framework manager & Cognos Transformer.
Can the "Outer Join" relationship be established in Dynamic Cube Designer? 

Please advise.
« Last Edit: 28 Aug 2020 11:37:53 am by vincydza@gmail.com »

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 480
  • Forum Citizenship: +45/-0
From what I gathered from your previous question and from one of the pictures which you posted elsewhere, you are putting your fact table into the dimension.  I have been so far unsuccessful in determining why you think you need to do that.

The UI allows for outer joins in the dimension but does not for the join between a dimension and the fact table.   

It would be rather easier and reflect the reality which you are trying to model by putting vendor into the category level as an attribute.