appsconsultant.com

appsconsultant.com

  • Home
  • About
      • About us

        Flexibility is the biggest selling point that we have over our larger rivals. We give our clients the freedom needed to thrive in today’s fast-paced business world, organisations say to us that they often see higher quality work from independent consultants like us, this reason is the primary motivator when choosing us over a big firm. This means that we have the same skills and experience as the big firms, with added freedom and flexibility to let us focus and resolve client requirements.

      • Latest news
        Be a leader who leads with HEART

        Great leaders know how to blend the analytical with the emotional. That doesn't make you a softie. Just the opposite. Some tips

        H: Humility

        E: Excellence

        A: Authentic

        R: Reliable

        T: Trust

         

        More tips for online meetings

        Say 'Thank you' and 'Please'

        Do not Respond to Negativity

        Do not nitpick

        Talk less but say more

        Listen without interrupting

         

         

         

         

        10 Disruptive ideas in 2021-2022

         

        BIG DISRUPTIVE IDEAS 2021-2022

        1 - Deep Learning (AI)

        2 - Virtual Worlds (Gaming and AR/VR)

        3 - Digital Wallets

        4 - Bitcoin Fundamentals

        5 - Electric Vehicles (EVs)

        6 - Online Web and Biometric Security

        7 - Autonomous Ride-Hailing

        8 - Delivery Drones

        9 - Orbital Aerospace

        10 - Home 3D Printing

        Happiness hacks

         

         

      • What we offer

        Business & Technology Consulting

        We offer clients specialised consulting in areas that we deeply understand. Our services include:

        • - Skills To Envision, Design And Develop Enterprise Apps
        • - Talent For SaaS/PaaS/IaaS In The Cloud
        • - API Architecture
        • - Data Science Talent
        • - ALM deployments – Agile/Devops
        Read more
  • Services
  • Blog
  • Contact
  • Home | 
  • Blog | 
  • Business Intelligence should not be Hype, use it to answer these 4 golden rules, I included an explanation of the OBIEE Design Architecture with step by step approach to building Reports.

Business Intelligence should not be Hype, use it to answer these 4 golden rules, I included an explanation of the OBIEE Design Architecture with step by step approach to building Reports.

by Alex Antonatos
on 19 October 2018

BI should provide users the data and tools to answer questions that are important to running the part of the business you are responsible for

  1. Determine if the business is on track
  2. Identify where things are going wrong
  3. Take and monitor corrective actions
  4. Spot trends

Below is the OBIEE Standalone Architecture and an overview of its components

 OBIEE Architecture

  • Data Source --Contain the business data, users want to analyze. OBI supports Relational Database, OLAP databases, Flat Files, Spreadsheets, XML files etc .
  • OBI Web Server-- Provides the processing to visualize the information for client consumption.
  • Clients
    • Answers--Provides a self-service analysis platform for analytical needs.
    • Dashboards—Provides a way to organize related information for easy access.
    • Delivers---Used to create Ibots. Delivers alerts to subscribed users. It is integrated with dashboards and answers.
    • BI Analytical Server--- Provides efficient processing , generates dynamic SQL to query data base iin the data sources, structures results to satisfy requests.
    • BI Scheduler---Manages and executes jobs requesting data analytics. Schedules reports to be delivered to users at specified times.

Last week received the following support email

From: **********************************
Sent: March 25, 2013 2:29 PM
To: Alex Antonatos
Subject: OBIEE reports with Answers

Hi Alex,

I am a regular reader of your blog, great website and thank you for sharing your experiences.

We have installed OBIEE and new to BI Answers trying to understand how to create reports with Answers. Can you help us understand the steps required in deploying procurement spent report with Oracle Answers.                                                    

Sincerely,

*******************

*******************

Step by Step approach in building BI reports using Answers

Oracle BI Answers is the Oracle BI interface used to query the organization’s data. They provide answers to business questions. It allows you to explore and interact with information, and present and visualize information using different views.

Answers can be accessed by using URL default area http://OBIServer/analytics/saw.dll?Answers

Step 1: Arrow mark indicates the subject areas accessed by the current user. In my current example I am using Purchasing to respond to the support email above.

 Step 1- BI Answers

Step 2: Once click on the subject area displays the related tables and columns in left side pane

 Step 2- Bi Answers

Step 3: Select the columns from the left side pane.

Step 3- Bi Answers

Step 4: Select the columns from the left side pane.

 Step 4- Bi Answers

Step 5: Save the results in the required folders

 Step 5 - Bi Answers

Then you can view reports in various formats. By selecting the type of report from the drop down, then it will generate the report in that view.

 Sample BI Output

Like always, don’t hesitate to share your experiences/tips with me and the website readers on OBIEE

Categories
  • Blogue (Francais)
  • Enterprise applications
2305 Rockland Rd Mount Royal, QC H3P 3E9
514-240-40907 Days a week from 9:00 am to 7:00 pm
alex@appsconsultant.com
appsconsultant.com © 2021. Privacy Policy
Login
 Facebook  Google

username / password