iSimplyShare.com

Yes !! That's what I do !!

By

Pre-requisites for installing OBIEE 11g on AIX

1. XLC Complier (11.1.0.4).

2. Configure the TEMP and TMPDIR environment variables (in addition to TMP) to point to the desired temporary directory with adequate free space of 8 GB.

3. Account by which installation be done must have access to Root folders.

4. Static IP is required.

5. User’s limits should be set to unlimited as the default.

To change this for all sessions edit as root the file /etc/security/limits

ulimit -c unlimited (turn on core files with unlimited size)
ulimit -f unlimited (sets the file limit to unlimited)
ulimit -d unlimited (sets the user data limit to unlimited)
ulimit -n unlimited (allows an unlimited number of open file descriptors)

6. Ensure all the ulimit parameters to be specified as below
<UserAccountName> :
fsize = -1
core = -1
cpu = 3600
data = -1
stack = 1024
rss = 1024
nofiles = -1
threads = -1
nproc = -1
cpu_hard = -1

Note: The above mentioned values will be set in /etc/security/limits configuration file.

7. Install bos.loc.utf.EN_US Package for the Oracle BI locale setting english-usa language.

8. There are two thread types that can be configured i.e. GATEWAY and SERVER. (AIX Admin shall change values as per required OS configurations)

GATEWAY is used by a thread pool to call a database client library for establishing a DB connection.
The default size is 256KB; we require it to be raised to 512KB. (No performance penalty for over-configuring)

SERVER threads are used to run queries.
512 KB is the default size, 2 MB The recommended 64-bit setting. No performance penalty.

9. Available Memory (RAM): 32GB 64-bit operating systems

10. Temp Space: 8GB

11. Swap Space: 12GB

12. Configure the loop back adapter (Make changes in etc/host to accept hostname / IP)

13. The Bash Shell needs to be installed, as its required by OBIEE for certain scripts.

14. List of packages required by OBIEE application server installation.

(Note: – we are not aware of latest package version but consider the package name and install the latest version respective to Operating system or Yum repository (local repository) must be configured and OBIEE user shall have sufficient privileges’ to install packages, required for OBIEE installation.)

AIX 6100-02
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.protocols
rsct.basic.rte
rsct.compat.clients.rte
xlC.aix50.rte (version 11.1.0.4)
xlC.rte (version 11.1.0.4)

15. Xming installed on AIX box, OBIEE installation requires input in GUI mod.

16. Stack and memory allocation to user from which installation is to be done; must be set to unlimited.

17. Open the <weblogic-server-home>/common/nodemanager.properties file in a text editor and set the StartScriptEnabled property to true from false.

18. Remove the entry of backup LAN entry from hosts.conf file on AIX.

By

What is Business Intelligence ?

What is Intelligence ??

  • Having knowledge and understanding of a particular thing
  • Foresight information about particular thing
  • Ability to solve complex problems
  • Better decision making

We make decisions all the time, which directly impact our Life.

Intelligence + information = Right Decision.
Business people take decision all the time. The decision they take, have direct impact on the success and growth of their business. Some decisions are proactive while others are reactive.

Business intelligence simply means making your business intelligent.

What does a business people have ? – Data about their business

This data is of no use for business people unless and until it is presented in Intuitive and Structured way.

That’s where Business intelligence comes in !! Converting raw data to Legitimate information.

Lets consider an example of John, who is a CEO of Footwear manufacturing company,

John has to keep track of certain things on a day to day basis

  1. How many sales did we do today ?
  2. How much profit did we make on one sale on a average ?
  3. What category of Foot wear contribute maximum to the profit ?
  4. Which region in United States were highest in sales today ?….and more

He has to keep track of these things in order to know how well his business is doing. However, in order to get ready for future success, John has to know some additional things.

  1. Which region in united states are likely to contribute highest sales in future ?
  2. In which region we need to decrease the supply ?
These questions are important if he has to do certain forecasting for the profit of his organisation

John can use two tools
Business Intelligence – which tells you your now
Business Analytics - Which helps you to do forecast

The above two tools will give john right information about his business in a very intuitive, Easily accessed, Structured and easily Managed way.

Quick Facts :

  1. Term Business Intelligence was coined in 1989
  2. More than 90% of the world’s data was generated in last 2 years.

By

What are Cubes and Dimensions ?

Cube A Multidimensional Way to Look at Data – The cube is the primary OLAP structure used to view data. It is similar to a table in the relational database world. The term cube implies three dimensions, but OLAP have stretched the concept a little bit.

Dimensions - The Perspectives Used for Looking at the Data Dimensions are the answer to the question How do you want to see your data?”

Here are some examples of dimensions –

  • Product – wise
  • Time – wise
  • Store
  • Customer Age
  • Customer Income
  • Employee

Levels & Hierarchies of Dimensions

By

OBIEE 11g Installation on Red Hat Linux

 

Prerequisites for successful installation of OBIEE.

 

  • Following list of packages should be installed before OBIEE installation
  1. binutils-2.17.50.0.6
  2. compat-libstdc++-33-3.2.3 for x86-64
  3. compat-libstdc++-33-3.2.3 for i386
  4. elfutils-libelf-0.125
  5. elfutils-libelf-devel-0.125
  6. gcc-4.1.1
  7. gcc-c++-4.1.1 Read More

By

That’s How WINNING is Done !!

It’s About How Hard You Can Get HIT AND Keep Moving FORWARD !!

That’s How WINNING is Done !!

 

By

Jab tak hai jaan review

Got a mail from one of my friend (Hussain Shaikh), reviewing the latest SRK romantic movie Jab tak hai jaan, after he watched it. I loved reading it, hence thought should share it with you all :D .

 

jab tak hai jaan

 

ROMANCE- The construed of which, in Hindi Cinema was changed by the legendary Read More

  • jab tak hai jaan
  • 2.5StarsJab tak hai jaan

By

OBIEE 11g simple installation on Windows

OBIEE 11g installation on windows machine is done in 2 parts :
  1. Creating the repository using RCU (Repository Creation utility)
  2. Installing OBIEE 11G
Pre-requisites :
  1. Availability of Oracle database
  2. Setup files for OBIEE 11g
Installation Process:
  • Unzip the RCU zip file into some directory and run the rcu.bat under BIN directory. Start the database before running the RCU; this will install the BI and Metadata schema.
Welcome Screen

Welcome Screen

  • WelcomeScreenOBIEE
  • Create Repository Screen
  • Database Connection Details Screen
  • OBIEE1
  • OBIEE1
  • Select Components Screen (for Create Operation)
  • Check Schema Prerequisites
  • Schema Passwords Screen
  • Map Table spaces Screen
  • OBIEE
  • OBIEE
  • Summary Screen (for Create Operation)
  • Completion Summary Screen (for Create Operation)
  • OBIEE
  • Welcome Screen
  • Software Update Screen
  • Types Of Installation Screen
  • Prerequisite Checks Screen
  • Location Screen
  • Administrator Details Screen
  • Configuration Screen
  • BIPlatform screen
  • Security Update Screen
  • Summary Screen
  • Installation Screen
  • Configuration Progress
  • ORACLE  Business Intelligence Login Page

By

Different ToolTip for different rows when user hovers on it in OBIEE 11g reports

OBIEE supports the functionality of adding ToolTip to the report but at column level [You see the same tooltip when you hover on any row in that column]. But I encountered a weird requirement of displaying a different tooltip to users when user hovers on different row in that column of a particular report.

Displaying a unique tooltip for different rows is not an inbuilt feature of OBIEE 11g but it was found achievable by using Narrative view. You need to add custom JavaScript code, HTML code and Some CSS [If you want a good design for your report]. Read More

  • Hover1
  • Hover2
  • Hover3
  • Hover5
  • Hover4

By

Integrating OBIEE 11g with EPM workspace in hyperion

  1. Login to workspace using your credentialsOBIEEHyoerionWorkspace
  2. After logging in Hyperion Workspace, click on the Explore tab in the tool bar. Read More
  • OBIEEHyoerionWorkspace1
  • OBIEEHyoerionWorkspace2
  • OBIEEHyoerionWorkspace3
  • OBIEEHyoerionWorkspace4
  • OBIEEHyoerionWorkspace5
  • OBIEEHyoerionWorkspace6
  • OBIEEHyoerionWorkspace7
  • OBIEEHyoerionWorkspace8
  • OBIEEHyoerionWorkspace9
  • OBIEEHyoerionWorkspace10
  • OBIEEHyoerionWorkspace11
  • OBIEEHyoerionWorkspace12
  • OBIEEHyoerionWorkspace13
  • OBIEEHyoerionWorkspace14

By

Project hierarchy of Android in Eclipse.

 

The following is the explanation for file structure in android :

src/
Contains your stub Activity file, which is stored at src/your/package/namespace/ActivityName.java. All other source code files (such as .java or .aidl files) go here as well. Read More

  • AndroidHierarchy