Skip to Content

Connection to BW via BusinessObjects Platform

Hi guys,

We want our users to log onto BW via the BO platform. At the moment I can pull a BW user through into our BO system and they can log onto Analysis by selecting BO platform using SAP Authentication. The next step is that they need to log onto BW. We don't have SSO set up so again they use their BW userID and password.

What are the options open to us for allowing our users to log onto BW? By that I mean which of the connection options can we use? Currently I only see a list of systems when I select 'Local System' and it pulls thought the systems from my .ini file and I can connect ok to any system regardless of which BO system I connected to.

Can/should I be able to see a list of Systems that we want to give our users access to from the 'System' option from the conenctions pull-down?

I can't find any documentation that details how I go about doing this, if it's at all possible. I assume I do some security in the BO CMC?

I hope the above makes sense? Regards and thanks in advance,

Stephen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 21, 2014 at 01:09 PM

    Hello Stephen,

    first of all Analysis Office - regardless from where the connection is being started - will honor your BW data level security and the authorization objects. Means that the user will not be allowed to access items where the user doesn't have the rights.

    In case you are using naming conventions in BW then you could for example use a single connection in BW pointing to your BW system and the user then would see all the InfoProviders and queries - based on the defined authorization objects.

    in case you are not using naming conventions in BW, you might want to think about setting up security on the SAP BusinessObjects BI System for the connections.

    regards

    Ingo Hilgefort, SAP

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for the reply Ingo. I am happy that any existing BW authorisation flow through when connecting via BO, but what I'm struggling to resolve is allowing a user to select which system they connection to. I have created an OLAP connect for our DEV system and the user exists in BO (SAP authentication) and BW. I have assigned the connection to a group and assigned my user to this group. But it only works if they user is also a member of Administrators and then they can see all the available OLAP connections.

      We can’t figure out what authorisations we are missing – can anyone help?


      Above is what our user sees without being a member of the Administrator group even though we have added them to a group that has access to an BW system via an OLAP connection.

      When part of the Administrator group they see all connections. We want them just to see specific connections for which we hace created an OLAP conenction and group in the BO CMC.

      image_1.jpg (27.7 kB)
      image_2.jpg (26.1 kB)
      image_3.jpg (45.9 kB)
  • Apr 16, 2014 at 03:08 PM

    Have you / your BI admin created OLAP connections to your BW system in the CMC?

    See video here: Analysis OLAP 4.0 SP4: Connect to an SAP Business Explorer (BEx) query using an OLAP Connection

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 27, 2014 at 10:42 AM

    Hi i have the same issue. do you know which access is missing?

    Add comment
    10|10000 characters needed characters exceeded