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

23  Download (0)

Full text

(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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– 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

Click to edit Master text styles

– Second level

• Third level

– Fourth level

» Fifth level

Figure

Updating...

References

Related subjects :