enable SAP IQ for DBACOCKPIT

last changed: 14th of October 2021

by default the User (SAP<SID>USR) which is used to move the data from the primary Database to the SAP IQ Database doesn’t have the necessary permissions to execute the options in Transaction DBACOCKPIT in ABAP.

Note 3094594 – Enable SAP IQ for DBACOCKPIT

Furthermore, it is more suitable to move the additional permissions to another user, like already with SAP HANA, called DBACOCKPIT to separate the permissions.

To change the necessary IQ Options mentioned in the following Note, these additional permissions are also mandantory.

Note 3017355 – SAP IQ 16.1 SP04 PLx – correct SAPIQDB.cfg settings

More Details of the complete SAP IQ Setup can be found in the Document mentioned here:

Note 2780668 – SAP First Guidance – BW NLS Implementation with SAP IQ

currently Transaction DBCOCKPIT is in the process of reshaping to support SAP IQ much better for the SAP standard Use Cases and also replace the retired SAP IQ Cockpit based of the Adobe Flash Technology which was stopped by End of 2020.

• structured data from BW(/4) – (NLS/DTO/Cold Store)
• unstructured data from ERP, S/4 (ILM)

a extensive SQL- Editor is underway as well …

stay tuned …

Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics, SAP SE
@SAPFirstGuidance

“I have no special talent, I am only passionately curious.”