We have created a Live connection on SAP Hana cloud platform in SAP BO Cloud. Once we try connecting to it by giving username and password (not SSO) it sometimes prompt again for authentication and does not connect. Other times it simply connects without any issue. We have given all the necessary roles and access rights to the user as mentioned in below blog.
Let us know if anyone has faced similar issue.