Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we use the KF (Knowledge Foundation) Detail stats tables even if we have KA (Knowledge Advanced)

Summary:
Creating Search reports for KA
Content (required):
the following tables are Knowledge Foundation tables and as we have KA enabled we are not sure whether we can use them or not.
kf_answer_stats
kf_search_stats
kf_searches

Regarding the "search"tables these tables are mentioned in the Administering Knowledge Advances documentation > https://docs.oracle.com/en/cloud/saas/b2c-service/faaka/c-Search-Dashboard.html#aa1239552 and therefore I assume we can use them even though we have KA enabled.

Regarding the "kf_answer_stats" table, this table contains very useful information that I cannot find in any other table, information like (bounce visit, total visits, last visit, first visit, search visit...). The most important is that the dataminer utility is responsible for aggregating the data from the 'clickstreams' tables and thus we do not lose historical data that is automatically deleted from the clickstream table. If this "kf_answer_stats" table is not applicable for KA, then which table contains similar information (aggregated) and is applicable for KA?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!