1 / 25

OBIEE introduction & Building Reports by QuontraSolutions

hi, we offer online IT training with placements, project assistance in different platforms with real time industry consultants to provide quality training for all it professionals, corporate clients and students etc. OBIEE online training by quontrasolutions. we are providing excellent OBIEE training by real-time IT industry experts. Our training methodology is very unique our course content covers all the in-depth critical scenarios. We have completed more than 200 OBIEE training batches through online training program. Our OBIEE classes covers all the real time scenarios, and its completely on hands-on for each and every session. Course content: • basics of data warehousing concepts • OBIEE concepts and overview • Oracle Business Intelligence (OBIEE) • Using Administration Tool and Creating Repository • Using Answers and Creating Interactive Dashboards • advanced OBIEE concepts Please Visit us for the Demo Classes, we have regular batches and weekend batches. Other Courses we offered: MICROSOFT: ADO .NET, ASP .NET, C# .NET, MSBI, SharePoint, Vb .NET PROGRAMMING: Core Java, Advanced Java, J2EE, Hibernates, Strutus, Java Scripting, Perl Scripting, Shell Scripting, springs, Ruby on Rails Mobile Apps: Android, IOS Training, Cloud Computing, Networking : Unix Admin, Sun Solaris, CCNA Testing Tools: Manual Testing, QTP, Selenium Sales force CRM: SalesForce Developer, SalesForce Administrator BUSINESS ANALYST, HADOOP DATABASE: SQL/PL-SQL Data warehouse : cognos, Informatica, OBIEE, QlikView If you are interested in taking any of the training please contact us: QUONTRA SOLUTIONS 204-226 Imperial Drive, Rayners Lane, Harrow- HA2 7HH. Email: info@quontrasolutions.co.uk Web: http://www.quontrasolutions.co.uk Phone : 44(0) 20 3734 1498 / 99

quontrasolutionsuk
Télécharger la présentation

OBIEE introduction & Building Reports by QuontraSolutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Business Intelligence Introduction & Building Reports By Quontra Solutions Email : info@quontrasolutions.co.uk Contact : 020-3734-1498 WebSite : www.quontrasolutions.co.uk

  2. AGENDA • About Oracle BI EE • Components of Oracle BI EE • Answers • Interactive Dashboard

  3. Introduction To Oracle BI EE • Business intelligence is a group of processes and technologies that transform the transactional data into valuable knowledge. • Enables business users to make correct decisions. • Improves the productivity of their enterprises, especially in the markets where there is huge competition. • In past days, business intelligence was related to only historical data. But now, real-time reporting is one of the most important requirements. Before, there were many reporting tools that were part of transactional applications. They were used to generate operational reports. But now, as you will imagine, there are many applications that are based on different technologies in an enterprise and a unified reporting solution is an important requirement.

  4. Introduction To Oracle BI EE • Analytical tool used to help users to view and analyze data. • Provide metrics to measure the state of the data • Presents Key indicators of changes in the market trends etc.

  5. Advantages of Oracle BI EE • Simple User Manipulation. • No deep Technical skills required. • Robust Customizations. • Multilanguage reports can be created with • data.

  6. Architecture of Oracle BI EE OO Oracle Repository SAP Presentation Services BI Server Siebel Client BI Scheduler Data Source Data Source

  7. Oracle BI Components • Oracle BI Client: • Web based User Interface. • Allows the users to create Answers or reports and • view them. • Allows the users to add the reports to the dashboard. • Oracle BI Presentation Services: • Business intelligence data to the clients through web browsers. • Communicates with the BI server component • directly and consists of query clients such as Analysis Editor and • dashboards. • End users will be able to create and modify analyses or just • access business data.

  8. Oracle BI Components • Oracle BI Server: • Oracle BI Server is the main component in the suite. • Query engine that converts the logical requests to a physical SQL statement in order to execute it in the data sources. • Optimized queries are generated based on the business rules that are defined in the BI server repository. “ Show me sales through today for my highest value customers. Assure sufficient inventory to fulfill orders.” • Repository • NQSConfig.ini • NQServer.ini • NQquery.log Oracle BI Server Intelligent Request Generation Data Warehouse Operational Inventory System Today’s sales Current inventory Historical sales (through yesterday)

  9. Oracle BI Components cont… Oracle BI repository: Is built and managed by the Oracle Administration tool and provides information and measures to clients used to create the reports. Presentation layer Physical layer Business layer

  10. Oracle BI Components cont… • NQSconfig.ini: This file is used for enabling and disabling the • cache and defining the repository to load. • NQServer.log : Record the OBI server messages. • NQquery.log : Records the messages of a query.

  11. Oracle BI Components cont… • Oracle BI Answers: • Guided experience leads user from insight to action. • Personalized, function-specific and role-based. • Allow the users to generate alerts. • Oracle Interactive Dashboards: • Ad-hoc data exploration. • True business user self sufficiency. • Create , modify and author analysis, pivots and dashboards. • Oracle BI Publisher: • Schedule and distribute enterprise-class reports. • Sophisticate “pixel-perfect” report layout controls.

  12. Oracle BI Answers

  13. Oracle BI Answers • Provides end users ad-hoc query and analysis capabilities. • Users interact with the logical view of information. • Requests that you create are saved Oracle BI • presentation catalog.

  14. Answers Workspace Subject Area Selection

  15. Add criteria to answers Add Criteria in report Filters Presentation Columns

  16. Display results in answers

  17. Report parameters Mandatory Report Parameters Add Criteria in report

  18. Interactive Dashboards

  19. OBI Interactive dashboard • User’s default dashboard is typically the first page that • appears. • Flexible information containers. • Personalized to automatically display data based on the • user’s identity or role.

  20. Dashboard Objects • Pages : Contains one or more columns and are used to align contents on the dashboard. • Sections: Within columns hold actual data. Can contain results, dashboard prompts, links, images, embedded content, text, folder, guide navigation link etc.

  21. Dashboard Builder

  22. Adding catalog object into DB

  23. How it works..

  24. OBIEE best practices • Instead of creating the Physical layer objects manually, use the Import option from the File menu. • Circular joins shouldn't be used in the repository. • Create aliases for each physical table to avoid the circular joins. • You may create more than one alias for a single physical table.

  25. Thank you!!!

More Related