Can somebody give me some light on this?

Chris, thanks for your input.In the above diagram,Logical levels for Fact_W_GL_BALANCE_F & Fact_W_GL_BALANCE_F_HFM are same.How can we force BI server to select FACT_W_GL_BALANCE_F_HFM instead of other fact. thanks R

I can see lot of dynamic repository variables with OOTB RPD. example:-

maC, Event pool table is not configured. Yes,I can see dynamic repository variables.We are using OBIA-11.1.1.9.2 RPD Out of the box RPD. thanks R

Thomas, thanks for your input.It was helpful. But for this BI Analyze->Role should have all the permissions in BIconsumer+My choices(How to add my choices to this role?) These choices should come from BIAuhor???Can you please explain? My Requirement is user wants to change the reports + Access reports. Thanks R

Can anybody give some inputs please?

Felipe, Thanks for your update.If i give BIauthor role then the user will be able to see all the dashboards/reports with the Biauthor subject areas. The user has the below roles. Thanks R

MAc2, OBIEE 11g cache purges automatically because of the following reasons:- 1) Automatically, by setting the Cache Persistence Time field in the Physical Table dialog box for a particular table. 2) Automatically, by setting up an Oracle BI Server event polling table. 3) Automatically, as the cache storage space fills up.…

Chris, I don't find the cache purge log information in nqquery.log.

Chris, What is the log file name and path?

Thanks.! I solved my self. the back ground color should be white.

Chris, thanks for your response.! I don't see any agents which purges all the cache files. Is there any way or any log file where we can see who is purging the cache? Thanks R

Mac2, I can see the cache files but the files are purging with out manual or automated purge... I'm trying to find the reason why the cache files are purging....? Thanks R

Hi All, Can anybody give some inputs on this? Thanks R

Chris, No cron job is scheduled on the server with SAPurgeALLcache(). It is very strange to me. Thanks R

Thomas, Why did the above .tbl files purged? 1)We did not purged manually. 2)We don't have any automated program to purge these .tbl files Thanks R

Based on the .tbl files in the path /appshr/obiee/MW_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache>

Thomas, For all the tables the cache options are below:-

Akansh, thanks for your response.! What about BI server cache?We are not purging it manually and we don't have any program to purge it.But all the files in /appshr/obiee/MW_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache ...are purging.. Is the based on some capacity? the below is…

Try this. https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=1963225.1%3AOBIA11GPERFTECHNOTE&action=inline