Post reply

Cube Wizard not detecting a Fact Table in SSAS

  • July 5, 2007 at 11:17 pm

    #120736

    Hi,

    While trying to create a Cube using the Cube WIzard, Under  'Identify Fact and Dimension Tables' screen, When I try to check option 'Fact' or 'Dimension'  for a FactTable, SS is flagging  an error.

    I need to select the Fact Table somehow.

    can Someone help me ?

     

    Thanks,

    Sundar

     

  • July 6, 2007 at 12:44 am

    #717585

    Figured out the reason for this behavior.

    In the Fact Table, I didnt define the Foreign Keys with the necessary Dimension tables, due to which SS  gave neither the Fact nor the Dimension  Status to the Fact Table in Question.

    Thanks to the SQLServerCentral group for all the useful articles.

     

    Regards,

    Sundar

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply