OBIEE – Opening an Image Using HTML Image Link

There are many use cases when and why a user would want to view an image in reference to a particular piece of data in OBIEE. The example below demonstrates how to create an HTML image link. The business users wanted to be able to review invoices that were assigned voucher numbers. If a voucher…

Read More

Financial Reporting Internal Essbase JAPI error

Sometimes, Hyperion Financial Reporting studio can run into an error upon the launch of a report. This can be frustrating when hours have been put in to build a dynamic, nice looking report, only to receive the below message when it is run: [caption id="attachment_4686" align="aligncenter" width="300"] (click to enlarge)[/caption] This is something that has…

Read More

Hyperion LCM blank values replaced with “null”

We have a use case for blank separator lines between groups of accounts. (indicated by red lines below) The business wanted these to provide for logical groupings of their accounts seen on the form. [caption id="attachment_4662" align="aligncenter" width="300"] (click to enlarge)[/caption] In order to implement this we have “tricked” a formula row by adding a…

Read More

OBIEE 11g Mapviewer Error: “Some map formatting cannot be displayed”

I ran across this error  working in OBIEE 11g Mapviewer("Some map formatting cannot be displayed") while building a  report that displayed dollars per county for the entire United States. After executing this report, not all the data for the counties would return. I received the following error. As you can see, there are certain counties…

Read More

CLEARDATA Before XWRITE

Before going into detail about why it is important to clear your target data before running an @XWRITE, I recommend reviewing the initial eCapital blog on how to properly write an @XWRITE calc script. Missing block movement with @XWRITE In the previous blog on this topic, a dense member was used in the calculation block.  This…

Read More