OBIEE Print Answers to PDF with Page Breaks

Oracle Business Intelligence

I’ve been too busy recently to actually post anything new. I would not know when the next time I am available to write my next blog. Hopefully I have time to do a blog article before March but let see. If you do send me emails, I’ll surely reply but it may take some time.

I was emailed a question lately and would like to share the solution to everyone. It’ll be a quick one.

Setting up your Answer Report for PDF Print Out with Page Breaks

The original requirement was to print PDF with page breaks by every product type. The solution to that is just a few setups in Answers.

Let’s use Sample Sales to do this example. Create an analysis report like the following.

OBIEE-Answer-PDF-Page-Break-008

Create either a pivot table or table. I’ll use table as an example.

OBIEE-Answer-PDF-Page-Break-007

And when you edit the table, drag product type to Sections. Then edit Section Properties. You will be able to see the first option called Insert Page Break!

OBIEE-Answer-PDF-Page-Break-006

The drop down allows you to choose No Page Break, Innermost Column, Outermost Column or a specific column which in this case will only be Products.Product Type.

No Page Break literally means no page break.

Innermost Column would be the first column you have on your sections area.

Outermost Column would be the last column you have on your sections area.

Specific Column would contain all the possible columns for Page Break and you can only choose one.

It does not matter which one you choose if you have only 1 column in the section area. When you have more than one, then you’ll need to give it some thought. Generally, I would choose the specific name in case I modify the sections area. If you need to combine 2 or more columns for the page break, you’ll have to concat these items in criteria before you use this feature.

OBIEE-Answer-PDF-Page-Break-005

So this is what you will get in Answers.

OBIEE-Answer-PDF-Page-Break-004

Click on Print button to print PDF.

OBIEE-Answer-PDF-Page-Break-003

You can achieve the same by exporting to PDF.

OBIEE-Answer-PDF-Page-Break-001

The result as follows, page break by product type in PDF!

OBIEE-Answer-PDF-Page-Break-002

 

This would be great for scheduled email purposes using Agents.

Advertisements

Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of MondayBI.com I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

4 thoughts on “OBIEE Print Answers to PDF with Page Breaks”

  1. Reblogged this on The Lit Tech and commented:
    Too good not to reblog . . . Anybody who uses OBIEE on a daily basis knows just how frustrating it can be to properly format a document into .pdf format from an analysis. OBIEE formats excellently as a web-based tool, but when you want to get those analyses into a printable document, there are certain nuances that you have to be aware of. This blog post helps explain one of the ways to create better .pdfs for end users.

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s