Custom Data Model Enhancement using User Inputs in EA SAC: SAP Incentive Management

[TarunArora]

SAP Custom EA Data Model with Parameter Approach

Feature: User Input in Custom EA Models

As we know when data is huge, adding Parameters capability to Model is the most looked-out approach, it works much better than Story Filters.

In EA Custom Data Models also we can use the same to enable EA-SAC Reports more efficient and quicker.

Use Case: -

Let’s take example where we have Model running on heavy load and adding Period User Input will make it more efficient.

Solution: Use of User Input in Custom EA Model: -

In our Problem Scenario, What User Input will do is instead of bringing all Periods in Report, it will ask User to select Period and accordingly will push the Response to the Model, rather than bringing data for all periods in Report.

What we have to do: Is to Update CSN File with Parameter Option

First Create Parameter like the one below

• Set the collection Path to the View Name
• Type:  InOut Parameter
• ValueList Property: Is the Database Field where we need User Input

Second Create Variable: In this we will use Variable property of Prompt and assign Parameter to It.

In the Third Step: You need to assign Variable to the View in the CSN File.

Assign Variable to the ABAP Model as below: -

User Prompt: - While launching SAC-EA Story

List of Values (Available Members): -

Note: User prompts cannot be optional and multi-selection prompts are not possible at this time. 

With the above Parameter Selection you will have light weight EA Report with Faster Response time.

Big Thanks to @jodiyuen who is instrumental in driving this feature and helping me to put into execution. 

[philipholtom]

Has anyone got this working with EA?

Does anyone have a complete example json file we can see?

For example what does Assign Variable to the ABAP Model as below: mean? Where does this go?