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?
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.