2 Replies Latest reply on Dec 28, 2012 4:16 AM by 649804

    Showing Query Result Like Form

      Hi all,

      I'm using OBIEE 11g.

      I have an analysis, with criteria:
      Month | Sales ID | Sales Name | Total Sales

      The filter is for one Sales ID and for one Month only, therefore, only 1 record is returned.

      The result for Sales ID = S001 and Month = January, shown with default table view is:
      Month | Sales ID | Sales Name | Total Sales
      January | S001 | Seller 01 | 1,000

      I would like to show this like in a form, like:
      Month: January
      Sales ID: S001
      Sales Name: Seller 01
      Total Sales: 1,000

      How can I achieve that using just table view or pivot table view? I can't use narrative view, because the Seller Name column's value need to have an action link to navigate to other reports.

      Any suggestion? Thanks a lot!