I have query regarding Bex Reporting . My scenario is like to create a vendor statement report. Now on the Info provider ( Info Cube) on which i am reporting is having data in multiple rows for a single document with each row with different GL entry.
Now as the output of the Bex Report I have manage to show rows corresponding to a single row & multiple GL items in Infocube as column(each column for a separate GL entry) ...
please suggest how could I manage to achieve above requirement i.e that converting multiple rows for a single accounting document in Cube to one row in query output with GL as column headers.