We see few reports in Business Value Dashboards.The default reports are not working properly.These reports are asking for few prompt value. I am unable to fill the prompts as Its showing no value and sometimes error. We just installed RO79125 patch as we do not have any tenant.
Here are the two mandatory prompts(Country,Time Period) which can not fetch value and therefore I am unable to provide anything and reports are showing blank. The Time Period prompt is showing error sometimes.
Environment:- SDM 14.1 with Oracle and CA BI 4.1 SP3
Furthermore, I found few related derived tables in universe
On the BROWSERLOCALE derived table, if I right click to view the Table Values ,its giving error
I am unable to replace LEFT keyword with SUBSTR in sql query of BROWSERLOCALE table.