Skip to Content

SAP OLE DB reports Multiple Log On

HI Experts,

We are using SAP BW OLE DB reports for One of our clients and when we have multiple Excel Tabs we are prompted to provide User ID and Password multiple times.

Is there any way like Bex workbooks so that we can provide User Id and password one time. So that when ever we refresh all the Tabs with in the Excel will not prompt Log in Credentials Again.

The SAP OLE DB Reports were bulit on top of the Bex Queries.

We have tried the Option for the Save Password but it will show our Password when we email the file to other Users.

Regards,

Srikanth Chennam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers