UNIQ_DOC_VIEW_CNT Does Not Contain The Count Of Unique Documents Viewed
Last updated on DECEMBER 09, 2016
Applies to:Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.
The UNIQ_DOC_VIEW_CNT in table FACT_USR does not contain the count of unique documents viewed by the user for that date.
The count of unique documents viewed is determined per batch run, so when the events of one day are processed by multiple batches, the UNIQ_DOC_VIEW_CNT is not reliable.
The measure UNIQ_DOC_VIEW_CNT given under FACT_USR table does not work when aggregated. Such measures should not have been calculated in the ODI layer but calculated on the reporting side.
The information of who has viewed an article on which day along with the version and other dimensional attributes available in FACT_CONTENT table
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms