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

Version as of 2007-05-01 19:55:12

Clear message


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 »óȲ¿¡ ¸Â´Â

8

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

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

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

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

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

9

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

10


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