HOW TO OPEN OBIEE RPD IN ONLINE MODE

1.     To open RPD in Online Mode, configure ODBC connection in client/Server(where obiee is installed) machine.

2.       Go to start menu, search for Data Sources(ODBC), click to open ODBC data source Administrator.

3.       In the User DSN tab, Click on Add button and select the data source (Oracle BI Server1). If multiple data sources are available select appropriate source and click on Finish.

4.       Enter the name of the data source and the server name and click next.

                        
Note: if it is server machine then configure datasource as shown in below screenshot.

5.    We can get the server name and port for OBIEE from EM as shown in below screenshot.

6.       Enter the Login ID and password used to login to OBIEE EM and the server port as shown in above screenshot.

                    Note: check the connect box to test the connection and also check save login Id check box.

7.    Click on Next, if the connection is successful then click on finish.ODBC connection is created, use this to Open RPD in online mode. 

 8.     Open Administration tool and go to File -> Open ->Online

9.       Enter the RPD  username and password and click on Open.

10.    The RPD will be opened  in Online Mode.

  

Note: If EBS security is implemented then Required for Authentication should be  unchecked for EBS Security Context Inititlization Block for Opening RPD in Online Mode.

 

TASKSEL COMMAND IN LINUX

Tasksel description Task select.
Tasksel is the command specific to Ubuntu.
This command is used to install different Servers in Linux.
When you enter this command it will display list of servers to install then we can select the software which are required and install.

DIFFERENCE BETWEEN RANK AND DENSE_RANK IN SQL

DENSE_RANK() and RANK()  are both aggregate functions.

The difference between the DENSE_RANK() and RANK() functions is that RANK will assign non-consecutive ranks to the values in a set in the case where the values are same, which means with RANK() there will be gaps between the ranking when the values are same.

The DENSE_RANK() will assign consecutive ranks to the values in the case where the values are same, so there will be no gaps between the ranking when the values are same.


Example:

select ename,sal,
rank() over (order by sal desc)  rank,
dense_rank() over (order by sal desc) dense_rank
from emp;

HOW TO START, STOP OR RESTART APPLICATIONS IN LINUX

The Start command is used to start a application.
The Stop command is used to Stop a application.
The Restart command is used to restart a application.

Ex: sudo /etc/init.d/apache2 start

Note: After each command space should be there. 

LINUX BASICS

Commands:

•  Sudo : Super user do.

     ROOT is the admin user in Linux. If a user logins as ROOT they can do anything in linux.
     If hackers can login as ROOT and cause problems.
     So in Ubuntu we can't login as ROOT so we need to use Sudocommand.
     Sudo command allows us to run commands as Administrator.

     Ex: Sudo apt-get

• man :

        man command gives the description of the Linux commands.

        ping displays all the Ubuntu commands.

      Ex: man ping

• q :

          q Command is used to quit and return to previous page.

• clear screen :

           Clear screen command is  used to clear the linux terminal screen.

• apt-get

          This command is used to manually install or uninstall or update the servers in linux from web.

          Ex: sudo apt-get install apache2

                 sudo apt-get remove apache2   
                 sudo apt-get upgrade apache2 

           To use this command we need to  install it in Linux.

How to execute commands in Linux:

•  Open Terminal which is a command line tool in Linux.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

INTRODUCTION TO LINUX

Introduction:

•  Unix is developed in 1970 in AT&T Laboratories.
•  Linux is Unix like Open Source Operating system developed in 1994.
•  Linux is not derived from Unix its a separate OS.
•  Unix/Linux are multi user operating system i.e.., more than one user can logon at a time. 
•  Example : Ubuntu, RedHat etc..,
•  Shell is the screen you use to interact with the operating system (Graphical or command).
•  ROOT is highest level of anything in Linux.    

             ROOT user is the highest level of user in Linux(Admin). 
             ROOT is the highest file location.
             ROOT is the home directory for a User.

•  Linux is caps specific that means HOME folder is different than Home folder.
•  Operating system will be server and desktop version.
•  Server will not have graphical user interface and minimal applications, desktop versions have  GUI.

Advantages of Linux:
1. Security
2. High Availability - it can run for many days without reboot.
3. Server functionality - Apache web Server, Email Server etc

Disadvantages of Linux:
1. Slow
2. Not user friendly

FLIPUD & FLIPLR COMMANDS IN MATLAB

1. fliplr command is used to reverse the data from left to right.
Please find  example below.

Example:

a=[ 0 0.1 .2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1]

Command:

b = fliplr(a)

output:
b=[1 0.9 0.8 0.7 0.60.5 0.4 0.3 0.2 0.1 0]

2. flipud command is used to reverse the data from up to down.
Please find  example below.

Example:

if the data is as below
c=[ 0
    0.1
    0.2
    0.3
    0.4
    0.5
    0.6
    0.7
    0.8
    0.9
    1 ]


Command:

d= flipud(a)

output:

d=[1
    0.9
    0.8
    0.7
    0.6
    0.5
    0.4
    0.3
    0.2
    0.1
    0 ]

Note : These commands are case sensitive.

DIFFERENCE BETWEEN TRUNCATE AND DELETE COMMANDS IN SQL

	Truncate	Delete
Definition	It removes all the rows from table.	It is used to remove specific or all the rows from table.
Syntax	Truncate table table_name;	Delete from  table_name; Delete from table_name where column=value;
Example	Truncate table employees;	Delete from employees; Delete from employees where employee_name like 'Sam%'
Commit	Truncate is auto committed.	Commit should be given after delete.