SBS - Solvay Business Service

The SBS dashboards are thus very critical because it consist of corporate info which are accessed by high level management.

All SBS dashboards are stored in the same folder on server.

They share more than 80 sources : SBS Data Source list (to be updated with every modification !)

80% of sources comes from BW cubes.

 

The following SBS departments have their QV dashboard

HtR - Hire to retire : Human Ressources

OtC - Order to Cash : Profitablilty KPIs. Orders, shipments, Invoices, Customer services, SAP SD & FIAR, Accounts receivable...

PtP - Procurement to Pay : Financial KPIs from purchase to settlement. Invoices, Payments, late payments, SAP MM & FIAP Procurement , Receipts, Vendor management, Accounts payable...

RtR - Record to Report : Accounting, Closures, SAP CO & PA , Controlling, Profit Center Accounting

Those dashboard comes from Rhodia legacy and Solvay is being progressively integrated in BW. QlikView has been used as a fast way to deliver in between… This means a lot of construction and deconstruction in those reports as data is being integrated.

Other SBS Dashboards :

  • SBS Macro
  • SBS Delivery

Providing Access

Check if the user is already existing / not from the QV usage

 

If it is a new request-> send for the validation to respective L0 Team

The validator itself will provide all the necessary access to be provided for the requested user.

Although the user may request to have different access but we must all go with the comments provided by the validator.

Go to the location and open the access excel as shown below

 

 

Fill all the necessary fields as stated by the validator

ACCESS – USER/ADMIN

NTNAME – NT UserName (Check and Type from LDAP)

TAB_CODE– Provide the necessary access to tespective dashboard as per Validators comments

mail - As per details from LDAP server (copy/paste)

CreationDate -  Date the access was created

Ptp T&E scope and PtP T&E Tab -  Enter the details as per Validators advise when requested access for PTP Dashbiard (Refer "Readme" Tab)

 

TSA and Future TSA - It is set as "ALL" and "Solvay"

Ur.Ref - It is the reference Ticket number raised for providing the access