OTBI - add a SQL column to a subject area analysis

Antony Hooper-29731

Summary

Can you refer to a table using SQL and a subject area at the same time?

Content

Is it possible to add column to a subject area using SQL?  I have tried editing the XML in the 'Advanced' tab, and using the SQL created the system in a new analysis without luck.

If it is possible, presumably it is using the 'Advanced SQL Clauses' section?

Many thanks

venkata veeragoni

Hi Antony,

I have a similar requirement. Can you advise if you have solved your problem.

 

Thanks

Venkat