Building Views

Building Views:

1) How many views are there in OBIEE 11g?

A) Mainly there are 22.

2) How can we integrate the views?

A) In compound layout.

3) What are default views?

A) Title and table.

a. Name of the report and logo of the event can be displayed in title.

4) What are the newly added features of table in OBIEE 11G?

A) Table prompts, sections, excluded.

a. We can calculate subtotal, grand total, alternate row colors, maximum number of rows per page.

1. In 11.1.7.1 the options that are newly introduced are

a. Fixed header with scrolling content.

b. Include rows with only null values.

5) Which provides the opportunity to rotate rows, columns and section headings to provide different perspective of the same data?

A) Pivot table.

6) How many parts are available in pivot table and what are they?

A) Six parts are available and they are:

1. Pivot table prompt.

2. Sections.

3. Excluded.

4. Rows.

5. Columns.

6. Measures.

a. 3D format of data is called as pivot table.

b. Duplicate layer can be added in pivot table.

7) What is a Graph?

A) GRAPH is used to understand by any language and illiterate people.

8) How can we compare one dimension with one measure?

A) With the help of gauge chart and it is nothing but speedometer.

9) How can we compare one dimension with two measures?

A) Funnel chart.

a. The two measures should be like actual vs target.

10) Criteria filter conditions can be captured automatically with the help of?

A) Filter.

11) What are selection steps in OBIEE?

A) Selection steps is useful to do row-wise calculations.

a. We can also create filter conditions by using this Selection steps.

b. It is a new feature in OBIEE11.1.1.6.

12) What view is useful to select the columns dynamically?

A) Column selector.

a. It affects all the views in the compound layout.

13) What view is useful to select the views dynamically?

A) View selector.

a. It is useful to integrate the other views.

14) Which view is useful to decode the color coding?

A) Legend.

15) Which view is required to design the paragraph reports?

A) Narrative.

EX: To capture the data refresh date automatically.

16) Which view is used to scroll information in the report?

A) Ticker.

17) Which view is helpful to provide comments in the report?

A) Static Text.

18) What is meant by Logical sql in OBIEE?

A) It is only for sql developer, business user cannot control the logical sql.

19) What is ‘No result’ view in OBIEE?

A) It is useful to display some custom message when ever report failed to show a result.

Advanced Features Of Analysis

Advanced Features Of Analysis:

1.What are set Operators?

A)There are four types of set operators.They are:

a. Union

b. Union all

c. Intersect

d. Minus

2.What are the requirements to work with set operators in OBIEE11G?

A)No of columns in two criteria/Requests must be same

a. Corresponding data types must be same.

3.Why we use set operators in OBIEE11G?

A)To develop a report from different criteria’s which are coming from different subject area or same subject area.

4.What is direct database request?

A)Executing a report directly from database is called as Direct Database Request(DDR).

5.What are the disadvantages in using DDR?

A)RPD/Oracle BI server security (Object and Data)rules will not be applicable.

a. Performance.

b. Need SQL experts to develop these reports.

6.What reports can be made using DDR?

A)General and simple reports can be developed using DDR.

7.What privileges should be given to develop DDR report ?

A)EDIT Direct Database Request.

a. EXECUTE Direct Database request in RPD and WEBCATALOG.

8.What is the condition to be maintained while we are developing report from two different criteria’s which may or may not be from same or different subject area?

A)Subject area’s must be build from same business model.

9.What is the functionality of UNION and UNION ALL on duplicates?

A)UNION will not allow duplicates but UNION ALL will allow duplicates.

Upgrade or Migration

Upgrade or Migration:

1.What is upgrade assistant?

A)Upgrade assistant is a wizard useful to migrate from OBI 10G to 11G.

2.What does the upgrade assistant migrates?

A)Upgrade assistant wizard migrates following:

RPD

RPD users and groups into WLS LDAP

Presentation services web catalog

Scheduler Schema

BI publisher Repository

BI Publisher Scheduler Schema.

3.what objects does the Upgrade Assistant wizard cannot migrate?

A) 3. Upgrade Assistant wizard cannot migrate

1. Configuration files

2. Custom style sheets

3. JavaScript

4. Logos

4.What batch file should we click to migrate the RPD from lower version to higher version?

A)UA.BAT is the file which is useful in migrating or upgrading the RPD from lower versions to higher versions.

5.What is the best practice  order to stop the Oracle servers?

A)The best order to stop the servers of Oracle are:

BI presentation server

BI Scheduler

BI Java host

BI Server

6.What is the best practice order to start the Oracle servers?

A)The best practice order to start the Oracle servers are:

BI Server

BI Presentation server

BI Java host

BI Scheduler   

Deployment

Deployment:

1.what is Deployment or migration?

A)Copying RPD or web catalog from one environment to another environment is called as deployment.

2.What are Deployment Components?

A)Two Deployment Components.Those are

1)RPD.

2)Web Catlog.

3.How many steps RPD Deployment?

A)Seven steps of RPD Deployment those are.

1) Tack backup of RPD from source and target environments

2) Stop target environment oracle BI server

3) Copy RPD from source repository folder and paste in target repository folder

4) Configure EM by pointing to new RPD

5) Start target environment oracle BI server

6) Reload Server meta data from Analytics web page.

7) Change Connection Pool Database name ,username and passwords .

Note : to access dev server box to test server box ,in dev server go to run type

\\<Test Server name>\C$

4.How many steps WEB Catalog Deployment

A)Two steps of web catalog deployment those are.

 1) First time deployment   

i. type: online.

ii. URL: http://localhost:7001/analysis/saw.dll?

iii. UN: web logic

iv. Password: RRitec123

v. Similarly open another instance of catalog manager in online mode.

vi. Copy & paste.

 2) Second time on wards deployment

   

          i.      Backup of source and target catalog

     ii.            Use catalog manager to deploy partially

5.What is catalog manager?

A)It is a window based client using catalog manager we can deploy web catalog

6.What are advantages of catalog manager?

A)

1. Deployment as per above.

2. Back up of web catalog.

3. Permissions.

4. Web catalog documentation

Action Links

Action links:

1.What is the use of ACTION LINKS?

A) THESE ARE USEFUL TO NAVIGATE FROM OBI REPORT TO

1.Another OBI report/Dashboard.

2.Any webpage.

3.EBS system.

4.Web service.

5.Java method.

6.Browser script.

7.HTTP request.

2.What is the difference between drill through and drill across?

A) Drill through is when navigating from one report to another report

Drill across is when navigating from one level of one hierarchy to another level in another hierarchy.

3.Can we create ‘n’ no of child reports and link them to master report via action link?

A)Yes,we can link ‘n’ no of child reports and link them to master report via action link.

4.Can we reuse a action link?

A)Yes,we can resuse a action link in many reports with the help of reusable action link.

Key Performance Indicator:

1.How KPI’s are defined?

A)KPI’s are defined using analytics webpage.

2.What are the requirements for a KPI?

A) KPI'S requires measures like actual and targets and also it requires THRESHOLD CONDITIONS to define good or bad performance.

3.Can KPI be dimensionalized?

A)Yes,KPI can be dimensionalized.

For eg:

1.Time wise KPI.

2.Product wise KPI.

3.Customer wise KPI.

4.What is a KPI watch list?

A)It allow user to gather KPI’s for monitoring.

Can include multiple copies of same KPI with different pinning.

Point of view can be altered to analyze via dimensions.

actions can be created.

KPI’s can be launched as analysis,comments can be added.

5.What is a score card?

A)These are useful to organize KPI’s into hierarchy or strategies.

Select Reports Dynamic using Dashboard Prompt

1. Select Reports Dynamic using Dashboard Prompt .

Step1: Develop a report R1

Step1: Log on to analytics page

Step2: Go to new then analysis and in criteria column drag and drop Region, Sales District and Dollars

Step3: Click on results and then save the report as R1

Step2:Develop a report R2

Similarly develop a report with columns Region, Address and Dollars and save it as R2

Step3: Go New then click on Dashboard prompt -→click on + (new)→Variable Prompt

→Provide the name as user_selected_report→user input as choice list then click on + symbol

→add R1,R2→click on ok and save it

Step4: Create a new dashboard with the name report choice list-→Drag and drop dashboard prompt,R1 and R2 into the work area→save it→run it

Step5: Initially reports will not follow the prompt

Step6 : For this go to R1→click on section properties

→click on filter symbol

→Condition

→ Browse R1→click on ok→click on ok

Step7: Now go to R1(report properties)(XYZ symbol)

→Edit Analysis→go to criteria→Click on filter option of first column→enable the option convert this filter to sql

→Provide below expression ‘@{user_selected_report}’=’R1’

Then click on ok

Step8: similarly follow step6 and step7 for report R2 also

Step9: save the dashboard and run it

Step10: Observe the output

OBIEE 12C Configuration

1.  OBIEE 12C Installation Part 6
   
   
   
   

   STEP 1 : Microsoft Loop Back Adatptor

   STEP 2 :  Oracle Database 11G

   STEP 3 :  JDK

   STEP 4 :  Web Logic Server Installation
   STEP 5  : OBIEE 12C Installation
   STEP 6  : OBIEE 12C Configuration
   
   
   

OBIEE 12C Installation

 

OBIEE 12C Installation part 5

STEP 1 : Microsoft Loop Back Adatptor

STEP 2 :  Oracle Database 11G

STEP 3 :  JDK

STEP 4 :  Web Logic Server Installation
STEP 5  : OBIEE 12C Installation
STEP 6  : OBIEE 12C Configuration

1. 
   
    
   
   

Web Logic Server Installation

1. 
   OBIEE 12C Installation Part 4
   
   
   
   

   STEP 1 : Microsoft Loop Back Adatptor

   STEP 2 :  Oracle Database 11G

   STEP 3 :  JDK

   STEP 4 :  Web Logic Server Installation
   STEP 5  : OBIEE 12C Installation
   STEP 6  : OBIEE 12C Configuration
   
   
   
   
   

OBIEE 12C JDK 8 Installation

1. OBIEE 12C Installation Part 3
   
   
   
   STEP 1 : Microsoft Loop Back Adatptor
   STEP 2 :  Oracle Database 11G
   STEP 3 :  JDK
   STEP 4 :  Web Logic Server Installation
   STEP 5  : OBIEE 12C Installation
   STEP 6  : OBIEE 12C Configuration