Forum Stats

  • 3,851,567 Users
  • 2,264,000 Discussions
  • 7,904,781 Comments

Discussions

OBIEE Answer horizontal pager on a crosstab answer

Gareth Roberts
Gareth Roberts Member Posts: 1,745 Silver Badge
I'm running OBIEE 10.1.3.3.2 and I have a Crosstab table based answer that has (dynamically) a lot of columns. When it renders it makes the width of the webpage huge. Is it possible to create like a horizontal pager after a certain number of columns?

E.g my report looks like this:

(across) Dept1 Dept2 Dept3 Dept4 Dept5 Dept6 .... Dept100
(down)
Revenue 111 2222 333 444 555 666 ... 1111
Expenditure -100 -200 -300 -400 -500 -600 ... -1000

So I'd like a "click here for more" after like Dept10.

Thanks,
Gareth

Edited by: gareth.roberts on Sep 22, 2009 4:20 PM
Tagged:

Answers

  • 628531
    628531 Member Posts: 1,293
    Garath,

    Here is a workaround based on a carriage return:
    http://obiee101.blogspot.com/2007/12/obiee-pivot-table-with-carriage-return.html

    Not quit what you are looking for but it might give you some ideas.

    regards

    John
    http://obiee101.blogspot.com
    628531
  • Gareth Roberts
    Gareth Roberts Member Posts: 1,745 Silver Badge
    Hi John,

    An interesting concept .. got me thinking though. I think perhaps a column selector or similar might help out perhaps ... with a formula column grouping columns into x at a time....

    Regards,
    Gareth
This discussion has been closed.