AdventureWorksDW2008 is missing dimTime Table?

Last post 08-20-2008 1:14 AM by moh_hassan20. 5 replies.
Page 1 of 1 (6 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 08-13-2008 5:21 PM

    • vvenk
    • Not Ranked
    • Joined on 08-13-2008
    • Posts 7

    AdventureWorksDW2008 is missing dimTime Table?

    Hello:

     I have been following the Tutorial on the Analysis Services. One of the steps that define a new data source asks the user to select a table DimTime (dbo) table. Unfortunately, this table does not exist in the database. This table is further referenced in subsequent steps and so, I cannot proceed further.

     Please help.

     Venki

  • 08-14-2008 5:01 PM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,515
    • Microsoft MVP
      Moderator

    Re: AdventureWorksDW2008 is missing dimTime Table?

    May be you need to download from Code plex site, as I can see on my end with 1158 rows.

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
  • 08-14-2008 7:57 PM In reply to

    • vvenk
    • Not Ranked
    • Joined on 08-13-2008
    • Posts 7

    Re: AdventureWorksDW2008 is missing dimTime Table?

    That's where I downloaded the database from (al beit the Zip version).

     I will try it once more.

     venki

  • 08-14-2008 8:24 PM In reply to

    • vvenk
    • Not Ranked
    • Joined on 08-13-2008
    • Posts 7

    Re: AdventureWorksDW2008 is missing dimTime Table?

    I downloaded the zip version, SQL2008.AdventureWorks_DW_BI_v2008.zip and after restoring it, I am still missing the dimTime table.

     When I downloaded SQL2008.AdverntureWorks_DW_BI_v2008.x64.msi and tried to run, I got the error message

     , "The processor is not supported" or something to that effect.

    I could not make SQL2008.AdverntureWorks_DW_BI_v2008.x64.msi work for me and so, I am not sure if that has the database with the missing table.

    Venki

  • 08-20-2008 12:56 AM In reply to

    Re: AdventureWorksDW2008 is missing dimTime Table?

     

    vvenk:

    ... I am still missing the dimTime table.

     

    review : http://www.codeplex.com/MSFTDBProdSamples/WorkItem/View.aspx?WorkItemId=7306 

    MCSE , MCITP (SQL 2005 Administration & Development), MCTS, MCPD
  • 08-20-2008 1:14 AM In reply to

    Re: AdventureWorksDW2008 is missing dimTime Table?

    vvenk:

     When I downloaded SQL2008.AdverntureWorks_DW_BI_v2008.x64.msi and tried to run, I got the error message

     , "The processor is not supported" or something to that effect.

    I could not make SQL2008.AdverntureWorks_DW_BI_v2008.x64.msi work for me and so, I am not sure if that has the database with the missing table.

    Venki

     

     

    can you try using the  32 bit version (SQL2008.AdventureWorks_DW_BI_v2008.x86.msi)

     

    MCSE , MCITP (SQL 2005 Administration & Development), MCTS, MCPD
Page 1 of 1 (6 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.