Ans: We can give a column as updatable and then view the reports, this option is called write-back option.
Ans: By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.
Ans: From the Criteria Pane of the Report Created from First Subject Area come to the bottom of the page and click combine request. By this, we can create reports from two subject areas.
Ans: For the RPD we can use the Merge option in Admin Tool and for dashboards and reports we can use the Content Accelerator Framework.
Interested in mastering OBIEE Training? Enroll now for a FREE demo on "OBIEE Training".
Ans: There are two types of variables in OBIEE 11g. a. Repository variable: This variable is used for the whole repository. b. Session variable: session variable is of two types: system variable and nonsystem variable. The system variable uses NQ_SESSION. Examples of nonsystem variables are user-defined filters.
Ans: OBIEE Comprises Presentation Services, Oracle BI Server: The user constructs SQL and passes it to the Analytic Engine, and then the Oracle BI (Analytic Engine) describes the physical sql to the Datasources and recover the data back to the Engine and presents to the presentation Services.
Ans: There are many ways to extract the SQL: a. Change the request and click Advanced in that you get XML code and also the actual SQL. b. In the catalog, the Manager clicks Tools-Create Report. In the Create Report Window –> Click Request SQL and save the SQL to the physical path in your PC. c. Enable Log level to 2 in the OBIEE 11g Administration Tool from Manage-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs. You will find the SQL for that User. d. By clicking Administration->Manage sessions-> view SQL.
Ans: Click on modify and then click on the sort (order by the icon) on the relevant column in the criteria pane.
Ans: By clicking modify the request and Narrative View and by giving @1 for the first column result and @2 for the 2nd column and so on and we can also give a heading for No Results by clicking the Narrative view.
Ans: In the NQSConfig.ini file use ENABLE under CACHE Section for System Level. For tables, if we want to enable the cache at table level, open the repository in offline mode This should be different from the current repository and click enable or disable the cache.
Ans: Check if the table is already existing if so add in the physical layer, then click on BMM and then the Presentation layer, then reload server metadata, then it will be visible to all users.
Ans: Using session variables for that user.
Ans: A table alias is used for creating self-joins. Table alias can be created by right-clicking the table in the physical layer then click alias.
Ans: Yes, we can create a hierarchy in the BMM Layer of OBIEE in dimensions for the dimension tables. This can be done by right-clicking the dimension table and click create dimension and then we can manually define the hierarchy and its levels.
Ans: Level-base metrics means, having a measure held at a certain level of the dimension. Examples Monthly Total Sales or Quarterly Sales To create a level based measure, create a new logical column based on the original measure. Drag and drop the new logical column to the appropriate level in the Dimension hierarchy.
Ans: The different layers of the OBIEE 11g Repository are:
Ans: Authentication is the procedure by which a system confirms, through the use of a user a. Operating system authentication b. External table authentication c. Database authentication d. LDAP authentication
Ans: If we want to connect two tables where there is no relationship we can use a thrived bridge table for connecting them which will have the same columns in both tables.
Ans: Using Scheduler – ibots we can generate a time-based triggered report.
Ans: 1. Complex Join –it uses multiple conditions, such as A.ROW_WID = B.ROW_WID AND / OR A.A_WID = B.B_WID 2. Natural Join
Ans: Using confirmed dimensions, we can fetch many metrics across various facts, but the join should be of the same level of data detail.
Ans: Shared Folders-XYZ Folder- It has two folders a. Prompts b. Reports
Ans: By clicking on the cancel button, we can stop an exact report placed on the dashboard.
A surrogate key is an artificially generated key, usually a number. A surrogate key, in the level aggregate table, simplifies this join and removes unnecessary columns from the fact table, resulting in a smaller-sized fact table.
Ans: 1.Repository stores the Metadata information. Siebel repository is a file system, extension of the repository file. rpd. METADATA REPOSITORY
2.With Siebel Analytics Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity are stored in metadata repositories.
3. Every metadata repository can store many business models. Siebel Analytics Server can access many repositories.
Ans: Siebel Analytics life cycle 1. Collect Business Requirements 2. Recognize source systems 3. Plan ETL to load to a DW if source data doesn’t exist. 4. Build a repository 5. Build a dashboard or use answers for reporting. 6. Define security 7. Based on performance, decide aggregations and/or caching mechanism. 8. Testing and QA.
Ans: There are five parts of Siebel Architecture.
1. Clients 2. data sources 3. Siebel analytics Web Server data sources 4. Siebel analytics scheduler 5. Siebel analytics server Metadata represents the analytical Model which is created using the Siebel Analytics Administration Tool. The repository divided into three layers 1. Physical – Signifies the data Sources 2. Business – copies the Data sources into Facts And Dimension 3. Presentation – Specifies the user's view of the model; rendered in Siebel's answer.
Ans: In the BMM layer, we can create one logical table (fact) and add the 3 fact table as a logical table source.
Ans: A connection pool is needed for each and every physical database. It contains material about the connection to the database, not the database itself. We can use either shared user accounts or pass-through accounts -Use: USER and PASSWORD for pass through. We can have many connection pools for each group to avoid waiting
Ans: Java Development Kit (JDK), is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.
Ans: An opaque view is a physical layer table that contains a select statement. An opaque view should be used only if there is no other option.
Ans: No, we can't migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files
Ans: Dimension tables contain descriptions about data analysts which is used as a query in the database. Every table contains a primary key that contains one or more columns; each row in a table is uniquely identified by its primary-key value or values
Ans: To improve the performance and query response time we have multiple LTS in BMM.
Ans: There is no full form for rpd as such, it is just a repository file which is known as Rapid file Database.
Ans: We can disable cache in the physical layer, by right-clicking on the table there we can have the option which defines cacheable
Ans: We have to make a dubbed table in the physical layer.
Ans: TCP/IP type protocol.
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox