Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

time dimension was not generated because it is bound to a time binding Expand / Collapse
Author
Message
Posted Monday, November 9, 2009 12:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 4, 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
Posted Thursday, December 3, 2009 1:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:35 PM
Points: 1, Visits: 216
Is there any update on this question?

I have the same situation and same error message...
Post #828478
Posted Thursday, December 3, 2009 2:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 4, 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
Posted Friday, December 4, 2009 3:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 23, 2013 1:13 PM
Points: 8, Visits: 25
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
Posted Thursday, February 11, 2010 8:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, April 6, 2010 9:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 6, 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/



Adam
~SharePoint, .Net, SQL, MS BI, Collaboration and Gadget~
Post #898096
Posted Wednesday, April 7, 2010 5:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 4, 2010 11:54 AM
Points: 3, Visits: 75
I'll give the article's suggestion a try. Thanks.
Post #898375
Posted Wednesday, April 27, 2011 12:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, September 19, 2012 10:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:15 AM
Points: 89, Visits: 438
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 »

Add to briefcase

Permissions Expand / Collapse