Oracle Business Intelligence

Products Banner

Problem making dashboard

Received Response

Hello I am a beginer in obiee. I have a table in which the entry and exit moves. I have another one of locations where I also have classified the department to which it belongs.

My movement table has date and time, movement type and location. When I do a query with the two tables to get the input or output moves by departament, the value of the department field that gives me as a result is that of the entry movement. Check-out date and time is the same as check-in. What I need is to compare if the department of origin is the same as the one of destination. I am a BI user and I do not have access to modify the repository. Thanks