Tuesday 25 February 2014

Limiting number of rows to display per page while exporting the report in OBIEE 11g

Hi,
While using OBIEE v11.1.1.7. In Analysis, you may need to set the row limit per page to 25 but while exporting it to pdf or Excel, its displaying more than 25 records per page.

How to set the row limit per page, while exporting the report?

Go to,
EM > Capacity Management > Performance.
Here, you can set,


User Session Expiry,
Maximum Number of Rows Processed when Rendering a Table View,,
Maximum Number of Rows to Download,
Maximum Number of Rows Per Page to Include

Set the values as per your choice, apply the changes. Activate changes and Restart the BI services.

You are done..!! :-)

8 comments:

  1. What i don't realize is actually how you're now
    not really a lot more neatly-favored than you
    might be right now. You are very intelligent. You understand
    therefore significantly relating to this matter, produced me for my part believe it
    from numerous numerous angles. Its like men and women aren't involved unless it's one thing to
    accomplish with Woman gaga! Your own stuffs excellent. All
    the time care for it up!

    My site: pure garcinia cambogia extract in stores

    ReplyDelete
  2. When I initially commented I clicked the "Notify me when new comments are added"
    checkbox and now each time a comment is added
    I get several e-mails with the same comment. Is there any way you can remove people from that service?

    Thanks!

    my site; women's trousers

    ReplyDelete
  3. Exerting force too high will tip it over - hopefully not on you.
    It requires a lot of money and research to get the right
    furniture for your space. The best kind of dining table come with
    six to eight chairs and is thus fit for a large gathering too.


    My blog - bathroom

    ReplyDelete
  4. This information is worth everyone's attention. When can I find out more?


    my homepage: tシャツ メンズ

    ReplyDelete
  5. It's hard to find well-informed people in this particular topic, however, you
    seem like you know what you're talking about!
    Thanks

    Feel free to surf to my homepage; 人気サングラス

    ReplyDelete
  6. Does your blog have a contact page? I'm having problems locating it
    but, I'd like to send you an e-mail. I've got some ideas for your blog you might
    be interested in hearing. Either way, great website
    and I look forward to seeing it improve over time.


    Feel free to visit my site; tシャツ メンズ

    ReplyDelete
  7. Hi, I´m trying to display more than 25 rows in a particular analysis, is there any posibility to change it just for one, not using the EM parameter?
    Thanks for advance

    ReplyDelete
  8. Hey there, I´m trying to change the number of rows displayed by a particular Analisys, is there any way to do it, just for one, without changing EM parameters?
    Thanks for advice

    ReplyDelete