Oracle Aleris. Click to edit Master text styles. Click to edit Master title style. Click to edit Master text styles

(1)

Click to edit Master title style

Click to edit Master text styles

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Oracle Analytics @ Aleris

March 2014

(2)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Overview & Introduction to BI @ Aleris

Bob Petro

(3)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

WHO WE ARE

Rolled & Extruded Products Recycling & Specification Alloys Privately-held

Headquartered in Cleveland, OH 2012 revenue: approx. $4.4 billion More than 7000 employees worldwide More than 40 production facilities

– Highly-efficient

– Flexible

– Technologically-advanced

(4)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

WHO WE ARE

Aleris participates in select segments of the aluminum fabricated products industry

Industry Position

End use applications Processing Recycling Bauxite mining Alumina refining Aluminum smelting

(5)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

A GLOBAL PLATFORM

Facilities in Key Locations Worldwide

North America

Europe

(6)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Global BI Team

Drive Culture Towards Analytics and Data Driven Decisions. Mark Macioce Director IT Bob Petro BI Manager Mark Whitlock BI Architect

(7)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Oracle Analytics Deployments Progress

(8)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customizations

Mark Whitlock

(9)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Who am I ?

• OBIEE Administrator

• Oracle BI Applications Administrator • Informatica Developer

• Oracle DBA

• Dashboard / Reports Developer

What I do ?

• Implement and Maintain US & European instances of OBIEE/OBIA

(10)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

What was the issue?

• Original departmental procurement

implementation was not strategically focused.

• Global platform

–

common configurations

• Aleris Spend Category

–

non standard

• Finance utilization of UNSPSC codes

(11)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Why use a Spend Classification Hierarchy?

• Aberdeen Group

Best Practices in Spending Analytics

–

Cure for the

Corporate Epidemic

(12)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

What Must be done to implement?

• Common Configurations

- Mandatory configurations completed

• Procurement configuration

- Procurement configs revisited

• Database tables altered

• DAC altered

(13)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

A way to classify products and services.

What is UNSPSC Code ?

U

nited

N

ations

S

tandard

P

roduct

S

ervices

C

ode

http://www.unspsc.org

(e.g. Business justification, Code Search, Training, etc)

(14)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

What methods are available in OBIA to

implement UNSPSC CODES?

• ORACLE Spend Classification

• Spend classifications parts CSV file

(Technote

–

16231019)

(15)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

UNSPC code usage at Aleris?

• Inventory part classification in matl_categories_b

• Oracle ERP R12.1.3

(16)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Overview of Customization:

• UNSPSC code was being applied to purchase orders in

ORACLE ERP

• Extract the category_id and bring it into the Oracle Business

Analytics Warehouse (OWAB)

• New tables and views in the OBAW for Products and

Products Hierarchy tables.

(17)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Overview of

Customization (cont’d):

• Two

new PLP’s

created to synchronize W_AP_INV_DIST_F

enabled UNSPSC code to be queried from PO Invoice

Distribution and Spend subject areas.

• Modified the RPD

• Modified the Webcat

• Created Analysis in PO Invoice Distribution Subject Area

using UNSPSC codes

(18)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Customization Challenges

• No customization had yet been made

• First need to create:

Custom Workflow folder - DAC

Custom Subject Area- DAC

Custom Execution Plan - DAC

Custom Workflow

–

Informatica

• Once the workflow were in place they had to be sequenced

to run in an order that updated the fact tables first, then the

product data hierarchy and product tables so all the foreign

keys would be create.

(19)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Aleris Option

:

Customizations using UNSPSC_WID

Create three custom PLP_ workflows

PLP1 - W_AP_INV_DIST_F

PLP2 - W_PRODCAT_DH

PLP3 - W_PRODUCT_D

(20)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Outcome

• Aleris now has standardized product hierarchy utilizing

UNPSC code

• Can now utilized all the features of OBIA 7.9.6.4

- GL segments for AP accounts - Small Business Classification - Employee Expenses

- Supplier Performance - AP Aging

(21)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Future Considerations

• Classification of internal product such as scrap types and

raw material purchases

• Integration of external spend sources

(22)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level

Click to edit Master text styles

Aleris Procurement Customization

Questions

Mark Macioce Director, IT (216) 910-3195 mark.macioce@aleris.com Bob Petro Manager, BI (216) 910-3463 bob.petro@aleris.com Mark Whitlock Oracle Architect (216) 910-3425 mark.whitlock@aleris.com

(23)

Click to edit Master title style

– Second level

• Third level

– Fourth level

» Fifth level