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)
|}}
Production Database ¿î¿µ µ¥ÀÌÅͺ£À̽º
ºñÁ¤Çü °èÃþ(Ragged hierarchy)
¿ø¹® 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)
}}}
Á¦ÀÏ µÚ¿¡ ')'°¡ ºüÁ³À½