Purging OBIEE Cache from OBIEE Report and Scheduling using BI Agent.
1) Create New Connection Pool with ODBC 2.0 Type and Weblogic Server Username and Password.
2) Create New OBIEE Report from Create Direct Database Request.
3) Connect Pool Name and Call SAPurgeAllCache(); command.
4) Run The Report and Schedule this report using BI Agent After Completion of ETL Loads and Add Mail Alert Notification.
1) Create New Connection Pool with ODBC 2.0 Type and Weblogic Server Username and Password.
2) Create New OBIEE Report from Create Direct Database Request.
3) Connect Pool Name and Call SAPurgeAllCache(); command.
4) Run The Report and Schedule this report using BI Agent After Completion of ETL Loads and Add Mail Alert Notification.
No comments:
Post a Comment