Very Nice blog that provides a very good overview.However after SAP migrated it to the new "url" your uploaded Pictures got lost and now there is missing a lot of information. (The Scenarios) @narasingha could you reupload your Pictures?
On DSP there is no ABAP possible.However if you are using BW-Bridge you sill can use ABAP but there are some restrictions for the BW and ABAP functionalitys.(Like you use lose the OLAP Enginge so the Query with the Customer Exit's ect.)This is a good...
An S-User you will recieve from your company you are working for (I don't know sur, but most likely they have to be SAP Partners oder SAP Customer so that they can create S-Users), or from a Customer you are working for (if you need to raise tickets ...
The 1st Level Approach would be to Use the View Analyzer. If you need more details you should use planviz in order to identify the root cause in your datamodel https://community.sap.com/t5/technology-blogs-by-members/performance-analysis-in-the-sap-d...