Oracle Analytics Cloud and Server

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

Select Client / End User Machine Name in RPD

Received Response
51
Views
9
Comments
Rai Qaiser Hussain
Rai Qaiser Hussain Rank 5 - Community Champion

Hi All

I want to define new variable in OBIEE (Oracle Business Intelligence 12.2.1.3.0) RPD which should select Client Machine name (end user machine who is using dashboard),  based on this Client Machine I have to select User Code and User Name.

Anyone please help about built-in function etc.

regards

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    The RPD is running on the server. It can't know the "client machine". Also....web-based users can log on from anywhere with any browser. The client-server principle is pretty much dead since a good 20 years.

  • In addition to what Christian said, even assuming you could have a prompt in the GUI setting a request variable, it still doesn't work.

    Luckily they forbid browser scripting languages like javascript to mess with the client on which they run and give away information.

    Would you be happy if any website could have access to your machine name and other things just by a piece of javascript? Probably not.

  • Joel
    Joel Rank 8 - Analytics Strategist

    In addition to @Gianni Ceresa & @Christian Berg, you may want to consider revising your logic to be based off the user rather than the machine as has been explained above, you won't be able to get that information from OBIEE

  • As we now all agreed it isn't possible, let's go back to the original need:

    Rai Qaiser Hussain wrote:...based on this Client Machine I have to select User Code and User Name.regards

    So the logic is: somebody login into OBIEE providing username/password (or a SSO token), once the login is performed the sessions variables are set.

    This means that when you wanted the "client machine name" to select "user code" and "user name" you already know the username used in the login. Isn't it easier to get a user code and user name from that info? From the login itself which at least is unique wherever somebody login to your system from?

    Or maybe you had something else in mind and this is a XY problem with this being the answer to Y while the original need is X ?

  • Rai Qaiser Hussain
    Rai Qaiser Hussain Rank 5 - Community Champion

    Hi @Gianni Ceresa

    Actually no one is using OBIEE directly, We have an application (Emp Code is used for login to application), we use webutil to open OBIEE dashboard URL then auto nevigate which hides credentials immediately, we have some employee wise parameters which we can get if we have client terminal name ---- These parameters will be used for dashboards prompts and others

  • Joel
    Joel Rank 8 - Analytics Strategist

    Can you not use the Emp Code to determine these parameters?

  • Rai Qaiser Hussain
    Rai Qaiser Hussain Rank 5 - Community Champion

    Hi @Joel Acha

    My mistake I could not explain my reply properly ---- We have two different applications, no link between these two applications

    1. We have Oracle application running in our institute, Emp code is used for login, some parameters are linked with every employee, parameter vary employee to employee --- I can get parameters against Employee Code
    2. We are using OBIEE with single user (we are not using Emp Code for OBIEE application, We are using single user for this application), There is no link between these two applications but If I could get client machine name in OBIEE then I can get employee code and their parameters.

    Note:- With our own developed scheme, we are calling dashboard URL from oracle application by using webutil and it is working fine ---- Webutil can not pass parameters to RPD/ dashboards

  • Joel
    Joel Rank 8 - Analytics Strategist

    I would personally recommend revisiting your security architecture between these 2 applications. In earlier responses in this thread it has been made clear that you can't get client side information like client machine in OBIEE. I think that you may need to consider setting up SSO for your authentication between OBIEE and your application.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    +1 to Joel. There is a very basic flaw in the underlying concepts that have been chosen.

    "Client" isn't a thing in a browser environment wheres "users" is. So you  need to integrate the security on the level of users and roles like the system is designed to do.