Datawarehouse Architect

What are the Physical Layer Objects 1. Database 2. Connection pool 3. Schema folder 4. Tables 5. Columns 6. Keys Screen shots for your reference Physical Layer Objects in OBIEE 11g

1. A common use of alias is to use the table or column to play simultaneously for several times. 2. A single dimension appears more than one time for more purpose. 3. OBIEE does not support Circular join in BMM layer, so we can overcome from this problem by creating alias table for one of the table in that circular join. 4. OBIEE does not support self join, so we can overcome from this problem by creating alias table. 5. If a fact table having relationship with dimension table on more than one key, then we can create aliases for the dimension table, then we can join fact table to these alias table on different keys. Steps: 1. Right click on the Physical layer of the table, New objectà Alias. 2. Give the name of the alias , automatically it assigns the columns of the physical table  3. Even it inherits all the properties of the physical table. Screen shots for your reference: Create a...

DSN – Data Source Name, the name which suggests connecting or relates the database. Steps to Create DSN: 1. Open control panel and go to Administrative toolsà ODBC Administrator. 2. Go to the second tab “system DSN”. 3. Click on Add and select the driver of the database which you are using currently. 4. Give the Credentials first assign name for the Data Source Name. 5. Give the TNS entry to connect the data source. 6. Database User name and then click test connection. 7. Give the credentials in test connection, user name and password of data base. 8. Check the connection is success or not if yes then click ok. Screen shots for you reference: DSN for OBIEE 11g DSN for OBIEE 11g DSN for OBIEE 11g DSN for OBIEE 11g

Select the Shared logon check box if you want all users whose queries use the connection pool to access the underlying database using the same user name and password which given in the connection pool. If this option is selected, then all connections to the database that use the user name and password specified in the connection pool, even if the user has specified a database user name and password in the DSN (or in user configuration). If this option is not selected, connections through the connection pool use the database user ID and password specified in the DSN or in the user profile. Screen shots for your reference: Shared Log On option in OBIEE 11g

1. Go to the location D:\11G\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1 2. and find the NQSConfig.INI file, move down to the section “Query Result Cache Section” Enable =yes. 3. Login to Console ( http://localhost:7001/EM ) 4. Go to Business Intelligence -> Core Application -> Select Capacity Management tab -> Select Performance tab below capacity management tab -> Click 'Lock and Edit Configuration' -> Deselect the 'Cache enabled' option -> Click Apply -> After that Click 'Activate Changes' 5. Restart the services. Screen shots for your reference: Cache in OBIEE 11g Cache in OBIEE 11g

Connection pool is defined as the connection between the data source and Oracle bi server. Connecting database using the interface like OCI, odbc, etc. to the Admin tool RPD to serve the information of data. Screen shots for Your Reference:

1. Relationship between the logical tables was expressed by logical joins in BMM layer. 2. Logical joins express the cardinality relationships between logical tables and are a requirement for a valid business model.  3. Specifying the logical table joins is required so that Oracle BI Server can have the necessary metadata to translate logical requests against the business model into SQL queries against the physical data sources. Logical joins help Oracle BI Server understand the relationships between the various pieces of the business model.  4. When a query is sent to Oracle BI Server, the server figures out how to construct physical queries by examining how the logical model is structured.  5. Examining logical joins is an integral part of this process.  6. The Administration Tool considers a table to be a logical fact table if it is at the “many” end of all logical joins that connect it to other logical...