If you want to change the path of Temporary directory and Cache storage directory in OBIEE then following are the steps:
For TMP Files:
1. Open the NQSConfig.ini file and modify the desired path for TMP
By default it is WORK_DIRECTORY_PATHS = “C:\OracleBIData\tmp”;
You can prefix # to comment out the above value and give the new path of tmp directory as follows:
#WORK_DIRECTORY_PATHS = “C:\OracleBIData\tmp”;
WORK_DIRECTORY_PATHS = “C:\Akash\tmp”;
2. Update the SATEMPDIR environment variable to the same path you provided in step 1. On windows, the SATEMPDIR is found under System Properties> Advanced > Environment variables.
3. After making the changes, restart the Presentation services and BI server services.
For Cache Storage:
The cache settings need to be updated in NQSConfig.ini files under “Query Result Cache Section” and “MDX Member Name Cache Section”.
By default it is DATA_STORAGE_PATH = “C:\OracleBIData\cache” 500 MB;
You can prefix # to comment out the above value and give the new path of cache directory as follows:
#DATA_STORAGE_PATH = “C:\OracleBIData\cache” 500 MB;
DATA_STORAGE_PATH = “C:\Akash\cache” 500 MB;
After making changes, restart the services.
Tags: Changing the path of Temp Directory and Cache Storage in OBIEE, DATA_STORAGE_PATH, NQSConfig.ini file setting for Cache storage, WORK_DIRECTORY_PATHS
