title: SQL Analysis Services OLAP TIME dimension
body: <p>Hi
  i'm struggling with adding time dimension to OLAP cube.
  I can get everything in cube to work except date.</p>
  
  <p>In my source data view I have datetime column.</p>
  
  <p>I go by using Dimensions->New Dimension-><strong>Generate time dimension on the server</strong>.
  I end up with a nice hierachical time dimension (Date-Month-Quarter-Year).</p>
  
  <p>Later I add this dimension to cube and define regular relationship with datetime column from source data view (same table which has fact data).</p>
  
  <p>When I try to deploy the cube, I get error:</p>
  
  <p>Errors in the OLAP storage engine: The attribute key cannot be found when processing:Table: 'table_name', Column: 'registration_date', Value: '3/29/2007 3:00:00 PM'. The attribute is 'Date'</p>
  
  <p>Maybe I don't get something? Every manual I can find talks about calendar table already created in the source database. There are plenty of script which will create calendar table for you. But why should I ? Isn't <strong>Generate time dimension on the server</strong> meant for it?</p>