Explore topic-wise InterviewSolutions in .

• Aggregate tables (_A) : These tables contain summed (aggregated) data.
• Dimension tables (_D) : Dimension tables with descriptive data
• Staging tables for Dimension(_DS) :These tables contain the data which is to be loaded to Target
• Fact tables (_F) : Tables storing facts and measures
• Dimension HIERARCHY tables (_DH) : Tables that store the dimension's hierarchical structure
• Fact Staging tables (_FS) : Staging tables used to HOLD the metrics being ANALYZED by dimensions that have not been through the final ETL transformations.

components of OBIA : 

DAC Repository metadata files: Content includes repository objects such as tables, subject areas, execution plans, and tasks, and is contained in XML files.The DAC client and server were included until version 7.9.5. Since then it is a separate installer.

EMBEDDED Informatica ETL tool and repository : ETL is a third party tool which includes mappings (wrapped in workflows) to extract data from the supported source systems (various versions of standard applications such as Siebel CRM - yes it was first - , ORACLE eBusiness Suite, Peoplesoft, JDEdwards and SAP (BI Apps version 7.8.4) ) and load the data into the Oracle Business Analysis Warehouse.

Pre built metadata content : This metadata content is contained in the Oracle BI Applications repository file (OracleBIAnalyticsApps.rpd). It maps the source physical tables to a generic business model and includes more than 100 presentation catalogs (aka subject areas) to allow queries and segmentation using Oracle BI clients such as Answers, Dashboards and SEGMENT Designer

Pre built reports and dashboard content : Contains hundreds of requests and ready-to-use dashboards which enable tight integration between the source applications and the BI infrastructure

Oracle Business Analytics Warehouse : The prebuilt data warehouse that holds data extracted, transformed, and loaded from the transactional database

Ad-hoc Analysis : Metadata layer serves as foundation to provide flexible and intuitive ad-hoc reporting and custom dashboard designs through Oracle BI Answers and Oracle BI Dashboard tools that are part of the OBIEE toolset.

Role-Based Dashboards : DELIVERED role-based dashboards are easily configurable to meet specific organizational needs and practices.

components of OBIA : 

DAC Repository metadata files: Content includes repository objects such as tables, subject areas, execution plans, and tasks, and is contained in XML files.The DAC client and server were included until version 7.9.5. Since then it is a separate installer.

Embedded Informatica ETL tool and repository : ETL is a third party tool which includes mappings (wrapped in workflows) to extract data from the supported source systems (various versions of standard applications such as Siebel CRM - yes it was first - , Oracle eBusiness Suite, Peoplesoft, JDEdwards and SAP (BI Apps version 7.8.4) ) and load the data into the Oracle Business Analysis Warehouse.

Pre built metadata content : This metadata content is contained in the Oracle BI Applications repository file (OracleBIAnalyticsApps.rpd). It maps the source physical tables to a generic business model and includes more than 100 presentation catalogs (aka subject areas) to allow queries and segmentation using Oracle BI clients such as Answers, Dashboards and Segment Designer

Pre built reports and dashboard content : Contains hundreds of requests and ready-to-use dashboards which enable tight integration between the source applications and the BI infrastructure

Oracle Business Analytics Warehouse : The prebuilt data warehouse that holds data extracted, transformed, and loaded from the transactional database

Ad-hoc Analysis : Metadata layer serves as foundation to provide flexible and intuitive ad-hoc reporting and custom dashboard designs through Oracle BI Answers and Oracle BI Dashboard tools that are part of the OBIEE toolset.

Role-Based Dashboards : Delivered role-based dashboards are easily configurable to meet specific organizational needs and practices.

ORACLE Business INTELLIGENCE Application (OBIA) is composed of : 

INFORMATICA + DAC + OBIEE

Oracle Business Intelligence Application (OBIA) is composed of : 

INFORMATICA + DAC + OBIEE

Oracle BI Applications includes the following modules:

Oracle Financial Analytics (Manage financial performance ACROSS locations, customers, products, and territories, and receive real-time alerts on events that may impact financial condition)

Oracle Human Resources Analytics (Correlate financial measures with key workforce metrics to demonstrate HR’s strategic value in the organization)

Oracle Procurement and Spend Analytics (Creates visibility to spending patterns for both direct and indirect spend, enabling users to identify and realize the savings opportunities, with the ability to do the spend analysis by commodities, suppliers, supplier locations, buying locations, BUSINESS units, cost centers, buyers and contract usage)

Oracle Project Analytics

Oracle Supply Chain and ORDER Management Analytics, ETC.,

Oracle BI Applications includes the following modules:

Oracle Financial Analytics (Manage financial performance across locations, customers, products, and territories, and receive real-time alerts on events that may impact financial condition)

Oracle Human Resources Analytics (Correlate financial measures with key workforce metrics to demonstrate HR’s strategic value in the organization)

Oracle Procurement and Spend Analytics (Creates visibility to spending patterns for both direct and indirect spend, enabling users to identify and realize the savings opportunities, with the ability to do the spend analysis by commodities, suppliers, supplier locations, buying locations, business units, cost centers, buyers and contract usage)

Oracle Project Analytics

Oracle Supply Chain and Order Management Analytics, Etc.,

Definition: Oracle Business Intelligence Applications is a prebuilt business intelligence solution that deliver intelligence ACROSS an ORGANIZATION, empowering users at all levels from FRONT line operational users to senior MANAGEMENT with the key INFORMATION they need to maximize effectiveness.

Definition: Oracle Business Intelligence Applications is a prebuilt business intelligence solution that deliver intelligence across an organization, empowering users at all levels from front line operational users to senior management with the key information they need to maximize effectiveness.

• SQL SERVER Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.
• SQL Server Analysis Services: Allows data DISCOVERY using data mining. Using business logic it supports data ENHANCEMENT.
• SQL Server Reporting Services:- Used for Data presentation and distribution ACCESS.

Column filter- simply a filter applied on a column which we can USE to restrict our column values while pulling the data or in CHARTS to SEE the related content.

Global filter- Not SURE. I understand this filter will have impact on across the application but I REALLY don’t understand where and how it can be user. I heard of global variables but not global filters.

Column filter- simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.

Global filter- Not sure. I understand this filter will have impact on across the application but I really don’t understand where and how it can be user. I heard of global variables but not global filters.

A dashboard in business intelligence allows huge data and reports to be READ in a single graphical interface. They help in MAKING faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business PERFORMANCE. It REPRESENTS the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.

A dashboard in business intelligence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.

Business intelligence tools are to report, analyze and PRESENT data. Few of the tools available in the MARKET are:

• Eclipse BIRT Project:- Based on eclipse. Mainly used for web applications and it is open source.
• Freereporting.com:- It is a free web based reporting tool.
• JasperSoft:- BI tool used for reporting, ETL etc.
• Pentaho:- Has data mining, dashboard and workflow capabilities.
• Openl:- A web APPLICATION used for OLAP reporting.

Business intelligence tools are to report, analyze and present data. Few of the tools available in the market are:

Business Intelligence helps to manage data by applying DIFFERENT skills, TECHNOLOGIES, security and quality risks. This ALSO helps in achieving a better understanding of data.Business intelligence can be considered as the collective information. It helps in making predictions of business operations using gathered data in a warehouse. Business intelligence application helps to tackle SALES, financial, production etc business data. It helps in a better decision making and can be also considered as a decision support system.

Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks. This also helps in achieving a better understanding of data.Business intelligence can be considered as the collective information. It helps in making predictions of business operations using gathered data in a warehouse. Business intelligence application helps to tackle sales, financial, production etc business data. It helps in a better decision making and can be also considered as a decision support system.

Supervisor: Supervisor is the control center for the administration and security of your entire BusinessObjects deployment.

DESIGNER: Designer is the TOOL used to create, manage and distribute universe for BusinessObjects and WebIntelligence Users. A universe is a file that contains connection parameters for one or more database middleware and SQL structure called objects that map to actual SQL structure in the database as columns,tables and database.

BusinessObjects Full client Reporting tool: Helps to create BUSINESS objects reports based on the universe and also from the other data sources.

BusinessObjects Thin client Reporting tool: Helps to query and analysis on the universe and also share the report among other users. It doesn’t require any software, just need a web browser and the system connected to the business objetcs server.

Auditor: Tool is used for monitor and analysis user and system activity.

Application Foundation: This module covers a set of products which is used for Enterprise Performance MANAGEMENT (EPM). The tools are 

• Dashboard manager.
• Scorecard.
• Performance Management APPLICATIONS.

Supervisor: Supervisor is the control center for the administration and security of your entire BusinessObjects deployment.

Designer: Designer is the tool used to create, manage and distribute universe for BusinessObjects and WebIntelligence Users. A universe is a file that contains connection parameters for one or more database middleware and SQL structure called objects that map to actual SQL structure in the database as columns,tables and database.

BusinessObjects Full client Reporting tool: Helps to create business objects reports based on the universe and also from the other data sources.

BusinessObjects Thin client Reporting tool: Helps to query and analysis on the universe and also share the report among other users. It doesn’t require any software, just need a web browser and the system connected to the business objetcs server.

Auditor: Tool is used for monitor and analysis user and system activity.

Application Foundation: This module covers a set of products which is used for Enterprise Performance Management (EPM). The tools are 

Online Mode- You can MAKE changes in the RPD file and push in changes which will be immediately VISIBLE to the USERS who are already connected. This feature we may use in PRODUCTION environment.

Offline mode- can be USEFUL in test or development environment.

Online Mode- You can make changes in the RPD file and push in changes which will be immediately visible to the users who are already connected. This feature we may use in production environment.

Offline mode- can be useful in test or development environment.

WHETHER it is:

• 1:1
• 1:m
• m:m
• 1:M

Whether it is:

while creating a chat in BI Answers, you can DEFINE the conditions and can APPLY COLOUR FORMATTING.

while creating a chat in BI Answers, you can define the conditions and can apply colour formatting.

OPERATIONAL Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.

ODS is more CLOSER to OLTP system. We don’t normally prefer to store aggregated data in OLTP. So it is with ODS.

UNLIKE data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.

ODS is more closer to OLTP system. We don’t normally prefer to store aggregated data in OLTP. So it is with ODS.

Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.