time dimension was not generated because it is bound to a time binding

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » time dimension was not generated because it...

time dimension was not generated because it is bound to a time binding

Rate Topic

Display Mode

Topic Options

Author

Message

Karen Schaefer-163016

Posted Monday, November 09, 2009 12:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 04, 2010 11:54 AM
Points: 3, Visits: 75

I am using SQL Server 2008 and am trying to generate a date dimension in Analysis Services using the "Generate a time table on the server" option and using the Date template. When I run Generate Relational Schema from the Database menu, I get the following error:

"time dimension was not generated because it is bound to a time binding"

I have not been able to find any information on what is causing this error. All help would be appreciated.

Post #816071

dphlps

Posted Thursday, December 03, 2009 1:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 1, Visits: 172

Is there any update on this question?

I have the same situation and same error message...

Post #828478

Karen Schaefer-163016

Posted Thursday, December 03, 2009 2:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 04, 2010 11:54 AM
Points: 3, Visits: 75

I haven't been able to solve the problem yet. I'll post a solution if I find one.

Post #828500

cindypsych

Posted Friday, December 04, 2009 3:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 23, 2009 3:28 PM
Points: 6, Visits: 7

If you can post some more information about what led up to that error then people may be able to help. Can you give step by step exactly what you did and when the error occurred? Also, what version of SSAS?

Post #829296

jball-1140155

Posted Thursday, February 11, 2010 8:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 29, 2012 11:20 AM
Points: 1, Visits: 15

Karen,

Did you find anything on this yet?
I'm in the same boat.

Post #864120

adam 81802

Posted Tuesday, April 06, 2010 9:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 06, 2010 9:24 PM
Points: 1, Visits: 0

Hi,

Check out the solution here if your error still exists:

http://www.bronios.com/index.php/2010/04/01/error-the-time-dimension-was-not-generated-because-it-is-bound-to-a-time-binding/

BigGrin

Adam
~SharePoint, .Net, SQL, MS BI, Collaboration and Gadget~

Post #898096

Karen Schaefer-163016

Posted Wednesday, April 07, 2010 5:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 04, 2010 11:54 AM
Points: 3, Visits: 75

I'll give the article's suggestion a try. Thanks.

Post #898375

ramu139

Posted Wednesday, April 27, 2011 12:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 19, 2011 9:48 AM
Points: 4, Visits: 27

Hi,

I was getting the same error because i don't have a sysadmin rights on the server. Once i have a sysadmin rights on that server, i'm able to create a time dimension with out any error.

Post #1099709

SQL Swerver

Posted Wednesday, September 19, 2012 10:10 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 3:24 AM
Points: 67, Visits: 350

I do have sysadmin role assigned to my user, I just created the entire database, created four other dimension tables and now I want to use the Generate Schema Wizard to create and populate a Date Dimension table for me and I still get this error:

The 'Date' dimension was not generated because it is bound to a time binding.

Does anybody have any further information other than that already post (I already know which boxes to tick).

Post #1361474

« Prev Topic | Next Topic »

Permissions