Fact - Fact Relationship ?

• H4K

  Hall of Fame

  Points: 3374

  More actions

  September 18, 2012 at 5:12 am

  #281493

  Hi Experts,

  Please Help !!

  I had a Manager who asked me this question during interview that:

  whether a Fact table can have a relationship with another fact table in SSAS ?

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI

• Tee Time

  Hall of Fame

  Points: 3745

  More actions

  October 19, 2012 at 2:37 pm

  #1551060

  No, you would not want to attempt to join to fact tables.

  You can have two fact tables in a cube that could relate to the same dimensions, but the two facts would not be connected directly.