Error while exporting/printing large data to PDF/Excel2007 in OBIEE11g

Today, my business user sends me an error screenshot saying he was not able to take a printout of detailed report which had approx. 7k rows. I provided an ‘Export‘ link at the bottom of the report and asked the user to download first and print. But, interestingly, he was able to download in excel 2003 but neither in excel2007 nor pdf. It triggered me to investigate the issue and provide a solution.

Issue: trying to export an analysis result in to pdf or printing to pdf and gives following error:

pdf_issue

A fatal error occurred while processing the request. The server responded with: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException.

error_printable_pdf

Solution: edit the config.xml file located at /$OBIEEHOME$/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1/config.xml

Note: take a backup of config.xml file in case you need to rollback the changes.

and edit the following entries:

xml_tag_change1

in my case value in <InputStreamLimitInKB> was 32768 and i changed it to 0 (zero)

<XMLP>
<InputStreamLimitInKB>0</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
</XMLP>

0 means deactivating the limit.

and restart the services.

But , would you like to limit the maximum input size (in kilobytes) for requests that are sent to the JavaHost service, then increase the parameter’s value until you are able to resolve the issue.

Note: everytime you make the changes in config.xml file, you need to restart the services.

You can also try changing the following tag in same file:

xml_tag_change2

Thanks

AKASH (@akashdgarg)

 

 

 

 

Advertisements

Showing dynamic data over image in OBIEE

There was a requirement in which we needed to show report’s data on a static image. This Image was provided by client and we had to place the tables of 4×2 on multiple places on this image. In image (refer below image) you will see Rectangles in different colours which are static, but values shown under those rectangles are dynamic. These values are changing as per there is a change in data in ETL table. To overcome as a solution of this requirement we took help of html code. Here is the step by step guide to implement the same.

show_dynamic_value1

  1. Criteria:go to criteria tab and drag and drop columns for which you want to show data on image.show_dynamic_value2
  2. Create one column called ‘Style’ for the position of different boxes on Image. This is how 8 different positions were created. No of positions may vary for your project. you can change the px values to change the position of objects on image.show_dynamic_value3
  3. Then use ‘Narrative View’show_dynamic_value4
  4. you can take reference from below code:Prefix: show_dynamic_value6Note: Image shown is placed at a path mentioned above. This path may be different for different projects

    Narrative: show_dynamic_value5

     

    Highlighted texts:

    color:red it is a tag for Red coloured box and @2 and @4 are referring to the columns in criteria which to be shown in row corresponding to red box: @2 and @4 are referring to two different columns, Internal and External respectively.

    Like wise this is done for other coloured boxes.

    Row seperator : </div>

    Post fix : </div>

    Please share your thoughts if it helped and keep watching this space for more updates.You can follow me on twitter (@akashdgarg) for quick updates about what’s happening in the area of BI, Big data, OBIEE etc.

Continue reading

How to show Null values as blank in reports

It is very common from a user to ask you mask Null values to something else, for example Null to be shown as Zero.

But, I come through a reverse requirement where user wanted to show Null as Null without any masking. By default, Obiee was showing zeros.

Quickly, it clicked in my mind I changed the setting at Physical layer in RPD.

Let’s go step by step.

  1. Values are being shown as 00/00/00 and 0.0 in second fourth and fifth column rescpectively in below screen shot.null1
  2. User wanted them to be shown as below.null2
  3. All you have to do is to login to RPD and Navigate to Physical columns of respective columns.
  4. Check the ‘Nullable’ option as shown below and Press OK. Then save the rpd and check
  5.  .null3Please share your thoughts if it helped and keep watching this space for more updates.You can follow me on twitter (@akashdgarg) for quick updates about what’s happening in the area of BI, Big data, OBIEE etc

How to insert page breaks while printing OBIEE Answer’s result in PDF

Sometimes we wonder how to insert page break in PDF output of Answers. We think that there is something to do with pdf file properties or the version of pdf is not compatible with OBIEE, but you may be wrong here as it is very simple to do it from OBIEE.

In this example I will use product type for grouping for page break.

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

insert_page_break_01

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

insert_page_break_02

  1. 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!

insert_page_break_03

  1. 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.

insert_page_break_04

5. So this is what you will get in Answers.

insert_page_break_05

  1. Click on Print button to print PDF

insert_page_break_06

  1. You can achieve the same by exporting to PDF.

insert_page_break_07

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

insert_page_break_08

Keep visiting this page for more posts!

JReport – An Intuitive Reporting Interface

JReport? what is this? how to use? what it does? Is it something related to Java? Hold your thoughts for a while. After completing this blog, all of your curiosity will be vanished and you will be ignited to know more about it. You will also be able to stifle the burning flames of same curiosity of others.

JReport is basically a data visualization tool, developed by Jinfonet Software. It is also being referred  as Reporting Tool/Business Intelligence tool. JReports provide embedded reporting solutions for an Enterprise. A Good thing about JReport, It is a Java Based Platform and can be embedded into any application and delivers enterprise reports, dashboards, analysis via web and mobile devices. JReport is accessible through mobile devices with an interactive interface and user friendly GUI. JReport’s approach to design, Build and deployment simplifies the life of both developer and users.JReport Can be deployed as an embedded reporting engine in other applications, as a stand alone system, or in any public, private or hybrid cloud environment.

For Developers; JReport provides wizard based interface similar to a software installation where you just press Next and Finish button (No Jokes). Wizard will not let you skip any step in creation of a report and you will be saved from finding a root cause for not getting desired output as compared to other conventional reporting tools. (Not saying that JReport is fool proof!). JReport has In-House Report Layouts such as Banded, Table (Group Above, Group Left, Group Left Above, Summary etc.), Croostab, chart and more which makes a developer’s life easy.

In this Blog, I will discuss more about the different Components of JReport and advantages and limits of the tool.

JReport Server Live, JDashboard, JReport Mobile and JReport Designer are key components of JReport. Let’s discuss in detail about each component.

JReport Server Live is a high performance, 100% Java report server able to seamlessly integrate with any enterprise application and scale to any workload. JSL provides complete report management, distribution and administrative functionality with highest reliability. On top of its high throughput report generation, JSL also supports on-demand, live report creation and modification, providing JReport’s powerful ad-hoc reporting solution. End users are empowered with JReport to create their own visual and interactive reports for powerful and secure data exploration in a completely self-service manner. JReport Server Live also provides a full administrator user interface to schedule reports, manage servers in a clustered environment, and provide ad-hoc capabilities such as browser-based report creation.

JDashboard delivers data visualization to end users. As an extension to JReport, JDashboard displays data in interactive visual components like maps, various forms of charts, graphs, tables and live charts. JDashboard combines them with a robust set of  on-screen interactions. JDashboard is accessible on mobile devices too with the help of JReport Mobile App for any iOS device. JDashboard enables users to analyze the business trend and helps in making decision for future targets.

JReport Mobile is a native iOS reporting application that provides data visualization through touch screen interactions. It comes equipped with sample data. Users can connect to JReport server to access their own dashboards built with JDashboard. JReport Mobile lets you choose how you want to view your data. In just one touch, you can quickly switch to different chart types. Seeing data from alternate perspectives will give you a clearer picture of your information. This app can be downloaded free from Apple app store.

JReport Designer is a report design tool which facilitates report build using precise and in-built layouts, flexible output and actionable reporting without any dependency on OS or hardware configuration. JReport is the component used very frequently and most important for report developers. Developers are able to use intuitive wizards to guide them through selecting data source, creating query and designing layouts. Additionally, Designer provides CSS style support allowing CSS style sheets to be applied at run time to provide custom report formats for users.

Designer is able to use data from different data sources in the same report and almost every data source system is supported by JReport. Designer provides a fexibilty to create reports in designer and publish them to server and use by web device. JReport Designer frees developers from the need to maintain static propmt lists for each individual report. Dynamic parameters can be passed at runtime to control the result of reports.

A Powerful utility of Designer is querying, Developers can write sql query to create reports and query will be used as a source for reports. Moreover, there are no limitations on using In-Built layouts with query featured reports as like OBIEE (Oracle Business Intelligence, has limitations on using direct sql query for reports).

Next, i will briefly discuss about advantages and limits of JReports:

Open source, freeware installation, Actionable reporting, Flexible Output, Visual-Rich and Interactive dashboards, Hundreds of ready to use templates, Mobile device accessibility, CSS supported, compatibility with any data source and ability to make reports with multiple data sources in single report enables JReport stands on different position in the world of BI.

But on the other hand it has some limitations supporting Java VMs from Sun and IBM only, JReport Mobile for iOS devices only, LDAP support limitations etc. There may be some more features of JReport which I couldn’t get through but will keep posted as soon as I come across any.

I will stop here till the next time. Keep reading my blogs as I will write more in coming blogs about Architecture, Best Practices, Development experiences of JReport etc.

Please give me your feedback and comments about this blog.