Skip to Content
avatar image
Former Member

WEBI Report Error - Rights issue

Nov 15, 2016 at 10:06 AM | 87 Views

Hi All,

Getting the below error on execution. Report is built with BW as backend. Have connected to infoproviders via Universe.

database-error.jpg

Error is Authorization Select is Denied on the connection. How to resolve this.

Thanks,

Harsha

database-error.jpg (18.1 kB)
SAP BusinessObjects - Semantic Layer
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2016 at 10:17 AM

    Amit,

    Can the access be provided over roles from SAP or does it needs to be added from BO CMC. Sorry for my ignorance, but these are the queries by my systems team.

    ,

    Amit,

    Can we provide access over role from SAP or it needs to be added from CMC. Sorry for my ignorance, but these are the queries from my systems team.

    Add comment
    10|10000 characters needed characters exceeded

    • AMIT KUMAR
      Nov 17, 2016 at 10:21 AM

      what is the authentication you have selected in the universe connection?Single Sign on or predefined(static user name & password)?

      If single sign on in the connection then you need to enable the SAP authentication in CMC and need to import users& roles from BW.

      If you have used predefined username & password then check in the CMC if user who is running the report has access on BO connection & universe..

  • avatar image
    AMIT KUMAR
    Nov 15, 2016 at 10:34 AM

    check if user has access on the universe connection?

    Also try to execute the test query in IDT and check.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2016 at 11:02 AM

    Amit- this access need to be checked in the roles or in the universe connection settings?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    AMIT KUMAR
    Nov 15, 2016 at 11:11 AM

    First you need to check if user has access on the BO connection..This you can check from BO CMC.

    Second if user which you have used in the universe connection has access to get the data from BW.with same user check if you can run the some reports in BW. either check from RSRT or from BEx analyzer.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2016 at 10:37 AM

    Alright Amit. Thanks.

    Add comment
    10|10000 characters needed characters exceeded