General OBIEE

Get Involved. Join the Conversation.

Topic

    Antony Hooper
    OTBI - add a SQL column to a subject area analysis
    Topic posted January 24, 2017 by Antony HooperRed Ribbon: 250+ Points, tagged Analyses, OTBI, Reports, SQL 
    401 Views, 1 Comment
    Title:
    OTBI - add a SQL column to a subject area analysis
    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

    Comment