1 Reply Latest reply on Feb 18, 2013 12:45 AM by Sasi Nagireddy

    using view generating report in pivotal view


      I have a database view and I don't have a common key to join the view to any other table, so imported the view to physical layer, created alias and joined the alias view and view. Drag the view and alias view into bmm layer and drag the original view to presentation layer. when generating report using direct database request in answers then I am getting all the rows in table view, but when I change it to pivotal view I am only getting one row.

      In Table view I am getting revenue from 2003 to 2013, but in pivotal view i am getting only for year 2003.

      I need my report in pivotal view. Please help .

      Thanks & Regards,