InfoArea hierarchy not up to date in RSECADMIN

Dear reader,

For my customer I set up the authorization concept in SAP BW7.4 on HANA. Last monday I encountered an issue when I tried to add an InfoArearestriction in an authorization object (via transaction RSECADMIN). The hierarchy with InfoAreas that was available in RSECADMIN was not in sync with the InfoArea hierarchy in transaction RSA1.

I visited some blogs and they only told me that I need to sync the hierarchy with command “/$sync“. This didn’t solve my issue. The hierarchy will be synchronized standard once a day, if you want to update this frequently, you can change the RSADMIN table and add a parameter :-) The correction will allow you to set your own refresh rate (in seconds).

Open report “SAP_RSADMIN_MAINTAIN” via SE38 and add the parameter:
Object: RS_INFOAREAHIER_REFRESH_RATE
Value: nnnn

Here nnnn corresponds to the refresh rate required for the InfoArea hierarchy. Mention the values in seconds, starting from 2.

This will update your InfoArea hierarchy at your own frequention. Problem solved :-D