Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasan_vinayagam
Active Contributor

Authentication methods for Create an OLAP Connection to SAP BW using BICS in SAP Business Objects:


     OLAP - Online analytical processing

     BICS – Business Intelligence consumer services

The OLAP connection to connect to SAP NetWeaver Business Warehouse (BW) from SAP Business Objects by using Business Intelligence Consumer Services (BICS).

Three types of Authentications

  1. Prompt
  2. Pre-Defined
  3. SSO

Prompt;


                The Prompt option forces users to specify SAP BW credentials every time they run a query in a Business Objects report using this OLAP Connection.

Pre-defined:


                The Pre-defined option sets a specific user name and password for the OLAP Connection that will be used for all users whenever they run a query in a SAP BO report based on this OLAP Connection. Users will not be prompted for a user name and password at the time of executing the query, and all users viewing BO reports based on this connection will see the same result set.

SSO:


The Single Sign-On (SSO) option captures a user’s SAP BW credentials from the user’s current BO platform log on, and passes the credentials to the SAP BW server when the user runs a query in a BO document based on password at the time of executing the query, and all users viewing BO documents based on this connection will see only records they are personally entitled to see.

7 Comments
Former Member
0 Kudos

Dear Sir,

Well thanks, for providing us useful document .

Regards,

N S Rathore

former_member189884
Contributor
0 Kudos
srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Josh,

Thank You.

Regards,

V Srinivasan

radhakrishnan_r
Participant
0 Kudos

Excellent Document thanks for sharing!!

Regards,

RK

Balaji
Participant
0 Kudos

Hi Srinivasan,

Good definition details about the different types of authentications.

Q1:just want to understand when we will use this prompt option, because as per your definition this will forcing users to enter the password every time

Q2:Are we have any scenario or best practice when we go for each authentication type?'

Regards,

Balaji

0 Kudos

Good post,thanks for sharing...

Regards,

Tamilvanan

Former Member
0 Kudos

Generally, SSO is useful to manage row-level securtiy based on user's Access levels

Thanks for sharing.

Emrah

Labels in this area