Agenda szkolenia
  1. Basic SAP BusinessObjects Universe Design
    • Describing Universes
    • Defining the Components of a Universe
  2. Data Connections
    • Defining Connections
  3. Data Foundations
    • Creating Data Foundations
    • Using Joins
  4. Business Layers
    • Accessing Data through the Business Layer
    • Integrating the Business Layer Components
    • Validating Objects
    • Creating Measure Objects
    • Creating Shortcut Joins
  5. Loops in a Data Foundation
    • Resolving Loops with Joined Tables
    • Resolving Loops Using Aliases
    • Resolving Loops Using Contexts
    • Detecting Contexts
    • Editing Contexts
    • Testing Contexts
    • Resolving Recursive Loops
  6. Data Restrictions
    • Defining Data Restrictions
    • Applying Mandatory Data Restrictions
    • Applying Optional Data Restrictions
  7. Lists of Values (LOV)
    • Providing a List of Values
  8. Parameters
    • Illustrating Runtime Parameters
  9. Object @functions
    • Using Object @functions in Queries
    • Applying the Aggregate Awareness Optimization Method
    • Using Other @ Functions
  10. Navigation Paths
    • Defining Drill Down Navigation Paths
  11. Derived Tables
    • Creating Derived Tables
  12. Key Awareness
    • Defining Numeric Keys
  13. Universe Management with Data Foundation and Business Layer Views
    • Managing a Universe using the Data Foundation View
    • Managing a Universe using the Business Layer View
  14. Universe Optimization
    • Optimizing Universes Using Parameters
  15. Universe Deployment and Security
    • Deploying a Universe
    • Securing a Published Universe
    • Creating Data Security Profiles
    • Creating Business Security Profiles
    • Assigning Security Profiles to Users
    • Identifying the Priority of Security Settings
    • Updating a Published Universe
  16. SQL Clause Processing Problems
    • Determining How the Order of SQL Clauses Affects Data Returned
    • Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables
    • Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
    • Identifying Fan Traps
    • Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
  17. Outer Join Problem Resolution
    • Resolving an Ambiguous Outer Join Using @AggregateAware
  18. Universe Creation from Different Data Sources
    • Identifying the Different Data Sources
    • Creating an OLAP Universe
    • Creating a Multi-source Universe
  19. Shared Projects
    • Using Shared Projects
    • Manipulating Other Designers' Resources
  20. Universe Conversion
    • Converting Existing .unv Universes
  21. Translation
    • Deploying Universes in Different Languages