RTF Template blank page issue --- BI Publisher

BI Publisher Blank page issue

This is the common issue when we creating reports from RTF templates.

When we are previewing the report some times last page will be blank because of blank spaces in RTF template.

But some time’s after deleting blank spaces also we can observe blank page in last.

These types of scenarios will come only when we are using different page orientations with different sections.

For example in my scenario I am using two page layouts Landscape and Portrait with section break.

First page layout is Landscape and I used section break without any blank spaces.

Second page is Portrait.

Portrait page having the condition that if VENDOR NAME is exists then only that page should display.

Here this condition is working but I am getting last page is blank and if no vendor name exists it was displaying header with blank page as shown in below screen shot.

I am having the separate Dataset for this vendor name.

So I added one condition in header level of portrait page layout.

<?for-each@section:RFQ_TEST1_ROW?>

And I removed foreach condition  from portrait layout

And I added <?end for-each-group?>  tag at the end of template

Now RTF will not generate Blank page while previewing the output.

RTF template to get Distinct Count --- BI Publisher

Distinct values in BI Publisher RTF template.

Here I got one requirement to calculate distinct count of Purchase requisition numbers.

Report will display PR number and other information as shown in below screen shot. Here some PRs having multiple lines.

In report we need to display PRs with multiple lines and in header we need to display distinct count of PRs.

In above screen shot count is 413 and this is not distinct count.

Because in RTF template I used XML tag in header  level as <?count(field_name)?>

I tried with distinct keyword.

RTF template will not support DISTINCT keyword.

But publisher having one key word to calculate distinct values.

i.e :   distinct_values

syntax  : 

<?count(xdoxslt:distinct_values(field_name))?>

So just I replaced this tag in header level of RTF template as shown in below screen shot.

<?count(xdoxslt:distinct_values(REQ_NUMBER))?>

 

And save the template and upload sample data to check the results.

Now count will be distinct count.

How to increase export limitation in OBIEE11g.

By default OBIEE will export 2500 rows.
Some times our client requirement will be to export more than 2500 rows.
To increase export limitation follow below steps and let me know if anybody facing issues while doing below steps.
 

Here we need to change insanceconfig.xml file.

Go to below location and take a backup.

Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Instanceconfig.xml

Open Instanceconfig.xml file .

And go to Views section.

There we will see pivot and table sub sections.

Open in notepad and add below XML code to two sub-sections.

---------------------------------------------------------------------------------------------------------------------

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>

<MaxVisiblePages>2500</MaxVisiblePages>

<MaxVisibleRows>500000</MaxVisibleRows>

<MaxVisibleSections>5000</MaxVisibleSections>

<MaxCells>500000</MaxCells>

And save it.

Now re-open the xml file and it should be like below screen shot.

Replace modified instanceconfigfile.xml file in original location.( Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Instanceconfig.xml)

Now go to Enterprise Management (EM) and follow below steps.

Step 1:  click on Lock and Edit Configuration.

Step 2: Go to Capacity Management, and click on Performance tab.

Step 3: change value for Maximum Number of Rows to Download to 500000. (It should be the value which we given in XML)

Step 4: Click on apply button.

Step 5: Click on Activate changes.

Step 6: Restart the services.