Datawarehouse Architect

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

To create a database 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.. To change the collation of the database, select the Options page, and then select a collation from the list. To change the recovery model, select the Options page and select a recovery mo

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 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 tha

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