Search This Blog

Tuesday 25 November 2014

OBIEE IMPORTANT INTERVIEW QUESTIONS

INTERVIEW QUESTIONS

Here are some list of important interview questions that we’ve put together. A comprehensive list of questions to help you get through your first interview. We’ve made sure that the most probable questions asked during interviews are covered in this list.

Question.1) What is logging level? Where can you set logging levels?

AnswerYou can enable logging level for individual users.
We can set the logging level based on the amount of logging you want to do. In normal operations, logging is generally disabled (the logging level is set to 0). If you decide to enable logging, choose a logging level of 1 or 2. These two levels are designed for use by Siebel Analytics Server administrators.
Set Logging Level:
1. In the Administration Tool, select Manage > Security.
2. The Security Manager dialog box appears.
3. Double-click the user’s user ID.
4. The User dialog box appears.
5. Set the logging level by clicking the up or down arrows next to the Logging Level field


Question 2) What is level based metrics?

AnswerLevel based metrics means, having a measure pinned at a certain level of the dimension. A LBM is a metric that is defined for a specific level or intersection of levels.
Monthly Total Sales or Quarterly Sales are the examples.
Ex: if you have a measure called “Dollars”, you can create a “Level Based Measure” called “Yearly Dollars” which is Dollars for a Year. This measure will always return the value for the year even if you drill down to a lower level like quarter, month, etc. To create a level based measure, create a new logical column based on the original measure (like Dollars in the example above). Drag and drop the new logical column to the appropriate level in the Dimension hierarchy in the above example you will drag and drop it to Year in Time Dim.
Question 3) What is object level security?
Answer:There are two types of object level security: Repository level and Web level Repository level: In presentation layer we can set Repository level security by giving permission or deny permission to users/groups to see particular table or column.Web level: this provides security for objects stored in the OBIEE web catalog, such as dashboards, dashboards pages, folder, and reports you can only view the objects for which you are authorized. For example, a mid-level manager may not be granted access to a dashboard containing summary information for an entire department.
Question 4) Define repository in terms of OBIEE?
Answer:  Repository stores the Meta data information. The extension of the repository file is “.rpd”.   With OBIEE Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business models. OBIEE Server can access multiple repositories
Repository is divided into three layer,
1. Physical –    Represents the data Sources
2. Business –   model the Data sources into Facts and Dimension and apply business logic
3. Presentation – Specifies the user’s view of the data rendered in OBIEE answers client
Question 5) If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
Answer: Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.

Question 6) Define repository in terms of OBIEE?

Answer:  Repository stores the Meta data information. The extension of the repository file is “.rpd”. With OBIEE Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business models. OBIEE Server can access multiple repositories
Repository is divided into three layer,
1. Physical –    Represents the data Sources
2. Business –   model the Data sources into Facts and Dimension and apply business logic
3. Presentation – Specifies the user’s view of the data rendered in OBIEE answers client
Question 7) What is connection pool and how many connection pools did you have in your last project?
Answer: Connection pool is needed for every physical database. It contains information about the connection to the database, not the database itself. Can use either shared user accounts or can use pass-through accounts. We can have multiple connection pools for each group to avoid waiting.
Question 8) How do we define the relationship between facts and dimensions in BMM layer?
Answer: Using complex join we can define relationship between facts and dimensions in BMM layer.

Question 9) Can we create any new logical column in BMM layer, how?

Answer: Yes. We can create new logical column in BMM layer.
Example: Right click on fact table> select new logical column>give name for new logical column like Total cost.

Question 10) What are different types of variables? Explain each.

Answer: There are two classes of variables:
1. Repository variables
2. Session variables

Repository variables-
A repository variable persists from the time the repository is started.
Static: This value does not change until a Siebel Analytics Server administrator decides to change it.
Dynamic: The values of these variables change with the values returned by queries. These variables are linked to an initialization block. An initialization block contains a SQL query. When the repository is started the value returned by the query in the initialization block will be assigned to the dynamic variable.

Session Variables-
Session variables are created and assigned a value when each user logs on(when a new session is started). There are two types of session variables:
1. System: System variables have reserved names, which cannot be used for other kinds of variables (such as static or dynamic repository variables, or for non-system session variables).
Ex: To filter a column on the value of the variable LOGLEVEL set the filter to the Variable NQ_SESSION.LOGLEVEL.

2. Non-system: A common use of non-system variables is for setting user filters. Eg: You could define a non-system variable called ‘SalesRegion’ that would be initialized to the name of the user’s sales region. You could then set a security filter for all members of a group that would allow them to see only data pertinent to their region. For example, to filter a column on the value of the variable ‘SalesRegion’ set the filter to the Variable NQ_SESSION.SalesRegion.
Question 11) How do you implement security using External Tables and LDAP?
Answer: Instead of storing user IDs and passwords in a OBIEE Server repository, you can maintain lists of users and their passwords in an external database table and use this table for authentication purposes. The external database table contains user IDs and passwords, and could contain other information, including group membership and display names used for Siebel Analytics Web users.
Instead of storing user IDs and passwords in a OBIEE Server repository, you can have the OBIEE Server pass the user ID and password entered by the user to an LDAP(Lightweight Directory Access Protocol ) server for authentication. The server uses clear text passwords in LDAP authentication. Make sure your LDAP servers are set up to allow this.

Question 12) If we have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?

Answer: Using level base metrics.

Question 13) If we want to create new logical column where will we create (in repository or dashboard). And why?

Answer: It would be better if we create a new logical column in repository because if it is in repository you can use it for any report. If you create new logical column in dashboard then it is going to affect only those reports which are on that dashboard. We cannot use that new logical column for other dashboards.

Question 14) What is Authentication? How many types of authentication do we have in OBIEE?

Answer: Authentication is the process by which a system verifies a user with the help of a user ID and password. It checks if user has the necessary permissions and authorizations to log in and access data. There are 4 main types of Authentication in OBIEE:
  • Operating system authentication
  •  External table authentication
  •  Database authentication
  •  LDAP authentication
Question 15) What is the difference between Data Level Security and Object Level Security?

Answer: Data level security controls the type and amount of data that you can see in a report. Object level security provides security for objects stored in the OBIEE web catalog like dashboards, dashboards pages, folder and reports.

Question 16) Can you migrate the presentation layer to a different server.

Answer: No, we cannot migrate only one particular layer to another server, we have to migrate the complete repository or the web catalog.

Question 17) How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?

Answer 
Dimension tables contain descriptions that data analysts use as they query the database. Ex: the Product table contains product packaging information; and the Period table contains month, quarter, and year values. The tables which contain numeric values used for calculations are used as Fact tables.

Question 18) Why do we have multiple LTS in BMM layer? What is the purpose?

Answer To improve the performance and query response time.

These are just some of the important questions that can be asked to test your BI skills. To learn more, join OBIEE 11g training on WizIQ. Learn from the experts!

Monday 17 November 2014

Why do you need to learn OBIEE?

Being in a business, you must have come across difficulties in decision making based on incomplete or inaccurate, inability to efficiently monitor critical performance indicators of business and spot trends and exceptions???

Then, Oracle Business Intelligence Enterprise Edition (OBIEE) can provide a solution to these challenges. 

How ?? Because it is highly instinctive and quite interactive web user interface bringing the most powerful and unique sets of information from multiple sources to you.

It includes all the ranges of Business Intelligence(BI) capabilities, including dashboards, ad-hoc analysis, proactive detection and alerts, intelligent work flow, MS Office integration, real time predictive analysis and more.

You can go through the summarize list of how OBIEE can really make your business productive.

  • Reduce cost and increase productivity with a common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad hoc analysis, and OLAP analysis.
  • Provide better alignment and visibility across the organization by ensuring that all metrics, calculations and definitions are uniformly consistent
  • Integrate with all popular extraction, transformation and load tools, databases, business applications, application servers, security tools, enterprise portals, and desktop tools
  • Optimize performance while simplifying systems configuration and life cycle management. An integrated systems management console provides superior scalability, high availability, and security benefits, while making upgrades and systems management effortless

So whether you are struggling in  making decisions in your business or looking forward to get into BI field, you must not wait in picking up OBIEE because it has lot to offer to you as well as to your business. 

Well if you scratch the web, there are various sources such as blogs, videos and even Wikipedia to get you started.Before starting, get aware of all the terminologies, Brush up your modelling capabilities, speed up your dimensional modelling.

Besides that, there are numerous courses available online, where you can always go and learn extensively with highly qualified instructors. You can look for courses on Udemy but they will be mostly video courses. If you are looking forward to 1-1 live OBIEE training sessions, you can look for the one at WIZIQ! Click here

Hope it helps you!

Post comments for any confusions! 












Tuesday 25 March 2014

Best Training for English Language Teaching Development

http://www.wiziq.com/course/48082-english-language-teaching-elt-development-by-mau-buchler
ELT Training is designed to enhance your effectiveness as an English teacher to creatively understand and deliver language lessons to young learners in the classroom. This course takes you on a fascinating exploration of being an online and offline teacher some of which includes-how to understand your students and their needs, choose the most appropriate activities to involve learners.

In this course, you will be given assignments that are going to be discussed on G+ Hangouts with other well known English language entrepreneurs. Each week you will be given text-based materials, discussions and videos to prepare for the next class and the most relevant topics will be discussed. Recording of the live classes will be made available if you by chance miss any class.

Course Outline
  •     WEEK 1: Discussing English speaking cultures
  •     WEEK 2: Teaching idiomatic language
  •     WEEK 3: Explaining advanced grammar and vocabulary
Course Highlights
  •     3 live online classes by an extremely versatile instructor
  •     Enhance your effectiveness as an English teacher
  •     Assignments and discussions with other English language entrepreneurs
  •     Suitable for new and experienced English teachers of all ages
  •     Understand your students and their needs
Enroll Now at:- English Language Teaching (ELT) Development

Monday 3 March 2014

Best Way to Become Fluent in English

http://www.wiziq.com/course/49070-how-to-finally-become-fluent-in-english
Many have said that the English language is one of the difficult to learn. However, with the right way or teaching, learning English as a second language can be a easy, fun and positive experience.One mistake that people often make is putting in effort to study grammar rather than conversational English. In order to become a Fluent in English, remember to focus on actual Conversation rather than just memorizing grammar. Help is in your hand .  Here is online Course which helps you to become fluent in English.

This Course show you exactly what you need to do to make fast progress and achieve your dream of being able to speak English freely and  this will also show you the best methods and techniques so that you are doing the right things to become fluent.Don’t miss this opportunity to learn English and become fluent in English. Anyone can achieve this Success, and this course will show you how.

Course Package:
  • 5 Live interactive online classes and 1 Class per week spread over 5 weeks.
  • Wednesday's at 6 PM GMT
  • Presentations ,Educational videos,& PDF documents for each lesson.
  • Tasks / assignments will assigned to you.
  • Lifetime access to course content and class recordings

Course Highlights
  • This course will show you How to become fluent in English
  • Learn how to approach learning English so you make fast progress
  • Learn the best methods so you focus on doing the right things
  • Free downloads and all the resources you need
  • Weekly challenges and tutor feedback

Learn American English Pronunciation