Guys just to let you know this Note resolved my problem OBIA 11g GL Related Balance Sheet Dashboard Not Displaying Data (Doc ID 2139167.1) Applied patch 21454239 and all is well now. Thanks fellas

I think my issue is the currency setup as all amounts appear as $0 as per screenshot below instead of local currency which is KES and correct amount

However the thing is if i actually do a simple analysis using the current subject area it retrieves data, but not on the pre-defined dashboards

I configured the RPD as per the Oracle Documentation, don't believe i missed out on anything, however these are some of the messages in the nqserver log file [2016-07-19T13:07:25.352+03:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 36d883615cd52f62:-210a7ee3:155ff4fbcb0:-8000-0000000000005595,0:1:71] [tid:…

rmoff, Not using caching and have not cleared cache since the data load completed Regards Edwin

I found the issue and it's addressed in the following Note Select Statement Throws ORA-01792 Error ( Doc ID 1951689.1 )