ssas | UserPreferences |
group ; ±×·ìÈ
Natural Hierachy ÀÚ¿¬ °èÃþ
Alternative Dimension Table ´ëü Â÷¿ø Å×À̺í
metric system µµ·®Çü
aggregate table ; Áý°è Å×À̺í
p.20 Sales cube¸¦ ¹®¸Æ ¶§¹®¿¡ '¸ÅÃâ °ü¸® Å¥ºê'¶ó°í ¹ø¿ª
sql ; ±¸Á¶Àû ÁúÀÇ ¾ð¾î
query´Â ¹®¸Æ¿¡ µû¶ó¼ query ±¸¹® ÀÚü¸¦ ÀǹÌÇÒ ¶§´Â 'ÁúÀÇ', µ¥ÀÌÅͺ£À̽ºÀÇ µ¥ÀÌÅ͸¦ °¡Á®¿À´Â ÇàÀ§¸¦ ÀǹÌÇÒ ¶§´Â 'Á¶È¸'¶ó°í ¹ø¿ª
¿ÀŸ p.21 dause -> clause
again, making the metadata match the logic of the data. ÀÌ·± ·ÎÁ÷µµ ¸ÞŸµ¥ÀÌÅÍ¿¡ ÀúÀåµÈ´Ù.¶ó°í ¹ø¿ª. '¹Ý¿µµÈ´Ù'¶ó´Â Ç¥ÇöÀ» ¾²°í ½ÍÁö¸¸ ¹®¸ÆÀÌ ¾î»öÇÔ.
´ÙÁß ¼öÁØ °èÃþ(Multilevel Hierarchy)
½ÇÁ¦ Analysis Services¿¡¼´Â ¡®Perspective¡¯¶ó´Â °³Ã¼¿¡ ´ëÇØ ¡®Å¥ºê ºä¡¯¶ó´Â ¿ë¾î¸¦ »ç¿ëÇÏ°í ÀÖÁö¸¸, ¹®¸Æ¿¡¼ ÇϳªÀÇ Å¥ºê¸¦ ¹Ù¶óº¼ ¼ö ÀÖ´Â ¿©·¯ °üÁ¡À̶ó´Â Àǹ̸¦ °®°í ÀÖÀ¸¹Ç·Î ¡®°üÁ¡¡¯À¸·Î ¹ø¿ªÇÏ¿´´Ù.
p.38
finace ȸ°è, ȤÀº À繫·Î ¹ø¿ª
Analysis Server ºÐ¼® ¼¹ö
context-sensitive »óȲ¿¡ ¸Â´Â
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 ½Ã°£ Å×ÀÌºí ¿ 1
transaction database ; Æ®·£Àè¼Ç µ¥ÀÌÅͺ£À̽º or ¾÷¹« µ¥ÀÌÅͺ£À̽º
groupable ±×·ìÈÇÒ ¼ö ÀÖÀ½
non-groupable ºñ±×·ìÈ ÇÒ ¼ö ÀÖÀ½?ÀÖÀ½?
customer °í°´
production ¿î¿µ°è 2
criteria ¿µ¿ª
Retained Earnings Since Inception »ç³»À¯º¸±Ý
metadata ; ¸ÞŸµ¥ÀÌÅÍ
detailed value »ó¼¼ µ¥ÀÌÅÍ (»ó¼¼°ªÀ̶ó´Â ¹ø¿ªÀº ´ÜÀÏÇÑ °ªÀÇ ´µ¾Ó½º°¡ ÀÖÀ½) 3
Generate Schema Wizard ½ºÅ°¸¶ »ý¼º ¸¶¹ý»ç
business intelligence designers BI µðÀÚÀ̳Ê
4
Add/ Remove Tables Å×À̺í Ãß°¡/Á¦°Å
½ÇÁ¦ Ã¥ 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À» ÀÌ¿ëÇؼ ¿ìÆíÀ¸·Î ³³ºÎÇÏ´Â °ÍÀÌ ÀϹÝȵǾî ÀÖ½À´Ï´Ù. |
pivot currency Çǹþ ÅëÈ
international regulatory ±¹Á¦ ±ÔÁ¦
toolbar µµ±¸ ¸ðÀ½ -> Â÷ÈÄ¿¡ ÀÏ°ýÀûÀ¸·Î ¹ø¿ªÇÒ °Í
p.257
p.262
p.266
p.307
p.308
p.317
p.324
p.330
p.333
p.335
p.336
Drop outdated cache ¿À·¡µÈ ij½Ã »èÁ¦
Low-Latency MOLAP ªÀº ´ë±â ½Ã°£ MOLAP
p.337
Client Initiated Ŭ¶óÀ̾ðÆ® ½ÃÀÛ
p.349
p.354.
p.369
p.370
p.375
p.380 10
11
standard action
Ç¥ÁØ ÀÛ¾÷
action target
ÀÛ¾÷ ´ë»ó
parameter ¸Å°³ º¯¼ö
MDX Builder MDX ÀÛ¼º±â 12
p.306
Restrict access to a dimension of a cube
½ÇÁ¦ ÀÖ´Â ±â´ÉÀΰ¡?
proactive cache ÀÚµ¿ °ü¸® ij½Ã
storage mode ÀúÀå¼Ò ¸ðµå
Hybrid OLAP ÇÏÀ̺긮µå OLAP
Double-count Áߺ¹ °ª
Missing value ¼Õ½ÇµÈ °ª
http://www.microsoft.com/korea/events/ready2005/sql_detail_teck_2.asp
Show Empty Cells ºó ¼¿ Ç¥½Ã
¿ÀŸ ; 1 °úÁ¤¿¡ Å¥ºê°¡ ºüÁ³À½
proactive cacheÀÇ latency ´ë±â ½Ã°£
silence override interval ´ë±â ´ëü °£°Ý
Medium-Latency MOLAP º¸Åë ´ë±â ½Ã°£ MOLAP
Update the cache when data changes µ¥ÀÌÅÍ°¡ º¯°æµÇ¸é ij½Ã ¾÷µ¥ÀÌÆ®
Update the cache periodcally ÁÖ±âÀûÀ¸·Î ij½Ã ¾÷µ¥ÀÌÆ®
Rebuild interval ´Ù½Ã ÀÛ¼º °£°Ý
Bring online immediately Áï½Ã ¿Â¶óÀÎ »óÅ·Π¸¸µé±â
ÀÚµ¿ ij½Ã °ü¸®ÀÇ ¾Ë¸² ±â´É¿¡ »ç¿ëµÇ´Â ÃßÀû(monitor) ±â´É ; ÇѱÛÆÇ¿¡¼ÀÇ ¿ë¾î ¶§¹®¿¡ ÃßÀûÀ¸·Î ¹ø¿ªÇÔ 13
p.348
Build ºôµå ; Á÷Á¢ ºôµå ÀÛ¾÷À» ÁöĪÇÒ ¶§¿¡´Â ºôµå, °³³äÀûÀÏ °æ¿ì¿¡´Â ÀÛ¼º, ±¸Ãà µî ±×¶§±×¶§ Àû´çÇÑ ¿ë¾î »ç¿ë
Open Width -> Open With
Show all files ¸ðµç ÆÄÀÏ Ç¥½Ã
Credential ÀÚ°ÝÁõ¸í
General-purpose ¹ü¿ë
toolbox µµ±¸ »óÀÚ
Control Flow Á¦¾î È帧
Workspace ÀÛ¾÷ °ø°£
Recovery º¹±¸
Restore º¹¿ø
ÆÐÅ°Áö »èÁ¦½Ã delete¸¦ Ŭ¸¯Ç϶ó´Â ¹®±¸°¡ ºüÁ®ÀÖÀ½
EditText
of this page
(last modified 2007-07-19 13:23:12)
FindPage
by browsing, searching, or an index
Or try one of these actions:
DeletePage,
DeleteUploadedFile,
LikePages,
SpellCheck,
UploadFile