This discussion is archived
1 Reply Latest reply: Jul 22, 2013 8:39 AM by RaviJegga RSS

report generation in bam

6b1588e2-1bd2-432a-8909-4e6a50117a0f Newbie
Currently Being Moderated

how to create a report by joining two tables without using odi

  • 1. Re: report generation in bam
    RaviJegga Expert
    Currently Being Moderated

    Hi

    1. BAM Reports are derived from Data Objects. And Data Objects are derived from any External Database Table, View or any component.

    2. For your scenario, on Database side itself, I would recommend Create a VIEW that joins these 2 Tables and pull the required Columns and add required conditions. Verify the VIEW has all the rows expected.

    3. Then create DataObject for this View. Once you have DataObject, create the Report. And for Report, you can have any Parameters also, that user can modify like Filters.

     

    Thanks

    Ravi Jegga

Legend

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