Scribd Logo
Upload

Welcome to Scribd!

  • 204 views

    What Application Content Is Available For The BI Apps? ERP Analytics

    Uploaded by

    Anandh Kumar
    This document provides an overview of Oracle Business Intelligence (BI) applications and tools. It discusses the various pre-built analytics applications available for ERP, CRM, supply chain, and other functions. It also summarizes the key components of the Oracle BI platform including the BI server, presentation services, administration tools, and security features. Finally, it briefly outlines the procedures for installing and configuring the Oracle BI applications, data warehouse, ETL tools, and setting up the BI repository, reports, and dashboards.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    What Application Content Is Available For The BI Apps? ERP Analytics

    Uploaded by

    Anandh Kumar
    204 views4 pages
    This document provides an overview of Oracle Business Intelligence (BI) applications and tools. It discusses the various pre-built analytics applications available for ERP, CRM, supply chain, and other functions. It also summarizes the key components of the Oracle BI platform including the BI server, presentation services, administration tools, and security features. Finally, it briefly outlines the procedures for installing and configuring the Oracle BI applications, data warehouse, ETL tools, and setting up the BI repository, reports, and dashboards.

    Original Title

    OBIA OBIEE DAC

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of Oracle Business Intelligence (BI) applications and tools. It discusses the various pre-built analytics applications available for ERP, CRM, supply chain, and other functions. It also summarizes the key components of the Oracle BI platform including the BI server, presentation services, administration tools, and security features. Finally, it briefly outlines the procedures for installing and configuring the Oracle BI applications, data warehouse, ETL tools, and setting up the BI repository, reports, and dashboards.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    204 views4 pages

    What Application Content Is Available For The BI Apps? ERP Analytics

    Uploaded by

    Anandh Kumar
    This document provides an overview of Oracle Business Intelligence (BI) applications and tools. It discusses the various pre-built analytics applications available for ERP, CRM, supply chain, and other functions. It also summarizes the key components of the Oracle BI platform including the BI server, presentation services, administration tools, and security features. Finally, it briefly outlines the procedures for installing and configuring the Oracle BI applications, data warehouse, ETL tools, and setting up the BI repository, reports, and dashboards.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 4

    What Application content is available for the BI Apps?

    ERP Analytics - Oracle Financial Analytics - Oracle Procurement and Spend Analytics - Oracle Human Resources Analytics - Oracle Supply Chain and Order Management Analytics - Oracle Spend Classification Analytics - Oracle Project Analytics CRM Analytics - Oracle Sales Analytics - Oracle Service Analytics - Oracle Marketing Analytics - Oracle Contact Center Analytics - Oracle Loyalty Analytics - Oracle Price Analytics Industry Applications - Oracle US Federal Financial Analytics BI Apps Installation Procedure 1. BI Apps Installation Procedure Data Base Configuration Steps Target Schema Creation 2. OBIEE 11g Installation Procedure

    3. Oracle Business Intelligence 11g.x


    4. 5.

    6. Data warehousing overview


    7. Basics of Data Warehousing 8. What is OLTP and OLAP? 9. Difference between OLTP and OLAP 10. Advantages of OLAP 11. What is Data Marts and ODS? 12.

    13. Dimensional Modeling Overview


    14. Introduction to Dimensional Modeling 15. What are Facts and Dimensions? 16. Star schema and Snowflake schema 17.

    Introduction to Business Intelligence


    What is Business Intelligence

    Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server

    18.
    19.

    Server Architecture Repository Basics


    What is Meta data?

    20. Creating a Repository using BI Administration Tool 21. Physical, Business Model and Mapping, and presentation layers

    Properties of repository objects

    22.

    Building Physical Layer of a Repository


    Objects of Physical Layer DSN for a data sources Build physical layer
    23.

    Building business Model mapping layer


    Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures
    24.

    Building presentation layer


    Objects of presentation layer Properties of the presentation layer
    25. Build presentation layer 26.

    Testing and validating Repository


    Checking repository consistency Checking Global Consistency Inspecting Oracle Answers inspecting SQL

    27. Inspecting log files(Nqquery.log,NQSserver.log) 28.

    Adding multiple sources to dimension


    De-normalizing tables structures in database design Adding multiple sources to existing logical tables source Adding second table sources
    29.

    Adding calculations to fact


    Calculation measures on the basis of physical and logical columns Using Calculation wizard

    30. Creating dimensional hierarchies and level based measures


    Creating dimensional hierarchies

    Use level based measures Create Rank and Share measures

    31.
    32.

    Using aggregation
    Importing Aggregated Tables into Repository

    Modeling aggregate tables to speed processing


    33. 34.

    Using partition or fragments


    Identifying reasons to segment data Techniques to model partitions Value based partitioning

    35.

    Using variables
    Presentation Variables Repository variables Session variables Initialization Blocks
    36.

    Multiuser Environment (MUD)


    37. Overview on Multiuser Environment (MUD) 38. How to create projects in MUD 39. Checkout and checkin of projects 40.

    Modeling time series data


    Types of SCDS

    Using of time series functions

    41.
    42.

    Modeling extension tables


    Purposes of extension tables

    43. Modeling extension tables for fact and dimensions

    44. Oracle BI Security


    45. Security at object and data level 46. Creating users and User groups 47. Assigning permissions to users 48. Setting Query limits and timing restrictions 49. Authenticating using an external database 50.

    51. Cache management


    Purge cache and event handling tables

    Making the table cacheable Setting of cache in NQSCONFIG.INI file

    52.

    53. Oracle BI Presentation services


    54.

    Working with Oracle BI Answers


    Building Busines Requests usiing Answers Adding filters to Business requests
    55. Adding Column Filter Prompts in Answers

    Views and charts in requests


    56.

    Creating Oracle Intelligence Dashboards


    Creating dashboard pages using report requests
    57. Creating dashboard prompts

    Configuring guided navigation links Adding content to dashboard Conditional links and conditional section
    58.

    Administering OBI Presentation Catalog


    Using catalog management to maintain web catalog Creating catalog groups, issuing privileges etc
    59.

    Using Oracle BI Delivers


    Configuring delivery devices Add delivery profiles Build Oracle alerts Create ibots Configuring Oracle scheduler database Configuring of Event poll tables
    60.

    Overview of Advanced Topics


    BI Applications/ Pre-Built RPO ETL Integration using DAC BI Publisher

    OBIA 7.9.6.3 installation 61. Informatica Installation Procedure Informatica Client Installation Procedure 4. Data Warehouse Administration Console (DAC) Installation Procedure
    INTEGRATION OF DAC Objectives Install the DAC Client Copy Hibernate Libraries Install JDBC Drivers Verify DAC Connection Configuration Enable DAC Client Communication with Informatica PMCMD Command Create a DAC Connection Create the DAC Repository Schema Import DAC Metadata Create the Data Warehouse Tables Configure Connection Between DAC Server and DAC Repository Set DAC System Properties Register the Informatica Services in the DAC Set Physical Data Sources in the DAC OVERVIEW OF DAC DAC Application-Specific Capabilities DAC Features Source System Containers DAC Repository Objects DAC Repository Object Hierarchy DAC Repository Object Hierarchy with Examples DAC Client User Interface DAC Client Tools Menu DAC Views Design View: Subject Areas Tab Design View: Tables Tab Design View: Source System Parameters Tab Design View: Source System Folders Tab Design View: Tasks Tab Design View: Source Tables Subtab Design View: Target Tables Subtab

    Design View: Phase Dependency Subtab Setup View Setup View: DAC System Properties Tab Setup View: Informatica Servers Tab Setup View: Physical Data Sources Tab Setup View: Refresh Dates Setup View: Email Recipients Tab Execute View Execute View: Execution Plans Tab Execute View: Parameters Subtab Execute View: Prune Days Execute View: Current Run Tab Execute View: Run History Tab Execute View: Scheduler Tab Resetting the Data Warehouse Object Ownership in the DAC Summary Practice: Exploring the DAC Customizing DAC Metadata and Running an Execution Plan Objectives Customizing DAC Metadata and Running an Execution Plan Creating or Copying a Source System Container Creating a Subject Area Assembling a Subject Area Creating an Execution Plan Generating Execution Plan Parameters Building an Execution Plan Verifying DAC Server Is Started Running an Execution Plan Monitoring an Execution Plan Viewing Run History for an Execution Plan Viewing Predefined Reports Verifying Data Summary Practice Overview: Customizing DAC Metadata

    You might also like