My UI screen has top selection criteria based on which data needs to be extracted for different sections of screen.
Data Selection criteria
Company Code, Profit center , Date Range - Only one Company code can be selected but option to select multiple profit centers from dropdown and date range.
Now all 5 sections of screen shows summarized data(diff criteria) based on input from selection criteria. I know we can get this data through regular get_entity set method for each screen section but that will be like calling service multiple time for each of them. How can we accomplish this task in single service using expanded entity set method. It is like I wanted to use the top selection criteria to get all data and then summarize data for diff section and pass it back to UI. Not sure if it is possible?
Ekansh Saxena replied
First of all, it would be better if you perform this aggregation/summarization logic in the backend. Coming to the gateway part, if you are not able to make a clear association with some common key properties, you can delete the referential constraint at the time of declaring the associations. So you can have association n navigations with any common key. Then implement the get_expanded_entityset method and get all 4-5 tables in the single call.
Otherwise you can opt for batch but the above method would be better in terms of performance as it is calling the RFC single time.