On , some users of the application CBS - Function costs were not able to refresh their personnal workbook created with the query BW_QRY_MPR_FC001_0001 CBS - Functions - end of month (Core query)

You can find below how this issue can be solved.

 

 

 

Step 1 - Add the authorization scope in the prompt

=> After  you must fill the authorization scope with SOLVAY, # or any others (ACETOW, BUTACHIMIE etc.)

 

Problem

When the workbook is refreshed, there is no more data

 

 

 

Solution

Open the prompt 

  1. You can delete the long list of Company codes by clicking 
  2. The field "Auth Scope on Company Code" can not remain blank

 

 

 

  1. Once the list of company codes is deleted, you have to enter the list of company codes, you want to display or enter  # to display all company codes you have access
  2. Enter the Auth Scope = SOLVAY and click  to enter # (star)

(star) Obviously when you work for a Non-Solvay company or a company with restricted accesses (ex: Butachimie), you must fill the scope accordingly (ex: ACETOW, INDUPA etc.)

 

 

Step 2 - Specific update for personnal workbooks using the query BW_QRY_MPR_FC001_0001 CBS - Functions - end of month (Core query)

Once the issue coming from the authorization scope is solved, you can face a second issue described below:

 

Problem

When the workbook is refreshed, there is only the column headings. 

 

 

Solution

  1. Go to the tab "Analysis"
  2. Click "Display" to open the design panel
  3. Drag and drop the structure from Data source pane to the "Raws" or "Columns" pane depending on how it used to be.  


 

 

Everything should be back to normal. If you have followed the procedure and there is still no data in your workbook, you may contact the Contact SBS Support..

 

Frequently Asked Questions

 

How do I know my workbook is based on the query BW_QRY_MPR_FC001_0001 ? 

Go to the design panel and open the tab "information". In the pane "Information", you will see the name of the query used. 

 

 

Is it a one time event or can these issues happen again  ?

These issues should not happen again: 

  • Once the authorization scope is filled, there is no need to update it anymore
  • The disappearance of the "structure" is also a one time event and only happened in the query BW_QRY_MRP_FC001_0001. It is an error that was not detected when a developpment was transported from the developpment environnement to the production environnement impacting the query BW_QRY_MRP_FC001_0001 only. 

 

 

What can I do if after having followed the procedure, my workbook is not fixed ?

If you have followed the procedure and there is still no data in your workbook, you may contact the Contact SBS Support..