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)

16 comments:

stijngabriels said...

Hi John,

there is a more simple solution by using the GO URL: http://oraclebizint.wordpress.com/2007/11/01/oracle-bi-ee-101332-hiding-banner-in-dashboards-using-go-url/

This is also used to integrate dashboards in Siebel CRM.

Regards,
Stijn

John Minkjan said...

Hi Stijn,

Thanks for sharing! I will update the article.

regards

John

ranga said...

HI john

A) i have 10 saved reports with one same column name.if i changed the column name in rpd. Is this change effected to the saved reports or not?How this change is effected to saved report.

I gone through the catalog manager.I can change one by one report only.
How can i change all the reports at a time?

Thanks in Advance

John Minkjan said...

@Ranga,

I don't see any relation with the subject of portalbanner?

If you rename a column in the RPD it will get an alias and all your old reports should keep working

If you want to change it using the catalog manager use the Find and Replace XML function.

ranga said...

Thanks for reply

If i do this, i can change only one report at a time. I want to change col name for ten reports at a time?
It takes long time for changing each report.

Help me Out.

John Minkjan said...

@Ranga,

It works fine if you select the whole folder.

regards
John

ranga said...

Sorry John
Its not working,Pls explain briefly;
Is there any link regarding this scenario.

ranga said...

give some idea about Bypass oraclebi presentation services cache in advance tab of answers?

thanks in advance

John Minkjan said...

@Ranga,

Please post not subject related questions on the OTN Forum!

Regards

John

John Minkjan said...

@Ranga,

Regarding your first question, see http://obiee101.blogspot.com/2010/08/obiee-catalog-search-and-replace.html

Regards

Anonymous said...

Dear John,
Congratulations for your post. It was very useful for us using the version 10. But now, we are upgrading the version to 11g and we would like to know if you have a similar procedure for remove the 11g's banners.
Thank you,
Daniel Santos
Brasilia - Brazil

John Minkjan said...

@Daniel,

Replace the name's with : and (including the extra space!

regards

John

Anonymous said...

Hi John,
Sorry, but we did not understand your reply. We have to replace the "name's with :"? But there is not any ":" in the script. Could you be more especific?
Thank you very much again.
Daniel Santos

John Minkjan said...

@Daniel,

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

regards

John

Anonymous said...

Hi John,
It worked!
Once again, thank you!
Daniel Santos

Anonymous said...

Hi john,


In dashboard, I have multiple tabs, in one of the report column i am using 2 navigation links: 1 is report and another one is Dashboard Page.
Initially I implemented Syndicate=&siebel but its not working.
Then I implemented your script, its working for this tab only, not for other tabs.

Please help me out! Waiting for your reply...

Thanks,
Aru.