| Table of Contents |
|---|
Training Process
Create a session
To request a new session on ISSP:
http://issp.priv.rhodiasolvay.com/issp/training/course/seetraining.do?courseid=279&languageSelectedId=1
Join a session (for the user)
To join an existing session:
http://issp.privsolvay.rhodia.com/issp/training/session/list.do
- to look for the BW Analysis course fill in the right handside fields with the following information.
then click the search button
- You will get a list of the forecasted sessions.
Note: the user can request a new session on ISSP :
http://issp.priv.rhodiasolvay.com/issp/training/course/seelist.do?courseid=279&languageSelectedId=1
Before training
Communicate
7 days before the training:
- Check that the users have a BW account.
- Check if needed that all training accounts are OK (passwords).
- 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 accountDear all,Please remind our BW ANALYSIS BASIC training session:
http://issp.priv.rhodia.com/issp/training/session/see.do?sessionid=5489Thursday July, 23rdPhone numbers:
From 13h30 to 17h00 (Paris Time)
via Fastviewer / In EPA room 403B
in English
https://docs.google.com/a/solvay.com/spreadsheets/d/1utUGDFP4sT5xFpQrZqWbHwI_WgOagWWnjjXPVaHtHPA/edit?usp=sharingPlease 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 contact sbs-is-appli-help@solvay.com to have your BW accountcreated/reactivated)
Regards
BWSupport
Team
After
the trainingtraining
- Go to ISSP, Check attendees and Send them the e-survey
- Send them a mail about documentation, asap after a session
Example :
Dear all
Thanks a lot for your participation to the SAP Analysis for Microsoft Excel training session.
Please find hereunder find :
1) the training Training documentation regarding about the Analysis tool
https://solvay.pixsoftware.de/confluence/display/ISAPPSUP/BW+-+Analysis + User + Guide
2) the The most common errors (and the way to solve it by yourself!)
https://solvay.pixsoftware.de/confluence/display/ISAPPSUP/BW+-+Troubleshooting
3) the documentation regarding the queries (will be updated soon)
https://solvay.pixsoftware.de/confluence/display/ISAPPSUP/BW+-+ApplicationBW Analysis Troubleshooting pagePlease remind that for any request/question/wish
- for Solvay users : Fasconnect
- for Rhodia users : mail to sbs-is-appli-help@solvay.comRegards
BW Support Team
BW training accounts
Server : PQ1
, please contact us by Freshdesk Application:
https://sbs-support.solvay.com/helpdesk/tickets/new
BW training account
Quality Server : WBQ
Client : 400Client : 020
| Account | Password |
|---|
| TRAINANA01 |
IMPORTANT : Passwords are changed every 60 days. Please keep this page updated.
Training Queries
| Analysis092019 | |
Password has been updated on 2019 june 11, so next change will be in 59 days.
| Warning | ||
|---|---|---|
| ||
You will be requested to change the password after 59 days, so please keep this page up to date. |
2 Training Queries
| Query technical name | Description |
|---|
| Comment | |
|---|---|
| BW_QRY_CRTRNG01_001 | BW - Training : Resort booking evolution |
| a sophisticated query | |
| BW_QRY_CRTRNG01_002 | BW - Training : Resort booking |
Query "BW - Training : Resort booking evolution"
Complex query that you can use with more advanced users.
There is a prompt on the Year but data will automatically be displayed for Y-1, Y and Y+1.
Query "BW - Training : Resort booking"
Simple query that you can use with basic users.
Pay attention to the filter set on Customer - Country = US.
| a simple query |
Agenda of a session
| Agenda | Environment | Example 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 )
Analyze of Data
| Training environment Quality server WBQ
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
|
...