Recently I start creating a repository (11g version) in offline mode and I want to import metadata which failed by the error ‘The connection has failed’.. I have searched for a solution and I will explain this in the next sections. We can import some metadata from the Oracle BI Administration Tool > File > […]

Introduction: Oracle Business Intelligence Enterprise Edition 11g, the new, industry-leading technology platform for business intelligence, which offers: – A powerful end-user experience with rich visualisation, search, and actionable collaboration – Advancements in analytics, OLAP, and enterprise reporting, with unmatched performance and scalability – Simplified system configuration, life-cycle management, and performance optimisation A first impression of […]

I have worked with BIP for a few months and I discover some tips & tricks around developing reports. If you develop too fast or you are unattended to some stuff, you would see some of following errors. I will give you a list where you have to be aware of. Tips & Tricks 1: […]

The columns of a cross-tab report are data dependent. At design-time you do not know how many columns will be reported, or what the appropriate column headings will be. Moreover, if the columns should break onto a second page, you need to be able to define the row label columns to repeat onto subsequent pages. […]

Since BI Publisher is integrated with MS Office, you can use some features of Word to add extra functionality into your reports. This topic will handle about the usage of checkboxes in your RTF-template. An example below.. We will create an checkbox which status is dependent on a value in the xml. First, we have […]

There is so much to talk about but what I haven’t discuss right now is extra functionality in Data Templates. Features that you can use to allow more complexity into your templates. One of the advantages of data templates is the use of Report Triggers. These triggers will handle a specific sequence. So, the sequence […]

Situation:One of the common questions that generally come up with regard to BI EE and BI Publisher is ‘how does one pass parameters to BI Publisher reports in Dashboards?’. One of the solution is to create a BI Publisher Report using HR-scheme as data source. Define a parameter for the BI Publisher report and then […]