Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
About OBIEE Usage Tracking
Hello,
I have a question about usage tracking on obiee. So, when I look at S_NQ_ACCT table, I see entries about reports usage, but not all of them are inserted the table.
In my case, I tested clicking many reports but only a few of them are seen on the table. Is there a problem or bug here? If you know, can you help me please.
OBIEE Version is: 11.1.1.7.140114 (Build 140126.2205.JANRECUT 64-bit)
Regards,
Dilek
Answers
-
Are you checking database table S_NQ_ACCT directly to verify if all report queries have been inserted or your verifying the same through BIEE Usage Tracking Report?
Because if you are checking usage tracking data through report there is a possibility that report might be hitting Cache and fetching the result hence not displaying all report run details also if your reports are hitting cache then there won't be separate entry for each time report is run
0 -
I look at db table directly, s_nq_acct from the database. So, no cache problem here. :S
0 -
Syed Hamd Salman wrote:also if your reports are hitting cache then there won't be separate entry for each time report is run
Wrong. S_NQ_ACCT.CACHE_IND_FLG = 'Y' means that the request hit a cached result. There IS an entry for each request!
0 -
Thanks Christian Berg for correcting, I thought for same entry it updates CACHE_IND_FLG to 'Y'
0 -
No it's a distinct usage. Otherwise you would never get the actual / real numbers on what is used how much, when, by whom etc.
0 -
@Christian Berg Do you have any idea about my issue? :S
0 -
I guess for all the new entries which are missing in the S_NQ_ACCT table even you are running the OBIEE reports, the CACHE_IND_FLG is 'Y'. As per my understanding, those are not hitting the database and showing the results from Cache itself.
0 -
Hi Dilek,
Do you see any usage tracking related errors in nqserver.log?
0 -
No, any errors in nqserver.log file.
0 -
@3410125 really? So you're also claiming that cache hits are not written into the S_NQ_ACCT?
0