Sunday 18 January 2015

Database EVALUATE Functions

Database Functions
Developers can create requests by directly calling database functions from either Oracle BI Answers or RPD. Key uses for these functions include the ability to pass through expressions to get advanced calculations, as well as the ability to access custom written functions or procedures on the underlying database
1.       EVALUATE
2.       EVALUATE_ANALYTIC
3.       EVALUATE_AGGR
4.       EVALUATE_PREDICATE
Exercise 4:  Find first space position in Name column of customer
1.    Create a logical column in RPD with the name of Name_Space_Position
2.    Develop below formula à drag and drop into presentation layer
 
3.    Develop a report as shown and observe output

Wednesday 7 January 2015

SAMPLE INTERVIEWS

Sample Interview 1:'
  1. In your previous project, what were your sources?
    1. we can tell 
      1. oracle apps
      2. siebel
      3. Peoplesoft
      4. Jdedwards
      5. Mainframes ..etc
  2. Have you ever worked with MySequel or Essbase sources?
    1. you can tell yes or no
  3. If you have 1 fact and 4 dimension, which table would you import first?
    1. Anything we can import
    2. If we are loading data using ETL then first we need to load dimension tables then fact tables 
  4. If you have two fact, can you join fact to fact.
    1. No .if we join fact to fact we wont get star schemas hence we can not define content logical level
  5. In the logical layer, the logical join, what is the cardinality?
    1. It tells how the tables are related ,based on this obiee understands fact and dimension tables 
  6. How do you use the chronological key
    1. In case time based hierarchies it will do calculations based on this key
    2. example : month level 12 +1 =1 and day level 31+1=1
  7. Cache management?
    1. Please refer class room notes

  8. Have you used IBot?
    1. IBOTS and AGENTS are same ,please refer class room notes 
  9. Have you ever installed and what environment?
    1. you can tell yes or no .but if you say YES you need to aware of LINUX /windows server installation process
    2. http://rritec.blogspot.in/2014/09/obia-111181-installation.html
  10. Have you ever did configurations on a linux environment?
    1. Yes or NO .if you say YES then need to answer steps of configuration
  11. Say that you have a report that is running for long hour, let's say 20 minutes, how do you debug it?
    1. we will take SQL query of the report and as for the query we will apply aggregat tables /cache/hints/partition/log level/index creation..etc
  12. What kind of security do you use?
    1. LDAP
    2. External table
  13. where you involved in code migration from one environment to another?
    1. Yes .refer classroom notes deployment chapter
  14. Say you developed a code, how do you migrate the code changes to production?
    1. using Catalog manger for more info refer deployment chapter
  15. Can you give me a brief background of your obiee experience.
    1. Refer project video of mine
  16. Can you explain to me about your previous project?
    1. Refer project video of mine