Hi Gianni, I am receiving unresolved hierarchy error while I use it as 4th parameter in front end.

Hi Gianni, I am struggling to add the 4th parameter to period rolling formula. It gives me below mentioned error when I add the 4th paramter. [nQSError: 27002] Near <,>: Syntax error [nQSError: 26012] .

Hi Madasamy, Thanks for your reply. Could you please confirm the tag need to be added to instanceconfig.xml to disable clientside caching ? Thanks Ebin

Hi Chris, Thanks for your reply. We are purging the BI server cache using event pooling method. That is not an issue here. Also it is not possible at the moment to make the presentation service cache change change report by report as we have large number of reports.

Hi Robert, We don't have any performance issue. The only issue is sometimes when user login, they see the error message as given in the problem description. We have OBIEE connection pool timeout of 5 minute specified. I monitored the essbase session and could see the sessions getting disconnected. I will try to increase…

Also this error occurs to User as soon as he login and run the report.

I monitored the session on essbase side. What I observed is the OBIEE session is terminated on Essbase side after the connection pool timeout.

Hi Christian, Thanks for the reply. How can I find the session keep-alive times in OBIEE ? Is it the ClientSessionExpireMinutes in instanceconfig.xml ? What would be better approach ? Disable connection pooling or increase the session timeout in Essbase ? Thanks !

HI Asim, I am aware of that option... but I am looking for a straight vertical line against an x axis data point. Thanks Ebin

Hi Matej, I faced the same issue in the past. In my case, issue was with the report. There were 'NULL' keyword used in one column formula of the report by the user and removing it resolved the issue. Thanks Ebin

Hi Asim, Thanks for your reply.User ID shows the user who is selected in the Run as Specified user section. I want to see the user who triggered the agent. For example.. say agent 1 is created and in that user 1 is selected in the run as specified user section. User 2 triggered agent 1. My question is where can I find…

I was able to achieve the required output using EVALUATE_ANALYTIC. EVALUATE gives "window function not allowed here" error if we have total enabled on the report. With EVALUATE_ANALYTIC, the report works fine. EVALUATE_ANALYTIC('SUM(%1) OVER (PARTITION BY %2)', "Accounts Payable"."AP Metrics"."Amount" , "Accounts…

Hi, Can you try giving the "SELECT" privilege to user used in connection pool ? GRANT SELECT ON owner.table TO user;

Bug 26088535 - you do not have access privilege for this subject area error when editing report

Hi Sree, Checkout the certification matrix to find the supported databases. For OBIEE 12.2.1.1.0, supported DB's are Oracle DB 12.2.0.1+; 12.1.0.1+; 11.2.0.4+, IBM DB2 10.5, Microsoft SQL Server 2012, 2014. Oracle Fusion Middleware Supported System Configurations

Hi Frog, We initially had the same issue in 12.2.1.1.0 and we applied patch 25187465. After that we were able to edit the report with "AGO" function. But now we are facing the same issue in certain other scenarios. Scenario 1 - Different levels in the column formula. TODATE("Margin Measures"."Gross Revenue","Time"."fiscal…

Hi Sulochana, We faced the same issue with one of our user. Followed the steps mentioned in Doc ID 1399996.1 and it resolved the issue. Thanks Ebin

Few days back I came across an oracle document which explain similar issue. It was for OBIEE 11g. Doc ID 2257126.1

Response from Oracle I did some research and found this to be a Bug which is raised as part of enhancement request . This is currently with Development team for review. Bug 21086656 : DATA FORMAT PROPERTIES SHOW ONLY LIMITED PROPERTIES

Any chance to post a sample rpd with this issue ? Also do you have any entry in the Aliases section in Presentation layer ?