Clear OBIEE Cache Usign DAC Task Actions

1. Login To DAC

2. Navigate to Setup >> Physical Data Sources and set up connection to the BI server

Optional >> In the extended properties tab add the connection pool ( Note it should match the connection pool name in your RPD)

3. Click Test Connection to test the connection

4. Navigate to Tools >> Seed Data >> Actions >> Task Action and click new to create a new action to populate aggregate Enter a name

5. 

Click on the Value filed to open the dialog and add a command to be run by nqcmd

call sapurgeallcache();

6. Navigate to Tools >> Seed Data >> Logical Data Sources and create a source for the BI Server

7. Goto Design >> Task and create a new task and associate the action created above in the command for incremental and full load, choose the logical data source created above

8. Add the task to a execution plan in the Following Task tab

9. In the execution plan connectivity parameter subtab click generate and map the logical datasource to the Physical Data source

 10.Rebuild the plan and fire away J