none
Dimension now showing up when creating a cube

    Question

  • I created a Date dimension using the generate time table using the data source.  Now I am trying to create a cube but it is not showing up as a dimension I can choose from.  Does anyone know how to fix this so I can select date as a dimension when creating a cube?
    Sunday, June 17, 2012 7:28 PM

Answers

  • Open your dimension up and do you see an entity representing the created table or do you see a link to update your data source view? For a dimension to be added to a cube, the source table that it is based on must be defined in the same data source view as the fact tables that your measure group is associated. My guess is that your table hasn't been created or you've added it to a DSV that your cube is not based on.

    HTH, Martin


    http://martinmason.wordpress.com

    • Marked as answer by Eileen Zhao Monday, July 09, 2012 2:38 AM
    Sunday, June 17, 2012 8:20 PM