This discussion is archived
2 Replies Latest reply: Dec 27, 2012 8:16 PM by 649804 RSS

Showing Query Result Like Form

649804 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points