Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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