ADM datamart DB table data dictionary
Do we have any documentation explaining data dictionary for below ADM data mart tables? The product documentation doesn't seem to have the information about this table and customer is looking for more information.
Do we have any documentation explaining data dictionary for below ADM data mart tables? The product documentation doesn't seem to have the information about this table and customer is looking for more information.
- PEGADATA.PR_DATA_DM_ADMMART_PRED_FACT
- PEGADATA.PR_DATA_DM_ADMMART_MODEL
Accepted Solution
Pegasystems Inc.
NL
And this is from a DSM install guide:
Adaptive Decision Manager can capture historical data for reporting purposes. The ADM data mart is implemented by periodically triggering the ADMSnapshot agent (Pega-DecisionEngine ruleset, PegaDM:Administrators access group). The agent runs the pzGetAllModelDetails activity. This activity captures the state of models, predictors and predictor binning in the ADM system at a particular point in time, and writes that information to a table using the Data-DecisionADM-ModelSnapshot and Data-Decision-ADM-PredictiveBinningSnapshot classes. By default, the time interval for running the agent is 120 seconds. The admmart/batchSize dynamic system setting in the Pega-ProcessCommander ruleset determines the batch size which, by default, is 50, a value considered suitable even in cases of large size models.
I don't think there currently is much more. I've alerted the doc team. For what it's worth, there's also some hints at what is available in the Mesh page about accessing the datamart from external (reporting) tools: https://mesh.pega.com/docs/DOC-125511.
Pegasystems Inc.
US
Found high level explanation about those tables at:
"Those tables are used for ADM reporting, and are populated by the ADM reporting agent (if enabled), which will extract on a regular basis statistics from the ADM server, an put that in those tables, so reports can be generated."
Accepted Solution
Pegasystems Inc.
NL
And this is from a DSM install guide:
Adaptive Decision Manager can capture historical data for reporting purposes. The ADM data mart is implemented by periodically triggering the ADMSnapshot agent (Pega-DecisionEngine ruleset, PegaDM:Administrators access group). The agent runs the pzGetAllModelDetails activity. This activity captures the state of models, predictors and predictor binning in the ADM system at a particular point in time, and writes that information to a table using the Data-DecisionADM-ModelSnapshot and Data-Decision-ADM-PredictiveBinningSnapshot classes. By default, the time interval for running the agent is 120 seconds. The admmart/batchSize dynamic system setting in the Pega-ProcessCommander ruleset determines the batch size which, by default, is 50, a value considered suitable even in cases of large size models.
I don't think there currently is much more. I've alerted the doc team. For what it's worth, there's also some hints at what is available in the Mesh page about accessing the datamart from external (reporting) tools: https://mesh.pega.com/docs/DOC-125511.