General OBIEE

Get Involved. Join the Conversation.

Topic

    Shalindra Singh
    Is Orders data available through the OTBI layer in Order...
    Topic posted November 20, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Report Output, Setup/Administration, SQL 
    58 Views, 1 Comment
    Title:
    Is Orders data available through the OTBI layer in Order Management / SCM?
    Summary:
    Is Orders data available through the OTBI layer in Order Management / SCM?
    Content:

    Is Orders data available through the OTBI layer in Order Management / SCM?

    Reason I am asking because when I querying direct table (doo_header_all) via BI Publisher, I get the data from this table.

    But when I use 'Issue SQL' on OTBI Administration section and write following query - 

    select_physical

    headerId, OrderNumber

    from "FscmTopModelAM.DooTopAM.Header"

    I don't get any records. 

    I need your help as I was asked not to use BI Publisher for data extraction (where I want order and line data to be extracted in every 10 minutes) hence evaluating data sync tool but I do not get any data when I used above query.

    Comment