Hi John, Thanks for the help. I found out that data actions should be avoided on calculated and hidden columns. Its always recommended to use on attributes. Thanks, Kusuma

Hi All, Thank you for the detailed explanation, Our Client querying for almost 12 years Date range, that was around 470 columns. Ideally best to have more specific filters instead of just date range, Or to have focused data in different dashboards. Thanks, Kusuma

Hi @Federico Venturin I got your point. This is a client environment and we are migrating their reports from 12c to OAC, The error report has only 30k records and it is working fine in 12c. Are there any limitations that apply if the pivot view is displaying more cells or more columns? Thanks,

Hi @Federico Venturin , Here is the screenshot. Oracle support feedbacked saying if there are more cells to display we may face this issue. please suggest.

I am seeing Default- English- United States

@Santa_B-Oracle you can see the current date and variable here.

@Santa_B-Oracle please check the init block here

I have used "USERLOCALE" with default 'en-gb' in the rpd but still in 'my account' in analytics Locale (location) has not changed. I saw in the document that the configuration changes for a few variables like ' GROUP, ROLES, DISPLAYNAME, USERLOCALE, TIMEZONE, PORTALPATH, SKIN.' should be moved to OAC system settings. And…

Hi Santa_B-Oracle, I have chosen the preferred time zone in the console and I can see the selected one in My account. I guess this will apply for all users. But My question is - how to change get the date format as DD/MM/YYYY?

Hi Gianni, Looks like "USERLOCALE" is to set the language of the user's browser when a user logs in for the first time. can find the document here: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/locale-user-interface-presentation-services.html#GUID-7A190D9E-2164-4290-B03C-C4E705F073E2

Please share if anyone has workaround