OBIEE REVISITED: 2013

Sunday 21 July 2013

Representation of Presentation variable

Got a request from OTN forum- https://forums.oracle.com/thread/2562081 asking for the formatting of the presentation variable representation-
User wants to show in the dashboard the exact representation of the presentation variable as below
@{My_PV}{Horse}

Used HTML ascii codes for the same-

1. In the criteria column formula use-

case when 1=1 then '@{Geo_Var1}{AMERICA}' else

dummy_column_name

end

2. In the narrative view, prefix use -@{Geo_Var1}

3. In the narrative section - {@1}

4. Rows to display - 1

There should be another way for this...

Comments are always welcome...

Friday 28 June 2013

Division of numbers/ intergers- Results in unexpected Data

In OBIEE 11g, We noticed that while dividing two integer numbers, the data result was not as expected. With data format as percentage.

For example- 607/ 1257 resulted in 11%

My colleague, changed the formula to double and the results were matching.

For example- cast(607 as double)/cast(1257 as double)*100.00

Comments are always welcome...

Tuesday 28 May 2013

OBIEE 11.1.6..Environment incompatible with IE 10 version.

There are OBIEE 11g incompatibility issues with IE10 and we had already raised SR with Oracle for the same.

As per updates from Oracle , IE10 is not certified with 11.1.1.6.x or 11.1.1.7.0. The supported browser versions with respect to 11.1.1.6.+ are as follows:
"Chrome 12+
Internet Explorer 9.x
Firefox 6+"

That is the reason there are issues with the IE10 in your environment. For IE users, it is recommended to use the IE9 browser to use OBIEE, or use the supported browser as mentioned above.

Workaround 1:

1. In IE browser window : Go to Tools -> F12 Developer Tools. This opens a window in the lower half of the browser.

2. Make the Browser Mode as IE 10 and Select Document Mode as IE 9 Standards.

Whenever a new tab is opened in IE10 , we need to do steps 1 and 2. The document mode settings cannot be set to 'IE9 Standards' globally.

Workaround 2:

These steps would help to roll back to your original IE version before it got upgraded to IE10 -

Ø Go to Windows Control Panel > select Programs and Features (note if you have windows XP then it would be ‘Add/Remove Icon’) > select ‘Turn Windows features on or off’ > You should now see a popup called "Windows Features".

Ø Un check Internet Explorer 10 > you get a popup message warning; just click ‘Yes’ > click ‘OK’ button.

Ø Now back to the program and feature screen click "View installed updates" > scroll down until you see Internet Explorer > right click > uninstall and click ‘OK’ all the way out.

Ø Reboot your computer and let Windows go through its update. When it's done you should have your old Internet Explorer browser back.

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

Pages

Sunday 21 July 2013

Representation of Presentation variable

Friday 28 June 2013

Division of numbers/ intergers- Results in unexpected Data

Tuesday 28 May 2013

OBIEE 11.1.6..Environment incompatible with IE 10 version.

Tuesday 12 February 2013

Removing/ Deleting Report Links in a Page

Thursday 17 January 2013

Remember Username and Password in Obiee11g