Training Process

Create a session

To request a new session on ISSP:

http://issp.solvay.com/issp/training/training.do

Join a session (for the user)

To join an existing session:

http://issp.solvay.com/issp/training/session/list.do

 then click the search button 

 

 

Note: the user can request a new session on ISSP :

http://issp.solvay.com/issp/training/course/list.do

Before training

 

  1. Check that the users have a BW account. 
  2. Check if needed  that all training accounts are OK (passwords).
  3. Send a google invitation (google agenda) to users( below an example), at least 2 worked days before the session:

 

Fastviewer session will be provided 10 minutes before 
Phone numbers:  

insert the list

Please ensure that :

1) the Analysis tool is installed on your computer (you should find the folder "Start / All programs / SAP Business Intelligence")
2) you already have an active BW account on BW Production server WBP or PQ1 (if not, please open a Freshdesk ticket  to have your BW account created/reactivated)

Regards
BW Support Team

 

After training

  1. Go to ISSP, Check attendees and Send them the e-survey
  2. Send them a mail about documentation, asap after a session 

    Example :

Dear all


Thanks for your participation to the SAP Analysis for Microsoft Excel  training session.

 

Please find  :
1) Training documentation about the tool
Analysis User Guide
2) The most common errors (and the way to solve it by yourself!)
BW Analysis Troubleshooting page

Please remind that for any request/question/wish, please contact us by Freshdesk Application:

https://sbs-support.solvay.com/helpdesk/tickets/new


BW training account

Quality Server : WBQ

Client : 400

AccountPassword
TRAINANA01Analysis092019




Password has been updated on 2019 june 11, so next change will be in 59 days.

 You will be requested to change the password after 59 days, so please keep this page up to date.


2 Training Queries

Query technical nameDescriptionComment
BW_QRY_CRTRNG01_001BW - Training : Resort booking evolutiona sophisticated query
BW_QRY_CRTRNG01_002BW - Training : Resort bookinga simple query


Agenda of a session



AgendaEnvironmentExample of exercice

How to Launch the BW Analysis tool the 1st time.  

2nd time directly via Excel

Open Analysis tool  in eXcel  2 ways

Path1-File tab then Analysis submenu  ( Open DS, Open Workbook, help )
Path2-Analysis Ribbon tab (Functionnalities).   

Open a Data Source or a Workbook - Path1
Prompt Window. (Mandatory, optional fields)
Crosstab : Table of results 
Design Panel 

  1. -Analysis tab (Lay out..), 
  2. -Information tab
  3. -Component tab (object properties)


Analyze of Data
Filter, Sort... 
Add new Calculations (Simple, Dynamic, Advanced, and restricted one).
Save the Document (local) , Reopen it.
Refresh a Data Source or Workbook


The Troubleshooting wiki Page.
 How Reenable the missing Analysis Add-in.  

Training environment  Quality server WBQ 
Client : 400 Language : EN


Not SSO mode > bypass mode = click cancel Button
Users TRAINANA01 Password xxxxxxxx 

Working Report : Resort Booking Evolution.

Via the search tab

Type the Text : Resort .

Select The resort booking evolution one


launch the query (connection )

In the prompt fill in mandatory fields

(Choose the year 2014 via the selection list)

Open design panel analysis tab

Change the display by default by adding the customer country menber.

Add a filter to get only european customers (foreground &/or background)

Go through the functionnalities.

Save the doc, Close excel, Reopen it and Refresh the doc.

To build a workbook duplicate twice the crosstab1

  • Crosstab2 Filter on US & Japan
  • Crosstab3 no filter (= worlwide)