OBIEE 11g: SQL Conditional COUNT & SUM

To apply condition in COUNT and SUM aggregations, use below methods:

FILTER(COUNT(Column1) USING(Column2 = ‘ABC’))

FILTER(SUM(Column1) USING(Column2 > 0))

List of Run Commands in Windows 7

Program Name	Run Command
About Windows	winver
Add Hardware Wizard	hdwwiz
Backup and Restore	sdclt
Bluetooth File Transfer	fsquirt
Calculator	calc
Change Printer Settings	printui
Command Prompt	cmd
Component Services	comexp.msc
Component Services	dcomcnfg
Connect to a Projector	displayswitch
Control Panel	control
Device Manager	devmgmt.msc
Diagnostics Troubleshooting Wizard	msdt
Digitizer Calibration Tool	tabcal
DirectX Diagnostic Tool	dxdiag
Disk Cleanup	cleanmgr
Disk Defragmenter	dfrgui
Disk Management	diskmgmt.msc
Getting Started	gettingstarted
Internet Explorer	Iexplore
Internet Options	inetcpl.cpl
Language Pack Installer	lpksetup
Magnifier	magnify
Malicious Software Removal Tool	mrt
Notepad	notepad
ODBC Data Source Administrator	odbcad32
ODBC Driver Configuration	odbcconf
On-Screen Keyboard	osk
Paint	mspaint
Pen and Touch	tabletpc.cpl
People Near Me	collab.cpl
Performance Monitor	perfmon.msc
Power Options	powercfg.cpl
Presentation Settings	presentationsettings
Problem Steps Recorder	psr
Region and Language	intl.cpl
Registry Editor	regedit
Registry Editor	regedt32
Services	services.msc
System Restore	rstrui
Tablet PC Input Panel	Tabtip
Task Manager	taskmgr
Task Scheduler	taskschd.msc
Windows Activation Client	slui
Windows DVD Maker	dvdmaker
Windows Repair Disc	recdisc
Windows Update	wuapp
WordPad	write
XPS Viewer	xpsrchvw

Linux: Basic Commands via Putty

cd	Change directory
pwd	To find the exact directory you are in type the command
cd ~/dir1	To navigate to a sub-folder in your home directory i.e. cd /home/keith/dir1 = cd ~/dir1
cd ..	Previous folder (Go back)
rm	Remove file
rm -r	Remove folder i.e. rm -r folder_name
rm -rf FILE_NAME	Force remove folder rm -rf FILE_NAME
tar cvzf	Zip/Archive folder i.e. tar cvzf Target_File_Name.tar.gz   Source_File_Name
tar xvfz	Unzip/Unarchive folder
Unzip	Unzip File_Name.zip - to unarchive .zip files i.e. unzip filesample.zip
Zip -r	Archive folder with .zip extension. i.e. zip  -r  Target_FolderName.zip  Source_FolderName
mv	Move folder/file i.e. mv [file_name] ./[location] Mv file_name ./.. - move to previous directory folder MV comman is also used to rename file name i.e. if I want to rename FILE into FILE1, the command is: mv Current_File_Name New_File_Name
/sbin/ifconfig	To view IP addresses and configurations (similar to Windows ipconfig)
vi	View editor. Once you are on view editor mode, press i to insert and navigate the cursor with keyboard arrows to edit the content.
:wq!	Save and Quit view editor mode.
:q!	Quit editor mode without saving the changes.
cat OR less	File viewer without editing privilege .
scp -r	Server copy file - to copy file from server to server or other directories i.e. scp -r filename* user@servername:/directory * - indicates to copy all content inside a folder User - previleged user at target server @servername - where the file will be copied to :/directory - file path to paste the copied files Follow instructions on screen afterwards.
ps -x	View running services / processes
kill -9 [PID#]	Kill process by force You can perform this task after ps -x (view running processes) i.e. kill -9  12345
tail -100f [log path]	Read last 100 rows of a file. i.e. tail -100f /home/file/abc.log Note: press Ctrl+C to exit tail view.
nohup	Run service/process in the background i.e. navigate to the path where you want to execute the process: nohup ./service_name &
export VAR_ENVR_NAME=	To set Variable Environment i.e.  export ORACLE_HOME=/user/Middleware/OBIEE11g
echo "$VAR_NAME"	View current variable environemtn i.e.  Echo "$ORACLE_HOME"
scp file_name user_name@server_name:path	Copy files from one user to another i.e. scp file_name user_name@server_name:/directory_path
sudo su - username
cp *	Copy all from current file into target_path i.e. cp * /home/user If you have multiple files that starts with the same syntax, i.e. file1, file2, file3 -then you can use this command:  cp file* /home/user This will move all files that names start with file
vi filename	Creates a new file
cp /home/vizid/filename .	. Represents current directory
top	View running services
./opmnctl startproc ias-component=COMPONENT_NAME	To start/stop individual OBIEE OPMN services, this command is used
touch	Create new file (.txt) i.e. touch FILE_NAME
Df	Check hard disk space
du -sh	Check folder usage space du -sh Folder_Name
Free -g	Check server RAM / Memory usage
./opmnctl stopproc ias-component=coreapplication_obips1	Stopping one BI service at a time
find . -name SEARCH_TERM*	Will search all subordinate folders from current directory

Robert Prechter Jr's Chapter 33: A Short List of Imperative “Do’s” and Crucial “Don’ts”

Recall the old Chinese character that entwines crisis and opportunity in the same glyph. Position yourself to take advantage of what's coming.
Don't:

• Generally speaking, don't own stocks.
• Don't own any but the most pristine bonds.
• Generally speaking, don't invest in real estate.
• Generally speaking, don't buy commodities.
• Don't invest in collectibles.
• Don't trust standard rating services.
• Don't presume that government agencies will protect your finances.
• Don't buy goods you don't need just because they are a bargain. They will probably get cheaper.

Do:

• Fight the inertia that will keep you from taking action to prepare for the downturn. Start taking steps now.
• Involve your significant others in your decisions. Put your home or business partners in tune with your thinking before it's too late.
• Talk to heavily invested parents or in-laws who may be planning to pass on their investments to you. See if you can get them to become safe and liquid.
• Think globally, not just domestically.
• Open accounts at two or three of the safest banks in the world.
• Invest in short-term money market instruments issued by the soundest governments.
• Own some physical gold, silver and platinum.
• Have some cash on hand.
• Make sure that you have insurance policies only with the safest firms and make sure that they deal only with safe banks.
• If you are so inclined, speculate conservatively in anticipation of a declining stock market.
• Sell any collectibles that you own for investment purposes.
• If it is right for your circumstances, sell your business.
• Make a list of things you want to buy at much lower prices when they go on "liquidation sale."
• If you want to have kids, hurry up. Statistics show that fewer people feel like doing so during a bear market.
• Give friends a copy of this book.
• Keep up with our Bear Market Strategies page, a continually updated report on-line at http://www. elliottwave.com/conquerthecrash.
• Contact the services mentioned in this book! I am a market analyst and forecaster, not a banker, insurer, money manager, institution rater or depression strategist. These services can help guide you through the maze. Some of them can help you design your whole strategy in a matter of days.
• Plan how to take advantage of the next major uptrend. For example, go back to school during the decline and come out with extra skills just as the economy begins to recover. Apprentice in a job for low pay and learn enough to start your own business at the bottom so you can ride the next big upwave of prosperity. Investigate troubled businesses to buy at the bottom at deep discounts.
• Smile! because you will not be jumping out of the window; you'll be preparing for the incredible opportunities listed in the next chapter.

Source: http://www.elliottwave.com/club/protected/ctc/resources/chp_33.aspx

OBIEE 11g: OPatch failed with error

If you receive this error message, check below:

1. Recheck if BI Services (OPMN) stopped correctly

2. To ensure that .zip file was unarchived correctly, delete the previous unzipped file and re-unzip the patch file.

3. Make sure to read the "README.txt" and follow instructed steps carefully.

21 Suggestions for Success!

By H. Jackson Brown - (most of it is common sense)

1. Marry the right person. This one decision will determine 90% of your happiness or misery.
2. Work at something you enjoy and that's worthy of your time and talent.
3. Give people more than they expect and do it cheerfully.
4. Become the most positive and enthusiastic person you know.
5. Be forgiving of yourself and others.
6. Be generous.
7. Have a grateful heart.
8. Persistence, persistence, persistence.
9. Discipline yourself to save money on even the most modest salary.
10. Treat everyone you meet like you want to be treated.
11. Commit yourself to constant improvement.
12. Commit yourself to quality.
13. Understand that happiness is not based on possessions, power or prestige, but on relationships with people you love and respect.
14. Be loyal.
15. Be honest.
16. Be a self-starter.
17. Be decisive even if it means you'll sometimes be wrong.
18. Stop blaming others. Take responsibility for every area of your life.
19. Be bold and courageous. When you look back on your life, you'll regret the things you didn't do more than the ones you did.
20. Take good care of those you love.
21. Don't do anything that wouldn't make your mom proud.

OBIEE 11g: 11.1.1.7 is Coming Soon - January 2013

 Demo version is out for VIP users :).

OBIEE11g: Analysis / Report Column/Field Drill-down Issue

To ensure that all Level-based Hierarchies created at .rpd level work properly, make sure not to include lower-level column/field in the report or in "Exclude" section in Layout.

• i.e: if you have a Level-based Hierarchy in this order: Product > Brand > Type > Product_Name; and you are creating and analysis with Brand to drill-down as needed, DO NOT include Type or Product_Name. 
• This happens, because even though you may put Type or Product_Name in "Exclude" section, the BI server will take as "not to show," since it is excluded.

  

OBIEE 11g: Starting / Stopping Domain Services in Linux

Starting the OBIEE 11g Domain Components 
1. Start WebLogic Domain: 

     a. Open a new terminal and login

     b. Go to: /user_projects/domains/bifoundation_domain/bin

     c. Execute: nohup ./startWebLogic.sh &

          i. Note: nohup is the command to run executions in the background.

2. Start Node Manager:

     a. From the same terminal, Go to: Hme>/wlserver_10.3/server/bin

     b. Execute: nohup ./startNodeManager.sh &

     c. To confirm the services started, access OBI Console and Enterprise Manager.

3. Start Managed Server:  

     a. Go to: /user_projects/domains/bifoundation_domain/bin

     b. Execute: ./startManagedWebLogic.sh

4. Start OBIEE (OPMN):

     a.  Go to: /instances/instance1/bin

     b. Execute: ./opmnctl startall

     c. Note: There is no need for nohup to start OPMN services.

Stopping the OBIEE 11g Domain Components

Note: to stop OBIEE services, the order is reverse:
 

1. Stop OBIEE (OPMN): 

     a. Open a new terminal and login

     b. Go to: /instances/instance1/bin

     c. Execute: ./opmnctl stopall

2. Stop Managed Server:

     a. From the same terminal, Go to: /user_projects/domains/bifoundation_domain/bin/

     b. Execute: ./stopManagedWebLogic.sh

   

3. Stop WebLogic:  

     a. Go to: /user_projects/domains/bifoundation_domain/bin

     b. Execute: ./stopWebLogic.sh

"Live, Learn, Apply & Educate!" DRAZDA

OBIEE: RPD Deployment Considerations

Here are few tips to consider when your repository (RPD) deployment fails (some of them are common sense, but given times we might overlook things):

1. .rpd wrong password
2. Correct version of .rpd. This is normally caused if RPD is edited by a different version of OBIEE Client.
3. In clustered environment, make sure to specify Shared Folder directory.
4. If users have trouble logging-in after .rpd deployment, make sure to check online user properties from Manage > Identity.
5. And of course you can always look into the NQS log file in: \instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

OBIEE 11g: Current Full Environment Status Check

To check current installation of Oracle Business Intelligence Enterprise Edition 11g, 

1. Log-in to Analytics with Administrator privileged user (i.e. weblogic) 
2. Click on Administrator link above, next to Help link.
3. You will see current install with all applied patches to the environment.

OBIEE 11g: Important Note Installing OBIEE Client

Once you install OBIEE Plus Client (to download click here) make sure to add Open Database Connectivity (ODBC) connections right away, because at this moment the driver will be added pertinent to installed OBIEE Client's version. If you cancel out, you might get this error message: "...system error code: 193"

Oracle Data Integrator: Error: 15050 "Flow control not possible if no key is declared in your target datastore"

This may be the result of interface not having a Primary Key (PK) or Unique Key (UK).

You may try these alternatives to solve the problem:

1. Go to Interface > Quick Edit > Mappings

2. Select one an ID; i.e. EMPNO as a UK.

 

OR – you can perform this:

1. Go to > Models, i.e. TARGET_SQL_MODEL > EMP [table] > Constraints

2. Right click on Constraints > New Key > Select Primary Key > Go To > Columns > Move EMPNO to right side.

Referenced to: http://oditraining.blogspot.com/2012/09/odi-15050-flow-control-not-possible-if.html

Hope this helped and feedback is welcomed! 

OBIEE 11g: Dashboard Selective View from Report Layout

One of the nice feature of OBIEE dashboard editor is that you can select particular view from a compound layout report. 

For example, if you would like to show only a pivot table from a report that has a graph, pivot table and a table; simply: 

1. Go to the dashboard > Edit Dashboard
2. Locate the report and click Properties > Show View (notice the Default Compound View), now you can select what content of the report you want to show.
3. Save the dashboard.

Hope this helped and feedback is welcomed!

Oracle Data Integrator 11g

1. To install ODI you need to have Database and WebLogic installed.

2. From unzipped\Disk1\install directory run the .exe:

3. Click NEXT

a. Before continuing, make sure that you have created the necessary schemas for the products you want to install, and that you have also installed and configured WebLogic Server.

4. You can skip software updates and click Yes if prompted.

5. Select Installation Type, in this case we will select all three:

a. Once checked, click NEXT

Field	Description
Developer Installation	This installation type includes the ODI Studio (with a local agent) and the Oracle Data Integrator Software Development Kit (SDK).
Standalone Installation	This installation type includes an Oracle Data Integrator standalone agent.
Java EE Installation	This installation type includes the Java EE agent, Oracle Data Integrator Console, and Public Web Services.

6. Make sure prerequisite checks are all 100%.

7. The Middleware Home will automatically detect the weblogic directory and will create a folder for ODI to be installed.

8. Next you can Configure repository during installation, however, you need to run ODI RCU before you proceed.

a. Select Configure Repository later.

9. Review Installation Summary and click Install.

10. Installation process…

11. Final installation screen. Click Next and Finish.

Hope this helped & feedback is welcomed!