Wednesday, September 28, 2011

MUD

MUD:
Multi User Development (MUD) environment is a feature of OBIEE Administration tool which permits multiple users to modify a single repository simultaneously and then check in changes. The repository here refers as the master repository. This supports concurrent development.
The master repository is created in a shared directory. The concept of MUD is to create different projects and assigned them to different users. Each of these projects can contain multiple fact and dimension tables.


To work in a MUD, the Client machines (Users) should have access to the master repository. The steps for working in a MUD are illustrated in the above diagram. There are some tips and best practices which should be followed while working in a MUD.
Removing # Copies:
When a column is renamed or modified and then dragged into the presentation layer, a #1 copy of the column is created in the presentation layer. Because while merging into the master repository the merge process gets the older column and then appends #1 with the newer column in order to differentiate.
To avoid such issues, the following steps should be followed.
1.
Make changes in your local rpd and test whether changes are getting reflected in Answers

2.
Save the local rpd.
3.
Checkout the master rpd (Go to Administration -> File -> Multiuser -> Checkout).
4.
Select your project.
5.
Save the subset of master repository with some name.
6.
Remove all objects from Physical layer, BMM layer and Presentation layer.
7.
Go to Manage-> Variable; Remove all the initialization blocks, repository and session variables.
8.
Save the blank repository.
9.
Go to File-> Multiuser->Merge local changes->Merge.
10.
Go to File-> Multiuser->Publish to Network.
11.
Again checkout the master rpd (follow steps 3 to 5).
12.
Copy all the physical layer, BMM layer and Presentation layer objects, all the variables and initialization block from the local rpd to the blank rpd.
13.
Go to Manage-> Projects-> Add the catalogs.
14.
Go to File-> Multiuser->Merge local changes->Merge.
15.
Check all the changes in the master repository.
16.
Go to File-> Multiuser->Publish to Network.
Another way is to check for the # copies manually before publishing to network.
OBIEE Repository and Catalog Change Tracker:
While working in MUD, it is a best practice to update a tracker which keeps track of the rpd and catalog change details. While changing the rpd we should always take the back up of the previous rpd for our future use. For this, a tracker can be used to keep track of the updates which are being done on the rpd and catalog. If in the future we want to revert back to the previous design, then the task will be just to merge the backup copy.
So every time we deploy our rpd and catalog to another environment or we update anything on the current design, we should update the tracker.
Benefits:
1. Track the changes that we are doing on rpd and answers.
2. Locations of the back up rpd (old rpd), archived file for catalog (old catalog) can be
stored in a single document.
3. Track the status of changes in the new environment.
4. Track the dates on which rpd /catalogs are merged in different environments and many more.

Tuesday, September 27, 2011

Features of OBIEE

Introduction to Obiee

Obiee first Designed by NQ software Later Siebel buied and Named as Obiee and later Oracle buied the siebel product and Done many modifications and renames as OBIEE in 2007

FAQS on Answer and Dashboards

Faqs on Answers and Dashboard
  1. What is Subject Area
  2. How many Subject Areas are there in you project
  3. If suppose i need to combine two subject area table columns how do you do  them
  4. What are the services to run the Presentation service
  5. What are the logging levels
  6. What is the full form of 0c4j
  7. How do you do the Object level security and column level security
  8. why do use the byepass
  9. Explain about pivot table
  10. What charts you have done in the project
  11. How can you hide the Dashboard
  12. What is rightback option
  13. How can you edit the column in report
  14. How can you find the rank on the report
  15. How can you increase the performance of the report
  16. What is difference between pagelevel prompt and dashboard prompt
  17. How to pass parameters in report
  18. Guided navigation in Obiee
  19. Narrativeview and normal view
  20. what is the columns selector
  21. Have you worked on Map
  22. Have you worked on bipublisher
  23. what is bidelivers
  24. how to find top ten products rank

Interview Qesions

Obiee Faqs On Repository Side:
  1. Explain about three Layers
  2. About alias tables
  3. About types of joins
  4. Does Obiee Support Ciruclar Joins
  5. What is Bridge table
  6. About Fragmentations
  7. What is Lts and Mts
  8. What is Implicit Fact
  9. Whati is Opaqueview
  10. What is ConnectionPool
  11. What is shared logon
  12. How many Connection pool are there in you current project
  13. What is dimensional hierarchy
  14. What is Ragged hierarchy
  15. How do you do level based metrices
  16. What is Chronological Key ?When do u create Chronological key
  17. What are Dimensional Tables and Fact Tables in you Project
  18. Can you able to join Fact and Fact ?how do u join them
  19. Questions on Repository variabale and sessionvariable
  20. Types of Repository variables and Session Variables
  21. How do you create the Security and what types of security are in the obiee
  22. How do u manage Cache
  23. What is MUDE ?
  24. Type of Creating Measures
  25. What is Presentation Layer
  26. What things can be done in Aggregation BMM layer