General OBIEE

Get Involved. Join the Conversation.


    Andy French
    Pivot Table/Table Horizontal Layout
    Topic posted November 1, 2016 by Andy FrenchGold Medal: 3,500+ Points, tagged Analyses, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, SQL 
    141 Views, 1 Comment
    Pivot Table/Table Horizontal Layout
    Adjusting the layout of a pivot table or table from vertical to horizontal

    I need to change the layout of a sectioned Table from vertical to horizontal. Is this possible? My report includes 12 sections which are, by default, presented vertically. Ideally, I’d like to limit the total number of sections on each row, so my report would have four rows with three sections on each.

    If this isn't possible on a Table, can a Pivot Table be formatted this way?

    Any help would be appreciated!



    • JF Carpentier

      Hello Andy,

      The options for these kinds of table formats are unfortunately very limited.   You can use a pivot table to emulate a horizontal-oriented table by populating the Y axis and a measure without anything on X-axis but this generally works with only very specific displays.

      I know of no option to make a standard table into horizontal-orientation in the current versions of OBI, so it may have to be posted as an enhancement request for a future development version.


      Thank you,

      -JF Carpentier