Thanks Gianni, will check there

This is solved now. The approach was correct. It was giving an error because I have to pass the trx code value in single quotes select ''''||"Financial-Transaction Codes - Details"."Transaction Code"||'''' from "Financial-Transaction Details" FETCH FIRST 65001 ROWS ONLY

Thank you Gianni for the suggestion. I did not appreciated the cinical ton from Christian between colleagues however. I already said, I am not an expert and prefer rather no answer to some arrogant answers. Below is what Christian suggestion returns. It transforms the description into market codes and group the market…

Don't know if it is possible at all

Hi Christian, Maybe i was not clear enough. I am using the description to easily identify specific market codes, but basically all i want to group are the market codes based on description. When description like %Retail%' summarize the market codes and call them RETAIL. it should summarize (BEN+ECM+MAR+REG) into a market…

Hello Christian, I used the RCU i download from https://www.oracle.com/middleware/technologies/bi-downloads.html where I also downloaded the OBIEE media files on 11.1.1.19 When I run the 11.1.1.19, it did not generate any log file I could find. When I run the rcu I found in D:\ORA\MWFR\12cappr2\oracle_common, it generates…

Hi Gianni, Not really, because i am happy to have the results into two rows as shown in the screen shot above. What am I asking is if there is a way to highlight these rows or to remove the ones I do not need. A simple NO would be sufficient. Regards

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…

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…

Hi Jerry, Thanks for this. As my prompts were not working and I google it, I found that they work not with union queries and also the error message says exctly that, but good to know they work. Will do more testing. I am not sure if it is called Bin function, but actually i did so, creating an extra column for channel,…

Hi Jerry, this solution would work if i could set the a filter on the report using a presentation variable which i would define in the prompt, however as this is a combined report , meaning is using UNION requests, you can not set prompts on the combined reports. This is why Important to get it with a timestamp function so…

Hi Gianni, sorry, but it seems i can not remove the other one.

I will remove the other one and leave this one. Thanks

Yes sorry, you are right. Regards

Hi Gianni, I am an end user, meaning i just use a business intelligence tool. There is a dual hirarchy, but I was told Fiscal is not working, therefore I need to find a way to build manually. The previous answer was helpful, using a CASE function to build the fiscal year to be used then as a filter. 2 limitation with that:…

I see what you mean and if I would like to make a comparison with previous fiscal year on same report? case when MONTH("Table"."Date")<5 THEN YEAR("Table"."Date")-2 ELSE YEAR("Table"."Date") END ? So i would need to join same query and filter differently correct?

mmm, not sure about this one. This will return only the correct year right? I do not have an additonal column for Month or so. The date field is called "Filters.Business Date". So i need to filter the business date, so that it will retrieve room nights and room revenue from 01-May-2020 till today and when i run the report…

Great!! That worked! how to i mark as solution provided?

Thanks , that helped! The solution was COUNT(DISTINCT "Property"."Resort" by "Guests"."Guest Name" ) and filter >1

that was it COUNT(DISTINCT "Property"."Resort" by "Guests"."Guest Name" ) Filtered >1 Thanks again