Create cube - not recognising Dim tables RRS feed

  • Question

  • Hi

    When creating new cube using existing tables is not able to recognise dimension tables, only taking fact table.

    in DSV, I've set the right relationship and in DSV its showing fact and dim tables with right relationships..

    any help?

    • Edited by SQL2012BI Thursday, August 22, 2013 12:30 PM
    Thursday, August 22, 2013 12:29 PM


  • Hi NoorBi,

    Generally, the "use existing tables" wizard will guide you through the process of selecting and defining measure groups and dimensions based on existing tables to build your new cube.

    In your case, please ensure that you select "Use existing tables" option. If so, please try to delete the DSV and recreate a new DSV for the SSAS project. If this issue still persists, please create a new SQL Server Analysis Services project to see if this works for you.

    Best Regards,

    Elvis Long
    TechNet Community Support

    Thursday, August 29, 2013 8:34 AM