Docstoc

IR_Dashboard

Document Sample
IR_Dashboard Powered By Docstoc
					BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   1
        !                                                                  "                         #
    "                    !                                                                 $ #
                                                     $                                 !

        %& '                                                  (
        )& "                                 $               (
        *&
        +& "                 "           ,           -,                    ,       .
        /&           (
        0& " $                                           1 &
        2& "                 $                             "
        3&
        4&                                       "
        %5&                                          "

                                                                                                 6                           7
                                                         8        6                                                  $
                                                                                                                                     $   $
            $                                                     8
                                     9                                         $                                 :
                         7                               8                                               ;               $
                 <                                                6                        6     $           $




6                                                                      (                             8
                                 7                   #                9            7
$                            $



                 BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports                                     2
                                                             7           $
                                       8        =                                %)5
                     9         9           9          9      9               $
                         (
$               $

    >                              $                             <?                     $"
        $   8




                BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   3
                                            $        $                           $
%&
)&
*& <
+&
/& 8       "
0& ,   7
               $                       1>       @        & 8                         $ 7
  <




  >    1< A&




               BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   4
8                  $       #          @



                                                       $
    !                  !
        "
                           "                                       $   9              $
                                      8         $                               =
                           @                               $   B                          B
                           <"
                                            $                               $                 C
                       !
               "




        BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   5
  To bring the data from the data source to the
report the first step is always to connect to the
data source. IN Hyperion IR we create OCE file
which is connection file. The OCE file store the
connection related all the information. However,
the OCE does not store the password.




    The filter request line is same
    as “where” clause in SQL
    Query




                                                                  The Request request line is
                          The Request request line is             same as “Select column” in
                          same as “Order by” in SQL               SQL Query
                          Query




           8     6
                                                    7                                               >
       6                                                                                $
      "
                                      8                       6

           $

                 6                        ,         "   ,                          6


                BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports     6
8           $       $
,       "           ,

                (
                    A                           (
                            @                           $
                                        9
    7                   (
            (
    9
        <                                   (
                9

:               (                   $       =               $
                                ,               "   ,




                BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   7
:       !                                               6          !
-   ,        8     .
"   ,                  ,   8




            BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   8
D@                                E                            $           F   @ 8
          $                                        7                            :
         6                                    8                                  ;
                                          9                            $                 $


             D@                   @               E D@                          E        D@
              E




<                             ,               8                    9                              (   $   $   $$
7    $                                    >                !                    (             "
                  7




<        (                            9                6                             (                8            $
(

                      BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports             9
                            (       $           *   ;
    %& @
    )& @
    *& @       @




#                                           $                                        $
                                "

'
    #                                           $                                7       $
                        (               <
                                (                                         =




           BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   10
, 7                      $       $                           1 &       G   H   6
                                         9                         =    $$
           $                 *

  !


      "
       :   "




       BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   11
$                 9
                                          8                             7                  9
        $

    $        @"                7 7




             $                   !    7                       "             I




            BISP | Building Sales Analysis Dashboard Using Hyperion Interactive Reports   12