Split text into different cells

You can take the text in one or more cells, and spread it out across multiple cells. This is the opposite of concatenate, where you can combine text from two or more cells into one cell. For example, if you have a column of full names, you can split that column into separate first name and last name columns, like this:

Go to Data > Text to Columns, and the wizard will walk you through the process. Here’s a full breakdown of how it works:

1. Select the cell or column that contains the text you want to split.
   Note:  Select as many rows as you want, but no more than one column. Make sure there’s enough empty columns to the right so nothing over there gets overwritten. If you don’t have enough empty columns, add them.
   
2. Click Data >Text to Columns.
   
   
3. This starts the Convert Text to Columns Wizard. Click Delimited > Next.
   
4. Check Space, and clear the rest of the boxes, or check Comma and Space if that is how your text is split (Smith, John, with a comma and space between the names). You can see a preview of your data in the Data preview window.
   
   
5. Click Next.
   
6. In this step, you pick the format for your new columns, or you can let Excel do it for you. If you want to pick your own format, select the format you want, such as Text, click the second column of data in the Data preview window, and click the same format again. Repeat for all the columns in the preview window.
   
   
7. Click the button to the right of the Destination box to collapse the dialog box.
   
8. Select the cells in your workbook where you want to paste your split data. For example, if you are dividing a full name into a first name column and a last name column, select the appropriate number of cells in two adjacent columns.
   
   
9. Click the button to expand the dialog box, and then click Finish.
   
   

OBIEE 11g: Application Roles, Groups and Users Management

Users can be created in Weblogic Server which is common with all Oracle Fusion Middleware 11g Based Products.

Application roles are nothing but collection of policies and it is defined in Fusion Middleware.

Application role defines the type of accesses given on various type of resources.

Groups and users are mapped with these application roles

OBIEE comes with a pre created set of roles called, Application Roles.

BIAdministrator which has all administrative privileges. The BIAuthor is able to create dashboards and also create analyses. Finally, the BIConsumer is a role where the user can only view existing dashboards and analysis. There is also an additional role that can be created called BIAnalyst. This role enables the user to create an analyses, but not the dashboards and also has viewing privileges like the BIConsumer.

Following are the steps to create user and assign it to Groups and Application role.

1.     Goto Oracle WebLogic Server Administration Console, http://[localhost]:7001/console

2.     click on the Security Realms menu item in the Domain Structure navigation tree menu.

3.     Under Summary of Security Realms page, click on the myrealm.

4.      Click on the Users and Groups tab to create new user.

5.     Press the New button, and then enter the details for the new user:

6.     Similarly you can create new group as well.

7.     To add this user to one of the groups, and therefore grant them the corresponding application role, click on the user in the list of users that’s displayed, and then click on the Groups tab.

      Select any group, for example BIConsumer, from the Parent Groups Available pane, then move it across to the Chosen pane.

We have created a new user and added them to the BIConsumers group. The policies within Oracle Platform Security Services are granted to  this group as group is added to BIConsumer Role in background.

Steps to create the Application Roles in EM (http://[localhost]:7001/em),

          1.      Login to Enterprise Manager with Admin User.

          2.      Click on Business Intelligence and coreapplication

          3.      Go to Security tab and Single Sign on

          4.      Click on Configure and Manage Application Roles

          5.      Click on Create and Provide the Role name and OK

Steps to Add User’s or Groups on Application Role in EM,

1.      Click on Role and Edit the Created Application role

2.      Add the Existing User’s and Groups to Application Role and OK.

Thats the process to create application roles and assigning groups and users under it.