{"id":14387,"date":"2021-03-05T18:24:06","date_gmt":"2021-03-05T18:24:06","guid":{"rendered":"https:\/\/oxfordcorp.com\/?p=14387"},"modified":"2023-10-24T10:46:52","modified_gmt":"2023-10-24T10:46:52","slug":"standardized-sap-hana-reporting-tool","status":"publish","type":"post","link":"https:\/\/www.oxfordcorp.com\/es\/insights\/case-study\/standardized-sap-hana-reporting-tool\/","title":{"rendered":"Standardized SAP HANA Reporting Tool"},"content":{"rendered":"<div class=\"case-study__overview-container\">\n<div class=\"table\">\n<div class=\"table-row\">\n<div class=\"table-cell overview\">\n<div class=\"table\">\n<div class=\"table-row\">\n<div class=\"table-cell\">\n<div class=\"h3\"><strong>INDUSTRY<\/strong><\/div>\n<p>Multinational Beauty Company<\/p>\n<\/div>\n<div><\/div>\n<div class=\"table-cell\">\n<div class=\"h3\"><strong>SERVICES<\/strong><\/div>\n<p>Project Management<\/p>\n<\/div>\n<div><\/div>\n<div class=\"table-cell\">\n<div class=\"h3\"><strong>SKILLS<\/strong><\/div>\n<p>SQL<br \/>\nSAP BW\/4HANA<br \/>\nBusiness Objects<br \/>\nHANA AMDPs<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"case-study__challenge\">\n<div><\/div>\n<div class=\"h3\"><strong>The Challenge<\/strong><\/div>\n<div class=\"field field--name-field-challenge field--type-text-long field--label-hidden field__item\">\n<p>An American multinational beauty company wanted to deliver considerable savings as part of its annual planning process. However, they had no common tool capable of reporting contribution margins. As a result, they required a partner who could provide a standardized tool using SAP HANA\u2122 that would support the decision-making process at the SKU, brand, house, company, and regional level. This tool would provide detailed portfolio management, pricing strategies, productivity opportunities, and product reformulation. The key goals were:<\/p>\n<ul>\n<li>A standard set of formulas and financial allocation\u00a0rules across all divisions<\/li>\n<li>Guaranteed accuracy of data aligned with corporate consolidation reporting<\/li>\n<li>Complex margin bridge calculations presented via an intuitive range of KPIs<\/li>\n<li>Allocation engine and SQL HANA views processing big data efficiently and faster pre-established performance benchmarks<\/li>\n<li>Analytical and visual dashboard-style reports<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"case-study__solution\">\n<div><\/div>\n<div class=\"h3\"><strong>The Solution<\/strong><\/div>\n<div class=\"field field--name-field-solution field--type-text-long field--label-hidden field__item\">\n<p>Oxford provided a small, but versatile team including a Solution Architect, Technical Architect, Lead Developer, and Project Manager. These professionals delivered an end-to-end technical solution and full project management support. By utilizing hands-on architects with strong techno-functional experience, we were able to create a self-sufficient delivery team. They were able to quickly address the various challenging requirements that surfaced during the project lifecycle. This approach allowed technical decisions to be considered and implemented very quickly in an Agile environment.<\/p>\n<p>The project was split into three phases \u2014 each building on the success of the previous. The final solution delivered a suite of 14 reports providing detailed analysis by customer, SKU, and individual brands, all supported by graphical analysis.<\/p>\n<p>The solution was built using SAP BW\/4HANA\u2122 SP7 backend, with reporting provided via Business Objects\u2122 analysis. The project used HANA AMDPs in transformations and custom planning functions with a backdrop of ABAP for HANA to reap the benefits of greatly improved performance (both loading and runtime) and supportability of custom logic code. The solution was aligned with SAP best practices utilizing the latest BW\/4HANA technologies including BPC embedded planning framework.<\/p>\n<\/div>\n<\/div>\n<div class=\"case-study__results\">\n<div><\/div>\n<div><\/div>\n<div class=\"h3\"><strong>The Result<\/strong><\/div>\n<div class=\"field field--name-field-result field--type-text-long field--label-hidden field__item\">\n<p>The project was delivered on-time and on-budget. The current solution forms the foundation for future business analysis and further enhancements as the overall business take-up increases. The tool now supports a harmonized and coordinated approach across the business when reviewing gross margins, profitability, SKU rationalization, and marketing value analysis.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0<\/p>\n","protected":false},"author":10,"featured_media":14760,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[181],"tags":[251],"category-tag":[],"class_list":["post-14387","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-study","tag-technology-communications"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.1 (Yoast SEO v27.1.1) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Standardized SAP HANA Reporting Tool - Oxford Global Resources<\/title>\n<meta name=\"description\" content=\"When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Standardized SAP HANA Reporting Tool\" \/>\n<meta property=\"og:description\" content=\"When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"Oxford Global Resources\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-05T18:24:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-24T10:46:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"516\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Luke Summers\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Summers\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\"},\"author\":{\"name\":\"Luke Summers\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3\"},\"headline\":\"Standardized SAP HANA Reporting Tool\",\"datePublished\":\"2021-03-05T18:24:06+00:00\",\"dateModified\":\"2023-10-24T10:46:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\"},\"wordCount\":394,\"image\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg\",\"keywords\":[\"Technology &amp; Communications\"],\"articleSection\":[\"Case Study\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\",\"url\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\",\"name\":\"Standardized SAP HANA Reporting Tool - Oxford Global Resources\",\"isPartOf\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg\",\"datePublished\":\"2021-03-05T18:24:06+00:00\",\"dateModified\":\"2023-10-24T10:46:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3\"},\"description\":\"When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage\",\"url\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg\",\"contentUrl\":\"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg\",\"width\":1600,\"height\":430,\"caption\":\"standardized sap hana reporting tool resized\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.oxfordcorp.com\/es\/final-homepage-2\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Standardized SAP HANA Reporting Tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#website\",\"url\":\"https:\/\/www.oxfordcorp.com\/de\/\",\"name\":\"Oxford Global Resources\",\"description\":\"Global\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.oxfordcorp.com\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3\",\"name\":\"Luke Summers\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g\",\"caption\":\"Luke Summers\"},\"url\":\"https:\/\/www.oxfordcorp.com\/es\/insights\/author\/lsummersthiel-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Standardized SAP HANA Reporting Tool - Oxford Global Resources","description":"When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/","og_locale":"es_ES","og_type":"article","og_title":"Standardized SAP HANA Reporting Tool","og_description":"When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0","og_url":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/","og_site_name":"Oxford Global Resources","article_published_time":"2021-03-05T18:24:06+00:00","article_modified_time":"2023-10-24T10:46:52+00:00","og_image":[{"width":1920,"height":516,"url":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg","type":"image\/jpeg"}],"author":"Luke Summers","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Luke Summers","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#article","isPartOf":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/"},"author":{"name":"Luke Summers","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3"},"headline":"Standardized SAP HANA Reporting Tool","datePublished":"2021-03-05T18:24:06+00:00","dateModified":"2023-10-24T10:46:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/"},"wordCount":394,"image":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg","keywords":["Technology &amp; Communications"],"articleSection":["Case Study"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/","url":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/","name":"Standardized SAP HANA Reporting Tool - Oxford Global Resources","isPartOf":{"@id":"https:\/\/www.oxfordcorp.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage"},"image":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg","datePublished":"2021-03-05T18:24:06+00:00","dateModified":"2023-10-24T10:46:52+00:00","author":{"@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3"},"description":"When an American multinational beauty company wanted to deliver cost savings, they needed to implement a standardized tool to report contribution margins. Discover how Oxford delivered a suite of 14 reports providing detailed, graphical\u00a0analysis.\u00a0","breadcrumb":{"@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#primaryimage","url":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg","contentUrl":"https:\/\/www.oxfordcorp.com\/wp-content\/uploads\/2021\/03\/standardized_sap_hana_reporting_tool_resized.jpeg","width":1600,"height":430,"caption":"standardized sap hana reporting tool resized"},{"@type":"BreadcrumbList","@id":"https:\/\/www.oxfordcorp.com\/insights\/case-study\/standardized-sap-hana-reporting-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oxfordcorp.com\/es\/final-homepage-2\/"},{"@type":"ListItem","position":2,"name":"Standardized SAP HANA Reporting Tool"}]},{"@type":"WebSite","@id":"https:\/\/www.oxfordcorp.com\/de\/#website","url":"https:\/\/www.oxfordcorp.com\/de\/","name":"Oxford Global Resources","description":"Global","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oxfordcorp.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/e880f6edc6bcf421204f294431943cd3","name":"Luke Summers","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.oxfordcorp.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d7d4c9724f33e3a19ac78af573b29ed6164c2ceffe51f72aff7df98b279e3de?s=96&d=mm&r=g","caption":"Luke Summers"},"url":"https:\/\/www.oxfordcorp.com\/es\/insights\/author\/lsummersthiel-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/posts\/14387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/comments?post=14387"}],"version-history":[{"count":0,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/posts\/14387\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/media\/14760"}],"wp:attachment":[{"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/media?parent=14387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/categories?post=14387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/tags?post=14387"},{"taxonomy":"category-tag","embeddable":true,"href":"https:\/\/www.oxfordcorp.com\/es\/wp-json\/wp\/v2\/category-tag?post=14387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}