Datawarehouse Architect

            An event table which is used to update the table and its columns rows frequently by pooling time. The wizard selects the table and setting the pooling frequency to update the all the columns rows of the table. When we selecting the table for “event table” pooling frequency the table will change to yellow color in the physical table. Just see below. I am using table here “s_nq_acct” and running the wizard, after completes the table will become as yellow color. Before: Using utilities option execute the “oracle BI Event Tables” and select the “s_nq_acct” table to run the utility. Then check in the physical layer, the frequency sets to every 1 minute. click no here because the table has join should not delete the joins Then we can see the table become yellow in the physical layer because the table has evented for 1 minute  

It is used to replace the columns or tables from physical layer to business model mapping layer. The Replace Wizard automates the process of replacing physical columns or tables in logical table sources by allowing the Oracle BI Administrator to select the sources from those displayed. The wizard prompts the Oracle BI Administrator to replace columns as well as tables in both 10g and 11g. Using single Column replace from physical to logical it affects the change in the mapping of physical table in BMM layer of logical table. For example see below: I am having the table name as “Absence_leave” with 12 columns. Just I am going to map the physical column Absence_type to asondate. Replace Column or Table in Logical Table Sources Utility Check the Asondate mapped with which physical column in BMM layer before replacing. Logical column of “Asondate” with the data type as “date”   Mapped with asondate of physical column of absence_leave table of

What is Utilities? Utilities involved in maintenance and development of the rpd. Some of the lists of utilities to work on Admin level Tool are, List of utilities in OBIEE 10G: · Replace Column or Table in Logical Table Sources · Oracle BI Event Tables · Externalize Strings · Rename Wizard · Update Physical Layer · Repository Documentation · Removed Unused Physical Objects · Aggregate Persistence Wizard                                   Admin Tool Utilities in OBIEE 10G & OBIEE 11G List of Utilities in OBIEE 11G: · Replace Column or Table in Logical Table Sources · Oracle BI Event Tables · Externalize Strings · Rename Wizard · Update Physical Layer · Repository Documentation · Removed Unused Physical Objects · Aggregate Persistence Wizard · Generate Deployment File

Sizing a Business Intelligence System involves knowing the nature and architecture of the system. These architectures have been broadly classified as Enterprise Data Warehouses, Data Marts and Extraction Engines [ETL]. Business Intelligence Architectures 1.Estimate the size of the Production Data Warehouse database 2.Estimate the rate of your database growth (i.e. 10% per year) 3.Estimate the update characteristics of the production database Data Mart Requirements  1.Estimate the size of the raw (source) data for the Data Mart 2.Estimate the size of the Production Data Mart database 3.Estimate the rate of your database growth (i.e. 10% per year) 4.Estimate the update characteristics of the production database 5.Estimate the rate of concurrent user base growth ETL [Extraction, Transformation and Load] Requirements 1.Indicate what ETL Tool will be used 2.What is the source of data extraction [Oracle, DB2, IMS, SQL Server, Flat files etc.]? 3.What is the Hard

Time Series in obiee Time series functions present the capability to evaluate and comparing business performance by current period of time to previous time periods, allowing you to analyze data for multiple time periods. Comparison between 10g and 11g ·           Only two series functions like AGO, TO DATE ·          In answer side we don’t have the option to implement time series functions ·          Only in RPD level have the function of time series in 10g ·          Three time series functions like AGO, TO DATE, PERIOD ROLLING ·          Here in answer side we have the function to implement time series functions ·          Both RPD and Answer side have the functions of time series in 11g Procedures where same for AGO and TODATE function in 10g as well as 11g. 1. Ago: Ago time series function defines the sale or revenue of business statistics according to t