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

Query time limit based on subject area query

Received Response
1
Views
1
Comments
user12863665
user12863665 Rank 6 - Analytics Lead
edited Aug 13, 2024 7:07PM in Oracle Analytics Cloud and Server

HI,

i would like to know if I can setup query time limit based on subject area.

some subject areas I want 15 mints and some I want 20 mints And some unlimited.

i Want to cancel the query if the query crosses more than 15 mints Or 20 mints.

where do I need to setup this

Answers

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

    As you can see from how things are built in the RPD, things are based on database objects in the physical layer:

    pastedImage_0.png

    So if you want to have a hard cut by SAs then you'll have to replicate your database objects so that each SA has its own distinct database objects that it points to. This way you can manage things with the normal query limits functionality.

    Obviously that would mean loads of duplicate physical layer objects...