obiee - introduction & building reports
DESCRIPTION
Introduction of Oracle BI and BI Interactive DashboardsTRANSCRIPT
![Page 1: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/1.jpg)
Oracle Business Intelligence
Introduction & Building Reports
By :Deepika Walia
Senior BI Consultant
![Page 2: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/2.jpg)
AGENDA
About Oracle BI EE Components of Oracle BI EE Answers Interactive Dashboard
![Page 3: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/3.jpg)
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.
![Page 4: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/4.jpg)
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.
![Page 5: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/5.jpg)
Advantages of Oracle BI EE
Simple User Manipulation.
No deep Technical skills required.
Robust Customizations.
Multilanguage reports can be created with data.
![Page 6: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/6.jpg)
Architecture of Oracle BI EE
Client Presentation Services
BI Server
BI Scheduler
Repository
OO
Oracle
SAP
Siebel
Data Sourc
eData Source
![Page 7: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/7.jpg)
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.
![Page 8: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/8.jpg)
Oracle BI ComponentsOracle 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.”
Oracle BI Server Intelligent Request
Generation
Data Warehouse
OperationalInventory
System
Historical sales (through yesterday)
Today’s sales Current inventory
•Repository•NQSConfig.ini•NQServer.ini•NQquery.log
![Page 9: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/9.jpg)
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.
Physical layer
Business layer
Presentationlayer
![Page 10: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/10.jpg)
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.
![Page 11: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/11.jpg)
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.
![Page 12: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/12.jpg)
Oracle BI Answers
![Page 13: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/13.jpg)
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.
![Page 14: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/14.jpg)
Answers WorkspaceSubject Area Selection
![Page 15: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/15.jpg)
Add criteria to answers
Add Criteria in report
Presentation Columns
Filters
![Page 16: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/16.jpg)
Display results in answers
![Page 17: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/17.jpg)
Report parameters
Add Criteria in report
Report Parameters
Mandatory
![Page 18: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/18.jpg)
Interactive Dashboards
![Page 19: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/19.jpg)
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.
![Page 20: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/20.jpg)
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.
![Page 21: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/21.jpg)
Dashboard Builder
![Page 22: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/22.jpg)
Adding catalog object into DB
![Page 23: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/23.jpg)
How it works..
![Page 24: OBIEE - Introduction & building reports](https://reader033.vdocuments.us/reader033/viewer/2022061118/54686239af795919288b514e/html5/thumbnails/24.jpg)
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.