File Path: < OBIEE Install Directory> / Oracle BI/ Server/ Config / NQSConfig.INI
Here I would like to share the importance of this file
First of all NQSConfig.INI is the main Configuration file for BI Server. Because it contains lots of parameters.
[Note: After changing anything to this file we have to restart Oracle BI server Services to reflect that changes ]
1) General
If Values in the literals, digits or _, they can be given as such. If values contain characters other than literals, digits or _, values must be given in quotes. (Like “”)
2) Repository
All repositories must reside in OracleBI \ server\ Repository directory, where OracleBI is the directory in which the oracle BI server software is installed.
3) Cache ( Learn in detail about CACHE MANAGEMENT)
Usually Cache ENABLE options = YES , If you change as “ NO ” then u can not check in Cache Manager about the entries ( means cache will be disable)
( to check in cache manager follow this
Start \ All Programs \ Oracle Business Intelligence \ Administration then File \ open \ online
Give Administrator as user and password. Then go to Manage\cache)
We can change parameters like MAX ROWS PER CACHE ENTRY, MAX CACHE ENTRY SIZE, MAX CACHE ENTRIES .
Above parameters are by default. And we can change it to need our need. To check the current caching situation on the server path: Oracle BI Admin tool > Manage > Cache > Go right pane and right click> show info.
You will see the screen as below.