Yes it can be achieved via using Open Document link. To get HTTP link, you need to store object in BO repository and get open document link from BI Launchpad.
When you store object in repository, you have to handle necessary credentials and running queries can be handled by this. You can setup SSO in OpenDocument and SSO source can be an Active Directory authentication, or SAP BW.
When SSO is setup, clicking the generated OpenDocument link should automatically log you on and open the dashboard and you don’t need to pass additional authentication.
In short, you have to follow below steps: