Error the ‘Time’ dimension was not generated because it is bound to a time binding.

If you come across the error “the ‘time’ dimension was not generated because it is bound to a time binding.” during creating a time dimension in SSAS 2008. Here is the solution:

1. Follow the normal step to create a time dimension in Analysis Services Project.

2. Proceed to configure the time dimension.

3. On the last screen of the wizard, make sure you check the generate schema. This step will immediately create the table in your database.

4. Go through “Generate Relational Schema..” on the context menu of the project will give you error as above.

Hope this helps :)

Leave a Reply