Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Financial reports use SAP data through SAP BW data sources provide by Business Systems department.

Current reports connecting to BPA:

ZDTR 2022

Quote Master

COVID Quote Summary

Connecting to BPA requires setting up SAP Logon application. It is installed and setup on tableau01-dev VM (or whichever VM hosts tableau-dev server).

Tableau-dev VM is our R&D environment for SAP reports.

Installation and setup SAP Logon application on tableau-dev VM

Log in to tableau-dev VM as yourself.

  1. Install SAP Logon from \\gp-reports\tableau_backups\Software\SAP 730\Broad_SAP.exe (Broad SAP & BE 7.30 Comp 1)
    Un-select Business Explorer and continue with the installation

  2. Execute patch: \\gp-reports\tableau_backups\Software\SAP 730\gui730_4-10010496.exe (SAP GUI for Windows 7.30 Comp 1 patchlevel 4)

  3. Install driver \\gp-reports\tableau_backups\Software\SAP 730\BWODBO64SP02_0-20007320 (SAP BW ODBO Driver 64bit SP02)

Setup a connection to SAP

  1. Log in to tableau-dev VM as tableau_auth

  2. Set the BPA connection
    Connection Type: Custom Application Server
    Description: BPA
    Application Server: erpbia
    Instance Number: 00
    System ID: BPA

  3. Test the connection in Tableau Desktop.
    In tableau-dev VM open Tableau Desktop.
    Connect to SAP NetWeaver Business Warehouse.
    Connect as tableauuser (password is in TeamsID) and make sure Client is set to 100.

Develop reports off SAP BW data

  1. Login to tableau-dev VM as yourself.

  2. Open Tableau Desktop and connect to SAP NetWeaver Business Warehouse as tableauuser. Password is in Teams ID.

  3. Navigate to the suggested data source in the list of cubes and views.

  4. Never use a live connection to SAP BW cubes / views. Always make a full extracts. The view provided by Business Systems team should be optimized for performance. ZDTR report are usually built off of a view which contains certain Fiscal years (usually current and previous FY as per users request) and there are filters on the level of the data (just right for the financial reporting)

  • No labels