SQL Server 2005 Analysis Services »ç¿ëÇÏ´Â Project Server 2003 ¹èÆ÷¿¡ OLAP Å¥ºê¸¦ ¸¸µé ¶§ ¿À·ù ¸Þ½ÃÁö: "ÁöÁ¤µÈ OLAP ¼­¹ö¿¡ ¿¬°áÇÒ ¼ö ¾ø½À´Ï´Ù."

¿µ¹®ÀÚ¿Í ¼ýÀÚ°¡ Á¶ÇÕµÈ PIN Äڵ尡 ¼³Á¤µÈ Bluetooth ÀåÄ¡°¡ ÀÖ´Ù¸é. ´ÜÀÏ ¼­¹ö ¹èÆ÷, ¼­¹ö ÆÊ ¹èÆ÷, ¶Ç´Â Microsoft Project Server 2003ÀÇ 3 °èÃþ ±¸¼º ÇÕ´Ï´Ù. ´ÜÀÏ ¼­¹ö ¹èÆ÷, ¼­¹ö ÆÊ ¹èÆ÷, ¶Ç´Â Microsoft SQL Server 2005 Analysis Services »ç¿ëÇÒ Project Server 2003ÀÇ 3 °èÃþ ±¸¼º ±¸¼ºÇÕ´Ï´Ù. Microsoft Office Project Web Access 2003À» ¼ö, ·Î±×¿Â ¹× ¿Â¶óÀÎ ºÐ¼® ó¸® (OLAP) Å¥ºê ºôµåÇÏ·Á¸é ´ÙÀ½ ½ÃµµÇϽʽÿÀ. ±×·¯³ª ÀÛ¾÷ÀÌ ¼º°øÀûÀ¸·Î ¿Ï·áµÇÁö ¾Ê½À´Ï´Ù. ¶ÇÇÑ ´ÙÀ½ ¿À·ù ¸Þ½ÃÁö¿Í À¯»çÇÑ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.

ÀÌ ¹®Á¦´Â ÇöÀç ¼­ºñ½º ÆÑ¿¡ Æ÷ÇÔµÈ ÇÖÇȽº¿¡¼­ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù. ÃֽŠProject Server 2003 ¼­ºñ½º ÆÑÀ» ¼³Ä¡ÇÑ °æ¿ì ÇÖÇȽº¸¦ ¼³Ä¡ÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.

¼­ºñ½º ÆÑ Á¤º¸

ÀÌ ¹®Á¦´Â Project Server 2003 ¼­ºñ½º ÆÑ 3¿¡¼­ ÇØ°áµÇ¾ú½À´Ï´Ù. ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Project Server 2003 ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼­ È®ÀÎÇϽʽÿÀ:

ÇÖÇȽº Á¤º¸

ÇÖÇȽº¸¦ ±¸ÇÏ´Â ¹æ¹ý

ÀÌ ¹®Á¦´Â Project Server 2003 ¼­ºñ½º ÆÑ 2a 2006³â 6¿ù 16ÀÏÀÚ ÀÌÈÄ ÇÖÇȽº ÆÐÅ°Áö¿¡¼­ ÇØ°áµÇ¾ú½À´Ï´Ù. Ãß°¡ Á¤º¸´Â ´ÙÀ½ ¹®¼­ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á¿¡¼­ È®ÀÎÇϽʽÿÀ: Áß¿äÇÑ ÇÖÇȽº¸¦ Àû¿ëÇÑ ÈÄ ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ. SQL Server 2005 Analysis Services »ç¿ëÇÏ´Â Project Server 2003 ¹èÆ÷¿¡¼­ OLAP ¼º°øÀûÀ¸·Î ºôµåÇϱâ Àü¿¡ ´ÙÀ½ ÀýÂ÷¸¦ ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.

1. SQL Server 2005 Analysis Services ½ÇÇà ÁßÀÎ ÄÄÇ»ÅÍ¿¡¼­ ´ÙÀ½ ÀÌ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
   1. Microsoft SQL Server 2005 ¼­ºñ½º ÆÑ 1 (SP1) ¶Ç´Â ÃֽŠ¼­ºñ½º ÆÑÀ» ¼³Ä¡ÇϽʽÿÀ. SQL Server 2005 ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
      913089

      (http://support.microsoft.com/kb/913089/ )

      SQL Server 2005 ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý
   2. ºÐ¼® ¼­¹ö¿¡¼­ ¼­¹ö ¿ªÇÒÀÇ ¸â¹ö°¡ ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ. Analysis Services ÀνºÅϽº¿¡ ´ëÇØ ÇØ´ç ¼­¹ö ¿ªÇÒ¿¡ ±¸¼º¿øÀ» Ãß°¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
      Âü°í SQL Server 2005 Analysis Services ÀνºÅϽº ¼­¹ö ¿ªÇÒÀÇ ¾×¼¼½º¸¦ ¹«Á¦ÇÑÀ¸·Î ¸ðµç Analysis Services °³Ã¼¿Í ÇØ´ç ÀνºÅϽº µ¥ÀÌÅ͸¦ ¼ö ÀÖ½À´Ï´Ù. Analysis Services ¼­¹ö ¿ªÇÒÀÇ ±¸¼º¿øÀÌ Microsoft Windows »ç¿ëÀÚ ¹× ±×·ìÀ» Analysis Services ¼­¹ö ¿ªÇÒÀ» Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
      1. SQL Server °ü¸® StudioÀÇ Analysis Services ÀνºÅϽº¿¡ ¿¬°áÇÒ ÀνºÅϽº À̸§À» °³Ã¼ Ž»ö±â¿¡¼­ ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߷ΠŬ¸¯ÇÑ ´ÙÀ½ ¼Ó¼º À» Ŭ¸¯ÇϽʽÿÀ.
      2. º¸¾ÈÆäÀÌÁö ¼±Åà â¿¡¼­ Ŭ¸¯ÇÑ ´ÙÀ½ ¼­¹ö ¿ªÇÒÀ» Çϳª ÀÌ»óÀÇ Windows »ç¿ëÀÚ ¶Ç´Â ±×·ìÀ» Ãß°¡ÇÏ·Á¸é Ãß°¡ Ŭ¸¯ÇϽʽÿÀ.
2. »óȲ¿¡ µû¶ó ÀûÀýÇÏ°Ô ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ ¼öÇàÇϽʽÿÀ.
   • ¾î¶² Project Server 2003 SQL Server 2005 ´ÜÀÏ ¼­¹ö ¹èÆ÷ Project Server 2003ÀÇ °æ¿ì, SQL Server 2005 Analysis Services ÇÑ ÄÄÇ»ÅÍ¿¡ ¼³Ä¡µÈ 3´Ü°è·Î À̵¿ÇϽʽÿÀ. 2 ´Ü°è ÀýÂ÷¸¦ ¼öÇàÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.
   • Project Server 2003 ¼­¹ö ÆÊ ¹èÆ÷ÀÇ °æ¿ì ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
     1. Microsoft ÀÎÅÍ³Ý Å½»ö±â¸¦ ½ÃÀÛÇÑ ÈÄ ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
        http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

        (http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en)
     2. ÄÄÇ»ÅÍ ¶Ç´Â Project Server º¸±â ¾Ë¸² ¼­ºñ½º¸¦ ½ÇÇàÇÏ´Â ÄÄÇ»ÅÍ¿¡ ´Ù¿î·ÎµåÇÏ¿© ´ÙÀ½ ÇÁ·Î±×·¥À» ¼³Ä¡ÇϽʽÿÀ.
        
        Âü°í ÀÌ·¯ÇÑ ÇÁ·Î±×·¥Àº ¿¡ Ç¥½ÃµÈ ¼ø¼­´ë·Î ¼³Ä¡ÇϽʽÿÀ.
        • Microsoft .NET Framework 2.0
          
          Âü°í .NET Framework 2.0¸¸ ÀÌ¹Ì ÄÄÇ»ÅÍ¿¡ ¼³Ä¡µÇ¾î ÀÖÁö ¾ÊÀ¸¸é ¼³Ä¡ÇϽʽÿÀ.
        • Microsoft ÇÙ½É XML ¼­ºñ½º (MSXML) 6.0
        • Microsoft SQL Server Native Client
        • Microsoft SQL Server 2005 °ü¸® °³Ã¼ Ä÷º¼Ç
        • Microsoft SQL Server 2005 ÀÌÀü ¹öÀü°úÀÇ È£È¯¼º ±¸¼º
          
          Âü°í SQL Server 2005 ÀÌÀü ¹öÀü°úÀÇ È£È¯¼º ±¸¼º ¼³Ä¡ÇÒ ¶§ °æ¿ì¿¡¸¸ ÀÇ»ç °áÁ¤ Áö¿ø °³Ã¼ (DSO) ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ´Ù¸¥ ±¸¼º ¿ä¼Ò¸¦ ¼³Ä¡ÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.
        • Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB °ø±ÞÀÚ
3. SQL Server 2005 Analysis Services ½ÇÇà ÁßÀÎ ÄÄÇ»ÅÍ¿¡¼­ ´ÙÀ½ ÀÌ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
   Âü°í SQL Server 2005 Analysis 3 °èÃþ ±¸¼º¿¡¼­ ¿ø°ÝÀ¸·Î ½ÇÇà ÁßÀÎ Services°¡ Æ÷ÇԵ˴ϴÙ.
   1. ´ÙÀ½ Æú´õ¿¡ DSO9 ¶ó´Â ÇÏÀ§ Æú´õ¸¦ ¸¸µì´Ï´Ù.
      C:\Program Files\Microsoft SQL Server\Mssql. \OLAP Number
      Âü°í Mssql. Number SQL Server 2005 Analysis Services ÆÄÀÏÀÌ ÀúÀåµÈ Æú´õÀÔ´Ï´Ù.
   2. SQL Server 2000 ºÐ¼® ¼­ºñ½º¸¦ ¿Ïº®ÇÏ°Ô ÆÐÄ¡µÈ DSO9 Æú´õ·Î SQL Server 2005 Analysis Services ½ÇÇà ÁßÀÎ ÄÄÇ»ÅÍ¿¡¼­ ½ÇÇà ÁßÀÎ ÄÄÇ»ÅÍ¿¡¼­ Msmdrep.mdb ÆÄÀÏÀ» º¹»çÇϽʽÿÀ.
   3. DSO9 Æú´õ¸¦ °øÀ¯ÇÏ°í MSOLAPRepository $ °øÀ¯ Æú´õ¿¡ ´ëÇÑ °øÀ¯ À̸§À» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
   4. Àб⠾׼¼½º ¹× °øÀ¯ Æú´õ¿¡ ´ëÇÑ ¾²±â ±ÇÇÑÀ» ÇÒ´çÇϽʽÿÀ. Project Server 2003 Analysis Services ó¸® ¿¬°áÇÏ´Â µ¥ »ç¿ëÇÏ´Â °èÁ¤ ¶Ç´Â ·ÎÄà °ü¸®ÀÚ ±×·ì¿¡ ´ëÇØ ÀÌ·¸°Ô.
      
      Project Server 2003 Analysis Services ¾×¼¼½ºÇÏ´Â °èÁ¤¿¡ Analysis Services ÀνºÅϽº¿¡ ´ëÇÑ ÀûÀýÇÑ »ç¿ë ±ÇÇÑÀÌ ºÎ¿©µÇ¾î¾ß ÇÕ´Ï´Ù.
   5. Msmdsrv.ini ÆÄÀÏÀ» ¿­°í <dso>ű×ÀÇ ³»¿ëÀ» ´ÙÀ½ ÄÚµå·Î ¹Ù²ß´Ï´Ù.

      <DSO>
      <RemoteRepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ComputerName\MSOLAPRepository$\msmdrep.mdb;Persist Security Info=False</RemoteRepositoryConnectionString>
      <RepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP\DSO9\msmdrep.mdb;Persist Security Info=False</RepositoryConnectionString>
      <RemoteLocksDirectory>\\ComputerName\MSOLAPRepository$</RemoteLocksDirectory>
      <LocksDirectory>C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP\DSO9</LocksDirectory>
      </DSO>
      

      Âü°í, Msmdsrv.ini ÆÄÀÏ Path \Config Æú´õ¿¡ ÀÖ½À´Ï´Ù. SQL Server 2005 Analysis Services°¡ ½ÇÇàµÇ´Â ÄÄÇ»ÅÍÀÇ À̸§À¸·Î Äڵ忡¼­ ComputerName ´ëüÇÕ´Ï´Ù È®ÀÎÇϽʽÿÀ.
      
      óÀ½ Msmdsrv.ini ÆÄÀÏÀ» ÀúÀåÇÒ ¶§ SQL Server 2005 Analysis Services "ConnectionString" Á¤º¸¸¦ ¾ÏȣȭÇÕ´Ï´Ù. ÀÌ ¹ß»ýÇÑ ÈÄ ÆÄÀÏÀ» ´Ù½Ã ¿­ ¶§ ÇØ´ç Á¤º¸¸¦ ÀÐÀ» ¼ö ¾ø½À´Ï´Ù. µû¶ó¼­ ³ªÁß¿¡ ÇÊ¿äÇÑ °æ¿ì Äڵ带 º¹»çº»À» À¯ÁöÇØ¾ß ÇÕ´Ï´Ù.
   6. SQL Server 2005 Analysis Services ¼­ºñ½º¸¦ ÁßÁöÇß´Ù°¡ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.
4. Project Web Access 2003À» ·Î±×¿ÂÇÏ°í OLAP Å¥ºê¸¦ ÀÛ¼ºÇϽʽÿÀ. OLAP Å¥ºê¸¦ ¸¸µé ¶§ SQL Server 2005 Analysis Services ¾÷µ¥ÀÌÆ® ÀÚ¿ø Å×ÀÌºí ¹× OLAP Å¥ºê ÆäÀÌÁö¿¡¼­ ½ÇÇà ÁßÀÎ ÄÄÇ»Å͸¦ ÁöÁ¤ÇϽʽÿÀ.

Microsoft´Â "º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿­µÈ Microsoft Á¦Ç°¿¡¼­ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù.

ÀÌ ¹®Á¦´Â Project Server 2003 ¼­ºñ½º ÆÑ 3¿¡¼­ óÀ½ ÇØ°áµÇ¾ú½À´Ï´Ù.

Project Server 2003 SQL Server 2005 µ¥ÀÌÅͺ£À̽º ¼­¹ö·Î »ç¿ëÇÒ ¶§ ¹ß»ýÇÏ´Â ¹®Á¦¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ. SQL Server 2005 Analysis Services DSO °³Ã¼¸¦ ¼³Á¤ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.SQL Server 2005 ¼­ºñ½º ÆÑ 1¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.