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

    OBIEE report using one table

      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,

      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.