Taking solutions global Blue Scope Steel tackles the

  • Slides: 23
Download presentation
Taking solutions global? Blue. Scope Steel tackles the Globe: Bringing OBIA worldwide! Prepared by:

Taking solutions global? Blue. Scope Steel tackles the Globe: Bringing OBIA worldwide! Prepared by: Cory Whited, Grant Thornton Barb Viola, Blue. Scope Steel North America @ Grant. Thornton Session ID: 10614

Cory Whited Cory is a Business Analytics Associate within Grant Thornton’s Technology Solutions Practice,

Cory Whited Cory is a Business Analytics Associate within Grant Thornton’s Technology Solutions Practice, focused on delivering functional and technical knowledge combined with industry acumen. Cory thrives on expanding customers' ability to understand utilize data to more effectively leverage information, plan for the future and achieve growth objectives. Currently based out of the Washington, D. C. market, Cory has experience in the Financial Services, Manufacturing and Supply Chain industries and has provided services on both the National and International Level. Cory has achieved certifications in Oracle BI Foundation Suite 11 g, Oracle BI Cloud Services, Oracle Essbase 11, and Tableau Desktop 9. April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Barb Viola Barb is a Business Intelligence Analyst/Developer at Blue. Scope Buildings North America

Barb Viola Barb is a Business Intelligence Analyst/Developer at Blue. Scope Buildings North America (BBNA). Her responsibilities include integrating ERP data into the BI data warehouse, with a primarily focus on RPD work and creating reports. She has worked with OBIEE for the past 4 years. Barb earned by degrees from Blackhawk Technical College with dual Associate degrees in Information Technology and Programming. She previously worked at Varco Pruden Buildings for 26 years before working at BBNA for the past 9 years. April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Blue. Scope buildings overview Blue. Scope Buildings • Manufactures world-leading steel products and solutions

Blue. Scope buildings overview Blue. Scope Buildings • Manufactures world-leading steel products and solutions principally for the global building and construction industries. • Global leader in engineered building solutions comprising Blue. Scope's businesses in North America, China, Indonesia, Malaysia, Thailand, Vietnam, and India. April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

About Grant Thornton We are the U. S. member firm of Grant Thornton International,

About Grant Thornton We are the U. S. member firm of Grant Thornton International, a global organization of member firms providing audit, tax and advisory services to clients for more than 90 years. Over 10% revenue growth in the U. S. last year with a 13% increase in headcount $1. 56 bn revenues PEOPLE PARTNERS • • 35% of the companies on the 2015 Fortune 1000 list 39% of the companies on the 2015 Fortune 500 list 54% of the companies on the 2015 Fortune 100 list 25% of the companies on the Russell 2000 list OFFICES April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Roadmap to Global Blue. Scope NA was seeking to: • Stabilize their Oracle BI

Roadmap to Global Blue. Scope NA was seeking to: • Stabilize their Oracle BI suite • Continue steady state activities while allowing migration and platform expansion • Develop a roadmap to deploy new business units in China! April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Blue. Scope in China • Acquired several manufacturing plants throughout China • Plants furthered

Blue. Scope in China • Acquired several manufacturing plants throughout China • Plants furthered production capabilities to turns raw materials into products and building solutions Steel Roof, structural, and wall systems, fasteners, sealants Textile, logistics, refurbishment solutions Stadiums, plants, farms, facilities, Buildings April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

OBI Health Check Security and End User Experience Overview Current Score Future Score ETL

OBI Health Check Security and End User Experience Overview Current Score Future Score ETL and Load Processing 2. 20 4. 20 Reporting Performance 2. 70 3. 95 Infrastructure 3. 10 3. 75 2. 45 3. 90 3. 17 3. 97 OBIA Extension Analysis Reporting Performance Security and End User 3. 95 Experience 3. 97 Ratings Breakdown 3. 90 OBIA Extension Analysis 5 - Exceptional 3. 75 4 - Highly Effective Infrastructure 3 - Proficient 2 - Inconsistent 1 – Low Performance April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Objectives for China • Incorporate E-Business Suite (EBS) data from Blue. Scope NA’s five

Objectives for China • Incorporate E-Business Suite (EBS) data from Blue. Scope NA’s five China locations into their existing data warehouse • Configure ETL processing and revise configuration to accept foreign data and Chinese characters • Integrate the customizations of the Suzhou plant into the existing single OBI instance April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

China reporting discoveries 1) Global EBS instance • Not all China plants were using

China reporting discoveries 1) Global EBS instance • Not all China plants were using a global EBS instance • OBIA Informatica-based ETL was previously customized to extract US data only 2) Custom reporting • Suzhou plant required customized mappings and reporting structure • Brought into RPD as a custom subject area April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Global EBS instance – database impact • NLS_CHARACTERSET = AL 32 UTF 8 which

Global EBS instance – database impact • NLS_CHARACTERSET = AL 32 UTF 8 which sets the encoding • NLS_LANG should be set to UTF-8 • NLS_LENGTH_SEMANTICS should be set to CHAR • Making sure that standard OBIA tables, as well as custom table definitions, do not have explicit BYTE semantics specifications • Higher space consumption, caution should be exercised when setting block size for Oracle instance • Connection settings in Informatica should be adjusted April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Global EBS instance – Informatica to ODI • Informatica based ETL is 80% customized

Global EBS instance – Informatica to ODI • Informatica based ETL is 80% customized • Custom and standard code was manually reverse engineered to understand the logic • While pre-processing happens on the source side - impact analysis of the replacement takes time • DAC 11 g is utilized to fire Informatica mapping and ODI workflows in parallel • New developments are all in ODI, Informatica is maintenance only April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Global EBS instance – Informatica to ODI Informatica • Loads data into its own

Global EBS instance – Informatica to ODI Informatica • Loads data into its own memory before applying transformation commands, even when input data exists in data warehouse staging schema Oracle Data Integrator (ODI) • ODI lets the data stay in the database and applies transformation logic in the form of SQL functions April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Global EBS instance – ETL Impact • A new integration service with Unicode data

Global EBS instance – ETL Impact • A new integration service with Unicode data movement mode should be set up with data codepage validation turned off • In the OS environment: • INFA_CODEPAGE, LC_ALL, LANG and NLS_LANG variables should be defined that correspond to UTF-8 • NLS_LANG should match the database server. NLS and LC variables must match with repository service configuration April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

One Global instance – Unicode • Had to create a new repository service schema

One Global instance – Unicode • Had to create a new repository service schema in a database where NLS_CHARACTERSET is AL 32 UTF 8 • Configure database properties and environment variables • Update parameters 建筑解决方案 April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Blue. Scope Steel Suzhou • Blue. Scope Steel coated China transformed into an import

Blue. Scope Steel Suzhou • Blue. Scope Steel coated China transformed into an import and distribution business, specifically for metallic coating and coil painting April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

One global instance – reporting • Creation of custom reports and dashboards • Business

One global instance – reporting • Creation of custom reports and dashboards • Business and management level • Focus on creating reports to be multi lingual and meet unique business structure requirements Business departments • Customer service • Finance • Inspection • Maintenance • Manufacturing • Planning • Purchasing • Sales April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Training April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Training April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Current state of Blue. Scope reporting April 2 -6, 2017 in Las Vegas, NV

Current state of Blue. Scope reporting April 2 -6, 2017 in Las Vegas, NV USA #C 17 LV

Q& A

Q& A

Contact us Cory Whited – Cory. Whited@us. gt. com Barb Viola – Barb. Viola@bluescopebuildingsna.

Contact us Cory Whited – Cory. [email protected] gt. com Barb Viola – Barb. [email protected] com

Please look for those wearing Education Committee ribbons to share feedback on this week’s

Please look for those wearing Education Committee ribbons to share feedback on this week’s sessions!

Please Complete Your Session Evaluate this session in your COLLABORATE app. Pull up this

Please Complete Your Session Evaluate this session in your COLLABORATE app. Pull up this session and tap "Session Evaluation" to complete the survey. Session ID: 10614