3661081 - Unable to view historical user activity data beyond quarter in SAC_STATISTICS_MDS_QUERY_PERF model in SAP Analytics Cloud (SAC)

Unable to view historical User Activity data beyond quarter in SAC_STATISTICS_MDS_QUERY_PERF model in SAC

• SAP Analytics Cloud
• Performance statistics

1. Login to SAC
2. Open the SAC_STATISTICS_MDS_QUERY_PERF model.
3. Create a Data Analyzer Insight or Story using the SAC_STATISTICS_MDS_QUERY_PERF model.
4. Add "Calendar Time" to rows and "Total Count" to measures.

Notice: The report only displays data for the current quarter.

The SAC_STATISTICS_MDS_QUERY_PERF model retains only a fixed number of records (1,000,000). Once this limit is reached, the oldest records are deleted based on usage rather than time, restricting the data to the current quarter.

Note that the SAC_STATISTICS_MDS_QUERY_PERF model is primarily designed for analyzing current performance issues and is not intended for long-term performance monitoring or trend analysis.

For long-term statistics, use the SAC_STATISTICS_AGGREGATED and SAC_ACTIONS_AGGREGATED models, which contain aggregated data with daily granularity and are suitable for trend analysis.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add any relevant text, keywords, warning messages or error messages to the text search field to filter the results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

SAC_STATISTICS_MDS_QUERY_PERF, data retention, current quarter restriction, historical data, performance statistics, aggregated models, trend analysis, SAC_STATISTICS_AGGREGATED, SAC_ACTIONS_AGGREGATED, SAP Analytics Cloud , KBA , LOD-ANA-XUS , User assistance, performance statistics , Problem