Hi Gianni and Christian, Thanks for your reply.

Hi Christian, Thanks for your prompt response. Currently, we are using OBIEE 12.2.1.2 and oracle 12c as a data source and metadata. we are planning migration from Oracle 12c to Oracle 19c. so that obiee 12.2.1.2 support oracle 19c? And also , is it possible move metadata from oracle 12c to 19c? kindly suggest on this.

Hi Berg, Sorry for late reply. We are getting below error message after changes. we are using OBIEE 12.2.1.2.0.

Hi Berg, Thanks for prompt response. I have tried same steps what mentioned in Oracle document, but no luck. Getting below error message after changes. Kindly suggest me on the same.

Hi Ceresa, Thanks for your support. I have tried blocking analyses in answers in OBIEE 12.2.1.2 as per oracle doc. No luck https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG1326 I created folder analyticsRes in…

Hi Berg, Thanks for your reply. I followed below link.But unable to deploy analyticsRes via console. Kindly suggest me on the same.

Hi All, I need to implement chapter 17.6 from this doc. https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#i1016030 Tried below points. no luck 1. C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\msgdb\messages\answerstemplates.xml changes file From "<script type="text/javascript">function…

Thanks for your response. Cache has been enabled in EM. I'm having an issue with a prompt in OBIEE 12.2.1.2.0. When user1 select drop down under "Region column prompt" (dashboard prompt) for the first time then able to see "Hyd, Bang, Chennai" and created cursor cache query in manage sessions with user1". When user2 select…

Hi Christian, Can we achieve this requirement without time hierarchy? If yes, Kindly suggest me design approach. Regards, Ram

Hi Christian, Thanks for a prompt response. There is a Financial year column in the time dimension table. Date dim: Financial_year Financial_quarter Date_time FY-2018 -19 FY2018-19 Q3, December 30-Oct-2018 If possible please send me timestampadd function for the First day of the Financial year. Best Regards Ram