Oracle BI Administration Tool Metadata management used to be one of the key strengths of Oracle Business Intelligence. Using BI Administration Tool developers were able to design and implement enterprise data models that were sitting on top of data warehouse data schemas. OBIEE developer designs and develops a metadata model, a repository, using BI Administration Tool, which results in a RPD file. This binary file is then deployed on BI Server. BI Server is a component of Oracle Business Intelligence architecture and is responsible for processing user requests and data queries against underlying data sources. BI Server uses metadata information from repository to perform the following two tasks: use logical SQL query and tranform it into corresponding query (ie. SQL, MDX), depending on the underlying data source (ie. Oracle Database, Microsoft SQL Server, Oracle Essbase, ...) transform and combine physical datasets retrieved and perform required calculations. Typical metadat
Oracle Analytics & Data Science