Adding SA button disabled while creating a column prompt

Saro

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

Saro

Guys, any idea about this problem.

Regards,

Saro

Saro

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]

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

Thanks christian. Got it.