Monday, November 21, 2016

Data Source Creation in YellowfinBI Tool

Data Source Creation in YellowfinBI Tool

It demonstrate the oracle database data source connection

1) Log on to Yellowfin BI, Go to Data Source
 

2) Select the type of data source.




3) Provide Connection name & other details in New connection window & test the same.
 


4) Now you can able to create Yellowfin view

Thursday, September 8, 2016

About Yellowfin BI Tool

About Yellowfin BI Tool
Yellowfin – BI Tool:
Yellowfin is a business intelligence tool with high data visualization and analytical capability so users can solve problems with data and increase the performance of their business.

Yellowfin is designed & built by BI industry professionals. Yellowfin positioned in Gartner magic quadrant for third consecutive year.
Yellowfin rises in Gartner's Magic Quadrant - February 2016.
Yellowfin rises in Gartner's Magic Quadrant - February 2015.
Yellowfin debuted in Gartner's Magic Quadrant - February 2014.

Features:
·         Awesome Dashboard & Data Visualization
·         Collaboration BI (Annotation, comment, Storyboard, Time Line & Discussion)
·         Mobile BI
·         Location Intelligence
·         Cloud BI (Azure & AWS)
·         Data Discovery
·         IT Administration (web-based, integrated platform, Data Governance, Security, Easy to manage)
·         Simplified pricing
·         Embedded BI

Advantages:
·         Track business operations effortlessly from the dashboard.
·         Discover data from multiple sources and analyze them in more ways than before. Create more intelligent business plans from multiple actionable insights.
·         Visualize and explore data to spot trends and outliers.
·         Collaborate and access data with Yellowfin’s mobile app.
·         Share insights and communicate with other members effectively with compelling data presentations, interactive reports, and descriptive texts.
·         Collaborate and turn business intelligence into effective business strategies.

Yellowfin offers an innovative and flexible 100% Web-based reporting and analytics solution that is cost effective, easy to use and deploy. Yellowfin can reach any platform or device and is a leader in data visualization, location intelligence, mobile and collaborative BI.

Friday, November 6, 2015

Oracle Business Intelligence Enterprise Edition 12c Released - OBIEE 12.2.1.0.0


Oracle Business Intelligence Enterprise Edition 12c Released - OBIEE 12.2.1.0.0


OBIEE 12c Released
The new version Oracle Business Intelligence 12c (12.2.1.0.0) is now available for download on Oracle OTN for Linux, Windows, Solaris, AIX and UX. It needs JDK 8 to install.


System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1) is here. Refer:  http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1221certmatrix-2739738.xlsx

Oracle Data Visualization
The most interesting feature that has been added in this release is new Data Visualization capability in OBIEE 12c, something that has been available on Oracle’s BI Cloud Service [Oracle BICS]. This is a completely new powerful visualization application introduced in OBIEE12C.

Visual Analyzer is the primary data visualization tool in Oracle Data Visualization.

1] New Features for Oracle BI Users
·         Enhancements to Graphs
·         Enhancements to Views
·         Enhancements to Analyses
·         Enhancement to Scorecards
·         Enhancements to Dashboards

Detail Level:
·         Ability to sort graph views by using a context menu (right-click). Mashup data using Visual Analyzer
·         New view type named heat matrix & Ability to sort graph, heat matrix, pivot table,  table, treemap, and trellis views by using a context menu (right-click)
·         Specify whether to multiply data by a 100 to display it as a percentage in an analysis & Add data from an external source to an analysis
·         Style and customize KPI Watchlists and every watchlist that appears in a scorecard
·         Set advanced dashboard page properties to specify incoming navigation parameters


2] New Features for Oracle BI Metadata Repository
·         Logical Level Sequence Numbers for Time Dimensions
·         DISPLAY | SORTKEY Syntax Supported in the SQL ORDER BY Expression
·         Oracle Database Fast Application Notification and Fast Connection Failover    Supported by Oracle BI Server
·         Generate Fragmented Aggregates in Aggregate Persistence
·         New Command Line Utilities:
a.    Download Repository Command
b.    Upload Repository Command
c.    List Connection Pool Command
d.    Update Connection Pool Command
e.    Rename Application Role Command
f.     Delete Application Role Command
g.    Rename Users Command
h.    Delete Users Command
i.      List Repository Variables Command
j.      Update Repository Variables Command



3] New Features for Oracle BI System Administrators
·         Invoking WLST From a Single Location
·         Oracle Home Location Redefined and No Middleware Home
·         OPMN is No Longer Used in Fusion Middleware
·         Oracle Web Cache Not Part of Fusion Middleware
·         Moving From Test To Production is Carried Out in a Different Way
·         New Commands For Process Control
·         Managing Metadata In Business Intelligence Archive Files
·         Single Enterprise Install
·         Changes to Scaling Out
·         Simplified Configuration
·         Managing System Component Instances Using Commands
·         Collecting Diagnostic Bundles


4] New Features in Oracle BI Security
·         BISystemUser and BISystem Removed
·         User GUIDs Removed
·         Database Security Store
·         Easier SSL Configuration
·         Migrating Catalog Groups to Application Roles

Detail Level:
·         To simplify administration and configuration, no longer requires a real user called BISystemUser for internal communication. The application role BISystem is also no longer present in the Policy Store, and will be removed from any upgraded 11g environment.
·          GUIDs are replaced with user names. There is no longer any need to refresh GUIDs as part of lifecycle operations. Your administrator is now responsible for ensuring that users leaving the system are cleaned up from Oracle Business Intelligence.
·         Security Store (Policy and Credential Stores) is configured in a relational database rather than in a file. The database is the same as used by RCU. This change makes scaling easier, and makes clusters more reliable.
·         In this release configuring SSL end to end is now less complex and uses offline commands.
·         In this release a new process enables you to migrate Catalog groups to application roles.



5] New Features for Oracle BI Publisher 12c
·         Generate Explain Plan from SQL Data Set
·         Best Practices Information

New Features for Oracle BI Publisher 12c Users

Look and feel of the user interface is refreshed. You will notice new icons and some changes to the presentation of features on the Home page.



 6] New Features for Oracle Business Intelligence Integrators

New features and upgrade considerations. It contains the following topics:

1)    New Service :


3)    New Methods:

 7] Other Features:
·         “Forecast” a new time-series function added in OBIEE12c
·         “migration-tool.sh” script to migrate metadata from OBIEE 11g to OBIEE 12c
·         TRENDLINE SQL function

Tuesday, April 28, 2015

OBIEE 11g Variables - Access Method



OBIEE 11g Variables - Access Method



There are basically four types of variables that you can use:
  • Session
  • Repository
  • Presentation
  • Request