Oracle Olap 11g

!

#

$%

%

&

'

(

)

*

+

,

(

&

,

%

-*.

%

-/

0

$

1

0

2

3

4

&

(

5

+

&

6

$

&

&

#

( +

'

%

&

2

$%

,

&

*

/

+

/

7

%

)

,

,

%

48

-+

$

1

&

7

53

53

%

48

56

+

&

5-9 !

+

51

+

/

7

)

&

63

(

4

$

6

&

65

! * 4 4 : • $% * • $% * • * 4 4 * ; < * $% ! * 9 $% = = = & * / / 8 $% * & * / / = = & * / / * / > ? & * / / ?

" / ! = : • / ( ? & ) @ + $ ( $ 4 4 A • 9 = A • 9 A • 9 = A 9 / A • 9 / A = BC " #$ $ % & ! ' # : • • $% * • % & & $% = 9 = $% 9 = = = $% 8 $% = % & 2 ! ' ( ( )( * + #$ * , - ( . / ( . * - + * . - 0 ( , . . + 0 1

2 $% = = 8 = 8 = ; < = 8 ' 3 4 # 4 8 ( * $% = ? ? = 2 $% ? = 8 $% ? = = * ? = $% ? ? ' & # & ! ' # : • = - ( 0( -#$ )( - 0 ( * + * * / ( / * + )( -/ * 1

5 • 0 • ) • + $% ! $( - 0 / 8 = 0 = = $ 8 = 8 * = *36 . 1 * $( -9 = / = * = 8 ( = / = 8 = = * / = & ; < 8 / ; 8 ! = < 8 # '5D = = ( ( = * / / & = ( / = = ! = 8 * = 8 = 0 8 ;#'_{E <} ( . * / 7 * (// - / / ( 0 *3 )( - 1 !( 00 8 )( - 0 / * -/ * / 7 * . +1

9 ( / * / = / = / = % % 8 = 8 ! = / 8 # '5D & ; / < ! = / 7 * & #(// -? = = 8 = / ? & / 0 / ; $% < * = • = / * = • ) ; < / 8 * ! • + *? 8 ? ; = < • / / ? $% / = ! ? = ( / * ( 0 /( * / * - -/ 7 * 0 , 3 )( * ( / ( 1

: $% * ! " = * / = = * / / ; < * = = * = % $ & 2 % $ & & / * % = E / ( ? / • & ! • / *

• ? • ( / / / = > / * * * * *? & / * * ) * ; $% < 8 8 ( B " * * ? ? ( ! E 8 8 E 8 8 / ! 9 = = ! = = = * = = / = ( = / = = ! ! 3 * ** / * ( -0 - 0 / , - * / - 0 ( * 1

; < * / = = ! / = = * ! ! ! ! " % $ & 2 % $ & F = / / / / - ! 0 '( / = " E

" " 8 0 8 8 ; < = ; < E = 8 $% % '( ) * % % ) ( + % , . / 4 * 0 0 ! ( 0 8 8 8 $% ( 8 $% F ) @G 8 ! 9 $% 8 = ' ( ( / ** * ( , - #$ 3 * . . ( ( 0( -, )( -( * * . ( 1

0 8 F + ( $G2 ! 8 0 8 : ! " !#$ % # # & ' ! " !#$ % # # & #&% ' !( ! " !#$ % # # & 9 = 8 / 9 8 ! ! 8 ! $% ! & )! * ! $* %$ ( ! % #+$% ! # !# !#$ % # # , * ! @ 8 $% 8 )4@ ! ( 8 ! / 8 * * : #- . #%( " )! / +0 ! + 1! ! ,!! 2 2 / 3 /2 . #%( 2 +/2 )! * ! $* ' / ! ,!! 2 2 / 3 /2 ' ' , * / ' / / +0 * . + 0 / + #$ - 0( + )( ; -7 ( 8 0 + / - 8 * . - -1

! 8 74) . 4) )&.C 74) $ H 9 8 ? ( ? $% ; 4& 4 ) 2@ < $% $% #(// - 0 ! ( . !( : 4 . * 0 8 . / = 8 = 48 ! ! 8 = * ? ? & $%

" * 0 8 8 ; 8 < ; < ; < = $% 0 * 8 8 . H9 = $% = = + * ' 4 -: 4 ( = = $% F ! : • " • = $%

2 8

8 $%

$%

! 8 IIIJ&2(4

; 8 2$4)J&2(4 J&2(4 ( J&2(4< $ % < 6 ! ' # < #$ $% = = ? $% = $% E E $% : • ! * / / • ! = !( 3 7 * 4 7 * = + * $( - + & * / / = . . + & * / / * / = ! * / = = / - )( - * * - * . ( / * 0 ( * 0 / * 1 !( 3 7 * / 7 * . + . . ( 7 + (// - * / * * 1 - . - 00 , * . ( * 0 * / 7 * . + + ( 1

5 * / / * / / = : • & • & * • + ? • ; < • 0 * / / / * ? > / = / * / / / * ? / = / / 8 = ; < ( * / / = / & * / / / &(K 8 0 8 / 2@ $J&2(4 &(K2@ $J&2(4 ( * / / / & / / = = $( - 8 / 8 * / / 8 : +4J + ) 2& J +

9 2@ $J0 & ( * / / * / / &(K2@ $J&2(4 / = = : #! !$ / +0 + ' 4 / + 2/ 4 / 3 + 3 4 #%( " 5 ( ' + ' 4 2/ + ' 4 /2 ' + ' /4 2 +" / " ,*! ! ' + 6 " ' + '+ 6 " '+ / + + 6 " + + 1 % / +0 + 4 / + 4 / 3 + 7 / / = = = * / / $% 8 ! #! !$ # !(! * #* $% ! #$ $ 8% #+$% ! &2(4 $& @ &(K2@ $J&2(4 * / / 4 # ! / 9 9 / / / * / /

: !( = + / $% . . + & = = = $% 4 $% * : • & • • . ( & ! ; < : = $% : !( . + ( (* (// , ( * * / ( - #$ * 1

' 0 (! ) $* 9 :;; %$ ) $* 9 :;; $%# (! ) $* 9 :;; $* ! ) $* 9 :;; # !# %( ! % # %( ! $ # %( ! 5 %( ! # !#+ + 1 %( ! # !#+ 55+ + 1 %( ! # !#+ $ 55+ + 1 %( ! # !#+ %( ! # !#+ + + 1 %( ! # !#+ 55+ + + 1 %( ! @ E 888J&2(4J7 49J& 2+@$ 4 E E ! ! : ' 0 (+&! ) $* 9 :;; !)! + (! ) $* 9 <; 1+ !#$ ) $* 9 :;; #* + !#$ ) $* 9 :;; $%# (! + + ) $* 9 :;; $%# (! + !1 + ) $* 9 :;; $%# (! +, !* %#!+ ) $* 9 :;; $%# (! +#* + + ) $* 9 :;; $%# (! +( &! +#!1(! + ) $* 9 :;; $%# (! + $$ % + ) $* 9 :;;

+JG4C ! ; < 474 J@ +4 8 $. J 9 )4. 2$4 )4F @ && 2@ + )G4 J$4F+4@ < 474 J@ +4 / = = $. ) J 4$&) @ @FJ 4$&) @ J +JG4C @ E 888J +4@$ @J7 49J& 2+@$ . 8 : • . • . )4@ ; +JG4C < • . ! ! 5 = ? 5_{$ !} =

: ' 0 (+&! ) $* 9 :;; !)! + (! ) $* 9 <; 1+ !#$ ) $* 9 :;; #* + !#$ ) $* 9 :;; ! ) $* 9 :;; ) $* 9 :;; $%# (! + + ) $* 9 :;; !1 ) $* 9 :;; $%# (! + !1 + ) $* 9 :;; , !* %#! ) $* 9 :;; $%# (! +, !* %#!+ ) $* 9 :;; #* + ) $* 9 :;; $%# (! +#* + + ) $* 9 :;; @ E 888J. 4) )&.CJ7 49J& 2+@$ $( - 8 / = 8 8

; & & < ;2 & <

& 0 & $ $ ( & : • +4J7 49 • +4J& 4@ )J7 49 • +4J0 $& J7 49 • ) 2& J7 49 • ) 2& J ) + )CJ7 49 • &2$ +4)J7 49 • &2$ +4)J$. +4@ $J7 49 • &2$ +4)J$4F+4@ $J7 49 • &. @@4 J7 49 • &. @@4 J ) + )CJ7 49 • 2@ $J&2(4J7 49

= = 8 / 8 : #! !$ ' +/ +=2 + ' 4 2/ +/ + 2/ 4 /2 /2 ' + 3 + /2 ' 4 " 5 ( ' + 4 2/ + 4 /2 ' + /24 / + / 4 2 +/2 + " ,*! ! '+ 0 6 " ' '+ 0 6 " 2/ /2 '+ 0 6 " /2 ' / '+ 0 6 " / + ' 6 >$ ! +-% ! > + ' 6 >$ ##> /2 + ' 6 > !1 > / + ' 6 > >7 = = / 8 : • = $ 4$ • = F) 2 (C • 474 J@ +4 • ? &. @@4 J7 49 2@ $J&2(4J7 49 4 ( = F) 2 (C / 6 _{? &. @@4 J7 49} 2@ $J0 & J7 49 = / = 8 = / * 6_{@ $2+ F) 2 (C} = 4 = F) 2 (C 8

= & 8 $% = $% = : • & = 0 8 • 0 8 . $2+ / $ • & 0 8 ! 9 $2+ ; < F) 2 (C 8 $% & 8 : #! !$ ' +/ +=2 + ' 4 " 4 " +0 +0 4 % " + / ""+0 +0 + 3 4: / +/ 3+0 5 ( ' + 4 2/ + 4 /2 ' + /24 / + / 4 2 +/2 + " ,*! ! '+ 0 6 " ' '+ 0 6 " 2/ /2 '+ 0 6 " /2 ' / '+ 0 6 " / + ' 6 >$ ! +-% ! > + ' 6 > > /2 + ' 6 > > / + ' 6 > > ' +/ +0 + >$ 9;;?>4>$ 9;;@> ! ' 7 ( ( / - . ( * * + ( /( . *1 / -)( - ( 1

" (! # !# # !#+ $ +$*1+ $ 9;;? -: <:<A:<<A ;B <:<A:<<A ;B C A $ 9;;? -9 <B@C9BC: 99 @D;9C;BD 9D ; C $ 9;;? -< <9@:B9CA ?B :;:@C:<9B A@ ; @ $ 9;;? -C <?<C?9CC :; :<@DA@?B: D@ ? : $ 9;;@ -: <@:?CA:A @: <@:?CA:A @: :? 9 $ 9;;@ -9 <@A:?@?B ;D B9DB;CB? B; ? B $ 9;;@ -< <9<:AD<C DC :;?9ADC:; @C < @ $ 9;;@ -C <CACAD:; BC :C;:<A<9: <A 9 <

8 & J&.FJC % & J&.FJC + % & J&.FJC 8 $% ; ? < / = 8 ; < = F " * = = = @ 8 = " = ! *3 >. ( *? / - ( + ( , / ; * * @* 3 * )( -/ * 00 1

2 #! !$ '+ 0 ' 4 " 4 " +0 +0 4 % " + / ""+0 +0 + 3 4 : / +/ 3+0 5 ( ' +/ + 4 2/ + 4 /2 ' + /24 / + / 4 2 +/2 + " ,*! ! '+ 0 6 " ' '+ 0 6 " 2/ /2 '+ 0 6 " /2 ' / '+ 0 6 " / + ' 6 > > /2 + ' 6 > > / + ' 6 > > '+ 0 6 >$ 9;;@> 6 >$ 9;;@> ! ' 7 (! # !# # !#+ $ +$*1+

$ 9;;@ :C;:<ACBA <A :C;:<ACBA <A 9 <

$ 9;;@ -: <@:?CDB? @: <@:?CDB? @: :? 9

$ 9;;@ -9 <@A:?@?B ;D B9DB;@<9 B; ? B

$ 9;;@ -< <9<:AD<C DC :;?9AD?@B @C < @

$ 9;;@ -C <CACAD:; BC :C;:<ACBA <A 9 <

= $

= !

5 = #! !$ ' 4 " 4 " +0 +0 4 % " + / ""+0 +0 + 3 4: / +/ 3+0 5 ( ' +/ + 4 2/ + 4 /2 ' + /24 / + / 4 2 +/2 + " ,*! ! '+ 0 6 " ' '+ 0 6 " 2/ /2 '+ 0 6 " /2 ' / '+ 0 6 " / + ' 6 > > /2 + ' 6 > > / + ' 6 > > ! "# $ %&''( )&$* ! ' 7 8 $% = # < < 4 < < ! ' # $% 8 * 0 = 9 ! + $ 9 ! + /

9 - A ; 4 9 ! + ! 2 9 ! + ! 9 ! + 9 ! + : • ; < • + ; ! < • • * • $ : • ( = ; < • 9 8 ? • ( ! / • • ) 8 ( = • ) 9 ! + !( - * ( -A ; 4 * . / ( / 7 * . + 0 - /1 ' 0 * -3 3* - */ 0 * / . . ; + / 7 * . + * 0 / ( 1

: ' % % - & & % * . , 4 7 * = + 0 0 !( ! ! 9 ! + / ! / / / ( * / / / (+$J+7 49 )40)4$. (+$J+7 49 )40)4$. ! / ! / * / ! 8 E ! ? / ! * * ! / * / / @ & ++ @ 4+ @ ! / & + 4 4 0 $ 0 )&4 0 8 2@ $J&2(4: ' +' " >$ 8% #+$% !>4>5> 7 0 $ / - A ; 4 * * 0 0 ( 1 * . , * */ * 0 ( + ( + 0 * -A ; 4 . - 1

* & + 4 4 D _{? !} / 0 )&4 ! / 0 $ & + 4 4 0 $ 0 $ * & + 4 4 6 ' & # & 4' # : $% $% / / + / ! ; / < $% = / : • = • & ! @ = • • $% F) @ )47 G4 7 D_{& * /} * 0( - / ** * ( , ( ( * - / 1 7 / , + ; . / 1

* 48 $ ! • ) & F & E E ! . ! * * ! ! # / = 2 * / / = $% $ $% / ! / !

B( - ::2 ( '(* * ! A * 6 *)( :: ;+ -*+ * # , ! 9 :" 1#1 1 A *+ * )( C 1" :1 :"12::: & 8 C 1" :1 :"12 :: 1 / ! - D ::2, 1 . *1 * (/ . * * 0 0 / ( - * 0 ( E + ( 1 * (/ + * 30 , ( E -+ * , + 8 * - / * +, (* / * + * * 0 / -0 0 ( ( 1 A 0 - * / -- + * (/ * ( 0 / * * - * - - * (/ 1 * (/ / - *( * / * - 0 / - - / , / , 0 - ( , + ( ( + / 1 * * / ; 0 ! *@ 00 1 / / - * / ; 0 . + 1