BIP Refresh Process

                                                             BIP Refresh Process

Login with a BI Administrator user and execute the following steps in order to clear the BI Cache:

1. Clear BI Publisher Cache:

Administration --> BI Publisher --> Manage BI Publisher --> System Maintenance --> Manage Cache --> Clear Object Cache

2. Clear cache for the integration between BI Publisher and OTBI

Administration-- > BI Publisher --> Manage BI Publisher --> Integration --> Oracle BI Presentation Services --> Clear the  BI Subject Area Metadata Cache

3. Clear OTBI Cache:

Administration-- > Issue SQL --> type :  "Call SAPurgeAllCache();" --> Click "Issue SQL" (you should see a message like "Operation SAPurgeAllCache succeeded!")

4. OTBI Reload Files and Metadata:

Administration-- > Maintenance and Troubleshooting --> Reload Files and Metadata

5. Logout --> Clear browser cache --> Restart browser

6. Login and retest  

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath