AstraZeneca Bi Reports
Case Study :
AstraZeneca is a British multinational pharmaceutical and biopharmaceutical company .AstraZeneca has a portfolio of products for major disease areas including cancer, cardiovascular, gastrointestinal, infection, neuroscience, respiratory and inflammation.
Business Requirement :
To bring in efficiency in the sales and service process, it was identified to mobilize the processes like Management, Service Order Tracking and Approval,
Solution :
- Understand and act upon data,
- Reporting’s goal is the first–to enable end-users to see data so
- We can analyze it and make it understandable through analysis.
Scope of work :
- Collecting and presenting data ready to be analyzed,
- Having the underlying figures to back up actions and explain decisions
- Empowering end-users with the knowledge to become experts in their area of business,
Example:
Components
List box, charts, cross tab, date function, icon,
Dimensions :
Vehicles, vendors, date, shifts, locations.
Measures :
Net load ability, number of trips ,
Data source :
Hana views
Report type :
Analysis olap for edition
Requirement
- Decision making reports with cube data
- Develop the hierarchies
- Develop the analysis reports and decision making reports
Business intelligence adoption in the retail chain
Case Study :
Business Intelligence (BI) tools are adopted by more and more companies in the current environment that requires companies to operate as efficiently as possible, Business intelligence, adoption, diffusion of innovations theory, system life cycle, benefits, retail chain, speed of adoption.
Business Requirement :
To increase the efficiency of management in retail chains on an ongoing basis and the growing pressure of cost efficiency in this field require the use of different approaches,
Solution :
- Improved ability to anticipate earlier the possible threats and opportunities
- Increase of sharing information
- Improved efficiency
- Problem definition
Scope of work :
- BI can produce many benefits if it is implemented well.
- BI is a wide term that is commonly used for technologies, applications,
- To gather, store, access and analyses data for better decision-making.
Example:
Components
List box, charts, cross tab, date function, icon
Dimensions :
Vehicles, vendors, date, shifts, locations.
Measures :
Net load ability, number of trips ,
Data source :
Hana views
Report :
Sap lumira discovery
Requirement
- Define the vehicle status date wise ,shift wise and location wise?
- Create adhoc analysis reports
- Create table format reports
- Create KPI dashboards, various charts
SAP Business Objects Implementation
Case Study :
Install and configure SAP Business Objects Enterprise (BOE) in 5 environments
Business Requirement :
Business requirements are the critical activities of an enterprise that must be performed to meet the organizational objective(s)while remaining solution independent.
Agenda :
- ✓ SAP Business Objects BI Platform 4.0 implementation
- ✓ Security Design
- ✓ BI Strategy & Governance Documents
- ✓ Current State
Solution :
- Project development environment
- Quality Assurance
- Migration form Developer to Admin.
Scope of work :
- Best Practices for Reporting
- Dashboards with SAP BW,Hana
- Describes the Architecture design for deployment of SAP Business Objects BI 4.0.
Example:
BO Client Installation and configuration
- You must have Administrative rights to download these from the Market Place.
- Chose BOBI 4.0 here
- Click on Installation and Upgrade
- Click ADD to Download Basket download the “SAP Download Manage
Configuration :
- Go to Start –> Run –> Drivers giving full access right to your system id
- Go to CMC –> Click on sessions
- Let’s logon to Universe Designer Tool
Requirement
Bo installation part step by steps
Roche Health Care- webi Reports
Case Study :
Roche was one of the first companies to bring targeted treatments to patients. With our combined strength in pharmaceuticals and diagnostics, we are better equipped than any other company to further drive personalized healthcare. Two-thirds of our Research and Development projects are being developed with companion diagnostics.
Business Requirement :
Provide direction for the successful completion of development and support of processes, analyze business processes and requirements and identify potential areas for improvement of the business processes.
Solution :
- ✓ Carried out the analysis of the Defects and the necessary
- ✓ Changes to close that bug during unit and
- ✓ System testing phases.
Scope of work :
- Estimation of change request.
- Discussing the reviews, status of the tasks/changes.
- Developed Universe based reports using web intelligence.
Example:
Components
Pie chart, line chart ,Linking
Dimension:
City
Measure:
SR , Quantity sold
Data source :
Universe
Requirement
Develop the universe in universe, use in webi report in element linking for decision making reports to give the better information
One element should control all elements and use in analysis reports.
Social Services Agency Dashboard Reports
Case Study :
The County of Santa Clara is the most populous county in the San Francisco Bay area, and home to California’s Silicon Valley.
Business Requirement :
The SSA consists of a number of departments of which the Department of Employment & Benefit Services(DEBS) is the largest consumer of business intelligence with the largest number of BI users.
Solution :
- ✓ The SSA is to contact APOS Systems to investigate.
- ✓ APOS Storage Center lets the SSA manage.
- ✓ Business Objects storage requirements more efficiently.
- ✓ Providing immediate access to backed-up and archived document
Scope of work :
- Carry out their plan to integrate the SAP Business Planning
- BO system consuming system resources and impacting system performance
- It were looking forward to working with multi-source universes, BI Mobile, and Design Studio dashboards, as well as the transition to Query as a Web Service (QaaWS).
Example:
Components
Spared sheet,
Dimension:
City, state, store name
Measure:
SR , Quantity sold
Data source :
Universe
Report :
Dashboard
Requirement
- Use query as web service
- Develop the report in xcelsius and use with some components
- Develop the report with web service query.
- Develop with different component
Shell- SAP BI Reports
Case Study :
Shell Oil Company is the United States-based wholly owned subsidiary of Royal Dutch Shell, transnational corporation “oil major” of Anglo-Dutch origins, which is amongst the largest oil companies in the world. Approximately 22,000 Shell employees are based in the U.S. The U.S. headquarters are in Houston, Texas.
Business Requirement :
BI, developed primarily as a system to solve analytical tasks, is generally considered to be a way of better decision-making, reducing costs and improving the quality of processes and performance. However, there are different definitions of BI.
Solution :
- ✓ Faster, more accurate reporting.
- ✓ Improved decision making
- ✓ Increased revenue.
Scope of work :
- Developed universes , reports using Designer
- Acquiring up-to-date and better quality information for decision- making
- Easy automated backup, archive and delete processes
- Ease of use.
Example:
Components
Line chart, table, list box, dropdown, data function
Dimension:
Ld 1,2,3,4
Measure:
SR , count
Data source :
Universe
Requirement
- Date wise , location wise what is vehicle count, and total quantity should display in line column two axis chart
- Date wise , what is the quantity transferred in column chart
- Total quantity transferred in tables
- Show future document details
- Filter the vehicle summary ,quantity transferred ,future document, through locations
- Use date function from date up to to date
Air products – SAP Bo Migration
Case Study :
Air Products (NYSE:APD) is a world-leading Industrial Gases company in operation for over 75 years. Air Products is also the world’s leading supplier of liquefied natural gas process technology and equipment.
Business Requirement :
Financial client needed to upgrade report from SAP BI Version 3.1 to 4.1 Front end application users reports are generated using data from data hub.
Solution :
- ✓ Including improved data access, usability and integration.
- ✓ To embrace the future of business intelligence within our organization
- ✓ Compare security between versions to determine what changed during the migration, documents, universes and security.
Scope of work :
- Reduce Timeline and Budget for SAP Business Objects 4.1 Migration
- HQ Sales.
- Migration More Secure & Under Control – Documentation/Audit of the system.
- Improve performance tuning.
Example:
Upgrade management Tool BI from 3.1 to 4.1
Complete Upgrade
Log on complete upgrade
Select Live to Live
BIAR to Live
Live to BIAR
Choose to include or exclude any of the object type listed below :
Check the upgrade status
Upgraded successfully
Incremental Upgrade :
Select Live to Live
BIAR TO LIVE
Select Export installation
Select objects
Export page
Upgraded successfully
Rebate- SAP Web Intelligence Reports
Case Study :
The Rebate Accrual Application Engine process (PO_VRBTACCR) calculates earned rebates for transactions that are related to purchase orders, such as receipts, vouchers, and return to vendors (RTVs). The Rebate Accrual process identifies all purchase order lines that have vendor rebate agreements defined.
Business Requirement :
Web Intelligence is a simple to use tool for the production of reports with the help of a web browser. CubeServ will support you with regard to the planning and designing of reports and applications with Webi.
Solution :
- ✓ SAP Business Objects storage requirements more efficiently
- ✓ Improved customer service.
- ✓ Better quality information acquired for decision-making
- ✓ Safeguarding their documents.
Scope of work :
- Interactive Viewing Over the Web.
- Track Data Changes
- Improved Prompting .
- Significant Performance Benefits
Example:
Components:
Table
Dimensions:
Year, state
Measures:
SR;
Prompt :
Single
Requirement 1 :
I want to give prompt , that report should be worked on prompt
Components:
Table
Dimensions:
Year, state
Measures:
SR;
Drill down :
3 tire
Requirement 2 :
To better analysis as hierarchy used the drill down option.
IBMD -SAP Design Studio Reports
Case Study :
IBMD Solution for an Indian multinational steel-making company. IBMD is a profit centre and deals in a variety of by-products and scrap in the entire value chain of the steel company. It handles more than 13 MnTPA with more than 25 products and 150+ SKUs in its portfolio.
Business Requirement :
To bring efficiency in Fleet Management System, Vehicle Tracking System, which allows transportation companies in business to minimize the risk related with the improving efficiency,
Solution :
- ✓ Reduce fleet management time and cost
- ✓ Integrate fleet planning and execution
- ✓ Improved customer service.
- ✓ Better quality information acquired for decision-making
- ✓ Easier information acquisition and analysis faster decision-making.
Scope of work :
- Design and development of the The reports in design studio application
- Understanding the meaning of information.
- Testing and support till UAT
- Easy automated backup, archive and delete processes
- Improve performance tuning.
Example:
Components:
List box, charts, cross tab, date function, icon,
Dimensions:
Vehicles, vendors, date, shifts, locations.
Measures:
Net load ability, number of trips
Data source:
Hana views
Requirement 1 :
Date wise , at location, what is net_ load ability?
Thane net_load ability ,i want to see and filter through vendor filter, vehicle filter, location filter.
Requirement 2 :
Date wise,shift wise,at location,what is net_load ability?
That net _load ability ,i want to see and filter through vendor filter, vehicle filter, location filter.
Requirement 3 :
Location wise how many trips is there and 70%, 75%, 85% how many trips is there?
I want to see and filter through vendor filter, vehicle filter, location filter.
Requirement 4 :
Location wise and vehicle wise, net _ load ability?
Date function: To know date information from date up to To date.
Refresh( icon): This is used to refresh the data.
Background: To improve report performance
Web & Mobile Application
Fiori Apps for Warehouse Management
Case Study :
A Web application to manage the Student Lifecycle in universities in India
Business Requirement :
Develop a Web based solution to manage Student Lifecycle processes for Universities in India in a cloud hosted model
Solution :
A web based solution in a cloud hosted model to manage the Student Lifecycle processes like Admission, Registration, Couselling, Examination, Admit Cards, Results, Marks Cards, Certificates, etc.
Scope of work :
- Develop the Web application
- Conceptualization & Design
- Functional & Feature design
- Server configuration & Support
- New features & enhancements
SAP S/4 Hana Custom development
Design Studio dashboard and Reports
Case Study :
A Web and Mobile application to manage the parcel delivery process in a marketplace model for companies in France
Business Requirement :
Develop a Web and Mobile based solution to manage the parcel delivery processes for companies in France in the marketplace model
Solution :
A web and mobile based solution to deliver parcels across France for various companies in a market place model. Deliveries are executed by registered drivers using their own vehicles
Scope of work :
- Develop the Web & Mobile applications
- Conceptualization & Design
- Functional & Feature design
- Server configuration & Support
SAP S/4 Hana Custom development
SAP HCM L2 Support
Case Study :
Develop and Extend S/4 Hana applications for a global steel manufacturer in India
Business Requirement :
Develop and Extend Fiori applications on S/4 Hana for different business processes in FI, MM and WM. Also develop dashboards and reports using Lumira with Hana as the backend system.
Solution :
Development of Fiori applications using the Fiori 2.0 design principles and based on S/4 Hana as the backend system using different data models like CDS, AMDP. Designing of data models. Development of dashboards and reports based on the Hana data models.
Scope of work :
- Design and development of the Fiori 2.0 applications
- Development of the oData services and ABAP-Hana
- Design and development of Hana data models
- Development of dashboards and reports using Lumira
- Testing and support till UAT
SAP HCM Support
SAP HCM L2 Support for the ICT, Qatar
Case Study :
SAP HCM L2 Support for the ICT, Qatar
Business Requirement :
Provide offshore L2 support for ICT Qatar for the various SAP HCM modules and SAP Portal
Solution :
An 8 member offshore L2 support team covering the various modules like OM, PA, PY, TM, ESS, MSS, LSO, Comp, SAP Portal and ABAP.
Scope of work :
- L2 Support
- Change Requests
- Knowledge Management & Support
SAP S4 Hana
S/4 Hana Implementation for Real Estate
Case Study :
S4 Hana implementation for Saudi Real Estate company
Business Requirement :
Implement and activate standard S4 Hana applications from the distribution industry for the modules MM, FI, RE-FX. The landscape was hosted on HEC
Solution :
Implement and activate standard S4 Hana applications for MM, FI, RE-FX in the Dev, Quality and Production environment. Also ensuring the proper assignment of roles to users. Provide production support.
Scope of work :
- Activating standard applications
- Roles assignment
- End to end testing
- Production support
SAP S4 Hana
S/4 Hana Implementation for Logistics
Case Study :
S4 Hana implementation for a distribution company in the Middle East
Business Requirement :
Implement and activate standard S4 Hana applications from the distribution industry for the modules MM, FI, SD and EWM
Solution :
Implement and activate standard S4 Hana applications for MM, FI, SD and EWM in the Dev, Quality and Production environment. Also ensuring the proper assignment of roles to users
Scope of work :
- Activating standard applications
- Roles assignment
- End to end testing
SAP Fiori
SAPUI5 based analytical dashboards
Case Study :
SAPUI5 based analytical dashboard application for an Analytics based product company in Australia
Business Requirement :
Develop Analytical Dashboard based application with various micro and standard chart controls. Backend data needs to be integrated with Hana.
Solution :
Develop the Analytical dashboard based application using SAPUI5 integrated with Hana Db as the backend. The chart controls are mostly custom developed using D3 Javascript Library. The dashboard is based on concept of tiles consisting of a number of micro charts
Scope of work :
- Design and development of the custom UI5 applications
- Develop custom chart controls using D3 Javascript library
- Integration with oData with Hana as the database
SAP Fiori
Fiori applications for Warehousing company
Case Study :
Standard Fiori and SAPUI5 based custom applications for a warehousing company in the Middle East
Business Requirement :
Mobilize a number of SAP HR ESS and MSS process for a fresh SAP implementation. Requirements include mobilization of a number of standard and custom HR processes in SAP
Solution :
Implement standard Fiori Apps to take care of the standard SAP HR processes in SAP like Leave Request, Paystubs, Employee Lookup, Timesheet, Leave Approvals, My Inbox, etc. Develop custom UI5 based apps for the custom implemented scenarios like HR Letters, Reimbursements, Disciplinary Action, On-Behalf Leave Request, HR Letters, etc.
Scope of work :
- Design and development of the custom UI5 applications
- Development of the oData services and ABAP objects
- Configure standard Fiori apps end to end
- Configure the My Inbox
- Configuration of the Launchpad
- Testing and support till UAT
SAP Fiori
SAPUI5 custom applications for car distributor
Case Study :
SAPUI5 based custom applications for one of the largest car distributor and dealer in the Middle East
Business Requirement :
To bring in efficiency in the sales and service process, it was identified to mobilize the processes like Vehicle Discount Management, Service Order Tracking and Approval
Solution :
Custom UI5 based apps were proposed for the scenarios to take care of the custom SAP processes implemented in the backend.
Offshore based delivery to optimize the project costs
Scope of work :
- Design and development of the UI5 applications
- Development of the oData services and ABAP objects
- Integration with the Launchpad
- Testing and support till UAT
SAP Fiori
Fiori custom applications and Support for SLcM
Case Study :
Fiori custom applications for a Netherlands based global SAP Higher Education and SLcM solution provider
Business Requirement :
Develop and Support Fiori web applications for a number of SLcM scenarios. Also migrate the applications to S/4 Hana and also develop Hyrbid apps for a number of scenarios
Solution :
Develop SAPUI5 based custom applications for a number of SLcM scenarios like Self Service Certificates, Electronic Document Verification, Refund, My Address, Contacts and Documents, Attendance, Tracking, etc. Integration with NFC.
Scope of work :
- Design and development of the custom Fiori applications
- Development of the oData services and ABAP objects
- Testing and support till UAT
- Migration of applications from ECC to S/4 Hana
- Development of Hybrid applications including device integration features like NFC
SAP Fiori
SAPUI5 based custom applications for IoT
Case Study :
SAPUI5 based custom applications for a innovation and technology company in Germany catering to the IoT domain
Country/Region : Germany
Line of Business : IoT
Business Requirement :
Develop web applications to integrate with the backend Hana database in order to cater to various IoT scenarios for the production shop-floor. Measure and manage strategic and operative targets for the production line.
Solution :
Develop SAP UI5 based custom applications to integrate with the Hana data models whose data are fed through a number of IoT based processes.
Scope of work :
- Design and development of the custom SAPUI5 applications
- Integration with the HCP
- Integration with the Hana cloud database