This discussion is archived
5 Replies Latest reply: Feb 20, 2013 10:07 PM by 718372 RSS

Drop down on report

718372 Newbie
Currently Being Moderated
Hi,

Im trying to create a report with a table and chart views.
Can i have the report as below:

1.Need to have a drop down for only View ie) Table,Chart
2.Need to have another drop down with values ie) Revenue and margin

If i click on Table and then revenue it should show revenue table values
If i click on Chart and then revenue it should show chart with revenue values

Same with margin.

Can this be done.

Regards,
KK
  • 1. Re: Drop down on report
    878994 Newbie
    Currently Being Moderated
    Hi KK,

    Yes your requirement can be done.

    1) create a view selector for choosing either Table or Chart.

    2) Then create column selector view to select which column you want.

    Thanks
    Thenmozhi
  • 2. Re: Drop down on report
    Satya Ranki Reddy Expert
    Currently Being Moderated
    Hi,

    We can archive this view selector.

    Create two repots
    1. table and revenue
    2. chat and revenue

    You have to add both reports to view selector view.

    Thanks
    Satya
  • 3. Re: Drop down on report
    718372 Newbie
    Currently Being Moderated
    Hi ,

    Thanks a lot for the reply,But i have 3 measure values on the report (and my 2nd drop down should be Revenue and Margin) EX

    Revenue,
    Weighted Revenue ,
    Revenue Share%

    Margin,
    Weighted Margin ,
    Margin Share%

    Its not helping out when I'm having 3 measures each on the reports.

    KK
  • 4. Re: Drop down on report
    718372 Newbie
    Currently Being Moderated
    Hi ,
    Any help please.

    Regards,
    KK
  • 5. Re: Drop down on report
    user248025 Guru
    Currently Being Moderated
    Hi,

    1) Create two report (chart & table based) then each view add one dummy column and make this to be prompted as (variable prompt)
    2) Create Dashboard prompt --> create two variable prompt ( one for report selection and another one for measure selection (here u have to add measure column as value like Revenue,Margin...N etc)

    then test it
    For report as column selector via variable prompt option sample screen short
    http://atlantabi.blogspot.com/2012/01/obiee-11g-using-dashboard-prompt-as.html

    For report as prompt selection via variable prompt option sample screen short
    http://orabi1001.blogspot.com/2012/05/obiee-report-prompt-link-obiee-11g.html

    Thanks
    Deva

Legend

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