This discussion is archived
4 Replies Latest reply: Mar 5, 2013 1:51 PM by 993731 RSS

Creating a report in OBIEE 11g

993731 Newbie
Currently Being Moderated
Hello Masters,

I need to create a report in dashboard
so, i added page for this, but where i can found subject areas in OBIEE 11g so that i can create a report on this page based on that subject area.

Thanks in advance.

Regards,
S Goud.
  • 1. Re: Creating a report in OBIEE 11g
    Sasi Nagireddy Expert
    Currently Being Moderated
    For Creating New Reports,

    1.Got to -> New ->Analysis you will have your Presentation Tables under Select Subject Area
    Click on your Subject Area -> you'll get list of tables under the Subject Area
    2. Expand the Folders and click the required column.
    3. Click on Result tab - > you'll get Title and Table View
    4. Format your Table view and Title View
    5. Save your New Report in Shared Folders (You may create your own folder under Shared folder)

    View the Reports on Dashboard.

    1.Got to -> New ->Dashboard -> you will have New Dashboard Window
    Name - Give the name of your Dashboard
    Select Location - /Shared Folders/Standard Dashboard/
    Click Ok -> you'll get Empty Dashboard window.
    2. Edit the Dashboard -> Drag and Drop your Saved reports from Shard Folder under Catalog
    3. Click on Save button (Top Right) and save your dashboard -> click run [Green right Arrow(Top Right)].
    4. Now you'll have your report in your dashboard page.
    Rename Dashboard Page

    Edit the Dashboard - > Click Properties Nedt to X Symbol -> Dashboard Properties
    -> You'll have the Dashboard Properties window -> Select the Dashboard Page -> Rename

    Prompts:

    1.Got to -> New ->Dashboard Prompt-> you will have your Presentation Tables under Select Subject Area
    Click on your Subject Area -> you'll get the Untitle Prompt Window
    -> Click + symbol -> Column Prompts ->you'll get list of tables
    2. Expand the Folders and click the required columns from the list (the Columns should be your Report's table).
    3. Save your New Prompts in Shared Folders.

    Note: The Prompt columns should be Is Promptd in your Reports Filters.

    Mark as correct if it is helpful.

    Thanks
  • 2. Re: Creating a report in OBIEE 11g
    Sasi Nagireddy Expert
    Currently Being Moderated
    Check this also u will be having step by step.

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1113/createanalysis/ps.htm

    Mark as correct if it is helpful.

    Thanks.
  • 3. Re: Creating a report in OBIEE 11g
    Sasi Nagireddy Expert
    Currently Being Moderated
    Any Updates?

    Thanks.
  • 4. Re: Creating a report in OBIEE 11g
    993731 Newbie
    Currently Being Moderated
    Thanks It is resolved...... You Rock !!!!

Legend

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