Article Search Historical

This subject area provides detailed information on searches for knowledge management articles. In addition to search count information, it also contains normalized questions that you can report on.

Note: Before using this subject area, run the below-mentioned scheduled processes.

• Refresh Denormalized Time Dimension Table for BI
• Knowledge Search Aggregation

Dimension Folder	Dimension	Definition
Facts	# of Normalized Questions	The number of normalized questions asked.
	# of Questions	The number of questions asked.
	Average # of Responses	The average number of responses to a query.
Normalized Question	Concept Terms	Words that are assigned as concepts
	Concept Tokens	The tokens associated with a concept.
	Department Name	The department associated with the normalized question.
	Normalized Question	A question from which the application has removed case distinctions, spelling errors, punctuation, skipped words, and other elements that may differentiate it from otherwise identical question
	Normalized Question Locale Code	The locale code for a normalized question.
	Normalized Question Locale Description	The locale name for a normalized question.
	Unknown Terms	Terms not associated with a concept. This dimension uses straight brackets ([]).
	Unknown Tokens	Tokens not associated with a concept. This dimension uses curly brackets ({})
Time	Search Stat Calendar Month	The calendar month of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Calendar Month End Date	The calendar month end date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Stat Calendar Quarter Start Date	The calendar quarter of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Calendar Quarter	The calendar quarter of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured
	Search Stat Calendar Quarter End Date	The calendar quarter end date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Calendar Quarter Start Date	The calendar quarter start date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Calendar Year	The calendar year of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Calendar Year End Date	The calendar year end date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Calendar Year Start Date	The calendar year start date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Date	The statistics (stat) date. This is the date on which the aggregation job was executed and ratings and other updates captured
	Search Stat Month	The month of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Quarter	The quarter of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.
	Search Stat Year	The year of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured.