Diff for "ssas" | UserPreferences |
¿ÀÈÄ 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)
|}}
group ; ±×·ìÈ
groupable ±×·ìÈÇÒ ¼ö ÀÖÀ½
non-groupable ºñ±×·ìÈ ÇÒ ¼ö ÀÖÀ½?ÀÖÀ½?
Natural Hierachy ÀÚ¿¬ °èÃþ
customer °í°´
production ¿î¿µ°è
Alternative Dimension Table ´ëü Â÷¿ø Å×À̺í
criteria ¿µ¿ª
metric system µµ·®Çü
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 ====
Generate Schema Wizard ½ºÅ°¸¶ »ý¼º ¸¶¹ý»ç
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 ÇÏÀ§Å¥ºê
* p.222 degenerate dimension [http://download.microsoft.com/download/c/4/0/c40eec0a-c937-448d-a430-9643824fa713/Solving_Business_Problems_SQLServer2005_Analysis.doc SQL Server 2005 Analysis Services¸¦ ÅëÇÑ ºñÁî´Ï½º ¹®Á¦ ÇØ°á]
* p.222 degenerate dimension Å𺸠Â÷¿ø [http://download.microsoft.com/download/c/4/0/c40eec0a-c937-448d-a430-9643824fa713/Solving_Business_Problems_SQLServer2005_Analysis.doc SQL Server 2005 Analysis Services¸¦ ÅëÇÑ ºñÁî´Ï½º ¹®Á¦ ÇØ°á]
relationship type °ü°è À¯Çü
Intermediate Measure Group Áß°£ ÃøÁ¤°ª ±×·ì
Currency Conversions ÅëÈ º¯È¯
salaries ±Þ¿©
pivot currency Çǹþ ÅëÈ
international regulatory ±¹Á¦ ±ÔÁ¦
toolbar µµ±¸ ¸ðÀ½ -> Â÷ÈÄ¿¡ ÀÏ°ýÀûÀ¸·Î ¹ø¿ªÇÒ °Í
==== 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¸¦ Ŭ¸¯Ç϶ó´Â ¹®±¸°¡ ºüÁ®ÀÖÀ½