Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

AH R Rank 2 - Community Beginner

Comments

  • We have a OOTB Oracle BI apps RPD and If I move my HR related warehouse tables in a separate db schema then how can I handle this in single RPD to use multiple db schema/user while I have only one OOTB "Oracle Data Warehouse" having contents of HR Physical tables. In this Oracle Data Warehouse's connection pool I can use…
  • We are using single database schema for HR analytics and Procurement analytics contents. In oracle BI apps I don't think we can have a two repositories.
  • There is no predefined model but as you can create connection with Oracle EBS database. Go and import EBS tables in physical layer of RPD and you need to create your model according to your requirement.
  • Krishna Prasad: Customizing Oracle BI Applications 11.1.1.7.1
  • Also for category-1 customization you don't need to include new load plan/etl scenarios at all. For category-2 customization add your custom etl scenario in X_CUSTOM Fact ETL group. Following documentation can be followed for details: https://docs.oracle.com/cd/E38317_01/doc.11117/e37988/customizing.htm
  • Kindly explain by doing one fact table customization you means Adding extra columns in fact table etl or you going to define a new etl to bring new new fact table in your warehouse ?