What is Obiee interview questions?
Basic Interview Questions
- Compare OBIEE & Tableau.
- Explain the Architecture of OBIEE 11g and function of each components?
- How we can extract sql from OBIEE for reports?
- How can you sort in Reports in OBIEE 11g?
- How we can do different types of narrative Reports in OBIEE?
- How will you create Interactive Dashboards?
What is the role of Obiee developer?
The role of an OBIEE Developer involves making use of OBIEE technology to help organizations collect, refine, and manage data from various sources that are crucial to important decision making. The developer must understand the context in which the business operates and the overall business requirements.
What are the key issues in Obiee?
Key Pain Points of OBIEE Users
- Poor analysis performance.
- Using analytical tool as reporting tool.
- No data quality processes.
- Has no reliable source of historical data.
- Time consuming ETL process.
- Manual, error-prone processes.
- No single source of truth for data.
- No clear road map for BI implementation.
How does Obiee architecture work?
How OBIEE System Actually Works? The initial request from the end user is sent to the Presentation server. The Presentation server converts this request in logical SQL and forwards it to BI server component. BI server converts this into physical SQL and sends it to database to get the required result.
What is implicit fact column in Obiee?
To guide OBIEE in the best choice, you need to select a fact attribute (measure) as an implicit fact column. The implicit fact column is used for queries that only select dimension attributes (no facts) from two or more dimensions.
What is writeback in Obiee?
“Writeback” – presenting an Answers interface so that users can update data in database tables or insert new rows – first appeared in version 7.8. 4. To use OBIEE’s writeback capabilities, there are several set up steps.
What is the full form of Obiee?
Oracle Business Intelligence Suite, Enterprise Edition (OBIEE) is an innovative and comprehensive BI platform that delivers the full range of BI capabilities on a next-generation architecture designed for true enterprise deployment.
How do I increase my performance in Obiee?
12 OBIEE Performance Tips You Need to Know
- There Are No “Magic Buttons”
- Activate OBIEE Usage Tracking.
- Don’t Disable Logging.
- Don’t Use OBIEE as a Data Extraction or Data Dump Tool.
- Export to CSV Instead of Excel.
- Push Complex Queries Down to the Database.
- Perform User Interviews.
- Search Usage Tracking for Points of Interest.
Why is Obiee so slow?
Why is OBIEE slow? A1: You can see from nqquery. log on the BI Server how long the SQL takes on the database, so you don’t necessarily need to run it manually. Bear in mind the network between your BI Server and the database, and also the user ID that the query is being executed as.