Best Solution to connect SAP Business Objects BI open document without logon prompt?

[mathewzdavis]

Hi Experts

Please suggest the solution to access BI open document with out logon prompt. Actually need to integrate with Fiori Launchpad.

Thank you

[former_member230921 · Accepted solution]

Hi Mathew,

"sViewer=fiori" is worked for you ?

User can set it in Classic BI launchpad: click on Preferences -> Web Intelligence

[former_member230921]

Webi reports using open Doc link and flag "sViewer=fiori"

https://blogs.sap.com/2017/10/23/sap-bi-4.2-sp5-whats-new-in-web-intelligence-and-semantic-layer/

[former_member230921]

Need to configure SSO to BOE.

If you can do Win AD SSO - https://blogs.sap.com/2017/05/15/bi-platform-odata-service-for-sap-fiori-launchpad/

-

Bharath

[mathewzdavis]

Thank you for your reply but we have implemented fiori on ABAP system, not configured webdispatcher. Domain of all system are same.

can you please check whether below note will solve?

https://launchpad.support.sap.com/#/notes/1593628

Thank you

[former_member230921]

yes Mathew.

But for each Open doc URL you have add user name in URL Query String or Header.

-

Bharath

[former_member230921]

Else you can use trusted auth with x509 certificate also. In this one certificate will contain user info. 🙂

[mathewzdavis]

Thanks Bharath.

Adding a username in the url is not a problem, if we can use a user as a service user, since the reports are not data dependent to users.

In this scenario, how and where to specify the user, with only which we want trusted auth, using query parameter?

[former_member230921]

yes. You have to specify user in URL or Header.

https://help.sap.com/viewer/2e167338c1b24da9b2a94e68efd79c42/4.2.4/en-US/468202df6e041014910aba7db0e...

[former_member230921]

https://help.sap.com/viewer/2e167338c1b24da9b2a94e68efd79c42/4.2.4/en-US/467f77526e041014910aba7db0e...

[mathewzdavis]

Any disadvantages using this method?

Thanks

[former_member230921]

As per my knowledge nothing like that. But I recommend to use certificates rather than sending user info in URL.

[mathewzdavis]

Hi Bharath

The trusted authentication solution worked, now we can see the opendocument from our fiori . In android it working fine but in ios, not able to scroll. Do you have any idea?

Thank you

[former_member230921]

Great. !!!

Is this happening for all reports or specific type of reports like Webi, CR,..... ?

[mathewzdavis]

Bharath, its for all type.

[former_member230921]

If it is not scrolling for all type of documents.

Please try to open the document from new window of the browser just to make sure the open doc works properly in IOS. if it works here then might be issue with FLP.

[mathewzdavis]

Hi Bharath

we tried to open the opendoc url separately in browser, it is not working. Is there any workaround ?

Thank you

[mathewzdavis]

Hi Bharath

Upgrading to BI4.2 SP5 will open doc work properly in ipad? I read in one blog that sp5 has enabled touch feature and parameter sViewer=fiori .

Thank you

[former_member230921]

As per my knowledge "sViewer=fiori" this parameter is only for Webi reports.

[former_member230921]

https://blogs.sap.com/2017/10/23/sap-bi-4.2-sp5-whats-new-in-web-intelligence-and-semantic-layer/#co...

[mathewzdavis]

Hi Bharath

Have you worked on SP5 ? Have you tried sViewer = fiori for webi report? if yes, can you please share me a screenshot, need to see whether it has home button on toolbar.

Thanks

[former_member230921]

with Flag:

[former_member230921]

Without Flag:

[mathewzdavis]

Thanks a lott..!!! Bharath.

When a user opens a document xyz using param sViewer=fiori, is there any option to open another report document abc from that ?

[former_member230921]

Using Open document link user can open reports using ID.

No navigation options available to open to other report.

[mathewzdavis]

When we open without flag, there is option in the toolbar to open another report, is that option available using flag?

[former_member230921]

yes. You are right.

This option is not available with flag in SP05.

my doubt is : what is the issue if user tries to open other reports. (Admin can restrict using rights management if user not authorized for reports).

[mathewzdavis]

Actually we are planning to integrate with fiori with a single user using trusted authentication.

Thanks

[former_member230921]

oh. Okay. 🙂

[ayman_salem]

Hi Mathew,

you can use RESTful Web Service SDKs to logon and get the logon token and then set it in the header "x-sap-logontoken" by every call

see: SAP BusinessObjects RESTful Web Service SDK

Ayman

[mathewzdavis]

Thank you Ayman for the reply, but from fiori I can just configure a url there, cannot fetch token and append it there.

Will this work using trusted user?

[ayman_salem]

see this blog for information about trusted authentication for BI RESTful Web Services

https://blogs.sap.com/2017/12/15/bi-platform-rest-sdk-rws-in-boe-4.2/

Ayman