4 Replies Latest reply: Apr 18, 2008 12:46 PM by 595582 RSS

    OBIEE report using one table

    595582
      Hi all, I was given a scenario to create some reports using OBIEE against a single table. Is it possible? The columns in the table include
      employee id,
      request log id,
      callers number,
      duration of log (in secs),
      cost of call,
      call rate,
      customer name,
      customer id,
      date

      Is it workable to create logical tables for dimensions and measures from that single table and map it? I would be required to create a pivot table report from that single table source.
      If it is possible, please can anyone tell me how it can be done.

      Thanks