How to Clear the Cache in Oracle BICS

2 years ago  •  By  •  0 Comments

Accelerant specializes in Oracle Cloud Computing, Business Intelligence, and Data Mining. We help our customers unlock actionable information scattered across multiple systems. Our comprehensive approach provides strategic road-map, technical expertise, post-delivery support. Accelerant is OBIEE specialized Oracle Gold Partner.

Oracle Business Intelligence Cloud Service (BICS) is the industry’s first BI platform (or technology or system) in the cloud that makes analytics available to everyone. Cloud is defined as access to a pool of computing resources (servers, storage, networks, services, etc.) that can be rapidly provisioned and made available with minimal overhead.

So you just loaded new data into your tables but you don’t see the latest data-set being immediately refreshed into the modeler, table or your  dashboard reports. Why? You will need to clear the cache in BICS.

Follow the steps below on how to clear the cache in BICS to see the latest data.

1) Login to Oracle BI Cloud Service.

2) Click the Modeler icon on the Home page.
PC1

 

 

 

In Data Modeler
3) To see new data in Data Modeler, click into the model name from your list.

Cache1. JPG

4) To the right of the “Lock to Edit” button click on the “gear” button for the Data Model Actions. Then select Refresh Model from the drop down list.

Cache2In Dashboard Reports
5) To see new data in the dashboard reports, you need to manually clear the cache from the Data Model.
a) In the left pane click on the “Data Model” to show this panel.

Cache3

b) Click on the “gear” button for the Data Model Actions.
c) Then select Clear All Cached Data from the drop down list.

Cache4

d) A confirmation box will pop up stating “All cached data has been cleared.” Click OK to step out of
the pop up dialogue box.

Cache5In a Specific Fact or Dimension Table
6) To clear cached data for a particular Fact Table or Dimension Table:
a) Select the table from the list. In our case we selected “OM Fact” from our Fact Table.
b)  Lock the model by clicking on Lock to Edit to make any changes.

Cache6c) Then click on the “gear” button for the Table Actions and select Clear Cached Data from the
drop down list.

Cache7

d) A confirmation box will pop up stating “Cached data cleared for: OM Fact.” Click OK to step out of the pop up dialogue box.

Cache8

To Cache all Data in BICS
7) To clear ALL cached data:
a) Make sure the data model is locked by clicking on Lock to Edit.
b) Click on the “gear” button for the Data Model Actions.
c) Select Clear All Cached Data from the drop down lit to remove all data from the cache.


Cache9d) A confirmation box will pop up stating “All cached data has been cleared.” Click OK to step out of
the pop up dialogue box.

Cache10