Decimal Notation changes in the BW backend does not get refelected in the Portal immediately

Symptom

The decimal changes in the backend system does not get reflected in the reports immediately when opened in the Java web.

However, You find that after few hours the changes get reflected. There is a delay in the changes to get reflected.

Environment

Netweaver BW 7.x

Reproducing the Issue

1. Maintain the user Profile  you have Decimal Notation as below

2. Execute the report in the Portal .The output looks as below

Notice the decimal notation, you have comma (,)

3. Now , make the decimal Notation changes as below

4.  Execute the report in the portal. The output looks the same as in shown in Step 2

5. Now after some time ( may be hour or 2 hours) you execute the same report , you see that the decimal changes are reflecting  as shown below
    Notice “ . “ instead of comma.

Causes

This issue might be a cache synchronization issue. BI Java on portal caches certain parameters for performance optimization

Solution

1. You have to invalidate the cache using the function module: RSWR_CACHE_INVALIDATE

2. Also, invalidate the ICM cache as per the note 529241

3. If this does not work, try restarting the J2EE engine.