Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OTBI - add a SQL column to a subject area analysis — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI - add a SQL column to a subject area analysis

edited Jan 24, 2017 11:51AM in General Transactional Reporting (OTBI) 1 comment


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


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!