Issue with Time Series Calculations — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with Time Series Calculations

Received Response
23
Views
5
Comments
Ebin Cherian
Ebin Cherian Rank 5 - Community Champion
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

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.

pastedImage_1.png

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

Answers

  • Souro
    Souro Rank 2 - Community Beginner

    Do non admin users have access to the time hierarchy.?

  • Indravathi
    Indravathi Rank 1 - Community Starter

    check  Permissions to that particular subject area. If no, then provide permissions and also check the LSN .

    Note: If post helps you then click on like.

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    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.

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    Yes, they have access to time hierarchy.

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

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