Hi Debayani, You can try by using the fragmentation properties of the LTS. Regards, Akansh Agarwal

Hi, Please check this link if it helps http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/querycaching.htm#BIESG290 Regards, Akansh

Hi, The Presentation services cache is a run time cache. It will clear automatically when the report is rendered. Presentation services cache: /appshr/obiee/MW_HOME/instances/instance1/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/obis_temp Regards, Akansh Agarwal

Hi Sandeep, The best way is to create a table with conversion rate and join the fact table to this dimension. Using conversion rate to convert your currency into USD. Regards, Akansh agarwal

Hi Sriram, You can use filter function as FILTER("Amount" USING Account_num = 300 ) Regards, Akansh

Hi Richard, I haven't tried it at my end. I just entered a session variable in the DSN and checked the consistency. Regards, Akansh

Hi, You can try using the value of session variable into the DSN of the connection pool. The session variable variable can be assigned different values based on user login. You need to have same Username/Password to connect the database. Regards, Akansh Agarwal

HI, You will not be able to display if your fact doesn't stores information at hour level. Regards, Akansh Agarwal