OBIEE 11.1.1.7 installation

Today I thought to share my experience while installing OBIEE 11.1.1.7 in Window 7 64bit Environment.

While installing I got below error:

1. Creating domain failed at configurations step 14th
2. After installations BI services can’t start weblogic server. Error : “Server state changed to FORCE_SHUTTING_DOWN

Let discuss about 1^st error:  

The Error due to Microsoft loopback adapter

Before installation of obiee you need to set loopback adapter in a proper way. Please follow below steps

Add the loopback adapter to the machine by launching Device Manager, and then when the Add Hardware dialog comes up, press Next, Next, Next. Then at the Common hardware types list, select Network adapters. Then, at the Select Network Adapter page, select Microsoft as the Manufacturer, and then Microsoft Loopback Adapter as the Network Adapter. Press Next, Next and Finish.

Then, using Network and Sharing Center click on the Local Area Connection 2 link to bring up the Local Area Connection 2 Status dialog. Press Properties, then double-click on the Internet Protocol Version 4 (TCP/IPv4), then enter the following details:

IP Address: 10.10.10.10

Subnet Mask: 255.255.255.0

Leave other values at default, then press OK, OK, Close; then close the dialog.

Add an entry in the "hosts" file that resolves your machine name to the loopback adapter, by selecting Start, then right-click on Notepad and select Run as Administrator

When notepad.exe opens, select File > Open > and using the file selector select C:\Windows\system32\drivers\etc\hostsand then enter the following details to the end of the file, to resolve the host name mentioned earlier to the IP address for this new loopback adapter

10.10.10.10 Rakesh-PC

Then, select File > Save to save the updated version of the file.

Finally, test that these new network settings work as expected by selecting Start > Command Prompt, then typing ping [machine name], so that the output looks like this

Once you did installation of loopback adapter. Follow the below steps for OBIEE 11.1.17 installation.

Step 1: Install Oracle Database 11g

https://www.youtube.com/watch?v=TooRYY80P7c

Step 2: RUC installation:

http://allinobiee.blogspot.in/2013/07/installing-rcu-111170-utility-on.html

Step 3: OBIEE installation – Check below link and follow the same steps for obiee installation.

https://www.youtube.com/watch?v=GOLxS620pDA

Let discuss 2^nd Error.

After installation I was not able to start weblogic services. I found below error massage.“Server state changed to FORCE_SHUTTING_DOWN”. 

If you getting same error follow below steps

Solutions: You need to change the “boot.properies” password.

Navigate to “boot.properties” and change with your new password as below.

Admin Server boot.properties 

Path:

<BIEE_HOME>\user_projects\domains\bifoundation_domain\servers\AdminServer\security

Note: The User name and Password is already in encrypted format, just remove that and change the entry

password=welcome1234
username=weblogic

Similarly do the same for bi_server1

BI Server boot.properties 

Path:<BIEE_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\security

password=********
username=weblogic

Save these files and start the services again. You should be able to start the server.

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist

Concatenate two columns

Some time you will get request to concatenate two column.You can do with help of concatenate formula.

Here i am concatenating Year and month

Formula  : ("Date (Common)"."Year" )||'-'||("Date (Common)"."Month Name")

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist

Reset button on Prompts

Many users want a button on the prompt itself that can clear off everything and take them to default values. Might be you would are thinking we can achieve this by “Reset” Button, but it does not work in all manner check below.

If (1) the prompt is blank (2) select some value, (3) reset (4) it goes back to blank.

If (1) the prompt is blank (2) select some value, (3) apply (4) reset. (5) It does NOT go back to blank. Actually it does not change anything.

If (1) the prompt is blank (2) select some value, (3) apply (4) change any values (5) reset. (6) it undo any changes done in step 4.

So we want to add new button where it will clear off all prompt value and take them to default value.

Go to Dashboard – Edit Dashboard – Drag Text box object below prompt

Edit Text box and Add below code into text box and enable HTML check box.

<P Align=Center <div class="XUIPromptEntry minibuttonOn"><a href="#" onclick="return PersonalizationEditor.removeDefaultSelection(false)"}>Clear Prompt : It will take you default prompt[Rakesh Patil] </a><align=left></div></P>

Save the dashboard - Run the Dashboard,

You will see the prompt button i.e. “Clear Prompt: It will take you default prompt [Rakesh Patil].

Now you select any prompt value and click on “Clear Prompt: It will take you default prompt [Rakesh Patil] button.

I hope it will help you :)

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist

Add Feedback Link

There was requirement, Add feedback link into dashboard.

So whenever user would click on feedback, automatically it should take you to outlook default mail.

Go to dashboard – Edit Dashboard – Drag Text object – Edit Text object – Add below code into text box and enable HTML check box.

<font family = Arial><font size=2><a href="mailto:rakeshpatil002@gmail.com?" subject=Feed back>Feedback</a></font>

Save the Dashboard - Run the dashboard - Click on Feedback

Output:

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist

Pre-defined presentation variables in OBIEE 11g

These variables can be referenced in analyses, dashboards, KPIs, and agents. The syntax for these pre-defined presentation variables is 

@{session.variablename}  " OR"

@{session.variables.variablename}

You can use variable in below views. For example Title view: here i am giving User name and loginTime.

All Views name where you can you Predefined Presentations Variable:

Title views	Headers and footers for PDF output
Narrative views	Link or image objects in a dashboard
Static text views	Text objects in a dashboard
Filters	Graphs to specify conditional formatting of graph data. Gauge thresholds.
Column formulas	Gauge limits
Conditional formatting conditions	Agents
Table and column headings in analyses	Actions to specify parameters.
Direct database requests	Conditions to specify parameters
Dashboard prompts and inline prompts	Selection steps
KPIs included in a KPI watchlist	KPIs to define thresholds

Pre-define presentation variable name : 

Scope	Presentation Variable	Example
system	productVersion	system.productVersion = 11.1.1.3 (Build 090619.0110.000)
system	currentTime	system.currentTime = 6/29/2009 7:35:59 PM
session	locale	session.locale = en-us
session	language	session.language = en
session	rtl This indicates whether the language selection in the Login page is a right to left language. For example, if the language selection is Hebrew, then this variable returns true.	session.rtl = false
session	timeZone	session.timeZone = (GMT-06:00) Central America
session	timeZone.id This returns a value that is not localized.	session.timeZone.id = (GMT-06:00) Central America
session	timeZone.name This returns a localized value.	session.timeZone.name = (GMT-06:00) Central America
session	timeZone.value This returns a localized value.	session.timeZone.value = (GMT-06:00) Central America
session	loginTime	session.loginTime = 6/29/2009 7:12:01 PM
session	logoutTime	session.logoutTime = 6/29/2009 8:02:01 PM
session	lastAccessTime	session.lastAccessTime = 6/29/2009 7:35:59 PM
session	currentUser	session.currentUser = Administrator
session	currency.name	session.currency.name = $ English - United States
session	currency.symbol	session.currency.symbol = $
session	currency.userPreference	session.currency.userPreference = Global Currency 2
user	id	user.id = Administrator
user	displayName	user.displayName = Administrator
user	homeDirectory	user.homeDirectory = /users/administrator
dashboard	currentPage	dashboard.currentPage = page 1
dashboard	xml	dashboard.xml = the dashboard XML
dashboard	dashboard.currency.name	dashboard.currency.name = Euro
dashboard	dashboard.currency.symbol	dashboard.currency.symbol = $
dashboard	dashboard.currency.userPreference	dashboard.currency.userPreference = Global Currency 1
dashboard	dashboard.path This returns the path in the catalog.	dashboard.path = /users/administrator/_portal/Sales
dashboard	dashboard.name	dashboard.name = MyDashboard
dashboard	dashboard.caption This returns the localized name of the dashboard.	dashboard.caption = Sales
dashboard	dashboard.location This returns the URL for the location.	dashboard.location = Dashboard&PortalPath=/users/administrator/_portal
dashboard	dashboard.description	dashboard.description = Sales by region and district
dashboard	dashboard.author	dashboard.author = Administrator
dashboard.currentPage	dashboard.currentPage.name	dashboard.currentPage.name = Sales page 1
dashboard.currentPage	dashboard.currentPage.path	dashboard.currentPage.path = /users/administrator/_portal/Sales/page 1
dashboard. current Page	dashboard.currentPage.currency.name	dashboard.currentpage.currency. name = USD
dashboard.current Page	dashboard.currentPage.currency.symbol	dashboard.currentPage.currency. symbol = USD
dashboard. current Page	dashboard.currentPage.currency.userPreference	dashboard.currentPage.currency.userPreference = Global Currency 2
analysis	report.currency.name	report.currency.name = $ English - United States
analysis	report.currency.symbol	report.currency.symbol = $
analysis	report.currency.userPreference	report.currency.userPreference = Global Currency 2

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist

Chronological Key

Def : Uniquely identify data on each level in Dimensional hierarchy

All other dimensions don’t care about the order of the values in it.

Example : In region_dim the values are north, south, west and east. Here nobody wants to see whether north comes first or south comes first. I.e. no order is required here.

In the case of time dimension there needs to be a particular order for all the values present in it.

e.g. 2010 is earliest and 2004 is older. Dec-10 is earliest and jan-10 is older. I.e. the values in the time dimension needs to follow a particular sorting order. So the chronological key is the key which tells the obiee that the data is incrementing based on the chronological column.

Here you may get another doubt. i.e. you are having columns like year, half_year, quarter, month, week and day. Here which one should become the chronological key?

Analyze it yourself. If you kept year as chronological key then obiee will be confused whether jan-10 is earliest or feb-10 is earliest. Because it knows only that 2010 is earliest and 2009 is older.

So always it should be the lowest level of the dimension which needs to be the chronological key. In the above case it should be date.

You can select either date or date_id(this could be a sequence generator values). 

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist

Rank

Hello All,

I hope all are good! After long time, I was busy with some work didn’t get time for blogging.

Let’s discuss today Ranks function in obiee 11g

RANK function returns the rank of a number. Suppose, user asking to create report, which shows rank column based on service request created every yearly.

Formula: Rank (expr)

Steps:

Select you’re columns – Year, # of SRs (Service Request) and take any column from subject area (On this column we have to put rank function) here I have taken “Problem type”

Click on Problem type: Go to edit formula and Click on function “F(..)” and select rank function from aggregate folder, you can see in screen shot.

Select the column. Here I have taken for “# of SRs” (Service Request) column.

Click on Ok and Run the report 

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist