Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Username and display showing incorrect when logging into BI Publiser with SSO

Received Response
11
Views
1
Comments
User_A81NX
User_A81NX Rank 3 - Community Apprentice

We have a Read Only SQL Authenticator Provider configured in WebLogic and in Oracle Analytics (BI) we are using the HTTP Cookie method to get a token that represents an authenticated user. We reference the token in the provider specific queries and SSO into Oracle Analytics works. However, the User ID and Display Name field when you click on My Account shows the token value coming from the cookie - even though we have defined the queries for describing the user, which select the username from a user table. Observing the queries being run against the database it appears as though only the SQL User Exists query (and another query that gets group memebership) runs - the query to get the user description doesn't run. So it appears that SSO using the cookie bypasses enriching the user object. Is there something that can be done to force those queries to run?

The version is OAS 2023 on Windows 2022 server, weblogic 12.2.1.4.0

thanks,

josh

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_A81NX

    Are you able to see correct value from /analytics application?

    Are you using any session variable to extract the values or userid ,display name is coming from any query?

    Did you followed any documentation?

    Regards,

    Arjun