Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 17 May 2014

OBIEE 11g Interview Questions from Virtusa


One of  my buddy who has 3+ year if experience in OBIEE 11g development has attended OBIEE interview in Virtusa today.

Question mention below is OBIEE 11g Interview questions which he faced recently with Virtusa



1 Tell me About yourself


2 Whats your role on project


3 what is the difference between Filters and Selection steps
 

4 what are all the components will have in dashboard
 

5 where we can see the sql queries in answer side
 

6 what is the use of Advanced tab in analysis
 

7 what are all the types of views
 

8 what is dashboard prompt  

9 what is agents and its steps
 

10 what is the difference between column selector and view selector
 

11 what is the use of narrative vierw
 

12 how you combine two subject area and get reports
 

13 what are all the options will use while combinig reports from different subject area
 

14 what the common possible things need to create a combined answer
 

15 what is use of delivery devices
 

16 Difference between Pivot view and table view
 

17 How you do sort order and what are all options are ther
 

18 How you do drill from report as well as graph
 

19 What is the use ticker view
 

20 How you will user comments in agents steps
 

21 How you will add document In the dashboards
 

22 What is the use of action links
 

23 Steps for write back and its use
 

24 What is the use of RPD
 

25 How will you import tables to Physical laeyr
 

26 what is the use of alias
 

27 cache management in RPD
 

28 variables
 

29 One connection pool may map to how many tables
 

30 Will the joins define automatically while imnporting from database to physical layer
 

31 I am having only one table in physical layer and moving to BMm layer what happens and if any errors came what the steps I have to take
 

32 whatis the use BMM layer
 

33 what is LTS
 

34 what is LT
 

35 types of hierarchy can you explain me one hierarchy and its steps and where we will use
 

36 in creating hierarchy where we can define logical levels
 

37 what is the use f chronological key why we have to define
 

38 what is the use of new logical key
 

39 can we set from parent to child and child to parent in hierarchy
 

40 what is the purpose of time dimension hierarchy
 

41 what is LBM
 

42 What are all the calcualtion done in BMM layer according to your project
 

43 how you define security in RPD
 

44 what are all the typesof security available in RPD
 

45 how you will set the permissions for different subject areas
 

46 what is mean by content level
 

47 what is the use purge why we are using
 

48 what is the use of jobs
 

49 Usage tracking and its steps
 

50 what are all the things will do in EM and Console
 

51 About Joins
 

52 Log Level
 

53 Disadvantage of cache

To create a database in SQL Server 2008



To create a database

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance 
  2. Right-click Databases, and then click New Database.
  3. In New Database, enter a database name.
  4. To create the database by accepting all default values, click OK; otherwise, continue with the following optional steps.
  5. To change the owner name, click (…) to select another owner.


The Use full-text indexing option is always checked and dimmed because, beginning in SQL Server 2008, all user databases are full-text enabled.

  1. To change the default values of the primary data and transaction log files, in the Database files grid, click the appropriate cell and enter the new value..
  2. To change the collation of the database, select the Options page, and then select a collation from the list.
  3. To change the recovery model, select the Options page and select a recovery model from the list.
  4. To change database options, select the Options page, and then modify the database options. For a description of each option, .
  5. To add a new filegroup, click the Filegroups page. Click Add and then enter the values for the filegroup.
  6. To add an extended property to the database, select the Extended Properties page.
    1. In the Name column, enter a name for the extended property.
    2. In the Value column, enter the extended property text. For example, one or more statements that describe the database.
  7. To create the database, click OK.

Create a database user using SQL Server Management Studio





1. In SQL Server Management Studio, open Object Explorer and expand the Databases folder.

2. Expand the database in which to create the new database user.

3. Right-click the Security folder, point to New, and then click User.

4. On the General page, enter a name for the new user in the User name box.

5. In the Login name box, enter the name of a SQL Server login to map to the database user.

6. Click OK.

MS SQL Server 2008 Installation Step by Step






MS SQL Server 2008 DATABSAE AND USER CREATION S

GOTO START PROGRAM CLICK SQL SERVER MANAGEMENT STUDIO






EXPAND SQL SERVER MANAGEMENT STUDIO SELECT SQL SERVER MANAGEMENT STUDIO







CONNECT TO DATABASE SERVER ENTER USER NAME AND PASSWORD










AFTER ENTERING USER NAME AND PASSWORD CLICK CONNECT



Id: sa

Pwd: ********




Expand the database in which to create the new database user

Right-click the Security folder, point to New, and then click NEW LOGIN









On the General page, enter a name for the new user in the User name box.







ENTER PASSWORD AND CONFIRM PASSWORD CLICK OK





Id: hyperion

Pwd: ************




ASSIGN SECURITY PREVILIGES TO A USER








ASSIGN USER MAPPED FOR A LOGIN








ASSIGN LOGIN STATUS SETTINGS TO A USER











AFTER SECURITY PREVILIGES SETTING TO A USER DISCONNECT THE SQL SERVER











CONNECT DATA BASE ENGINE











ENTER WITH NEW LOGIN AND PASSWORD







In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

Right-click Databases, and then click New Database








In New Database, enter a database name. To create the database by accepting all default values, click OK; otherwise, continue with the following optional steps.














To change the owner name, click (…) to select another owner

The Use full-text indexing option is always checked and dimmed because, beginning in SQL Server 2008, all user databases are full-text enabled.











To change the default values of the primary data and transaction log files, in the Database files grid, click the appropriate cell and enter the new value..







REPEAT THE ABOVE STEPS FOR CREATING ANOTHER DATABASE



















To change the collation of the database, select the Options page, and then select a collation from the list.

All products support Latin Collation for the SQL Server database. Use this statement:

2. SQL_Latin1_General_CP1_CI_AS












ASSIGNED USER MAPPING TO THE LOGIN FOR BOTH DATABASE CREATED





When creating a Microsoft SQL Server database for use as a repository, ensure that you set these options:

Set READ_COMMITTED_SNAPSHOT = ON

Set ALLOW_SNAPSHOT_ISOLATION = ON




USING THIS QUERY WE CAN ALTER ISOLATION AND SNAP SHOP STATUS OF THE DATABASE









TO TAKE DATABASE BACK UP GOTO DATABASE NAME RIGHT CLICK SELECT TASK AND SELECT BACKUP







SAVE THE FILE







AFTER SAVING THE FILE WE GO TO THAT LOCATION







Cheers

Thursday, 15 May 2014

Scorecard in obiee 11g



Score Card in OBIEE 11g

Score Card
Monitor and manage strategy Performance of the organization from the top to bottom.

Progress and performance over a time of period of an organization.

Balanced Score Card
Some of the Organization focusing on financial related strategies as traditionally.

Some of the perspectives are customer, internal processes, Financial, Learning and growth.

To define the strategy of the organization they ensure all these perspectives.

Financial
Which is used to find the financial measures it helps the financial management people to know strategy of organizational performance.

Customer
This is used to find the customer point of view to know the strategy performance.

Internal Process
Internal process is used to identify the measures by all level in organization.

Learning and Growth
It is used to identify the measure according to that finds the way to improve the performance.

Steps to Create Score Card
1.      Click New àunder Performance Management go to à Score Card
2.      Give the name for the score card and set the location where it has to save.

3.      A new screen with score card overview will get display.

4.      Create a new strategy objective, go to left side pane and in the top you will find strategy, click new to create a strategy and assign name and location.


5.      In analysis tab we have score details, children details, Descendants details.

Score - This is used to define the value of the KPI which included in the analytics
Children – it is used to display the status of the analytics
Descendants – Perspective type, assessment formula, Indicator type.
Actions – it is used to link some reports or dashboards or any other links from the score card.

Perspective:
Perspective can represent the key stack holders in the organization.
It is the category to associate initiatives, objectives, and KPI’s


Perspective types:
ü  Internal Process- Support the corporate by internally for performance management strategy using the internal policies and procedures.
ü  Financials – support the corporate for development of organization
ü  Customers – Client support to improve the performance of the organization
ü  Learning & growth – It supports the employee training to develop organization status.


Assessment Formula:
 It is used to set the rule for performance of initiative or objective.

Worst case: specify that the status of the worst performing child KPI or objective is to be used.

Best Case: Specify the status of the best performing Child KPI and Objective used.

Most Frequent (Worst Case): If the performance of half of child KPI has High performance and low performance in that situation can use Most Frequent (worst case) for worst performance strategy.

Most Frequent (Best Case): If the performance of half of child KPI has High performance and low performance in that situation can use Most Frequent (Best case) for Best performance strategy.

Weighted:  Specifies to use a weighted average based on the weights you have assigned to the child KPIs and objectives.

Indicator types:

1.      Leading – it will indicate the performance of objectives drives the other objectives.
For Example: It drives the value which is higher and gives more performance.

2.      Lagging – It will indicate whether it is affected by the performance of other objectives or other data process.

6.      Go to Actions Tab in right side of the analytics.
Click the  to add the Dashboard or Report or links. An action link dialogue box will get display if the state equals to ok then take the action.
Click the action button to add the contents, options are

Navigate to BI Content – It is used to navigate the link to any of the reports and dashboards.

Navigate to a page – It is used to navigate the link to any of the web sites.

Invoke a web service – It is used to invoke an information and link to some of URL.

Invoke a java method - It is used to invoke java code to link to some other documents.

Invoke a browser script – According to parameters it is used to link to some url through the browser and conditional parameters.

Invoke a HTTP Request – It is used to invoke a request and then it will send it to the http request.
Here I am using “Navigate to BI Content” to have link to Dashboards.
Click on Navigate to BI Content, select the dashboard and click ok.
Give some link text name and click ok.
 
7.      Objectives & KPI’s
Add the KPI’s to this objectives, by clicking objects à Add KPI
            Select the KPI which you had already created and check the prompted values and click ok.

Do the same for all the other KPI’s and check in the Objectives & KPI’s List.
 Once check in the strategy, whether all the Objects are added or not and save it.

Initiatives
Initiatives support objectives and KPI’s tasks. By the time specific conditions it will execute the above created Objectives and KPIs to know about the organization strategy.
An initiative will support more than one objective these are depending on KPI’s.
Initiatives that you create are displayed hierarchically in the "Initiatives pane". The root initiative represents all the initiatives that you implement to achieve objectives and goals. The KPIs that are assigned to an initiative are displayed below the initiative in the Initiatives pane.
Initiative pane which shows the status of the objectives.
It contains the start date, Due Date, Completion date to run the objectives by scheduling time.

Steps to Implement Initiative:

Analytics:
In analytics tab you have the option of scheduling the initiative, Analytics status, Children status, Descendants, actions.
1.      Give the name for the new objective and assign the scheduling time.
2.      Check the status of KPI’s in children tab.
3.      Assign the perspective for the KPI’s, perspective types are discussed above.
4.      Add the action content to have link in the initiatives KPI reports.
5.      Action setup is discussed above already.


Initiatives & KPI’s
1.      Add new KPI’s to the initiative by clicking on objects you will find Add KPI.
2.      Select the location of KPI already saved in the catalog.

3.      Check whether the KPIs are added to initiative and its status

4.      In the Collaboration tab you can add the comments and related documents.

5.      Check the status of initiative on the left side pane whether the KPI’s are added to it.


Score Card Documents:
Score card documents which I used to know the strategy details of organization by various or individual departments.

Objects of score card Documents:
1.      Create New Folder
2.      Create Cause & effect map
3.      Create custom view
4.      Create KPI
5.      Create mission
6.      Create strategy map
7.      Create strategy tree
8.      Create vision
9.      Create KPI watch list

Steps to Implement Score card Documents and Objects:
1.      Create new folder
It is used to create a new folder under that you can add other objects of score card for the individual organizational departments.
On the left side pane go to Score card documents and click on new you will have the list under that select “Create New Folder”.


2.      Create Cause & Effect Map

A cause and effect map also indicates the proportionality (that is, whether changes in performance or value in the cause and effect relationship are directly proportional (direct) or inversely proportional (inverse) and strength (strong, moderate, or weak) of cause & effect relationships using symbols.
A cause & effect map helps you to better understand the implications of future Strategic changes.
On the Left side pane, go to Score card documents and click new and select create cause and effect map icon.

            Drag and drop the KPIs from the catalog.
Right click on the KPI under strategy then click on to see “View Cause and Effect map” then you can see the relationship between the KPI’s.
            Can check the status of Linkage between the strategies, by right click on the link go to edit “Casual Linkage”.
Some of the details or information about the link will get display.
           
Note:
The Link can‘t be done while using “create Cause & Effect Map”. It will be created when “Strategy Map”.

Create Custom view:

It is used to make the strategy in a form of diagram view with hierarchy.
Drag and drop the KPIs from strategy or catalog.
Options under the custom view KPIs are Actions, Add related Strategy nodes, remove from diagram, open, Add comment, override status.

Action Link which is used to link the dashboard, reports, URL from the scorecard.

If you want remove the strategy from the diagram, you can click on “remove from diagram”.

Open is to use for modify or check the status of the KPI.

Add comment is used to give the comment of the KPI diagram.

If the KPI status is in warning or critical you can change the status by using this option “override Status”.

Check the custom view diagram after drag and dropped from catalog.
Save the diagram.
You can zoom in and zoom out the diagram by using the symbol on the top.
Display as: Full- which shows the information about the KPI in a short format.
Simple: only the KPI name and its status will get display
Name which shows only the name of the kpi in the diagram and not even the status.
View types are: Name, Icon, status, trend, value, target, variance, % variance, change, and % change

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)