General description

This dashboard contains data and statistics relative to the BW and BO broadcasts (Automatically scheduled reports). It is used by IS teams to :

• Analyse the broadcasts usage : how many users, how many broadcasts, by zone.
• Search easily what broadcasts are sent to a person.
• Search easily if a broadcast exists on a subject (by name, subject...)

Content documentation

Below are the list of some fields which may need explanations :

Topic* : it's a grouping based on the name of the broadcast. The grouping codes can be found in the QV loading script (BWSettings portion for BW and "BOBroadcasts_temp" for BO).

• Example : All broadcasts containing "order book" in the name will have a topic "Order Book".* Scheduled* field :

• Yes h1.If Status<>Paused and Recurring = True in BO. In BW scheduled using the standard schedule- Yes - Program Scheduled in BW via the program or process chain. This means that the setting is set as "non scheduled" in the BW administrator workbench but the setting exists in the BW Broadcasts Eroom file.

Example : All the industrial dashboards.

Note that BO instances which are scheduled but with a "PAUSED" status are considered as "NO" Scheduled.

Include IT* field : Based on a hard-coded list of emails and user logins. The list can be found and updated in the QV loading script.
Example : If email h1.davidtonda@ap:rhodia:com --> IT X (IT)
Zone* field : it is based on the email or login receiving the broadcast. Possible values :
AP : if email contains "@ap".
EU : if email contains "@eu".
LA : if email contains "@br".
NA : if email contains "@us".
Publication : if recipiant contains "address" (for BO only).
Eroom : if email contains "@rho" (for BW only).
External : if not in other cases and contains "@"
Inbox : if not in other cases and does not contain "@" (for BO only)
Path* field : For BO only, contains the path ("Folder") of the report.

Updating procedure (Manual)

Files needed before updating

The broadcast dashboard is not an automated dashboard so it means it has to be updated once a month manually. To do that you need 5 files :

• The * qvw file* (Qlikview Document) "QV Broadcasts Dashboard.qvw". This can be requested to the QV admins.
• The * O Broadcasts* file "BO Broadcasts.xls" : it contains the information about the BO broadcasts.
• The * W Settings* file "BW Broadcast Settings_formated.XLS" : it contains the list of all the BW broadcast settings.
• The * W Emails* file "BW Emails.xls" : it contains the list of emails receiving the broadcasts
• The * W Eroom Broadcast* file "Broadcast-WBP.xls" : it contains additional information on the BW settings.

Then there is global file (not monthly but replaced each month) :

• The * ser Master Data file* : this contains the HR (Job, Family, GBU...) and geographical data (Zone, Country, Plant...) of each employee which is linked by email to the broadcast users.

Month Folders

The dashboard loads the data for a set number of months. That is defined in the loading script variable :

Let vNbOfMonths =X;
Where X is the number of months, starting with previous month, that will be loaded.

Ex : If vNbOfMonths = 2 and now is August 2012 then it will attempt to load from folders Jully 2012 and June 2012.

The script will attempt to load the data from folders with the name format MmmYY (Ex : May2012) :

Due to this it is necessary to create each month a new folder and add the files in it.

The BO Broadcasts file

1. Go to the Saints Tools Instance page : http://wdcbiaq01:9000/bi41sdk
2. Input wdcbiap01 as the system. Also input your BI4 ID/password.
3. Click on "Search"
4. Go to the bottom of the results to "Export All Data" and click on the first icon.
5. Save the file as "BO Broadcasts.xls"

The BW Settings file

1. Log into BW Production (WBP) via the SAP Logon.
2. Launch transaction RSRD_ADMIN.
3. Click on "Settings".
4. Select parameters : Object Version A, Created By Empty.
5. Click on Execute
6. Click on Export, Select Spreadsheet, then Excel (in MHTML Format).
7. Save the file as "BW Broadcast Settings.MHTML".
8. Open the file in Excel and save it in the XLS format as "BW Broadcast Settings.xls".

The BW Emails file

1. Log into BW Production (WBP) via the SAP Logon.
2. Launch transaction SE16.
3. Open table RSRD_SETT_NODE_A.
4. Select parameters and run it : Version A, Parameter ID = DI_EMAIL, Maximum No. of Hits = 99999, Width of Output List 9999.
5. Once you get the result, go to the "Edit" Menu and choose "Download".
6. Choose the "Spreadsheet" format and save it as "BW Emails.XLS".
7. Open the file, delete the first 3 rows and delete all empty rows and columns

   The BW Eroom file

1. Go to the BW Broadcast G-doc :https://docs.google.com/a/solvay.com/spreadsheets/d/1ELpzknVvRiVDpJh_MY4AmJmnjNNFfvwqGi9MR9UE5_A/edit#gid=1580080871
2. Save the file locally as "Broadcast-WBP.xls".

The BW broadcast log file OBSOLETE

This is no longer uploaded in the dashboard but kept for reference only.

1. Go to SE16 and open table BALHDR
2. Select Program = RSRD_BROADCAST_STARTER.
3. Select the wanted period in DATE (Ex : 1 year)
4. Once you get the result, go to the "Edit" Menu and choose "Download".
5. Choose the "Spreadsheet" format and save it as "BW broadcast logs.XLS".
6. Open the file, delete the first 3 raws and delete all empty columns.

Note that for this file it is necessary to replace the old file. There is no monthly folder.

The User masterdata file

This file contains a list of useful data about the users (GBU, zone, country, job...) which can be linked to the broadcasts via the email.

To get it you need to have access to Business Objects and the "ICARE" public reporting application :

1. Log into BO (http://boxi.priv.rhodia.com/InfoViewApp/logon.jsp)
2. Go to folder "7 - HR / 71 - ICARE Public / 711 - Headcount"
3. Run the report "ICR_HEADCOUNT_LIST_W_SNA_001" (or further version).
4. In "Situation Date" select the current month. Snapshot type = Fixed. Rest can be left empty. Run the report.
5. Export the "Headcount List" sheet into excel.
6. Save the file as "UserMD.xls" in the "QV Sources" folder of the dashboard.

Uploading of the files

1. Open the QV Broadcasts Dashboard.qvw file with Qlikview.
   2. Go to "Files" and "Edit script".

5. Click on Reload.
6. If everything went well, save and send the qvw file to the Qlikview admin for uploading.