Getting missing functional dependency association when trying to add a new columns to fact table

789446

Hello All,

Need help on the below issue.

We are using our RPD in 11.1.1.7 platform.

I have added a new descriptive column in the fact table which is used on many other reports.

The datatype is varchar2(50)

When I source it into BMM and extend it to Pres layer, getting error "15004 missing functional dependency association for this new column" in consistency check..

I checked the logical column and I see datatype as varchar 50 and nullable displayed in logical column.

The logical fact table has 4 LTS. 2 of them has different joins in the physical layer. Few of these joins has been used to derive few measures out of the joined dimensions.

The other is an aggregated fact which does not have this extension column.

I have checked it multiple times, but I am not able to find any clue why is the BI throwing this error when I try to add a new descriptive fact column.

I am facing the same error when I created a new physical and logical tables out of the alias of the fact table and joining the same with the PK of the fact table and use the alias for the new column in the logical table in BMM layer.

Any thoughts on where I am getting it wrong?

Thanks in advance..

Shravan

[Deleted User]

789446 wrote:I have added a new descriptive column in the fact table which is used on many other reports.

Yyyyeah. Wrong. Dimension or degenerate dimension. Attributes / descriptive columns do not belong in facts.

Edit: Dimensional modelling 101:

http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techn…

http://www.kimballgroup.com/2003/06/design-tip-46-another-look-at-degenerate-dimensions/

789446

Hi Christian,

Thank you for the response.

However, When I was able to resolve it by following the below blog:

https://www.rittmanmead.com/blog/2010/01/oracle-bi-ee-10-1-3-4-1-modeling-degenerate-dimensions-fact-attributes/

Thanks

Shravan