OBIEE REVISITED

Tuesday, 12 February 2013

Removing/ Deleting Report Links in a Page

Please add the below piece of code in the Text object with HTML check box enabled.

<head>
<script type="text/javascript">
var element1 = document.getElementsByTagName('td');
var count=0;
var classname2 ="ResultLinksCell";
for (var j = 0; j < element1.length; j++)
{
var classes1 = element1[j].className;
if (classes1==classname2)
{
count=count+1;
{
element1[j].parentNode.removeChild(element1[j]);
}
}
}
</script>
</head>

But the '-' will remain and if needed you can move these to the extreme below of the page with my previous blogs enteries.

Comments are always welcome...

Thursday, 17 January 2013

Remember Username and Password in Obiee11g

Go to your BIPS config path, for example like below,

D:\Oracle\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 and the search Security tab in your instanceconfig file and add <AllowRememberPassword>true</AllowRememberPassword>

Then save it and restart bips servervices.

Include the elements and their ancestor elements as appropriate, as shown in the following example:

<AllowRememberPassword>true</AllowRememberPassword>

<CookieDomain>value</CookieDomain>

<CookiePath>/analytics</CookiePath>

<InIFrameRenderingMode>prohibit</InIFrameRenderingMode>

</Security>

Save your changes and close the file.

Restart Oracle Business Intelligence Presentation Services via OPMN

Then Test it,

Just click on yes and then it will load in BI Home page ..then next logout and login OBIEE page it will remember your Username and Password then load in BI home page.

For More please refer,

http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/psconfigset.htm#BIESG1292

Sunday, 30 December 2012

Searching a Text in Page

If your report is too large and you want to search your desired record, if you know the value.
Then add the below code in the text with 'HTML' tag enabled.

<script type="text/javascript" language="JavaScript">

var OtherBrowser = (document.getElementById);
var IE4 = (document.all);
var NS4 = (document.layers);
var win = window;
var n = 0;

function findInPage(str) {
var txt, i, found;
if (str == "") {
alert("Enter some thing to search");
return false;
}

else if (IE4) {

txt = win.document.body.createTextRange();

for (i = 0; i <= n && (found = txt.findText(str)) != false; i++) {
txt.moveStart("character", 1);
txt.moveEnd("textedit");
}
if (found) {
txt.moveStart("character", -1);
txt.findText(str);
txt.select();
txt.scrollIntoView();
n++;
}
else {
if (n > 0) {
n = 0;

findInPage(str);
}
else
alert("Sorry, we couldn't find.Try again");
}
}
else if (OtherBrowser) {
if (!win.find(str)) {
while (win.find(str, false, true, false, false, false, true))
n++;
}
else if (win.find(str)) {

n++;
}
}

if (NS4) {
if (!win.find(str)) {
while (win.find(str, false, true, false, false, false, true))
n++;
}
else if (win.find(str)) {
n++;
}
}
return false;
}

</script>

</head>
<body>
<div style="padding-top: 5px; padding-right: 10px; float: right;">
<form name="Search" action = "" onsubmit="return findInPage(this.string.value);">
<p align="center">
Keyword Search:
<input style="width: 200px; border-right: #666666 1px solid; border-top: #666666 1px solid;
font-size: 10pt; border-left: #666666 1px solid; border-bottom: #666666 1px solid"
onchange="n = 0;" size="16" name="string" />
 <input style="border: #fff 1px solid; font-family: Tahoma; color: #FFF; background-color: #2e6ebd"
type="submit" value="Search"/>
</p>
</form>

Result-