Thursday, March 29, 2012

OBIEE- Merge Repositories: the unconventional way

We all know about 2-way and 3-way repository merge. Here’s the documentation to know details: Merge Repositories. In this post I am showing a different way to manage and merge repositories.

Say you and another developer are working on a project. Both of you are developing different subject areas independent of each other, which end up in two repositories. Now, you want to merge them together in to a single repository. Of course merging them as per the information in the link above is ideal but there is another quick and easy way. This has worked for me very well so far.
-          Open two sessions of BI Admin tool and open both the repositories.
-          Copy objects from one rpd to other by simple right-click copy and paste
-          Below I am showing this for Physical Layer. Do the same for BMM and Presentation Layer.

-          Once done, do a consistency check. It should be consistent if you are using two consistent rpds.

Bingo! You have a merged rpd and can work on new Subject Areas after deploying this rpd.

Friday, March 16, 2012

Oracle BI Publisher 11g- template upload error- Upload Failed: org.apache.commons.fileupload.FileUploadBase$SizeLimitExceededException

I was working on BI Publisher ( recently and came across this error while uploading my rtf template. 

Upload Failed:
the request was rejected because its size (132923375) exceeds the configured maximum (30000000)

I was not able to upload an rtf template because of its size. I did not realize that the four page template I created is over 130MB!!  It does not make sense to configure BI Publisher to handle this kind of size. I could sense that this is something related to my rtf file. I was using Microsoft Office 2007 to create this rtf. Here’s what I found at Microsoft Support website – “If an EMF, a PNG, a GIF, or a JPEG graphic is inserted into a Word document, when the document is saved, two copies of the graphic are saved in the document. Graphics are saved in the applicable EMF, PNG, GIF, or JPEG format and are also converted to WMF (Windows Metafile) format.” This according to Microsoft is by design.

Check this link to find out more- Document file size increases with EMF, PNG, GIF, or JPEG graphics in Word  ( I ran the patch available on this page which reduced the size of the template to 3MB enabling me to upload the template.

Hope it helps.