Alligning two results on same row

fabryddorf-Oracle

Hi Guys,

I have the below report, where i need to find out which guest is departing today and which is arriving today and occupying the same room.

Basically the guests should be remembered to leave the room in type to have some space to clean it for the next guest.

Any idea?

Thanks a lot

Gianni Ceresa

Hi,

Are you using OBIEE?

As you maybe know, OBIEE is delivered empty, no data, no models, no analysis.

You are asking a "functional" question which is based on a model and a dataset. But you are the only one having that model and dataset, nobody else in here have it.

Therefore it's just impossible to give you an answer if you don't explain in detail what is available and how does the model look like.

fabryddorf-Oracle

Hi Gianni,

This tools is using OBIEE, but since it is a cloud product and I am only a user, i do not have access to the data model.

It would be already enough to filter out only reservations with departure/arrival on same date and that have same room number.

without alligning them.

The sample from before should show only Luigi Santoro e Giuliano Bruno reservations. Exclude all others.

I tried also with a UNION and filtered each query differently and labeled them, but still i can see all other reservations.

Sorry, i can not provide more detailed explanation.

Gianni Ceresa

This tools is using OBIEE, but since it is a cloud product and I am only a user, i do not have access to the data model.

OBIEE doesn't exist as "cloud product". There is Oracle Analytics Cloud (OAC) which is a cloud product. Or you using another product which has a old OBIEE embedded for analytics (like OTBI or Fusion).

Still, the point is that you ask a question based on your model. I don't have your model, therefore can't answer anything as it's based on something which isn't OBIEE but custom provided metadata.

fabryddorf-Oracle

Hi Gianni,

I can not answer your questions. OBIEE is pointing against a database which is behind SSD 3.0. Not sure if it is considered in cloud, but we are restricted to access it.

It is actually an oracle product called R&A pointing against a DB in cloud from Oracle.

Nevertheless I found a workaround , which is acceptable, just need to mark the rows with a conditional formatting now.

Thanks for your help.

Regards