Hi Christian Berg You mean to say that there is no separate Usage Tracking RPD and Catalog.(I sure that I have downloaded the Usage Tracking RPD and Catalog from Oracle Site during the year of 2013 April and then this Usage Tracking RPD is merged with Master RPD and show the 10 plus out of the box reportts to the Users)…

you mean to say that RPD and Catalog for Usage tracking are not available as out of the box.

Hi All Let me rephrase my question Where can I download the usage Tracking RPD and catalog for OBIEE 11.1.1.9 version. I can merge the downloaded RPD into my Master RPD and do display the reports.

Hi Christian Our current Prod version is Oracle Business Intelligence 11.1.1.9.0. We have around 20 country implmentation. we have a separate data warehouse for each country and however we have only one OBIEE Instances. Moving the RPD from Lower environment to higher environment is tedious task as we have manually change…

Hi Gianni, We- OBIEE guys well understood the need of Distinct Clause. But how do I explain to the business users as they dont understand well. Can we suppress the Distinct Clause or not? if yes, how do we do. Thanks Selva

Hi Gianni, Yes, When we select some set of Attributes only Report for our Legal Compliance. We lose some valuable information. so We want to suppress the Distinct clause. Thanks Selva

Hi Gianni Could you throw some more light on options 2 or 3. Thanks Selva

Hi Gianni, These 40 schema resides in 40 hosts.or may be in 4 or 5 Regional Servers. Thanks Selva

Hi All So we cant do the init block more than one time . What is the best alternative solution to connect 40 different schemas having the identical tables for the set of reports. Thanks Selva

Hi Christian/Gianni We enabled the checkbox to set by any user. on the Variables Thanks Selva

Hi Christian/Gianni The solution is not working out. We used the following query as initialization block SELECT DBNAME , DBLOGIN, DBPASSWORD, LOGIN_NAME FROM DB_DETAILS WHERE LOGIN_NAME='VALUEOF(NQ_SESSION.OBILOGIN_NAME)' We used OBILOGIN_NAME as the Request varaiable and also as the session variable. The connection is…