SAP MDG · UTILITIES
How do I combine MDG Change Request analytics with workflow step details for drill-down by master data attributes?
Use Change Request Analytics by Master Data Attributes together with Work Items Analytics for Change Requests, then join the generated master-data cube with I_MDGovChgReqWrkflwTskCube on MDGovChangeRequest to drill from CR overview into workflow step details.
Use Change Request Analytics by Master Data Attributes together with Work Items Analytics for Change Requests, then join the generated master-data cube with I_MDGovChgReqWrkflwTskCube on MDGovChangeRequest to drill from CR overview into workflow step details.
This guide shows how to combine MDG Change Request overview analytics by master data attributes with workflow-step analytics in one application. You first generate the master-data analytics CDS, then join its generated CUB view with I_MDGovChgReqWrkflwTskCube, create a query CDS, publish it via OData, and configure the Smart Business drill-down app and roles.
Process flow
- Use ABAP Development Tools to create the custom CDS views.
- Configure and generate the Change Request Analytics by Master Data Attributes CDS.
- Select the master-data attributes required for analysis.
- Open the generated objects and identify the generated CUB view.
- Create a combined cube CDS with @Analytics.dataCategory: #CUBE.
- Define P_MDGovDataModel and P_MDGovChgReqWrkflwScen parameters.
- Join the generated master-data cube with I_MDGovChgReqWrkflwTskCube on MDGovChangeRequest.
- Expose the CR and workflow measures with the shown @DefaultAggregation: #MAX pattern where applicable.','Create the query CDS with @Analytics.query: true and @OData.publish: true.','Configure the Smart Business Generic Drill-down report.','
ABAP Development Tools (ADT)
Create the custom CDS views required for the combined analytics solution.
Change Request Analytics by Master Data Attributes configuration process
Generate the master-data analytics CDS views and the generated CUB view used later in the combined cube.
Smart Business Generic Drill-down
Consume the published query CDS as the end-user analytics application.
PFCGFrontend Fiori role / backend authorization role
Assign the app content and data authorizations required to launch and use the analytics report.
Referenced tables
| Object | Purpose |
|---|---|
I_MDGovChgReqWrkflwTskCube | Standard SAP cube for MDG Change Request workflow-task analytics. |
ZBP_CUST_REUSECUB | Example generated master-data cube reused in the combined custom cube. |
ZBP_CUST_OBJ_WF_CUB | Example custom combined cube joining Change Request analytics and workflow analytics. |
ZBP_CUST_OBJ_WF_OPEN | Example analytics query for open BP work items. |
The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- What is the purpose of this MDG analytics guide?
- How can I analyze Change Requests and workflow steps together?
- Can I drill down CR analytics by master data attributes and workflow information?
Possible questions
- What two standard analytics capabilities are combined?
- What development tool is required?
- How do I prepare the master-data analytics CDS view?
- How many objects are generated for the analytics configuration?
- Which CDS view provides work-item analytics?
- What is the combined-cube join field?
- How do I create the query CDS view?
- How do I configure the Smart Business report and roles?