This OBIEE certification training from Intellipaat is meant to provide you with a deep understanding of this tool. You will be trained in various Business Intelligence scenarios, BI life cycle, concepts of OLAP, and working with charts and graphs. This OBIEE online training will help you generate templates and reports as well.Explain the background and history of Oracle Business Intelligence.Active Directory Administration for large enterprise.
Obiee Admin Tool How To Work With1 Oracle Business Intelligence ence Enterprise Edition OBIEE SampleApp V309 R2 User Guide September 20132 Table of Contents 1 Introduction to SampleApp Image Contents Software Content Organization Recordings/ Viewlets Deploying the image Starting Services on the image Startup Scripts Shortcuts and Scripts Image Software Inventory Accessing SampleApp Contents Connecting to Analytics OBIEE Cache is ON Admintool access to SampleApp RPD Importing Oracle OLAP metadata using local BI Admintool Accessing a Host Shared Folder How to increase disk space on the VM Functional Scripts Data Inflation Scripts Webcat Analysis Webcat Error Checker Webcat Reference Checker Webcat ACL Permissions Dump Physical SQL Generator Concurrency Simulation Usage Tracking (UT) - Access to physical SQLs Setting Your VM Screen Resolution. After successful installation of the software you be shown how to work with the Oracle Business Intelligence (BI) Administration Tool (11.1.1.6) to build, modify, enhance, and manage an Oracle BI repository. You will learn how to import metadata from a data source, simplify and reorganize the imported metadata into a business model, and then structure the business model for presentation to users who request business intelligence information via analyses and interactive dashboards.Then you will be shown how to create and modify analyses with different views, and add these analyses in interactive dashboards and alerts used to deliver the notifications by using your preferred method of communication.It is neither maintained nor supported by Oracle as a licensed product. Disclaimer: The SampleApp contents and its example custom codes, including but not limited to, any example custom Java programs, JavaScript, SQL, SQL Loader Scripts, Shell Scripts, R Scripts and reports, are distributed free for demonstrative purposes only. It demonstrates a broad range of OBIEE 11g capabilities including Enhanced visualizations such as interactive dashboards, modeling best practices, Action Framework, BI Publisher, Scorecard and Strategy Management, Mobile style sheets, Semantic layer modeling, Multisource federation and integration with products such as Essbase, ORE, Oracle OLAP, ODM, TimesTen, Endeca and more.Configuration dashboard contains the setup details such as SampleApp Launchpad, URLs and login credentials, database diagram, dimensional hierarchy diagrams, rpd physcial, logical and logical hierarchy diagram and so on.many of the other dashboard pages have inline help documentation on the contents exhibited on those respective pages/ analyses.4 1.2 Recordings/ Viewlets Several practical Viewlets on SampleApp and OBIEE are publically available under YouTube channel Subscribe to the ORACLE BI TECH DEMOS YouTube Channel to receive automatic updates when new videos are posted 1.3 Deploying the image Refer to SampleApp V309 R2 Quick Deployment doc for step by step deployment instructions. Once SampleApp is deployed, navigate to General Index dashboard to see the full list of its contents. It is sequenced and organised under dashboards as shown in the screenshot here. 1.1 Image Contents Software The SampleApp V309 R2 image includes following preconfigured and integrated software: Oracle Linux 5.9 (el5pae ) OBIEE (including Mobile App Designer, OBIEE Essbase/EPM Suite) Oracle Database 12c Oracle TimesTen Endeca Server Endeca Studio 3.0 Endeca Integrator 3.0 Oracle Application Express 4.2, APEX Listener R , ORE 1.3 Java SE Development Kit 7u17, JROCKIT Oracle SQL Developer EPM Standalone (Offered as a separate download for the SampleApp OTN page) Content Organization The dashboards and analyses within SampleApp are grouped together by related functional/ product areas. You must accept and comply with OTN License Agreement to use OBI EE SampleApp.They are marked using the blue gear icons. Start scripts are accessible from the Desktop as shown below. Wait for each of them to start completely before proceeding to next. 1.4 Starting Services on the image Notes: 1.) Your host file (/etc/hosts) is automatically updated to reflect your current VM IP address 2.) BIEE services may not start up if VPN service is running on the host machine Startup Scripts To fulfill the dependencies, it is important to start the services in the sequence indicated in screenshot below from 0 to 4. Free file compare tool for macThis indicates that WLS is up. Wait for the message that shows "Server started in RUNNING mode". For full details on start services/ ram usage and startup order use the SampleApp Launch Pad Recommended Startup order and RAM Usage page Scripts to stop these services are saved under the folder Stop Services on the desktop.5 SampleApp LaunchPad Screenshot: Example: Starting WebLogic Admin Server Few notes on WLS startup: On the desktop, double click on Startup Scripts folder and select 1a-WLSAdminSrvr.sh and choose Run in Terminal option. To get the IP address of the VM machine, open a terminal window and type the command /sbin/ifconfig. For further details on these scripts, refer to Functional Scripts section of this document6 1.5 Image Software Inventory See software inventory PDF available from the Launch Pad to complete deployment detials Software Details OBI EE Weblogic Server Oracle Database Apex Times Ten Endeca Version: RCU Login: DEV_BIPLATFORM/Admin123 Middleware Home: /home/oracle/obiee (weblogic/admin123) Plus all other functional users described in dashboard page 0.2 Configuration -> Users Version: Admin Login : weblogic/admin123 Console URL: EM URL: EM: Users: sys/admin123 system/admin123 ORACLE_SID=orcl ORACLE_HOME= /home/oracle/app/oracle/product/12.1.0/dbhome_1 ORACLE_BASE=/home/oracle/app/oracle Admin/Welcome1! APEX_PUBLIC_USER/Admin123 Version: Datastore BISAMPLE_TT Login: BISAMPLE_TT/BISAMPLE_TT BI_AGGS_TT/BI_AGGS_TT Home: /home/oracle/timesten/tt1122/ Daemon port : Instance: tt1122 TimesTen server port : EID Studio=/home/oracle/Endeca/Discovery/3.0.0/endeca-portal EID Workspace= /home/oracle/endeca/discovery/workspace Integrator=/home/oracle/Endeca/Discovery/3.0.0/Integrator Endeca Server= /home/oracle/obiee/user_projects/domains/bifoundation_domain/endecaserver EID Studio logon /Admin123 ORE Version: R and ORE 1.3 OLAP AWM Version: Path - /home/oracle/scripts/awm Map Builder Version: SQL Developer Version:7 2 Accessing SampleApp Contents 2.1 Connecting to Analytics From within the image: Open the Firefox browser on the desktop, and connect to From outside the image: First find out the IP address of the machine. Dashboard page 9.11 SampleApp Scripts provides an overview of these scripts. Please navigate to File menu > Bookmarks to access these shortcuts SampleApp Scripts Several custom scripts and utilities are saved on virtual box image providing examples of functional customizations on the image. To get the IP address of the image, from the running image, open a terminal window and type the command /sbin/ifconfig Note down the ip address under the heading inet addr. To do this, you need to access the IP address of the VM image. On your host machine where OBIEE client is installed, create an ODBC connection to connect to the BI Server. Install OBIEE Admintool client locally. OBIEE client can be downloaded from the Get Started section on the Home page in your OBIEE environment. On the tool bar, click on Places->Connect to Server In the service type, choose Windows Share. Option 1 Login to the VM image. 2.5 Accessing a Host Shared Folder In order to access a shared folder on the host environment, perform the following. JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = " :9810" NOTE: Replace the server IP with the right IP of you VM. You can now connect with admintool to your VM RPD.8 2.4 Importing Oracle OLAP metadata using local BI Admintool If you have a local install of BI Admin Tool on your host and want to import OLAP metadata from the database inside the VM, you need to update the JAVAHOST parameter to the right value in NQSConfig.ini file on your local Admin Tool install.
0 Comments
Leave a Reply. |
AuthorKathy ArchivesCategories |