5 Replies Latest reply: Feb 21, 2013 12:26 AM by user248025 RSS

    Drop down on report

    718372
      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
          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
            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
              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
                Hi ,
                Any help please.

                Regards,
                KK
                • 5. Re: Drop down on report
                  user248025
                  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