SQL Server Performance

Creating cube

Discussion in 'SQL Server 2005 Analysis Services' started by california6, May 14, 2007.

  1. california6 New Member

    I am going through the Analysis Services documentation provided here. but not able to fully understand it as to how to start implementing it. I have a question: when i install SQL Server 2005 (full installation) does all the analysis, reporting services tools get installed?

    How could i create a Cubes, dimensions etc?

    Thanks,
    Cali
  2. MohammedU New Member

    Analysis services and reporting services are two different services(products) of sql server, when you install one the other one will not be installed unless you checked check box to install.

    Check the following topics in BOL...

    http://msdn2.microsoft.com/en-us/library/ms175641.aspx
    http://msdn2.microsoft.com/en-us/library/ms174940.aspx
    http://msdn2.microsoft.com/en-us/library/ms174487.aspx

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. california6 New Member

    Thanks for the answer. I was able to sucesfully install all the analysis and reporting services. but just confuse in getting started using them. reading online documentation and having hard time in understanding as to how to start. never used these before and pretty new to this environment.

    Any basic documentation out there?

    Thanks,
  4. MohammedU New Member

  5. satya Moderator

    In addition to Mohammed's references you can also take help of webcasts:
    http://msdn2.microsoft.com/en-us/sql/aa336323.aspx
    http://msevents.microsoft.com/cui/eventdetail.aspx?eventID=1032263432&Culture=en-US
    http://msevents.microsoft.com/cui/eventdetail.aspx?eventID=1032293595&Culture=en-US

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  6. Raulie New Member

    I think you should also pick up a book on the fundamentals of Dimensional Design or Star Schemas. Building cubes with out dimensional design experience/knoweledge could be a recipe for disaster. I advocate a lot of Ralph Kimballs teachings who pioneered the dimensional design. Look here for referenceshttp://www.ralphkimball.com/

    Raulie



  7. satya Moderator

    Raulie<br />No doubt that Ralph's insight is a bible but it will be way high for the beginners, as most of it covers the deep dive sessions [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  8. Raulie New Member

    In this site there is a wealth of information for Beginners to Senior Architects, a deep dive session is difinately not for a beginner, "fundamentals" is more like it which some can find in the articles or books section of the site.

    Raulie



Share This Page