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

Differences between version dated 2007-05-03 18:02:42 and 2007-09-07 19:05:17 (spanning 21 versions)
Deletions are marked like this.
Additions are marked like this.

¿ÀÈÄ 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 ====

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

 

 Generate Schema Wizard ½ºÅ°¸¶ »ý¼º ¸¶¹ý»ç
 
business intelligence designers BI µðÀÚÀ̳Ê
 
Analysis Server ºÐ¼® ¼­¹ö
 

context-sensitive »óȲ¿¡ ¸Â´Â

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 ¾Ï½Ã ÂüÁ¶
 

Checking Account
óÀ½ Checking Account¸¦ °³¼³ÇÏ¸é ¹Ù·Î temporary check book(¼öǥå)À» ÁÖ°í ¾ó¸¶ ÈÄ ÀÚ½ÅÀÇ À̸§°ú ÁÖ¼Ò, ÀüÈ­¹øÈ£ µîÀÌ ÀμâµÇ¾î ÀÖ´Â check bookÀÌ ¿ìÆíÀ¸·Î ¹è´ÞµË´Ï´Ù. ±× ´ÙÀ½ºÎÅÍ´Â ¹°°ÇÀ» ±¸ÀÔÇÒ ¶§ check¿¡ ±Ý¾×°ú ÇØ´ç»çÇ×À» ÀÚ½ÅÀÌ Á÷Á¢ ±âÀçÇؼ­ »ç¿ëÇÏ¸é µË´Ï´Ù. ¹Ì±¹Àº ÀüÈ­ »ç¿ë·á, Àü±â »ç¿ë·á, ½Å¹® ´ë±Ý,¹æ¼¼ µî ¿ì¸®°¡ ÀºÇà¿¡¼­ Áö·Î¿ëÁö¸¦ ÀÌ¿ëÇØ ³³ºÎÇÏ´Â °ÍµéÀ» ÀÌ °³ÀÎ checkÀ» ÀÌ¿ëÇؼ­ ¿ìÆíÀ¸·Î ³³ºÎÇÏ´Â °ÍÀÌ ÀϹÝÈ­µÇ¾î ÀÖ½À´Ï´Ù.
|}}

 * 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 µµ±¸ ¸ðÀ½ -> Â÷ÈÄ¿¡ ÀÏ°ýÀûÀ¸·Î ¹ø¿ªÇÒ °Í

 
==== 10 ====
 * action ; ÀÛ¾÷
 * named query ; ¸í¸íµÈ Äõ¸®

 

==== 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 ShowText of this page
EditText of this page
FindPage by browsing, searching, or an index
Or try one of these actions: DeletePage, DeleteUploadedFile, LikePages, SpellCheck, UploadFile