You are quite right. Thanks for clarifications

OK, but he didn't responded to my reply. Maybe I should to notify him again. Thanks

Dear Gianni, Recently, I've asked two questions in this community but I didn't get answer for them. Since these questions are important for me, I've notified you from this thread to help me again, please. Unfortunately, it seems that there is no other way in this community to contact or notify someone. The questions:…

I'm new to OBIEE and I don't know what does mean Pre-canned reports and ad-hoc in this context. 10 TB is the size of our data warehouse, i.e. our Star Model (Dimensions and Facts), not Database raw data.

Thanks for your answer.

Thanks a lot.

Great answer. It works like a charm I greatly appreciate your help, especially for attaching the images. From your answer it seems that there are many more hidden features than what are explained in oracle official tutorial for creating repository. If there exists a good tutorial, could you please introduce it to me? ...…

Gianni, thank you for the answer, I'm new to obiee and your answer is hard for me to understand The first part of your answer, i.e. hardcoding the 2nd logical column for each LTS, seems to be easy, but the second part, i.e. defining a fragmentation rule for each LTS to populating the 1st logical column, is very confusing…