First, nothing up my sleeve.
![cache is cleared](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzUErj1WO7KBsq2NRDsap6Afl2XxsLxhlZ4p1J_kP74yTdyzupNX2REFKsHywoSfve87PpKfRzX2laZ3xTiC-rKspm9AwVAAWB5TtopjIkQDGpJKnJhzt3aiJb7E0JIWbAs8QKiMSwSWuA/s800/01_obiee_clear_cache.png)
So you understand the mapping, I made a pretty picture for that (it's not readily available in the cache manager)
![mapped RPD](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqkjPNyif1mDxK73gvr_3FwytWVF0Isk5yPbjGIpVJg0OvwfasIGrwj-lldHcZCz8PIDiuU2oNzNB3msmyg1EVCXw9AToEOOCgF10pSFBwxs32TJqZ6z5q3i80FvAGHA-C6Deo0RpPSce0/s800/07_obiee_mapping.png)
I go off and run the reports (no need for screenshots of those).
Refresh the cache manager
![cache full!](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgK6eF2CLUP-WP2w26iUbAmW8uOLiX6IQ65dSJKEUqIMGDaJlvkiix1TV_JrB9noNFkbb2aMlIHoOLHeTsYRBEj7NSJokl5SZVz2a4dj-5OnrzX3-7E4p2_1mqWcoLIKxUfPZRF-rI2-4rT/s800/02_obiee_cache_full.png)
So now I have cache entries for both "databases" (in quotes because they are actually the same physical database, just 2 separate connections).
I then create the SQL file and put the following:
CALL SAPurgeCacheByDatabase( 'local-sh' );Then I just follow the same procedure as SAPurgeCacheAll()
nqcmd -d AnalyticsWeb -u Administrator -p Administrator -s sapurgecachebydatabase.sqlThe output is almost identical as well
-------------------------------------------------------------------------------And voila! The Sales cache has been cleared.
Oracle BI Server
Copyright (c) 1997-2009 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------
CALL SAPurgeCacheByDatabase( 'local-sh' )
CALL SAPurgeCacheByDatabase( 'local-sh' )
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
------------------------------
RESULT_CODE RESULT_MESSAGE
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
------------------------------
1 [59118] Operation SAPurgeCacheByDatabase succeeded!
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
------------------------------
Row count: 1
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
------------------------------
Processed: 1 queries
![cache cleared!](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjc_BKLjl0-BeaxCWjvzKutq2BOBBAr1BCR0Tk1tEqea-ZDSrDXw1vJwjAl3r6mmVyndoRdDM1tQx1lH9DdnxgpzpKE0PVIlmFBLuDITYksg0WSrK6FYnQlCsvO4rP2ezsg0pfdj3vpwrTa/s800/08_obiee_cache_cleared.png)
No comments:
Post a Comment