Issue with Time Series Calculations

Question

Hi All,

Oracle Business Intelligence 12.2.1.1.0.

We use time series functions like AGO,TODATE in various reports. If we include 2 levels in the column formula calculation, then after saving the report, other non-admin users are not able to edit the report. If they click on edit, following error message is displayed.

eg : TODATE("Margin Measures"."Gross Revenue","Time"."fiscal time"."Fiscal Quarter")-TODATE("Margin Measures"."Gross Revenue","Time"."fiscal time"."Fiscal Year").

If level is made same in calculation, then users are able to open the report.

eg : TODATE("Margin Measures"."Gross Revenue","Time"."fiscal time"."Fiscal Year")-TODATE("Margin Measures"."Gross Revenue","Time"."fiscal time"."Fiscal Year").

In all scenarios, users with BI Administrator role is able to edit the report.

Edit : Same Error is thrown if an IFNULL(expr,0) is added to TODATE function.

Please let me know if anyone else faced same issue and resolved it.

Thanks

Ebin

Ebin Cherian · Answer

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

Ebin Cherian · Answer

Yes, they have access to time hierarchy.

Ebin Cherian · Answer

As mentioned in original post, they are able to create the report. This means user have access to that subject area. Issue is happening when they try to edit it again.