ssas UserPreferences
 
Help Info Print View Search Diffs Edit
 À妽º   Ã£±â   Freeboard   Subjectless   Images   ÃÖ±Ù±Û 

¿ÀÈÄ 7:03 2007-09-07 Àû¿ë»çÇ×
°´Ã¼ -> °³Ã¼ éÅÍ -> Àå ½Ç½Ã°£ ºÐ¼® ó¸®! Âü°í·Î ¹æ±Ý Àü ³ðÀº... 55ÆäÀÌÁö 18¹ø ·¦ ¼³¸í ºÎºÐ ¹Ø¿¡ ¼³¸í.... ÅõÇà -> Æ©Çà < ¼ýÀÚ°ª -> ºÐÀÚ ³ª´©´Â °ª -> ºÐ¸ð ´ÙÂ÷¿ø Ç¥Çö½Ä -> ´ÙÂ÷¿ø ½Ä °è»êµÈ ¸â¹ö -> °è»ê ¸â¹ö °è»êµÈ ÃøÁ¤°ª -> °è»ê ÃøÁ¤°ª calculated measure ¾îÇø®ÄÉÀÌ¼Ç or ÀÀ¿ëÇÁ·Î±×·¥ Action -> ÀÛ¾÷, µ¿ÀÛ (9Àå) 9Àå ÄÚ¸àÆ® ; job, task, actionÀ» ´Ù ÀÛ¾÷À¸·Î ¹ø¿ªÇؼ­ ¹®Á¦ Çà Ãà -> Çà Çʵå (row axis in grid) ¸í·É°ú ¿É¼Ç -> ¸í·É ¹× ¿É¼Ç ; Çü½Ä ÅÇ -> ¼­½Ä ÅÇ Å×À̺í Ãß°¡/Á¦°Å -> Å×À̺í Ãß°¡/»èÁ¦

6Àå »ç¿ëÀÚ ·Ñ¾÷ ¿¬»êÀÚ(Custom rollup operators) -> »ç¿ëÀÚ ÁöÁ¤ ·Ñ¾÷ ¿¬»ê related measure group ¿¬°áµÈ ÃøÁ¤°ª ±×·ì p.142 ÇÏ´Ü ºÎºÐ ; you must subtract the Taxes Total value from the sum of Operating Profit Total and Taxes Total; µÚÀÇ taxes total -> Other Income and Expense Explore Data µ¥ÀÌÅÍ Å½»ö p.152 ÇÏ´Ü In this procedure, you¡¯ll change the AggregateFunction? property of the Account measure to LastNonEmpty? to observe the aggregation behavior ; Account measure -> Account dimension Äĸ¶ -> ÄÞ¸¶ Query Log Äõ¸® ·Î±× ¿ªÇÒ±â¹Ý Â÷¿ø -> ·ÑÇ÷¹À× Â÷¿ø °èÁ¤Â÷Æ® -> °èÁ¤°ú¸ñÇ¥(chart of account)

os ȯ°æ¿¡¼­ windows 2003ÀÓÀ» ¸í½ÃÇÒ °Í ; chapter 11 º¸¾È °ü·Ã¿¡¼­ windows 2003ÀÓÀ» ¸í½ÃÇÏ°í ÀÖÀ½

1

transaction database ; Æ®·£Àè¼Ç µ¥ÀÌÅͺ£À̽º or ¾÷¹« µ¥ÀÌÅͺ£À̽º

group ; ±×·ìÈ­ groupable ±×·ìÈ­ÇÒ ¼ö ÀÖÀ½ non-groupable ºñ±×·ìÈ­ ÇÒ ¼ö ÀÖÀ½?ÀÖÀ½?

Natural Hierachy ÀÚ¿¬ °èÃþ customer °í°´ production ¿î¿µ°è

Alternative Dimension Table ´ëü Â÷¿ø Å×À̺í

2

criteria ¿µ¿ª

metric system µµ·®Çü

aggregate table ; Áý°è Å×À̺í Retained Earnings Since Inception »ç³»À¯º¸±Ý

p.20 Sales cube¸¦ ¹®¸Æ ¶§¹®¿¡ '¸ÅÃâ °ü¸® Å¥ºê'¶ó°í ¹ø¿ª

sql ; ±¸Á¶Àû ÁúÀÇ ¾ð¾î metadata ; ¸ÞŸµ¥ÀÌÅÍ

query´Â ¹®¸Æ¿¡ µû¶ó¼­ query ±¸¹® ÀÚü¸¦ ÀǹÌÇÒ ¶§´Â 'ÁúÀÇ', µ¥ÀÌÅͺ£À̽ºÀÇ µ¥ÀÌÅ͸¦ °¡Á®¿À´Â ÇàÀ§¸¦ ÀǹÌÇÒ ¶§´Â 'Á¶È¸'¶ó°í ¹ø¿ª

¿ÀŸ p.21 dause -> clause

again, making the metadata match the logic of the data. ÀÌ·± ·ÎÁ÷µµ ¸ÞŸµ¥ÀÌÅÍ¿¡ ÀúÀåµÈ´Ù.¶ó°í ¹ø¿ª. '¹Ý¿µµÈ´Ù'¶ó´Â Ç¥ÇöÀ» ¾²°í ½ÍÁö¸¸ ¹®¸ÆÀÌ ¾î»öÇÔ.

´ÙÁß ¼öÁØ °èÃþ(Multilevel Hierarchy)

½ÇÁ¦ Analysis Services¿¡¼­´Â ¡®Perspective¡¯¶ó´Â °³Ã¼¿¡ ´ëÇØ ¡®Å¥ºê ºä¡¯¶ó´Â ¿ë¾î¸¦ »ç¿ëÇÏ°í ÀÖÁö¸¸, ¹®¸Æ¿¡¼­ ÇϳªÀÇ Å¥ºê¸¦ ¹Ù¶óº¼ ¼ö ÀÖ´Â ¿©·¯ °üÁ¡À̶ó´Â Àǹ̸¦ °®°í ÀÖÀ¸¹Ç·Î ¡®°üÁ¡¡¯À¸·Î ¹ø¿ªÇÏ¿´´Ù.

p.38 detailed value »ó¼¼ µ¥ÀÌÅÍ (»ó¼¼°ªÀ̶ó´Â ¹ø¿ªÀº ´ÜÀÏÇÑ °ªÀÇ ´µ¾Ó½º°¡ ÀÖÀ½)

finace ȸ°è, ȤÀº À繫·Î ¹ø¿ª

3

business intelligence designers BI µðÀÚÀ̳Ê

Analysis Server ºÐ¼® ¼­¹ö

context-sensitive ¹®¸Æ°¨Áö (»óȲ¿¡ ¸Â´Â)

Script Organizer ½ºÅ©¸³Æ® ±¸¼º µµ¿ì¹Ì

Å° Ư¼º(Key Attribute)

ȸ°è ´Þ·Â(Fiscal Calendar)

4

Add/ Remove Tables Å×À̺í Ãß°¡/Á¦°Å

analysis Server ºÐ¼® ¼­¹ö

Auto Build ÀÚµ¿ »ý¼º

Available Objects »ç¿ë °¡´ÉÇÑ °³Ã¼

Column ¿­

Column Containing The Member Name ¸â¹ö À̸§À» Æ÷ÇÔÇÏ´Â ¿­

DataItem? Collection Editor DataItem? Ä÷º¼Ç ÆíÁý±â

Define Time Periods ±â°£ Á¤ÀÇ

Deployment Progress ¹èÆ÷ ÁøÇà·ü

Included Objects Æ÷ÇÔµÈ °³Ã¼

Main Table ÁÖ Å×À̺í

Parent-child Relationship ºÎ¸ð ÀÚ½Ä °ü°è Á¤ÀÇ

Reconnect ´Ù½Ã ¿¬°á

Select Dimension Attributes Â÷¿ø Ư¼º ¼±ÅÃ

Select Related Tables °ü·ÃµÈ Å×ÀÌºí ¼±ÅÃ

Select the Dimension Type Â÷¿ø À¯Çü ¼±ÅÃ

Server Time Dimension ¼­¹ö ½Ã°£ Â÷¿ø

Specify Dimension Type Â÷¿ø À¯Çü ÁöÁ¤

The Select The Dimension Type Â÷¿ø À¯Çü ¼±ÅÃ

Time Dimension ½Ã°£ Â÷¿ø

Time Table Columns ½Ã°£ Å×ÀÌºí ¿­

Production Database ¿î¿µ µ¥ÀÌÅͺ£À̽º ºñÁ¤Çü °èÃþ(Ragged hierarchy)

7

Estimated Count ¿¹»ó °³¼ö Partition Count ÆÄƼ¼Ç ¼ö Performance Gain Reaches ´ÙÀ½ ¼º´É Çâ»ó Á¤µµ±îÁö Estimated Storage Reaches ´ÙÀ½ ¿¹»ó ÀúÀå¼Ò Å©±â±îÁö Deploy And Process Now Áö±Ý ¹èÆ÷ ¹× ó¸®

Specify Object Counts °³Ã¼ ¼ö ÁöÁ¤ Usage-Based Optimization »ç¿ë ºóµµ ±â¹Ý ÃÖÀûÈ­

8

Format String Çü½Ä ¹®ÀÚ¿­ Non-empty behavior ºñ¾î ÀÖÁö ¾ÊÀº µ¿ÀÛ

¿ø¹® p187 MDX¹® Ʋ¸²

iif(IsEmpty(([Measures].[Reseller Sales Amount],[Product].[Product 
Category].Parent)),1,([Measures].[Reseller Sales Amount])/([Measures].[Reseller Sales 
Amount],[Product].[Product Category].Parent) 
Á¦ÀÏ µÚ¿¡ ')'°¡ ºüÁ³À½

¿ø¹® p197 $B$7 -> $B$6 ¿ÀŸ implicit reference ¾Ï½Ã ÂüÁ¶

½ÇÁ¦ Ã¥ 192ÆäÀÌÁö¿¡¼­ {(Measures?.Reseller Sales Amount?), ( ] ([Measures?.Reseller Order Quantity?)} ¾î¶»°Ô ±â¼úµÇ¾î ÀÖ´ÂÁö È®ÀÎÇÒ °Í

Calculation Tools pane °è»ê µµ±¸ ¿µ¿ª Functions tab ÇÔ¼ö ÅÇ box »óÀÚ

Clear Results °á°ú Áö¿ì±â

½ÇÁ¦ Ã¥ 202ÆäÀÌÁö : 13 .. (2002 is comment parent -> common)

subcube ÇÏÀ§Å¥ºê

9

2ÀÎ ¶Ç´Â 2ÀÎ ÀÌ»óÀÇ ¿¹±ÝÁÖ ¸íÀÇ·Î °³¼³µÈ ±¸Á¸¦ °øµ¿ ±¸ÁÂ(Joint Account)¶ó°í ÇÏ¸ç ´ºÁú·£µå¿¡¼­´Â °¡·É ºÎºÎ°¡ °øµ¿±¸Á¸¦ °®°í ÀÖ´Â °æ¿ì ¹è¿ìÀÚ°¡ ¿©Çà µîÀÇ »çÀ¯·Î ºÎÀçÁßÀÏ °æ¿ì ´Ù¸¥ ¹è¿ìÀÚ°¡ ±× ±¸ÁÂÀÇ ±Ç¸®¸¦ ´ëÇà ÇÒ ¼ö ÀÖ´Ù. - °èÁÂÀÇ Æ¯Â¡ ¹Ì±¹¿¡¼­ ±âº»ÀûÀ¸·Î ¸¹ÀÌ ÀÌ¿ëÇÏ´Â °èÁ´ Checking Account ¿Í Savings Account Àε¥, ÀüÀÚ´Â °³ÀÎ ¼öÇ¥¸¦ ¹ßÇàÇÒ ¼ö ÀÖ´Â ´çÁ°èÁ¸¦ ¸»Çϸç ÈÄÀÚ´Â ¸» ±×´ë·Î µ·À» ÀúÃàÇØ ³õ´Â ¿ëµµ·Î »ç¿ëµÇ´Â °èÁÂÀÔ´Ï´Ù. ¹Ì±¹ ³»¿¡¼­´Â Çö±Ýº¸´Ù´Â ½Å¿ëÄ«µå³ª °³ÀμöÇ¥¸¦ »ç¿ëÇÏ´Â °ÍÀÌ º¸ÆíÀûÀ̹ǷΠ°³ÀÎ ¼öÇ¥¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â Checking Account °èÁ¸¦ °³¼³ÇÏ´Â °ÍÀÌ Æí¸®ÇÕ´Ï´Ù. ¹Ì±¹ÀÇ ÀºÇàÀº ¿ì¸® ³ª¶óó·³ ÅëÀåÀÌ ¾ø°í, ´ë½Å ¸Å¿ù ¶Ç´Â ¾àÁ¤µÈ ±â°£¸¶´Ù ÀÔÃâ±Ý ³»¿ªÀ» ±â·ÏÇÑ º¸°í¼­, Áï Bank Statement¸¦ º¸³» ÁÝ´Ï´Ù. Checking Account óÀ½ Checking Account¸¦ °³¼³ÇÏ¸é ¹Ù·Î temporary check book(¼öǥå)À» ÁÖ°í ¾ó¸¶ ÈÄ ÀÚ½ÅÀÇ À̸§°ú ÁÖ¼Ò, ÀüÈ­¹øÈ£ µîÀÌ ÀμâµÇ¾î ÀÖ´Â check bookÀÌ ¿ìÆíÀ¸·Î ¹è´ÞµË´Ï´Ù. ±× ´ÙÀ½ºÎÅÍ´Â ¹°°ÇÀ» ±¸ÀÔÇÒ ¶§ check¿¡ ±Ý¾×°ú ÇØ´ç»çÇ×À» ÀÚ½ÅÀÌ Á÷Á¢ ±âÀçÇؼ­ »ç¿ëÇÏ¸é µË´Ï´Ù. ¹Ì±¹Àº ÀüÈ­ »ç¿ë·á, Àü±â »ç¿ë·á, ½Å¹® ´ë±Ý,¹æ¼¼ µî ¿ì¸®°¡ ÀºÇà¿¡¼­ Áö·Î¿ëÁö¸¦ ÀÌ¿ëÇØ ³³ºÎÇÏ´Â °ÍµéÀ» ÀÌ °³ÀÎ checkÀ» ÀÌ¿ëÇؼ­ ¿ìÆíÀ¸·Î ³³ºÎÇÏ´Â °ÍÀÌ ÀϹÝÈ­µÇ¾î ÀÖ½À´Ï´Ù.
relationship type °ü°è À¯Çü Intermediate Measure Group Áß°£ ÃøÁ¤°ª ±×·ì Currency Conversions ÅëÈ­ º¯È¯ salaries ±Þ¿©

pivot currency Çǹþ ÅëÈ­ international regulatory ±¹Á¦ ±ÔÁ¦

toolbar µµ±¸ ¸ðÀ½ -> Â÷ÈÄ¿¡ ÀÏ°ýÀûÀ¸·Î ¹ø¿ªÇÒ °Í

10

11

p.257 standard action Ç¥ÁØ ÀÛ¾÷ action target ÀÛ¾÷ ´ë»ó

p.262 parameter ¸Å°³ º¯¼ö MDX Builder MDX ÀÛ¼º±â

p.266

12

p.306 Restrict access to a dimension of a cube ½ÇÁ¦ ÀÖ´Â ±â´ÉÀΰ¡?

p.307 proactive cache ÀÚµ¿ °ü¸® ij½Ã storage mode ÀúÀå¼Ò ¸ðµå Hybrid OLAP ÇÏÀ̺긮µå OLAP

p.308 Double-count Áߺ¹ °ª

p.317 Missing value ¼Õ½ÇµÈ °ª http://www.microsoft.com/korea/events/ready2005/sql_detail_teck_2.asp

p.324 Show Empty Cells ºó ¼¿ Ç¥½Ã

p.330 ¿ÀŸ ; 1 °úÁ¤¿¡ Å¥ºê°¡ ºüÁ³À½

p.333 proactive cacheÀÇ latency ´ë±â ½Ã°£

p.335 silence override interval ´ë±â ´ëü °£°Ý

p.336 Medium-Latency MOLAP º¸Åë ´ë±â ½Ã°£ MOLAP

Drop outdated cache ¿À·¡µÈ ij½Ã »èÁ¦ Update the cache when data changes µ¥ÀÌÅÍ°¡ º¯°æµÇ¸é ij½Ã ¾÷µ¥ÀÌÆ® Update the cache periodcally ÁÖ±âÀûÀ¸·Î ij½Ã ¾÷µ¥ÀÌÆ® Rebuild interval ´Ù½Ã ÀÛ¼º °£°Ý Bring online immediately Áï½Ã ¿Â¶óÀÎ »óÅ·Π¸¸µé±â

Low-Latency MOLAP ªÀº ´ë±â ½Ã°£ MOLAP

p.337 ÀÚµ¿ ij½Ã °ü¸®ÀÇ ¾Ë¸² ±â´É¿¡ »ç¿ëµÇ´Â ÃßÀû(monitor) ±â´É ; ÇѱÛÆÇ¿¡¼­ÀÇ ¿ë¾î ¶§¹®¿¡ ÃßÀûÀ¸·Î ¹ø¿ªÇÔ

Client Initiated Ŭ¶óÀ̾ðÆ® ½ÃÀÛ

13

p.348 Build ºôµå ; Á÷Á¢ ºôµå ÀÛ¾÷À» ÁöĪÇÒ ¶§¿¡´Â ºôµå, °³³äÀûÀÏ °æ¿ì¿¡´Â ÀÛ¼º, ±¸Ãà µî ±×¶§±×¶§ Àû´çÇÑ ¿ë¾î »ç¿ë

p.349 Open Width -> Open With Show all files ¸ðµç ÆÄÀÏ Ç¥½Ã

p.354. Credential ÀÚ°ÝÁõ¸í

p.369 General-purpose ¹ü¿ë

p.370 toolbox µµ±¸ »óÀÚ Control Flow Á¦¾î È帧 Workspace ÀÛ¾÷ °ø°£

p.375 Recovery º¹±¸ Restore º¹¿ø

p.380 ÆÐÅ°Áö »èÁ¦½Ã delete¸¦ Ŭ¸¯Ç϶ó´Â ¹®±¸°¡ ºüÁ®ÀÖÀ½


PythonPowered EditText of this page (last modified 2007-09-07 19:05:17)
FindPage by browsing, searching, or an index
Or try one of these actions: DeletePage, DeleteUploadedFile, LikePages, SpellCheck, UploadFile