Price: Check with seller

Sponsored Ads

Description


  • Building the Physical Layer of a Repository

    • Importing data sources

    • Setting up connection pool properties

    • Defining keys and joins

    • Examining physical layer object properties

    • Creating alias and select tables



  • Building the Business Model and Mapping Layer of a Repository

    • Building the Business Model and Mapping Layer of a Repository

    • Building a business model

    • Building logical tables, columns, and sources

    • Defining logical joins

    • Building measures

    • Examining business model object properties



  • Building the Presentation Layer of a Repository

    • Exploring Presentation layer objects

    • Creating Presentation layer objects

    • Modifying Presentation layer objects

    • Examining Presentation layer object properties



  • Testing and Validating a Repository

    • Checking repository consistency

    • Turning on logging

    • Defining a repository in the initialization file

    • Testing a repository using Oracle BI Answers

    • Inspecting the query log



  • Adding Multiple Logical Table Sources & Adding Calculations to a Fact Table

    • Adding multiple logical table sources to a logical table

    • Specifying logical content

    • Creating new calculation measures based on existing logical columns

    • Creating new calculation measures based on physical columns

    • Creating new calculation measures using the Calculation Wizard



  • Creating Dimension Hierarchies and Level-Based Measures

    • Creating dimension hierarchies

    • Creating level-based measures

    • Creating share measures

    • Creating rank measures



  • Using Aggregates

    • Purpose of aggregate tables in dimensional modeling

    • Modeling aggregate tables to improve query performance

    • Testing aggregate navigation

    • Using the Aggregate Persistence Wizard



More Details

Total Views:8
Reference Id:#590535
Phone Number: 9989275111
Website URL: Click To Visit
Current Rating: /5 0 Vote
Copyright © 2017 |   All Rights Reserved |   TuffClassified |   24x7 support |   Email us: query[at]tuffclassified.com