You are trying to preview data sources like Material Supply and Demand Keyfigure AND Material Supply and Demand List. System takes lot of time to open these data sources in preview mode and later fails with a crash.
Reproducing the Issue
- Go to Business Analytics Work center
- Go to Design Data Sources view
- Select the Data Source that you want to preview.
- In this case, Select Material Supply and Demand Keyfigure data source and click on Preview button
- System takes long time in opening the data source and after some time fails with a crash
- Same scenario happens when Material Supply and Demand List data source is also attempted to open with Preview button.
The cause of this crash is the huge number of records in these data sources. To retrieve information regarding these records, the system is taking more time than the set time limit. Due to this a time out event is triggered and system crashes.
Please follow the below mentioned steps to avoid such crash while trying to preview the data source:
Go to Business Analytics work center.
Go to Design Data Source view and select the Material Supply and Demand List data source that you wish to preview.
Click on the New button and select option Report from drop down.
A Guided Activity screen opens up. In this screen, please provide a Report name and proceed with default selections.
In step 4:Characteristic Properties, select Planning Area ID, Specification ID and Material ID as Using Variable under Value Selection column.
In step 7: Confirmation step, select the option Create View for this Report in a Web Browser.
Now in the new screen, you will have the Planning Area ID, Specification ID and Material ID as selection parameters for the report.
Generating the report using value by providing any of the selection parameter doesn't result in a dump as the result set contains filtered data as per the selection parameter. Similar steps can be followed to preview Material Supply and Demand Keyfigure data source.
KBA , scmpdv01 , scmmsdvv02 , scmmsdvv01 , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement