08_02_22_oracle_dbi

8/12/2019 08_02_22_Oracle_DBI

1/85

Oracle Daily BusinessOracle Daily Business

Intelligence (DBI)Intelligence (DBI)

8/12/2019 08_02_22_Oracle_DBI

2/85

Agenda

What is DBI?

DBI Components

DBI Nomenclature

Financial Intelligence Payables Intelligence

DBI Setups

Dimension Setups Manager Reporting

Security Profile

Profile Options

8/12/2019 08_02_22_Oracle_DBI

3/85

What is DBI?

Daily Business Intelligence is embeddedDaily Business Intelligence is embeddedmanagement reporting within Emanagement reporting within E--Business SuiteBusiness Suite

Part of Oracle Self service web applicationsPart of Oracle Self service web applications

Provides integrated information across all modulesProvides integrated information across all modules

Consists of preConsists of pre--configured reports and workbooksconfigured reports and workbooks

Includes KPIs (Key Performance Indicators)Includes KPIs (Key Performance Indicators)

Links enable you to drill down to transactionsLinks enable you to drill down to transactions

8/12/2019 08_02_22_Oracle_DBI

4/85

DBI Components

Financials IntelligenceFinancials Intelligence

Payables IntelligencePayables Intelligence

Purchasing IntelligencePurchasing Intelligence

Project IntelligenceProject Intelligence

Human Resources IntelligenceHuman Resources Intelligence

Contracts IntelligenceContracts Intelligence

Interaction Center IntelligenceInteraction Center Intelligence

Marketing IntelligenceMarketing Intelligence

Quoting IntelligenceQuoting Intelligence

Sales IntelligenceSales Intelligence

Supply Chain IntelligenceSupply Chain Intelligence

8/12/2019 08_02_22_Oracle_DBI

5/85

Agenda

What is DBI?

DBI Components

DBI Nomenclature


DBI Setups


Security Profile

Profile Options

8/12/2019 08_02_22_Oracle_DBI

6/85

DBI Portal PageDBI Portal Page

Links to Drill-DownReports

KPI (KeyPerformanceIndicators)

ManagementSummaries

Related Pages

8/12/2019 08_02_22_Oracle_DBI

7/85

DBI Page DetailsDBI Page Details

Set the Dateof the Report

Period TypeSelection

Week, Month,

Quarter or Year

Set ComparisonYear

Set theManager

View OptionsManager / LOB

8/12/2019 08_02_22_Oracle_DBI

8/85

Report DetailsReport Details

Sort options

Related

Reports

8/12/2019 08_02_22_Oracle_DBI

9/85

DrilldownDrilldown

Choose linksto drilldown

to details

8/12/2019 08_02_22_Oracle_DBI

10/85

Agenda

What is DBI?

DBI Components

DBI Nomenclature


DBI Setups


Security Profile

Profile Options

8/12/2019 08_02_22_Oracle_DBI

11/85

Financial Intelligence isFinancial Intelligence is

A collection of out of the boxA collection of out of the box Financial OperationalFinancial Operationaland activity monitoringand activity monitoring pages and businesspages and businessintelligence reports that empower informationintelligence reports that empower informationconsumers to :consumers to :

Stay InformedStay Informed of daily financial activitiesof daily financial activities

Develop insightsDevelop insights to achieve operationalto achieve operationalefficienciesefficiencies

Take actionTake action timely to drive positive resultstimely to drive positive results

8/12/2019 08_02_22_Oracle_DBI

12/85

Business Needs for FinancialBusiness Needs for FinancialIntelligenceIntelligence

Stay Informed, Develop insights, Take actionStay Informed, Develop insights, Take action

Provide Executives Daily preProvide Executives Daily pre--close profit and loss activityclose profit and loss activity

monitoring against forecasts and plans.monitoring against forecasts and plans. Provide cost center Managers Expense ManagementProvide cost center Managers Expense Management

insights.insights.

Provide visibility into Global Shared services operationalProvide visibility into Global Shared services operational

efficiencies.efficiencies.

Provide a LowProvide a Low--Cost, Quick to Implement, High availabilityCost, Quick to Implement, High availability

intelligence solution alternative.intelligence solution alternative.

8/12/2019 08_02_22_Oracle_DBI

13/85

Content OverviewContent Overview 3 Responsibilities3 Responsibilities

Cost Center ManagerCost Center Manager

Profit Center ManagerProfit Center Manager Daily Financial IntelligenceDaily Financial Intelligence

3 Pages3 Pages Profit and LossProfit and Loss

Profit and Loss by ManagerProfit and Loss by Manager

Expense ManagementExpense Management

2 KPI Regions with 102 KPI Regions with 10 KPIKPIss

9 Table Regions9 Table Regions 10 Graph Regions10 Graph Regions

~ 35 Reports~ 35 Reports

8/12/2019 08_02_22_Oracle_DBI

14/85

Daily Financials IntelligenceDaily Financials Intelligence

8/12/2019 08_02_22_Oracle_DBI

15/85

Profit & Loss PagesProfit & Loss Pages

KPIsKPIs

View financial performance at a glanceView financial performance at a glance

Compare PeriodCompare Period--toto--date performancedate performance vsvs previous periodsprevious periods

Track cumulative revenue to date against forecast and prior periTrack cumulative revenue to date against forecast and prior periodod

8/12/2019 08_02_22_Oracle_DBI

16/85

Profit & Loss PagesProfit & Loss Pages

KPIsKPIs

Revenue: Based on the accounts mapped to the Revenue

financial category.

Expenses: Based on the accounts mapped to the Operating

Expenses financial category.

Operating Margin: xTD Revenue - (xTD Cost of Goods Sold

+ xTD Expenses)

Operating Margin %: (xTD Operating Margin / xTD

Revenue) * 100

8/12/2019 08_02_22_Oracle_DBI

17/85

Expense Management PagesExpense Management Pages

KPIsKPIs

Monitor key operating expense performance metrics.Monitor key operating expense performance metrics.

Compare Spending Vs Forecast and Vs previous Periods.Compare Spending Vs Forecast and Vs previous Periods.

8/12/2019 08_02_22_Oracle_DBI

18/85

Expense Management PagesExpense Management Pages

KPIsKPIs Expenses: Based on the accounts mapped to the OperatingExpenses financial category in the Financial Dimensionsetup.

% of Forecast: (Actual Expenses / Forecast Expenses)* 100

Forecast vs. Budget: ((Forecast Expenses - Budget

Expenses) / Budget Expenses) * 100

Expenses per Head: Total Expenses / Headcount

T&E per Head: Total Travel and Entertainment Expenses /Headcount

Headcount: Employee headcount based on the As Of date

displayed in the dashboard. The manager hierarchy used to

8/12/2019 08_02_22_Oracle_DBI

19/85

Funds Management PagesFunds Management Pages

KPIsKPIs

8/12/2019 08_02_22_Oracle_DBI

20/85

8/12/2019 08_02_22_Oracle_DBI

21/85

Benefits of P&LBenefits of P&L

Profit & Loss pages provide monitoring of revenueProfit & Loss pages provide monitoring of revenueand expenses as period progresses, allowingand expenses as period progresses, allowing

corrective action to be taken before period end:corrective action to be taken before period end:

Manage RevenueManage Revenue--generating activities based on dailygenerating activities based on dailysnapshotsnapshot

Compare actual expenses Vs Budget and forecastCompare actual expenses Vs Budget and forecast

Pinpoint actions to specific managers and areas ofPinpoint actions to specific managers and areas of

BusinessBusiness

8/12/2019 08_02_22_Oracle_DBI

22/85

Benefits of Expense ManagementBenefits of Expense Management

Expense Management page allows managers toExpense Management page allows managers totrack and manage spending to meet their budget:track and manage spending to meet their budget:

Manage Expenses to prevent overspendingManage Expenses to prevent overspending

Improve employee carefulness through targeted reviewImprove employee carefulness through targeted review

of top spenders.of top spenders. Reduce operating expenses by identifying largestReduce operating expenses by identifying largest

categories of spending.categories of spending.

Drilldown to realDrilldown to real--time transaction details enablestime transaction details enablesidentification of specific items to target for action.identification of specific items to target for action.

8/12/2019 08_02_22_Oracle_DBI

23/85

8/12/2019 08_02_22_Oracle_DBI

24/85

Benefits

Better management reportingBetter management reporting Role based ReportingRole based Reporting

Accurate and timelyAccurate and timely

Drilldown to detailsDrilldown to details

Integrated Reporting within EIntegrated Reporting within E--business suitebusiness suite Self service web accessSelf service web access

No need for a separate data warehouseNo need for a separate data warehouse

Satisfies multiple reporting needsSatisfies multiple reporting needs Transaction ReportingTransaction Reporting UsersUsers

Management ReportingManagement Reporting ManagersManagers

8/12/2019 08_02_22_Oracle_DBI

25/85

Payables Intelligence

Payables Management PagePayables Management Page

Payables Status PagePayables Status Page

8/12/2019 08_02_22_Oracle_DBI

26/85


Payables Management page empowersPayables Management page empowersmanagers to analyze process efficiencymanagers to analyze process efficiency

metrics across operating units to :metrics across operating units to :

Optimize invoice Transaction ProcessingOptimize invoice Transaction Processing

Improve invoiceImprove invoice--toto--pay cycle timespay cycle times

Maximize discount opportunitiesMaximize discount opportunities Reduce hold turnaround times.Reduce hold turnaround times.

8/12/2019 08_02_22_Oracle_DBI

27/85


Payables Status page provides payablesPayables Status page provides payablesanalyst daily actionable information to :analyst daily actionable information to : Optimize open payables positionsOptimize open payables positions

Capitalize on remaining discount opportunitiesCapitalize on remaining discount opportunities Identify critical outstanding holdsIdentify critical outstanding holds

Enhance relationships with suppliers.Enhance relationships with suppliers.

Drilldown to realDrilldown to real--time transaction details.time transaction details.

8/12/2019 08_02_22_Oracle_DBI

28/85


Content OverviewContent Overview

1 Responsibility1 Responsibility

Daily Payables IntelligenceDaily Payables Intelligence 2 Pages2 Pages

Payables ManagementPayables Management

Payables StatusPayables Status

1919 KPIsKPIs 7 Table Regions7 Table Regions

10 Graph Regions10 Graph Regions

30+ Reports30+ Reports

8/12/2019 08_02_22_Oracle_DBI

29/85

Payables Management ComponentsPayables Management ComponentsKPIsKPIs

8/12/2019 08_02_22_Oracle_DBI

30/85

8/12/2019 08_02_22_Oracle_DBI

31/85

Payables Management ComponentsPayables Management ComponentsPaymentsPayments

8/12/2019 08_02_22_Oracle_DBI

32/85

Payables Management ComponentsPayables Management ComponentsDiscountsDiscounts

8/12/2019 08_02_22_Oracle_DBI

33/85

Payables StatusPayables Status

KPIsKPIs

8/12/2019 08_02_22_Oracle_DBI

34/85

8/12/2019 08_02_22_Oracle_DBI

35/85

8/12/2019 08_02_22_Oracle_DBI

36/85

Setup steps for GL Revenue &Setup steps for GL Revenue &Expense ReportingExpense Reporting

Set Up Daily Business Intelligence Framework Set Up Manager Reporting

Define Source Ledger Group

Define Financial Dimensions Define Dimension Mapping Rules

Set Up Budgets and Forecasts

Set Up Security

Set Up Profile Options

8/12/2019 08_02_22_Oracle_DBI

37/85

Setup Global ParametersSetup Global Parameters

8/12/2019 08_02_22_Oracle_DBI

38/85

Define ContentDefine Content

8/12/2019 08_02_22_Oracle_DBI

39/85

8/12/2019 08_02_22_Oracle_DBI

40/85

Define Request SetsDefine Request SetsInit ial Load: Creates an initial request set that performs

initial loads for empty summaries and an incremental refresh

for any summaries that are not empty.

Incremental Load: Creates an incremental request set that

performs incremental refreshes for all summaries.

Clear and Load All Summaries: Creates an initial request

set that clears all populated summaries and reloads data.

8/12/2019 08_02_22_Oracle_DBI

41/85






Set Up Security


8/12/2019 08_02_22_Oracle_DBI

42/85

Manager ReportingManager ReportingSetup Checklist

Set Up HR Profile Options Create Organizations for Company Cost Center

Combinations

Run the Synchronize GL company cost centerswith HR Request Set

Validate that the Company Cost CenterOrganization Classification is Enabled

Assign Managers to the Organization

Run HRI Load All Cost Center Managers

Manager ReportingManager Reporting

8/12/2019 08_02_22_Oracle_DBI

43/85


HR Profile OptionsHR Profile Options HR: GL organization name format

-

--

HR: GL Cost Center Org Synchronization Options Synchronize only:

Synchronize and add missing classifications:

Synchronize and add missing classifications and organizations:

HR: GL Cost Center Org Classifications None:

Company Cost Centers:

HR Organizations and Company Cost Center: HR: Automatically Synchronized Single GL Company

Cost Center with HR Yes

No

8/12/2019 08_02_22_Oracle_DBI

44/85


8/12/2019 08_02_22_Oracle_DBI

45/85

8/12/2019 08_02_22_Oracle_DBI

46/85


8/12/2019 08_02_22_Oracle_DBI

47/85


8/12/2019 08_02_22_Oracle_DBI

48/85


8/12/2019 08_02_22_Oracle_DBI

49/85


8/12/2019 08_02_22_Oracle_DBI

50/85

8/12/2019 08_02_22_Oracle_DBI

51/85






Set Up Security


8/12/2019 08_02_22_Oracle_DBI

52/85

Define Source Ledger GroupsDefine Source Ledger Groups

8/12/2019 08_02_22_Oracle_DBI

53/85

8/12/2019 08_02_22_Oracle_DBI

54/85

Financial Dimensions

8/12/2019 08_02_22_Oracle_DBI

55/85


Set Up Daily Business Intelligence Framework

Set Up Manager Reporting




Set Up Security


8/12/2019 08_02_22_Oracle_DBI

56/85

Dimensions

Setting up DBI for Financials-specificdimensions enables you to map data from

different chart of accounts structures to a

single structure, which makes it possible todo enterprise-wide aggregation of financial

data.

8/12/2019 08_02_22_Oracle_DBI

57/85


Company

Cost Center

Financial Category

Line of Business

User Defined

8/12/2019 08_02_22_Oracle_DBI

58/85

Dimensions

8/12/2019 08_02_22_Oracle_DBI

59/85

Financial Category Dimension

This dimension is based on the naturalaccount segment from the different charts of

accounts that you have defined in the

source ledger group.

8/12/2019 08_02_22_Oracle_DBI

60/85

Line of Business Dimension

A line of business can be a grouping ofcompanies or cost centers that crosses

country boundaries and legal entities, such

as General and Administrative, Sales,Support, Manufacturing, and so on. The

following diagram displays an example of

grouping cost centers to define a CustomerSupport line of business.

8/12/2019 08_02_22_Oracle_DBI

61/85

Loading Financial Dimensions

8/12/2019 08_02_22_Oracle_DBI

62/85

8/12/2019 08_02_22_Oracle_DBI

63/85


8/12/2019 08_02_22_Oracle_DBI

64/85



8/12/2019 08_02_22_Oracle_DBI

65/85

- Master Value Set

8/12/2019 08_02_22_Oracle_DBI

66/85

8/12/2019 08_02_22_Oracle_DBI

67/85


8/12/2019 08_02_22_Oracle_DBI

68/85


8/12/2019 08_02_22_Oracle_DBI

69/85

Financial Dimensions Hierarchy Manager

8/12/2019 08_02_22_Oracle_DBI

70/85

y g

Create New Parent

8/12/2019 08_02_22_Oracle_DBI

71/85

Financial Dimensions Hierarchy Manager

8/12/2019 08_02_22_Oracle_DBI

72/85

y g

Edit Ranges

Define Financial Category

8/12/2019 08_02_22_Oracle_DBI

73/85

Cost Center Dimension

8/12/2019 08_02_22_Oracle_DBI

74/85

8/12/2019 08_02_22_Oracle_DBI

75/85

8/12/2019 08_02_22_Oracle_DBI

76/85

8/12/2019 08_02_22_Oracle_DBI

77/85

Define Security ProfileDefine Security Profile

8/12/2019 08_02_22_Oracle_DBI

78/85

yy

Define Security ProfileDefine Security Profile

8/12/2019 08_02_22_Oracle_DBI

79/85

yy

Assign Security ProfileAssign Security Profile

8/12/2019 08_02_22_Oracle_DBI

80/85

g yg y

Operating Unit ListOperating Unit List

8/12/2019 08_02_22_Oracle_DBI

81/85

8/12/2019 08_02_22_Oracle_DBI

82/85

8/12/2019 08_02_22_Oracle_DBI

83/85

Benefits SummaryBenefits Summary

DBI satisfies the following business needs:

Ability to provide integrated reporting information within E-

business suite

Ability to access information easily

Ability to provide accurate, timely and relevant information

Ability to drilldown to details from summary

8/12/2019 08_02_22_Oracle_DBI

84/85

Daily Procurement IntelligenceDaily Procurement Intelligence

8/12/2019 08_02_22_Oracle_DBI

85/85

DBIDBI

08_02_22_oracle_dbi

Documents