nqcmd :cache rebuilding to Improve Performance in 10g

Sometimes we want users to access OBIEE reports quickly without delay, in this case we try to populate cache by executing logical queries of the reports.

Step 1: Purge cache : run the following cmd directly from 'Issue Sql Directly' in                                    settings-->Administration O
Call SAPurgeAllCache(); 

Step 2: Take logical queries in settings-->Administration-->Manage Sessions and collate all the required queries in a text file.E


Step 3: Navigate to nqcmd path  \OracleBI\server\Bin in cmd prompt and execute in the below format


NQCMD -d AnalyticsWeb -u Administrator -p Administrator -s C:\Cache.txt