About OBIEE Usage Tracking

dilek

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

Syedsalmancs110

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

dilek

I look at db table directly, s_nq_acct from the database. So, no cache problem here. :S

[Deleted User]

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!

Syedsalmancs110

Thanks Christian Berg for correcting, I thought for same entry it updates CACHE_IND_FLG to 'Y'

[Deleted User]

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.

dilek

@Christian Berg Do you have any idea about my issue? :S

3410125

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.

Sherry George

Hi Dilek,

Do you see any usage tracking related errors in nqserver.log?

dilek

No, any errors in nqserver.log file.

[Deleted User]

@3410125 really? So you're also claiming that cache hits are not written into the S_NQ_ACCT?