Public views containing produced statistics
The public views expose all the time series data in the data warehouse (DWH) that has been collected and summarized by the warehousing process.
When you use the TrueSight Capacity Optimization console to run analyses and models, the time series data that is produced is not included in the public views. The produced data is displayed as charts in the console.
You can view the charts and download the underlying data, but the data itself is not saved in the database. However, a user with administrative privileges can promote any analysis or model to “golden” and the analysis or model is marked as a golden analysis or model. The Golden producer tasks (background tasks) run the golden analyses and models automatically on a periodic basis, and save the produced data in the database as a “producer-based” time series. For details about how to configure this kind of data, see Working-with-custom-statistics.
Such producer-based data is also exposed through public views. The public views are described in the following sections.
PV_ANALYSIS_STAT_PROD
Contains information about all analyses promoted to Golden in the Capacity Optimization console workspace.
PV_MODEL_STAT_PROD
Contains information about models promoted to Golden.
PV_FORECAST_MODEL_DETAILS
Contains information about the time forecasting model.
PV_SYS_DATA_CUST_STAT
STAT_DEF
Contains custom statistics saved by a time forecasting model.
PV_SYS_EST_DAILY_TREND
Contains daily statistics for a system produced by a golden time forecasting model.
PV_WKLD_EST_DAILY_TREND
Contains daily statistics for a business driver produced by a golden time forecasting model.
PV_SYS_EST_HOURLY_TREND
Contains hourly statistics for a system produced by a golden time forecasting model.
PV_WKLD_EST_HOURLY_TREND
Contains hourly statistics for a business driver produced by a golden time forecasting model.
PV_PLA_EST_HOURLY_CAPACITY
Contains hourly statistics based on a “Performance vs. Load analysis” and produced when a golden PLA is executed by the producers.
PV_PPA_EST_HOURLY_CAPACITY
Contains hourly statistics based on a “Performance vs. Performance analysis” produced by an extrapolation or a queue network model.
PV_LLA_EST_HOURLY_CAPACITY
Contains hourly statistics based on a “Performance vs. Performance analysis” produced by an extrapolation or a queue network model.
PV_PLA_EST_DAILY_CAPACITY
Contains daily statistics based on a “Performance vs. Load analysis” and produced when a golden PLA is executed by the producers. These sets of views contain the result of the last execution and not the historical data as normally expected.
PV_PPA_EST_ DAILY_CAPACITY
Contains daily statistics based on a “Performance vs. Performance analysis” produced by an extrapolation or a queue network model. These sets of views contain the result of the last execution and not the historical data as normally expected.
PV_LLA_EST_ DAILY_CAPACITY
Contains daily statistics based on a “Performance vs. Performance analysis” produced by an extrapolation or a queue network model. These sets of views contain the result of the last execution and not the historical data as normally expected.