Thursday, July 29, 2010

OBIEE Hide “my dashboard”

Recurring OTN Question:

How can I hide my dashboard:

image

Goto Administration:

image

Next goto manage privileges:

image

Next goto Catalog Personal storage:

image

Set the privileges:

image

tada:

image

Till Next Time

Wednesday, July 28, 2010

OBIEE11g download

Hi, I’m getting about 10 request a day for the download link of obiee11g.

Well I don’t have it.

As far as I’m aware at the moment (28/jul/2010 15:30 GMT), there isn’t a public one available yet.

Please be patient! It might tonight, it might be tomorrow, it might somewhere next…. If you want to have a beta release contact your local Oracle rep!

If it does come online all the OBIEE blogs will light up for sure!

In the mean time you can still place a bet:

http://obiee101.blogspot.com/p/obiee-11g-ga-bet.html

or join the farewell game:

http://obiee101.blogspot.com/p/obiee-10g-farewell-competition.html

Till Next Time

Thursday, July 22, 2010

OBIEE using prompt as report selector

Yes, I know Venkat did it before:
http://oraclebizint.wordpress.com/2008/01/17/oracle-bi-101332-selecting-reports-from-dashboard-prompts-and-guided-navigation-sections/
So I will do it again so you can all reference mine ;-)
Create a prompt with a dropdown list of your reports:
image
image
If you can use an LOV instead off the CASE 1=0 construction!
put it all in a presentation variable
Add some dummy reports which only rows if the right pReports are selected:
image
image
Add the prompt and your real reports to your dashboard, give each report a separate section:
image
Set the Guided Navigation:
image
image
And Now you have a report selector:
image
image
Till Next Time

Monday, July 19, 2010

OBIEE Handling long dashboard page names

First of all I don’t think long dashboard names are really that clever. But still if someone else is paying the bill…..
image
You have the risk of running out of background space:
image
Still you can control the names a bit by using HTML BR and NOBR tags:
BR:
image
image
NOBR:
image
image
Till Next Time

Friday, July 16, 2010

OBIEE remove the whole portalbanner

Or how how to remove this in one go:
image
Add a textbox to your dashboard:
image
Add the following code:
[code]
<script type="text/javascript">
    var tds = document.getElementsByTagName('table');
    for (var td = 0; td < tds.length; td++) {
        if (tds[td].className != 'PortalBanner' && tds[td].className != 'PortalBottomTable' ) {
            continue;
        }
        if (tds[td].className == 'PortalBanner') {
        //alert (tds[td].className);
        var x = tds[td].parentNode;
        //alert (x.className);
        x.removeChild(tds[td]);}
        if (tds[td].className == 'PortalBottomTable') {
        //alert (tds[td].className);
        var x = tds[td].parentNode;
        //alert (x.className);
        x.removeChild(tds[td]);}
        }
</script>
[/code]
image
Till Next Time

Update:
Stijn showed an much simpler trick by using the GO URL: http://oraclebizint.wordpress.com/2007/11/01/oracle-bi-ee-101332-hiding-banner-in-dashboards-using-go-url/

Update2:
for OBIEE11Gr5 :

The formatting was screwed up replace 'PortalBanner' ==> 'HeaderTopBar'
'PortalBottomTable' ==> 'HeaderSecondBar ' (Including the space)

Wednesday, July 14, 2010

OBIEE Images Cheat Sheet

Mouse over has the names

\images\
report_agreements report_account_appl report_activities
report_automotive2  report_bad_progress report_automotive1
report_bankAccount report_bottomN report_bad_percentage
report_bankBalances  report_call report_bad_value
report_callcenter  report_cautionary_progress report_cautionary_percentage
report_cautionary_value report_comm2 report_comm1
report_cust_sat report_expiration report_email
report_forecasting report_geographical report_good_progress
report_generic report_good_percentage report_household
report_good_value  report_insurance_Policy report_insuranceClaim
report_investigative report_invoices report_location
report_medicalResearch report_mktShare report_order
report_phone report_pillcount report_pipeline
report_reportsCatalog report_retailAudit report_salesrep
report_salesVolume report_service_profitibility report_scorecard
report_serviceRequest report_targetActual report_topN
report_tradepromo report_tradefund report_universal_queue
report_trends  report_win_lossDeals report_medicalResearch
\portal\
actuateroilarge actuateroxlarge add2bb add2bb
bgviewbarsep blank btn_max btn_min
dash_refresh dashboardwarning download idashed_addcolumn
 idashed_bb hdgportals 
\Maps\
europe_map_1color europe_map_4color
usa_map_1color usa_map_1color_noLabels
usa_map_4color_noLabels
world_map_1color world_map_4color