SAP MDG · UTILITIES
How do I add object counters to MDG HANA analytics?
Use this procedure to extend SAP MDG HANA-Based Analytics with an object counter and an average-object KPI for Change Requests. It applies from MDG 7.0 SP05 and, per the source, is only available in ECC.
Use this procedure to extend SAP MDG HANA-Based Analytics with an object counter and an average-object KPI for Change Requests. It applies from MDG 7.0 SP05 and, per the source, is only available in ECC.
Use the existing HANA-Based Analytics setup, generate the required Business Object Type Code scenario with `MDG_ANA_HDB_GEN_REPO_CONTENT`, then enhance the generated query view in SAP HANA Studio. Create a new counter for total objects in Change Requests, and a second calculated column for the average objects per Change Request.
Process flow
- Ensure HANA-Based Analytics for SAP MDG is already up and running.
- Identify the required Business Object Type Code (BOTC).
- Run generation report `MDG_ANA_HDB_GEN_REPO_CONTENT` for the BOTC.
- Locate the generated BOTC-specific query view in the data-model subpackage.
- Open the query view in SAP HANA Studio and select the Aggregation node.
- Create a New Counter under Calculated Columns.
- Configure `TotalObjectsInChgReqs` with `COUNT_DINSTINCT` and the relevant unique key columns.
- Prefer technical keys such as `MATERIALTechKey` or `BP_HEADERTechKey` when available, together with `ChangeRequest`.','Save and activate the query view.','Open Data Preview and supply mandatory `SAPClient`.','Validate the counter on the AnА
Generate the BOTC-specific HANA analytics content with report `MDG_ANA_HDB_GEN_REPO_CONTENT`
Create the object-specific scenario before enhancing the query view.
SAP HANA Studio > HANA content package > query view (example: `tmp.enhancement.MM` > `CRHeaderFor194Query`) > Aggregation node > Calculated Columns > New Counter
Add the total object counter and its key columns.
SAP HANA Studio > HANA content package > query view > Aggregation node > Calculated Columns > New Calculated Column
Add the average objects per Change Request formula measure.
Data Preview Editor > Analysis tab > value axis
Validate the created counter and average measure.
Referenced tables
| Object | Purpose |
|---|---|
Business Object Type Code examples | Source examples for BOTC-specific generation: `194` Material/MM, `147` Business Partner/BP_HEADER, `154` Company/0G. |
BP_HEADER business object types | `BP_HEADER` may represent `147` Business Partner, `266` Supplier, and `159` Customer; add filters if you need to distinguish them. |
The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- What is this guide about?
- Which releases support this procedure?
- Why add object counters?
Possible questions
- How do I extend the query view for object counters?
- Which report generates the object-specific scenario?
- What must I generate before enhancing the query?
- Which query view can be enhanced?
- How do I calculate average objects per change request?