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

I then create a small SQL script and put it in my c:\ folder:

(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

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