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...

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...

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:

<Security>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<ClientSessionExpireMinutes>210</ClientSessionExpireMinutes>

<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

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" />
&nbsp;<input style="border: #fff 1px solid; font-family: Tahoma; color: #FFF; background-color: #2e6ebd"
type="submit" value="Search"/>
</p>
</form>

Result-

Comments are always welcome...

 

Adding Bookmark Link in OBIEE

To add 'Bookmark' link in OBIEE, you need to pull a text object in Dashboard and add the following code with 'HTML' check box enabled.

<a href="javascript:void(0);" onclick="if(document.all) window.external.AddFavorite(window.document.location,window.document.title);">Bookmark Page</a>
Save and Run the dashboard page. A pop-up box opens to save the page.

Result-

Comments are always welcome...

 

Edit Analysis and navigate to Criteria Tab-11g

Always when you edit the analysis, you would be navigated to the 'Results' tab by default and then again you need to click on the 'Criteria' tab, to edit.
There is an option to go to criteria tab when clicked on edit analysis.
This feature is available now in 11.1.1.6 in 'My Account' section.

People might have noticed this, but might not have tested the change.

 

Next time when you click on edit analysis, the system will take you to criteria tab.

 

11g Removing the Gray Header from Reports

In 11g, the user can right click on the pivot table report and do sorting excluding the column etc.. also a little grey header on the column heading appears.
This feature is good to some extend and worse in most of the cases. Supposing the user wants to disbale all this, then there should be a way out :)

To remove the gray color tab appearing above the column headings in the pivot table.

Just Edit your analysis and then click on "Analysis Properties dialog" then select Interactions tab here you uncheck all the Interactions link then save it and test it.

 

 If you want to disable enitre report just add below content in your instanceconfig.xml file then restart bi presentation services then test it out.

Include the elements and their ancestor elements as appropriate, as shown in the following example:
<ServerInstance>
<Analysis>
<InteractionProperties>
<InteractionPropertyAddRemoveValues>false</InteractionPropertyAddRemoveValues>
<InteractionPropertyCalcItemOperations>false</InteractionPropertyCalcItemOperations>
<InteractionPropertyDrill>false</InteractionPropertyDrill>
<InteractionPropertyGroupOperations>false</InteractionPropertyGroupOperations>
<InteractionPropertyInclExclColumns>false</InteractionPropertyInclExclColumns>
<InteractionPropertyMoveColumns>false</InteractionPropertyMoveColumns>
<InteractionPropertyRunningSum>false</InteractionPropertyRunningSum>
<InteractionPropertyShowHideSubTotal>false</InteractionPropertyShowHideSubTotal>
<InteractionPropertySortColumns>false</InteractionPropertySortColumns>
</InteractionProperties>
</Analysis>
</ServerInstance>

For More Refer Oracle Note:
http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#BIESG3772
18.3.4 Manually Configuring for Interactions in Views

 Result-

Or to individual pivot table report,  add this code in the static view and append it to pivot table view


<script type="text/javascript">
var tds = document.getElementsByTagName('td');
var lCSS = new Array();
for(var td=0;td<tds.length;td++){
if( tds[td].className != 'PTCC' ){
if( tds[td].className != 'PTCHC0 PT_CPLCHLD PTLC' ){
continue;
}
}
tds[td].style.backgroundColor="#FFFFFF";tds[td].style.display='none';
lCSS.push(tds[td].innerHTML);
}
for(var len =0; len < lCSS.length; len++){
}
</script>

Comments are always welcome...

OBIEE 11.1.1.6BP1 not showing graphs correct in Chrome

OBIEE 116BP1 graphs dont appear or looks bad in Chrome.
Despite several logins or disabling browser cache, the issue persists.

Try disabling Flash in Chrome and then install the latest version.

The below link should help if you don't know how to disable Flash: http://support.google.com/chrome/bin/answer.py?hl=en&answer=108086

Comments are always welcome...

OBIEE 11.1.1 - How to use OBIEE Impersonate

If you quickly need to check a user permission issue, you can use the Impersonate parameter on the url. However, you have to issue two requests to get a report, you cannot do this in a single url:

Impersonation is "atomic" with authentication. It's not a "request" level parameter. You have to authenticate in "impersonated mode":

http://server:7001/analytics/saw.dll?Logon&NQUser=YourAdministrator&NQPassword=Admin123&Impersonate=TheUserToImpersonate

Then

http://server:7001/analytics/saw.dll?Go&Path=%2fshared%2ftests%2ftest1&Options=rmf&Action=print

Also, you need to make sure that the user "YourAdministrator" has the right permissions in 11g: oracle.bi.server.impersonateUser and possibly oracle.bi.server.queryUserPopulation

 

Refer Oracle link-

https://blogs.oracle.com/pa/entry/how_to_use_obiee_impersonate

OBIEE 11G- Javascript and CSS locations

In OBIEE 11g, the path for Javascript and Custom Style Sheet is located at-

OBIEE\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\

And for calling them-
<script type="text/javascript" src="res/test.js"></script>
<link href="res/test.css" type="text/css" rel="stylesheet">
Refer- https://forums.oracle.com/forums/thread.jspa?threadID=2453825&tstart=0



 

Possible Changes in Oracle BI Enterprise Edition Appearance and Behavior After Upgrade-10g to 11g

Beautifully documented by Oracle for the upgrade changes from 10g to 11g.

http://docs.oracle.com/cd/E21764_01/bi.1111/e16452/apndx_ui_chngs.htm

 

Gauge Sub-title removed in 11g

In OBIEE 11g Gauge view, Sub-Title is removed from Gauge Titles tab.
People who have migrated from OBIEE 10g to OBIEE 11g having the Sub-Title view in their reports would have to check it out.
May be this too would go into OBIEE 11g pitfalls :)

Comments are always welcome...

Customizing in OBIEE 11g

Found good materials for customizing OBIEE 11g/ 10g.

One from Rittman-
http://www.rittmanmead.com/files/biforum2012/masterclass/RM_BIForum12_Cust2.pdf

and also material from Oracle-
http://www.oracle.com/technetwork/middleware/bi/customizing-oracle-biee-11g-176387.pdf

http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm#BABBDHHD
http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm#CIHJDHGI

For removing 'Preparing for Guided Navigation' Text in 10g
http://obiee1000.blogspot.in/2012/01/hide-message-preparing-guided.html?showComment=1347426536087

Sub Tabs in OBIEE 10g
http://www.eeblog.org/index.php/obiee-10g-nested-tabs-by-embedding-a-dashboard-into-a-page/#more-502

Currency change options
http://docs.oracle.com/cd/E21764_01/bi.1111/e10541/configcurrency.htm#BABFDFIC

Hope this helps all.


 

Right and Left Function in OBIEE

This is a basic report, but still wanted to make this post to show the results compared.
When we would need to use the left side or right side values from a column then we do have String Function-Right and Left Function
So in the column formula we can pull the String Functions-Right and Left function and check the Syntax.

Syntax-RIGHT(Column_name,integer) and LEFT(Column_name,integer)

And the result Comparison.

Comments are always welcome...

Conditional Hyperlink/ Removing Conditional Hyperlink

In OTN forum, I came across a good requirement and I tried the same.
Cases where you need to keep/ remove the conditional underline  of a text while showing navigation can be handled by our user friendly HTML script. This can be played under the impression where customized text is required for the navigation.
Below piece of code shows the text to represent without an underline beneath the data values. And also do note that the pointer shape is replaced with default to remove the 'Hand' symbol.  You also need to change the Data format of the column to HTML

Save and see the result...

Comments are always welcome...

Left Indent on OBIEE 11g

I have seen couple of questions raising for changing the indent style of the data values in the OTN forum and also me myself had a requirement in OBIEE 11g to change the style of the data values to indent 20 from left. We found to add the indent properties to 20 and see the change.
But you can also still trust on css properties. And of course, both the trick plays their role perfectly.

Take a reference of the below screenshot-

Save and check the results...

Also try using 'text-indent:30px' and would produce the same results

Comments are always welcome...

IsNumeric or NOT

I needed to show the column values containing numbers as 'Numeric' and the values without the numbers as 'Alphabets'. I would first validate the column values with the case statement, if it is containing any numeric value. If it doesnt contain then it is named as 'Alphabets'
And on top of it I need to show the custom messages back ground with different colors.
I have tried the below method with HTML and with conditional formatting.

First method approach is with HTML and case statement.

case when ("Products"."Product" like '%1%')
OR ("Products"."Product" like '%2%')
OR ("Products"."Product" like '%3%')
OR ("Products"."Product" like '%4%')
OR ("Products"."Product" like '%5%')
OR ("Products"."Product" like '%6%')
OR ("Products"."Product" like '%7%')
OR ("Products"."Product" like '%8%')
OR ("Products"."Product" like '%9%')
OR ("Products"."Product" like '%0%')
then '<span style="background-color:Red">Numeric</span>'
else '<span style="background-color:Green">Alphabets</span>'
end

Second method with conditional formatting and case statement.

Here you need to add the below code in the column formula

case when ("Products"."Product" like '%1%')
OR ("Products"."Product" like '%2%')
OR ("Products"."Product" like '%3%')
OR ("Products"."Product" like '%4%')
OR ("Products"."Product" like '%5%')
OR ("Products"."Product" like '%6%')
OR ("Products"."Product" like '%7%')
OR ("Products"."Product" like '%8%')
OR ("Products"."Product" like '%9%')
OR ("Products"."Product" like '%0%')
then 'Numeric'
else 'Alphabets'
end

and in the column properties-->conditional formatting-->add condition

Save and check the results...

Comments are always welcome...



Scope of Variables

You can reference variables in the following areas:

-Title Views
-Narrative Views
-Column Filters
-Column Formulas
-Conditional Formatting conditions (presentation variables only)
-Direct Database Requests
-Dashboard prompts
 Users will be prompted for a variable value which is then set into a request (session)   variable and passed to the Oracle BI server.
-Chart scale markers.
-Gauge range settings.
-Static text.
-iBot Headlines and text

Prompt with Combined Subject Area

Values produced from a single subject area in the prompt can be used to filter the data in the report. But if we need to combine the results of both the columns in two different subject area then we need to combine both the columns using a UNION request in the SQL results.

Lets start with the creation of the prompt. We first pull the column from the first subject area and in Options-->Choice List Values-->SQL Results. We copy the Logical SQL query from the first prompt.
For Example-SELECT "Time"."Per Name Year" FROM "Sample Sales Lite"

Next, we create a second prompt and as the steps mentioned above try to copy the Logical SQL results from the second prompt with a different subject area.
For Example- SELECT "Time"."Per Name Half" FROM "Sample Targets Lite"

We combine the first Logical SQL query with the first logical SQL query with a union between the two SQL clause.
Now the query looks similar to the below-

SELECT "Time"."Per Name Half" FROM "Sample Targets Lite"
union
SELECT "Time"."Per Name Year" FROM "Sample Sales Lite"

Save and check the results...

Comments are always welcome...

UA.bat hangs in OBIEE 11.1.1.6.2

As a reference-
https://forums.oracle.com/forums/thread.jspa?threadID=2400314&tstart=240

As per Christian-

I did a fresh installation of OBIEE 11.1.1.6 on a Windows Server 2008 R2 Standard 64 bit (I installed the 64bit version) and patched it to 11.1.1.6.2. When trying to upgrade the .rpd file from 10.3.4.1 the Upgrade Assistant simply hangs when clicking on the "next" button after supplying the relevant informations. Setting the ORACLE_HOME environment variable as mentioned in the thread above didn't solve the problem. Also I don't have another oracle home on that machine, so I think I started the correct UA.
When looking at the logfile of UA i get those messages:

[2012-06-11T10:36:58.033+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 11] [ecid: 0000JVQg5GmBt1YzLofP8A1FpQrf000002,0] Please enter the repository password:
[2012-06-11T10:36:58.051+02:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 11] [ecid: 0000JVQg5GmBt1YzLofP8A1FpQrf000002,0] Please enter the 10g Admin password:

I get those log file entries immediately after I press the "next" button. Needless to say I entered the correct admin password and a valid repository password. It also hangs with the same messages in the logfile when I only supply the Admin username but no passwords at all, so I guess even though I enter both passwords UA simply doesn't recognize them and fails to present me a error message.
This worked previously in 11.1.1.6.1 (and also in 11.1.1.5), and there where no changes to the .rpd file so I don't think it's the fault of the .rpd file.

Deepika answered it as-

This is an open bug with oracle, refer to the following bug detail in support web,
Bug 14160867: UA UTILITY HANGS AND DOES NOT PROGRESS AFTER STEP 3 ON 11.1.1.6.2

Comments are always welcome...