Adding SA button disabled while creating a column prompt — 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

Adding SA button disabled while creating a column prompt

Received Response
11
Views
4
Comments
Saro
Saro Rank 5 - Community Champion
edited Aug 13, 2024 7:08PM in Oracle Analytics Cloud and Server

Hi friends,

Im in OBIEE 11.1.1.7.1

When im trying to create a column prompt with the primary SA and also im trying to add the another column from the other SA, but the button for adding it is disabled in the column prompt window. But from the help note i can find this "This button is available only if one or more related subject areas are available and you have permission to access them". Since im accessing it as a weblogic user(As this super user have permission to all the SA, but then too why the button is disabled? is there any other extra privilege is missing.

Thanks in advance.

Regards,

Saro

Answers

  • Saro
    Saro Rank 5 - Community Champion

    Guys, any idea about this problem.

    Regards,

    Saro

  • Saro
    Saro Rank 5 - Community Champion

    Hi friends,

    Got the reason, as this will be enabled only if both the SA are related to each other. Hence in my case 2 SA are from two different views and it is not related to each other interms of joins.

    Thanks,

    Saro

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

    Late to this party but you basically found what's written in the documentation. You can not  combine subject areas which are not based on the same business model. It's like in normal Answers analysis construction - non-related SAs can only be combined using SET operations (read: UNION requests)

  • Saro
    Saro Rank 5 - Community Champion

    Thanks christian. Got it.