Mr. Minkjan has a great article here and Gerard Nico has one here.
Caching has been enabled (via <BI_SERVER_HOME>\server\Config\NQSConfig.ini)
For a list of ODBC Function extensions, read here.
First up, I run a simple report and then verify that there is an entry in the cache
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi30XajlGMGw3B3ZvqoJ15lrh3bCbSx0TMkmGH8zSV_sncYrmFqcu6DmVTgQ2f4U7Qc5RSUPWvuDsrjGMO3PkTxMaYq0irI90jlB8ZaBE68yKBUAucTkmZMm97XdtFY49__qrsKof84p_HA/s800/01_obiee_cache_exists.png)
I then create a small SQL script and put it in my c:\ folder:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQSJqbLkbxTNgRSY9ZRC3eN-I0jbhRU1fXetYTaFd0EXrNf1EQ9zIbkuHHXsB692hGAHoPRIm-GB7QN3BF4FA4mWxdbPSR4Tj7qImQyYnqRxyVAfrQUPu1N9tJm3K2QZorksIoX-9x449j/s800/02_obiee_call_sapurgeallcache.png)
(OK, just ignore what it says in the Title bar, I moved it)
Open up a cmd prompt and issue the following:
nqcmd -d AnalyticsWeb -u Administrator -p Administrator -s purgeallcache.sqlHit enter and you should see the following:
-------------------------------------------------------------------------------Check the Cache Manager and voila!
Oracle BI Server
Copyright (c) 1997-2009 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------
CALL SAPurgeAllCache()
CALL SAPurgeAllCache()
------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
------------------------------
RESULT_CODE RESULT_MESSAGE
------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
------------------------------
1 [59118] Operation SAPurgeAllCache succeeded!
------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
------------------------------
Row count: 1
------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
------------------------------
Processed: 1 queries
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-06hFEsSThQt9ZEGsGUn_G8T_dyJa_LOSbFOPaHzRHbWtYxLB8rgarEXGFglCvfRsJM3oOu88Ne02YPisOMveoHFL1IsKZw6iJGpMHCOfslD0LKVwGYNx3Yk9ajtnxhslYUIGZgqji3fl/s800/03_obiee_cache_cleared.png)
For future reference, here are the options available for the nqcmd utility:
Command: nqcmd - a command line client which can issue SQL statements
against either Oracle BI server or a variety
of ODBC compliant backend databases.
SYNOPSIS
nqcmd [OPTION]...
DESCRIPTION
-d
-u
-p
-s
-o
No comments:
Post a Comment