Docstoc

Business Objects Designer -IGROW

Document Sample
Business Objects Designer -IGROW Powered By Docstoc
					         1
 © Copyright Polaris
Software Lab Limited,
       2007
                        What is a Universe
                        •A universe is a semantic layer that maps the
                        data structure found in databases (tables,
                        columns, etc) in business terms.
                        •A universe can represent any specific
                        business area, process, or department. For
                        example, a universe can relate to a
                        department in a company such as marketing
                        or accounting.




         2
 © Copyright Polaris
Software Lab Limited,
       2007
                        Business Objects Designer




         3
 © Copyright Polaris
Software Lab Limited,
       2007
                        A typical universe layout...



Objects

Classes




      Universe Pane
                                       Structure Pane
         4
 © Copyright Polaris
Software Lab Limited,
       2007
                              Class
                           A class is a logical grouping of objects within a
                            universe. In general, the name of a class reflects a
                            business concept that conveys the category or
                            type of objects.

                           A class can be further divided into subclasses.

                           As a designer, you are free to define hierarchies of
                            classes and subclasses into a model that best
                            reflects the business concepts of your company.


         5
 © Copyright Polaris
Software Lab Limited,
       2007
                         Objects
                    An object is the most refined component in a
                    universe. It maps to data or a derivation of data in the
                    database.
                    Types of objects -
                       Dimension Objects
                          • Focus of analysis in a query.
                          • Maps to one or more columns in a database
                          that are key to a query.




         6
 © Copyright Polaris
Software Lab Limited,
       2007
                           Measure Objects
                        Aggregate functions that map to statistics in a
                        database.
                        •Map to “fact attributes” of a star schema.
                           Detail Objects
                              •Descriptive data about the dimensions.
                              •Always attached to a dimension.




         7
 © Copyright Polaris
Software Lab Limited,
       2007
                        Five stages in universe development process

                          User Requirements
                             •Detailed analysis of the information needs of
                             the users.
                          Data Analysis
                             •Detailed data analysis of the database
                             breaking it down into functional areas that
                             users can relate to.
                          Design
                             •Information from first 2 phases must be
                             amalgamated to create the conceptual design
                             of the Universe, its objects and other
         8                   components.
 © Copyright Polaris
Software Lab Limited,
       2007
                        Development and distribution
                        •Create using the Designer module.
                           •Test using the User module.
                           •Distribute to the users via the repository.

                        Maintenance
                           •Designer is responsible for updating and
                           maintaining Universe and keeping it up to date
                           with any changes in the User Requirements.



         9
 © Copyright Polaris
Software Lab Limited,
       2007
                           Creation of the Universe


              Define the Parameters
                                                  Resolve the Loops

                        Insert Tables

                                              Create Classes and Objects

                        Make the Joins

                                                 Set up Hierarchies



         10
 © Copyright Polaris
Software Lab Limited,
       2007
                         Creating a Universe

                        To begin creating a new universe:
                                  Select File, New

                        To access the Universe Parameters dialog
                        box for an existing universe:

                        Select File, Parameters
                         or
                         Click on

         11
 © Copyright Polaris
Software Lab Limited,
       2007
                            Setting up Parameters

                            A universe is
                            identified with a user
                            name and a
                            connection to the
                            database
                           A detailed description
                            can also be added




         12
 © Copyright Polaris
Software Lab Limited,
       2007
                        What Is a Connection?
                            Definition:
                             A connection   is a link from the universe to
                              the target database.
                             The link is achieved using middleware (for
                              example ODBC).
                             An existing connection may be used or a
                              new connection created for a universe.
                             There are three different types of
                              connections.
         13
 © Copyright Polaris
Software Lab Limited,
       2007
                        Different Types of Connection

                        Personal
                         Can only be used on the client

                        Shared
                         Can be used by more than one user to send
                         queries to the target database from a shared
                         server
                        Secured
                         This connection is used when you wish to
                         distribute the completed universe to the user
                         population via the repository
         14
 © Copyright Polaris
Software Lab Limited,
       2007
                        Creating a New Connection

                        1. Click on New
                                                    2. Choose the middleware




                        Identify the driver to be
                        used to access the
                        target database



         15
 © Copyright Polaris
Software Lab Limited,
       2007
                            Setting up Universe Parameters
                           Definition Tab:name,description
                            and connection to the database
                           Summary Tab: author and statistics
                            about the universe
                           Strategies Tab: internal or personal
                            wizards to make creating a universe
                            easier
                           Controls Tab: manages access and
                            control of resources
                           SQL Tab: queries and SQL
                            parameters
                           Links Tab: enables dynamic links
                            with other universes


         16
 © Copyright Polaris
Software Lab Limited,
       2007
                            Saving a Universe
                        Save the universe giving a business name with up to three
                        characters as an extension

                        This makes it possible to distribute the universe across
                        different kinds of computers

                        Choose File, Save or click

                        •By default the universe is saved in the folder:
                                C:\Documents and Settings\<profile
                           name>\Application Data\Business Objects\Business
                           Objects 11.5\universes

         17
 © Copyright Polaris
Software Lab Limited,
       2007
                               Adding Tables
                        Use the Table browser:
                           Double-click on the background of
                           the Structure
                            Choose Insert, Tables from the menu
                        The Table browser displays all the tables
                        and views of the database

                        You can select multiple tables using the
                        Shift key or Ctrl key




         18
 © Copyright Polaris
Software Lab Limited,
       2007
                        Creating classes

                            Manual Creation
                                Use “Insert > class”
                                 from the menu. An
                                 ‘Edit Properties’ box
                                 appears. Enter class
                                 description
                        OR


                            Use        to create a
                             class



         19
 © Copyright Polaris
Software Lab Limited,
       2007
                         Creating classes
                        Automatic creation
                          Select a table in the structure pane.
                          Drag it to the universe pane.
                          A class is created in the universe pane with the same
                          name as the table name.
                          Objects are also created automatically in the class
                             corresponding to the fields in the table.




         20
 © Copyright Polaris
Software Lab Limited,
       2007
                         Object Properties
                        Three property pages
                          Definition
                             •Name
                             •Datatype
                             •Description
                             •SELECT statement
                             •WHERE clause




         21
 © Copyright Polaris
Software Lab Limited,
       2007
                        Properties
                          •Qualification
                          •Associated List of
                          Values




         22
 © Copyright Polaris
Software Lab Limited,
       2007
                           Aggregate projection
                            •   Applicable only to
                                measures.
                            •   Defines how the measure
                                will be aggregated when
                                projected from a micro-
                                cube.




         23
 © Copyright Polaris
Software Lab Limited,
       2007
                           Advanced
                            •   Security
                            •   User rights on Objects
                            •   Database Formats




         24
 © Copyright Polaris
Software Lab Limited,
       2007
                        Joins



         25
 © Copyright Polaris
Software Lab Limited,
       2007
                              Joins

                        WHAT THEY ARE
                            Relationship between 2 or more tables that
                           help restrict the result set of a query run against
                           those tables.

                         WHY USE
                            They limit the occurrence of a Cartesian
                           product, a situation in which all possible
                           combinations       between each row of each
                           table are retrieved.



         26
 © Copyright Polaris
Software Lab Limited,
       2007
                          Types of Joins
                        Equi-Join
                            Table 1.Column A = Table 2.Column B
                            Resulting data set limited to values common in Column A & B.
                         Outer-Join
                           Table 1 OUTER JOIN Table 2 on Column A = Column B
                           Resulting data set limited to ALL the values in Table 1 and ONLY
                           matching values in Table 2 based on Column A and Column B.
                        Theta-Join
                            Table 1.Column A BETWEEN ….. AND ……
                            Links tables based on a relationship other than equality between 2
                            columns.

                        Self-Join
                         Table 1.Column A =Table 1.Column B
                         Links two Columns in a single table
         27
 © Copyright Polaris
Software Lab Limited,
       2007
                        Creating and Deleting Joins

                           A join can be entered manually using two
                            methods

                               Graphically




                            With the menu
                            option Insert, Joins
                            and the Edit Join
                            box

                        To delete a join, click on the join line and press Delete
         28
 © Copyright Polaris
Software Lab Limited,
       2007
                         Integrity Check
                       Integrity check
                        allows the checking
                        of Universe
                        structure, Loops ,
                        Contexts ,
                        Cardinality and
                        Parsing Check on
                        Joins , Conditions
                        and Objects .



         29
 © Copyright Polaris
Software Lab Limited,
       2007
                        Restricting Data




         30
 © Copyright Polaris
Software Lab Limited,
       2007
                        Types of Restrictions

                           Hard Coded / Direct Restrictions

                         Indirect Restrictions



                         Flexible Conditioning of   the Data

                         Multiple Prompt

         31
 © Copyright Polaris
Software Lab Limited,
       2007
                        Hard-coded Restriction

                        Adding a WHERE condition to an object allows you
                         to give a more precise définition:




         32
 © Copyright Polaris
Software Lab Limited,
       2007
                        How Data is Restricted

                        The Where clause in an SQL statement restricts the
                          number of rows returned in the result set:




         33
 © Copyright Polaris
Software Lab Limited,
       2007
                            Indirect Restriction

                           Achieved using conditional objects
                           In the User Module , user has the option to
                            apply the restriction.
                           Obviously , more flexible than previous type of
                            restriction.
                           Once a conditional objects are included,
                            restriction becomes hard-coded for the query.




         34
 © Copyright Polaris
Software Lab Limited,
       2007
                            Condition Objects

                            Select Condition Object
                             View
                           Insert a Condition Object
                        Condition object name

                            Description

                            Where clause




         35
 © Copyright Polaris
Software Lab Limited,
       2007
                        Flexible / @Prompt type Restriction

                          Offers maximum flexibility
                         Limitation of Indirect type of restriction is
                          overcome by having flexibility in selecting
                          the where clause.
                         Achieved using @Prompt Command.




         36
 © Copyright Polaris
Software Lab Limited,
       2007
                        @Prompt Command Syntax

                        •   Message in the Prompt                     ‘Any
                            Message’

                        •   Data Type                   ‘A’ or ‘N’ or ‘D’

                        •   List Of Values
                            •   Hard Coded List of Values    {‘Japan’, ‘USA’,’France’}
                            •   Values of existing Objects

                        •   Number of Choices                 Mono ; Multi

                        •   Type of Choice                    Free ; Constrained
         37
 © Copyright Polaris
Software Lab Limited,
       2007
                            Multiple Prompt Conditioning
                           Extension of @Prompt Conditioning
                           More than one where clause can be prompted.
                           If the same ‘Message text’ is used in the next prompt,
                            the user is prompted only once and the same value is
                            substituted for the next prompt too.
                           For instance, consider the following where clause -
                                 WHERE column A = @prompt(‘Enter value’,…...)
                                 AND column B = @prompt(‘Enter value’,…..)
                            This will result in the user being prompted only once and the
                            same value will be substituted for column B as well.



         38
 © Copyright Polaris
Software Lab Limited,
       2007
                        List of Values




         39
 © Copyright Polaris
Software Lab Limited,
       2007
                            What is a List of Values?
                           A list of the distinct values from the column or columns to
                            which the object refers
                           A LoV is used on the operand side of a condition in the
                            query panel of the User module




                           This is only available if set by the designer
         40
 © Copyright Polaris
Software Lab Limited,
       2007
                            Creating a List of Values

                           A LoV is created within the Properties tab of an object

                           By default,
                            Associate a List
                            and Allow Users
                            to edit are
                            checked

                           It is important
                            to uncheck this
                            box for objects
                            that don’t need
         41
                            a List
 © Copyright Polaris
Software Lab Limited,
       2007
                            Controlling How Lists are Refreshed

                            Normally, the first time a LoV is used in a User login
                             session, the system fires a query at the target database.

                            The results of this query are used to populate the list,
                             and are stored in the .lov file.

                           Thereafter, the .lov file from this query is used each time
                            the List is required.




         42
 © Copyright Polaris
Software Lab Limited,
       2007
                            Controlling How Lists are Refreshed

                           Not normally used -
                            uncheck this box


                               Check this box for
                                frequently changing
                                lists

                           Check this box for lists that
                            never change



         43
 © Copyright Polaris
Software Lab Limited,
       2007
                            Creating a Hierarchy for a List of Values

                           The resulting Hierarchical View of the LoV makes
                            it easier to select the required value:




         44
 © Copyright Polaris
Software Lab Limited,
       2007
                            Basing a LoV on a Personal File

                           Select Tools, Lists of Values from the Menu bar:




                           Select the object:




                           Select Personal Data:


         45
 © Copyright Polaris
Software Lab Limited,
       2007
                            Basing a LoV on a Personal File

                            Click OK to acknowledge the message




                           Specify the file that contains the values for the list and
                            click OK
         46
 © Copyright Polaris
Software Lab Limited,
       2007
                          Creating objects
                        Manual Creation
                          Select the class where object is to be created.
                          Use “Insert”--> “Object” from the menu. An ‘Edit
                          Properties’ box appears. Enter object details.

                        Automatic creation
                          Select a column from a table in the structure pane.
                          Drag it to the universe pane.
                          An object is created under the nearest class to the
                          point where you drop the column.
                          Default object name is column name with underscores
                          replaced with spaces.

         47
 © Copyright Polaris
Software Lab Limited,
       2007
                        Hierarchies




         48
 © Copyright Polaris
Software Lab Limited,
       2007
                        What is a Hierarchy?

                         An ordered set of related dimensions.
                           For example, A hierarchy called Geography may consist of
                           Country, Region and City.
                                                  Data Returned
                                                       INDIA


                                        North                      South



                              Panjab   Haryana   Rajasthan   A.P   Karnataka   T.N

         49
 © Copyright Polaris
Software Lab Limited,
       2007
                        Hierarchies
                         An ordered set of related dimensions.
                               For example, A hierarchy called Geography may
                              consist of Country, Region and City.
                         Necessary to ‘drill up / down’ to see less or more
                           details.
                         Designer uses the class structure as the default
                                hierarchy.
                         Custom Hierarchies can be built using Tools >
                           Hierarchies. A Hierarchy editor pops up. Use this
                        to create new hierarchies.
                        Some classic examples for hierarchies -
                               Products - Category > Brand > Product
                               Time - Year > Quarter > Month > Week > Day
         50
 © Copyright Polaris
Software Lab Limited,
       2007
                            What is a Default Hierarchy?
                           A Default Hierarchy is the hierarchy based on the order of
                            the Objects within the Class

                        Default Hierarchies are
                        represented in the User module by the order in which
                        Dimension Objects are organized in the Classes and
                        Objects box of the Query
                        Panel




         51
 © Copyright Polaris
Software Lab Limited,
       2007
                            What is a Custom Hierarchy?
                           A Custom Hierarchy combines Objects from Default
                            Hierarchies to build a Custom Analysis Path

                                                             Custom Hierarchy



                        Default Hierarchies




         52
 © Copyright Polaris
Software Lab Limited,
       2007
                            Creating Custom Hierarchies



           (or Tools,
           Hierarchies)




                           Add Objects from Default Hierarchies to build a new
                            Custom Hierarchy
         53
 © Copyright Polaris
Software Lab Limited,
       2007
                        Loops




         54
 © Copyright Polaris
Software Lab Limited,
       2007
                         Multiplepaths between the tables selected
                         in queries.




         55
 © Copyright Polaris
Software Lab Limited,
       2007
                         Loops can be resolved by

                        ALIASES
                        Alias - Same as the namesake in SQL.
                        •Exact duplicate of the original table.
                        •A different name “tricks” the SQL query to accept that you
                        are using 2 different tables.

                        CONTEXTS
                        •Rule which helps BO decide which of the 2 paths to choose
                        in a loop.
                        •BO prompts the user to indicate the correct perspective
                        (relevant path) for the query.


         56
 © Copyright Polaris
Software Lab Limited,
       2007
                                   Aliases
                           In SQL an alias is an
                            alternative name
                            for a table. The
                            purpose of aliases
                            is to resolve
                            structural issues in
                            a database arising
                            from SQL
                            limitations. In
                            DESIGNER, an alias
                            is just a pointer to
         57
                            another table
 © Copyright Polaris
Software Lab Limited,
       2007
                           When to Alias

             A loop with a single                      NN        N
                                                                  N
              lookup table should be
              resolved by an alias
                                                  11
                                                  NN                   11
             A lookup table can be
                                                   11                  N
              identified by its cardinality                            N
                                                   N
                                                   N
                                                             1
                                                             1    11




                       A lookup table only has
                        the ‘one’ end of joins           Alias needed here
                        attached to it
         58
 © Copyright Polaris
Software Lab Limited,
       2007
                            How to Alias ?
                           Designer routines detect
                            loops and candidates for
                            aliases


                        Break the loop by creating
                        an alias of the lookup table
                        for each side of the loop




         59
 © Copyright Polaris
Software Lab Limited,
       2007
                        Resolving Loops using Contexts



                                              Sales              Sal
                                                                Lines


    Country                Customers




                            There are two Loans             Loans
                                           possible routes to
                                                            Lines
                            link Clients with Models:
                                       • Working with rentals
                                       • Working with sales
         60
 © Copyright Polaris
Software Lab Limited,
       2007
                            Detecting and Creating Contexts
                           Loop Detection routine: suggests candidates for both aliases
                            and contexts
                           “Detect Contexts” detects and proposes a list of contexts
                            to create


                           “Insert Contexts” inserts a context manually




         61
 © Copyright Polaris
Software Lab Limited,
       2007
                            Linking Universes

                           Linking can mean reduced maintenance.



                                                                    Universe A


                        Universe A

                                                                Universe B




         62
 © Copyright Polaris
Software Lab Limited,
       2007
                            Two Approaches to Linking
                        •   Kernel approach




                        •   Master approach




         63
 © Copyright Polaris
Software Lab Limited,
       2007
                        Kernel Approach


                                              Kernel    +

                                          Human Resources
                        Kernel
                                 Staff                 Motors2000


                                             Kernel     +

         64
 © Copyright Polaris
Software Lab Limited,
       2007
                           Master Approach


                                                 Master    -

                                              Human Resources
                        Master       HR
                                    and
                                 Motors2000               Motors2000


                                                 Master   -

         65
 © Copyright Polaris
Software Lab Limited,
       2007
                            Making a Link

                       Click   and click on the Links tab

                                                            Click Add Link...




                                                            Choose universe to
                                                             link and click Open

         66
 © Copyright Polaris
Software Lab Limited,
       2007
                            The Derived Universe




                           The linked universe structure and objects cannot be edited in
                            the derived universe
                           The linked universe should be treated as though they were
                            new tables inserted in the derived universe. The same
                            procedure should be applied
         67
 © Copyright Polaris
Software Lab Limited,
       2007
                        Including Universes
                            Including a Universe COPIES structure and objects to the
                             derived universe:


                                             Everything              Universe A
                                                from
                        Universe A           Universe A




                                                                  Universe B


         68
 © Copyright Polaris
Software Lab Limited,
       2007
                        Included Universes
             Included universes become part of the new universe




         69
 © Copyright Polaris
Software Lab Limited,
       2007
                        Q&A
                         ?


         70
 © Copyright Polaris
Software Lab Limited,
       2007
Thank You




Presented By : PavanKumar .C

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:14
posted:8/26/2012
language:
pages:71
Description: Business Objects Designer -