Sure.Definitely I will discuss with my technical team and manager . Thanks foe the inputs

Finally after removing the filters- fiscal year,period and quarter from criteria pane and also i have modified the amount column formula in the report. Now the data is coming as expected. Thank you for each and everyone for their valuable suggestion and inputs.

Yes .Its a real time hierarchy and its having unique key at all levels.

Time Dimension structure is as below \ We are not purposefully ignoring the out-of-the-box functionality of time series.But we are storing the Forecast,Actual,Budget,ABR,FBR data in one table.so if we want get the data we have to write complex formula as per revenue forecast dashboard functional design.

Please follow my comments as inline below Your version of OBIEE - 12.2.1.3.0 What your time dimension looks like in the subject area in question?- Are you asking me about Time Dim structure? What logic you are using in answers to get the Current versus Next Qtr?-Logic as below

Yes. detail report having 10 filters where as summary report having 15 filters(Summary report is coming from two subject areas) at criteria section.

Yes. detail report having 15 filters but in summary report having 10 filters at critera section

Thanks for inputs .yes above mentioned columns are prompted at criteria side. its coming from 2 subject areas.

I ran the both summary and detail report physical queries in the DB and it is giving as expected ...but why it is not showing 5 records as per date 07-sep-2015 ??? why it is considering supervisor name column and displaing 2 records instead of 5 ?? i need more inputs to check further thanks in advance

I could see that there is a permission issue in RPD.I have provided and checked again. Everything is working fine now. Thank you for your inputs.

I have checked and confirmed that writeback.xml file has read and write permissions in production instance.

Yes .Previously it is working for one of the report in the dashboard but now facing the issue after moving the newly created dashboard/report from dev to prod.

and also how to generate/get below junk code for a column '@{ca6aab9a39bac1758}' please help me with understanding

Yes.. I have moved the file from Dev to Prod with Weblogic/Administrator user

Hi Gianni, I have followed the below steps to implement the new cilent logo in both home page and login page in Prod 1.stopped the OPMN services,Managed Server,weblogic server 2.Taken the backup of old client logo and rename the new client logo as oracle_logo.png(80*25 is the pixel size) and uploaded in below two paths…