Business Intelligence and ETL
I recently came across this little issue where our users were printing dashboards, but not all of the colors were printing. The headers and conditional formatting’s colors were just coming out white.
Solution: This is caused by the “print background colors” setting not being enabled in the browser. For IE, go to Tools>Internet Options>Advanced and the setting is listed there.
Posted in OBIEE.
– September 7, 2010
The wait is over. Here is the link to download OBIEE 11g.
Posted in OBIEE.
– August 16, 2010
Here is a link to the OBIEE 11g Launch website. I still do not see an availability date anywhere.
http://www.oracle.com/oms/businessintelligence11g/oraclebusinessintelligence11g-075560.html
Posted in OBIEE.
– July 8, 2010
The OBIEE 11g launch date is scheduled for Wednesday, July 07, 2010
http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=113706&src=7036704&src=7036704&Act=9
As of now, I do not see any download for it in the Partner Network.
Posted in OBIEE.
– June 15, 2010
In OBIEE, the dashboard prompts are aligned to the left by default. One of the OBIEE developers I am working with asked me to find a way to center the prompts on a dashboard. This can be done by inserting the following code into a text object on the dashboard.
<head>
<style type=”text/css”>
.GFPBox{text-align: center }
.DashboardPromptViewCell {text-align: center }
</style>
</head>
Posted in OBIEE.
– May 3, 2010
The code below creates a button in OBIEE that resets the prompt to its default values. Just add a text object to your dashboard and insert this code.
<div><a href=”#” onclick=”return PersonalizationEditor.removeDefaultSelection(false)”>Reset Prompts</a></div>
It will look like this:
Posted in OBIEE.
– May 3, 2010
When exporting to Excel from OBIEE, Excel Viewer will not be able to open what you download. This is because although the file extension is .XLS, the code is that of a MHTML file (single file web page). Excel Viewer cannot open this type of file. The error that I kept getting is “Microsoft Excel Viewer cannot open files of this type.”
When you open the file in notepad, you can see that the format is MIME and not what you would expect to see when opening a normal Excel file.
Exporting to Excel 2000 does not work either. This is what that file looks like when opening in notepad. You’ll notice that it is more in line with traditional HTML.
The response I got from Oracle when I opened a SR for this was that it was a bug/enhancement request that has been in the system since 2006. “BUG 5661454 – ABILITY TO GET EXCEL VIEWER WORKING WITH ‘DOWNLOAD TO EXCEL’” It is another issue that is supposed to be fixed with the OBIEE 11g release. This one is slated for 11.1.1.2.0.
.
Posted in OBIEE.
– April 8, 2010
If you need to hide the go button for a dashboard prompt in OBIEE insert a static text object on to the dashboard, select the “Contains HTML Markup” option and enter the following text into it:
<style type=”text/css”>
.XUIPromptEntry{display:none}
</style>
Posted in OBIEE.
– February 11, 2010
There was a customer request that when first going to the dashboard page in OBIEE, the report would not run until there was a value selected from the dashboard prompt. The following options were not allowed:
I opened an SR to Oracle and they have said that it is not possible in the current version of OBIEE. This is an enhancement request set for Oracle 11g.
Below is the response to my SR that I got back from Oracle:
Based on my research in Knowledge Management (My Oracle Support portal), this functionality is currently not available. This was requested on Enhancement Request 5543298, which is targeted for Release 11.1.1.2.0
Enhancement Bug Request 5543298 – CR 12-192I9RO /FR 12-192I9SQ DON’T RUN REPORTS AUTOMATICALLY ON INITIAL PAGE ENT
I can add you to the Enhancement Request. Let me know if you have any other questions. – liz
Research:
1. how to turn off auto-running (Doc ID 544692.1)
Their is no way to automatically stop the dashboard from executing the reports. The solutions would be simillar to the customers where to prevent the report from returning any records one would use either a non-matching prompt value or by using filters that will return nothing initially or conditional dashboard functionality. But all these methods will show the message “no result” and still run a sql query against the database.
2. Prompted dashboard automatic execution (Doc ID 496679.1) For the benefit of other readers.
As discussed in Service Request 38-3149629751, there “is no way to automatically stop the dashboard from executing the reports.”
The following Enhancement Request was logged to address this:
****Defect 6685664, DASHBOARD REQUESTS ARE RUN AUTOMATICALLY (This was closed as a duplicate to ****Enhancement Request 5543298, which is targeted for Release 11.1.1.2.0 ****Bug 5543298 – CR 12-192I9RO /FR 12-192I9SQ DON’T RUN REPORTS AUTOMATICALLY ON INITIAL PAGE ENT
“When a user navigates to a Dashboard, requests are run automatically.
Enhancement Request to be able to decide if a request on a Dashboard runs automatically or not.”Workarounds are to apply filters that return less or no values.
Posted in OBIEE.
– January 8, 2010
By default OBIEE does not allow HTML or JavaScript coding in the headers, which is necessary to do this. To enable it, insert the following element to the instanceconfig.xml file. I placed it right after the <ServerInstance> tag.
<HardenXSS>false</HardenXSS>
This is the format of the code to place in the column header so that the text will hover.
The result would look something like this.
Posted in OBIEE.
– December 16, 2009
I am a BI Consultant that has experience with OBIEE, Informatica, Netezza, SSIS, and several other tools. Right now, my main focus is on OBIEE and I started this blog to journal some of the issues I have come a cross and to keep track of little useful pieces of code.
