Oracle Analytics Cloud and Server

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

Dynamic variable in OBIEE 12 connectionpool

1
Views
2
Comments
User_8DRI6
User_8DRI6 Rank 1 - Community Starter

Is it possible to use dynamic variable in OBIEE 12 connection pool. Created a intialization block with case stmts to determine username based on environment. Assigning that variable instead of username not working

Comments

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    "not working" meaning what in this case? It doesn't get used at all? The wrong one gets used? What precise error do you get and where? What exact configuration have you done?

  • User_8DRI6
    User_8DRI6 Rank 1 - Community Starter

    Issue has been resolved, there were circular connection pools between two dynamic variables