Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    SHAVUL HAMEED
    How can i edit or see database query for a pre-defined...
    Topic posted April 22, 2019 by SHAVUL HAMEED, tagged BI Publisher, BI Publisher Reports, BICS, OBIEE Answers, OTBI 
    75 Views, 2 Comments
    Title:
    How can i edit or see database query for a pre-defined Subject Area in OBIEE?
    Summary:
    How can i edit or see database query for a pre-defined Subject Area in OBIEE?
    Content:

    Hi,

    I need to know about a SCM predefined subject area backed query or form functionality used.

    If any one have information about this.Please share.

    Thanks in advance.

     

    Regards,

    Shavul Hameed.

    Comment

     

    • Chandra Yerra

      Hi Shavul,

      You can use the "Issue SQL" option from Administration tab by taking the Logical SQL from Advanced tab of BI Answers.

      Thanks.

    • SHAVUL HAMEED

      Hi Chandra,

      Thanks for your reply.

      Can you please elaborate the answer with an example.I am new to OBIEE.

      Inventory-Inventory Supply Real Time is a Pre-Defined Subject Area in Fusion.I wanna see the SQL query of this subject area.

      Can you please guide me on it.

      Thank you for your kind generocity.

      Regards,

      Shavul Hameed.