What is OBIEE? OBIEE are short form to Oracle Business Intelligence
Enterprise Edition 11g and it is a comprehensive business intelligence platform
that delivers a full range of analytic and reporting capabilities. This Application
provide interactive dashboard, ad hoc queries, mobile analytics, notifications
and alerts, enterprise and financial reporting, scorecard and strategy
management.
There have 4 architecture components:
1.
Presentation Services (Analysis Editor and
Dashboard)
2.
Oracle Presentation Server (Presentation Catalogue)
3.
Oracle BI Server (Repository)
4.
Data Sources
For one day we learned how to install all Oracle Business
Intelligence products intended for Weblogic. Basically, Weblogic domain must be
installed configure at the same time. All the installation must be followed the
method and procedure. All the installation basically are provided by Oracle and
the trainer.
The lesson also stress about what is Repository Creation
Utility (RCU) and it act as graphical tool for creating and managing Oracle
Fusion Middleware Database Schemas in the database. How to start Oracle
Database?
How to start OBIEE? There have 4 way to start the OBIEE.
Firstly, we need to start weblogic by
enter the directories of the weblogic (cd
/home/oracle/bi11g/user_projects/domains/bifoundation_domain/bin) and type ./startWeblogic.sh. secondly, we need to start
the Node Manager by enter the directories and type ./startNodeManager.sh.
Thirdly, we need to start Managed Server using same method but with localchost
and followed with port number.
Lastly, we need to start all Oracle Process Manager and
Notification Server (OPMN) . There have several tutorial that trainer gave to us including how to do report from Oracle about business intelligence. All the tutorial are mainly from limiting and grouping data, view and graph in analysis. For Limit data, we are using Filters.
1. Only those results that match criteria are incuded
2. Filters are applied before the query is aggregated.
Another methods on limit data are using Selection and creating groups. All the methods are basically using same database and same tutorial but different team. Pivot table? The function of pivot table are customize the overall appearance of a pivot table by applying green-bar styling and formatting
In last day of OBIEE lessons are Graph Formatiing. The only method for showing a graph on report are Graph Properties. Ther have several elements in graph formatting and there are :
1. General
2. Style
3. Scale
4. Title and Labels
No comments:
Post a Comment