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

Is it possible to create (or delete) aggregates via "Administration > Issue SQL"?

Received Response
12
Views
6
Comments
User_U4XQW
User_U4XQW Rank 2 - Community Beginner
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

I know it's not an official Oracle book, but as per "Oracle Business Intelligence 11g R1 Cookbook" by Cuneyt Yilmaz (Packt Publishing), after you've generated an aggregate creation script via the Aggregate Persistence Wizard, you can run the script via nqcmd *or* via Presentation Services "Administration > Issue SQL".

However, even if I try a simple command such as "delete aggregates" (or any aggregate creation statements) I always get an error. However, issuing some simple analysis SQL via the same method works just fine.

The error is "Authentication failed: invalid user/password".

When I check the EM log I get OWS-04086. (Can't seem to paste the error message into this box?).

I've done some googling and it suggests an issue with WSM_POLICY mismatch, which I shall look into.

However, I was wondering if anyone can confirm if it's definitely possible to create or delete aggregates via this method?

If so, is there any Oracle documentation confirming this approach?

Thanks.

Alan.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Depends - who are you logged on as? You need BIAdministrator rights to do anything aggregate-related.

  • User_U4XQW
    User_U4XQW Rank 2 - Community Beginner

    Hi,

    thanks for the reply. I'm logged in as my own account but I have both "BI Administrator Role" and "BIAdministrators" (with an 's').

    Should be good enough, right?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Which version are you running and which site are you referencing for the policy mismatch?

    And also why do you have 2 administration application roles?

  • User_U4XQW
    User_U4XQW Rank 2 - Community Beginner

    11g (11.1.9.0 methinks).

    The mismatch doc is from MOS - 1955595.1, might be relevant, might not be, but it's what I would check next.

    Good question about the Admin Roles, I guess I'll have to dig further.

    But in general - deleting and creating aggregates should be possible via Admin > Issue SQL, right?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Works for me with weblogic

  • User_U4XQW
    User_U4XQW Rank 2 - Community Beginner

    OK thanks, good to know. I'll see if I can get access to that login here, and if that does work maybe I can figure out which security policy I need.