KPI Partners Blog

Oracle BI Experts from KPI Partners Selected to Speak at Collaborate 2012

Posted by KPI Partners News Team on Fri, Mar 23, 2012 @ 12:01 AM

Educational Sessions to Focus On Oracle Business Intelligence & Exclusive KPI Solutions

Newark, CA -- March 23, 2012 –- KPI Partners, the 2011 Oracle Titan Award Winner for Business Intelligence Applications, announced today that two members of their organization have been selected to present at Collaborate12: Technology and Applications Forum for the Oracle Community, April 22-26, 2012 in Las Vegas, NV.

Read More

Tags: Oracle BI, News, Oracle BI Applications, Pre-Built Solutions

What Partners are Saying about Oracle Exalytics In-Memory Machine

Posted by KPI Partners News Team on Thu, Mar 22, 2012 @ 02:41 PM

KPI Partners Founder, Sid Goel, was recently quoted in a recent article regarding the release of Oracle Exalytics:

Read More

Tags: Press, Exalytics

Bullet Graphs in Oracle Business Intelligence (OBIEE)

Posted by KPI Partners News Team on Thu, Mar 08, 2012 @ 11:06 AM

by Kurt Wolff

Stephen Few designed the Bullet Graph as a way to display measurements vs. goals or other benchmarks. The screen shot below shows bullet charts in the column “MTD & Proj Comp MAgo” (Month to Date and Projected Expense Compared to Month Ago).

Read More

Tags: Blog, Oracle BI, Kurt Wolff

Basic Security Options in Oracle Business Intelligence (OBIEE)

Posted by KPI Partners News Team on Sun, Mar 04, 2012 @ 02:31 PM

Oracle Business Intelligence (BI) is designed to provide open, complete and integrated solution including dashboards, ad hoc query and analysis, score cards and enterprises.

Some of the aspects offered include an expansive spectrum of embedded search, visualization options, mobile access and collaborative applications along with Microsoft Office integration. Users are afforded the ability to initiate most of these actions from a  dashboard environment.

Oracle Business Intelligence Foundation Suite

The Oracle BI Foundation Suite is designed to be a common enterprise information model which enables users to ensure accurate and consistent information on a continual basis at any location. In particular, Oracle Business Intelligence technology tools include:

  • products for query and analysis;
  • enterprise reporting; and
  •  highly scalable, architecturally unified technology foundation.

The OLAP server is designed to enable rapid modeling of security solutions which streamline forecasting, management reporting and variance analysis processing. Real-time decision solutions were developed to optimize:

1. Defined repository security. Oracle Business Intelligence provides an administration tool  that may be used to create groups and users with particular and specified permissions that are defined through certain types of authentication. Once the permissions are assigned, permissions are granted to specific groups and users.

Privileges granted with exclusivity most often have precedence over group privileges. When conflict exits, privileges with least restrictions will apply.

2. Database authentication. Below is the process used for authenticating the database:

  • Adjustments are made in the NQSConfig.ini file to authenticate the database.
  • Security section specifies the authentication database.
  • Users are created in the repository which identical to those in the  database.
  • Users are assigned privileges.
  • Database is imported to physical repository layer using the DSN of each particular database. For example, a connection pool may incorporate a non shared logon.
  • The new connection pool is used to connect to the database.

Upon connection, authentication has been effected successfully.

3. Lightweight Directory Access Protocol (LDAP) authentication. Many businesses, companies and enterprises have implemented LDAP server authentication as part of their Oracle Business Intelligence solution. One popular aspect of this is the Active Directory Service Interface (ADSI) for client projects.

The LDAP server is created in the security manager. Below is the process:

  • At Action> New> LDAP Server, access the Server dialog box
  • Assign parameters such as port no., host name, LDAP version (the default is 3), base DN and bind DN from the general settings.
  • Define the settings in the Advanced tab by filling in aspects such as Connection Time-Out, Enable/Disable SSL and Domain Identifier.
  • Create an LDAP initialization block, associated with the LDAP Server.
  • Define USER as a system variable, mapped to LDAP uid.
  • Alternatively, it is also possible to use the LDAP server exclusively to import group and user definitions. This scenario would be utilized if external authentication is not desired by LDAP.

4. External table authentication. The External Table Authentication is implemented by establishing a table within the database that includes columns defining aspects such as passwords, users, groups, display name, the log level, display name and security level and privileges. The table for authentication is created as follows:

  • To connect to the db/table, created a new physical layer connection pool.
  • Establish an initialization block with the newly defined connection pool for the table.
  • Define initialization aspects such as the password, username, lognumber, and groupname from the auth_table where username = ':USER' and password = ':PASSWORD' is located).

  • Define the corresponding variables (such as user, password, group, loglevel).
  • Ensure that the variables order is identical to that of the initialize.

The above describes some of the processes by which the extensive Oracle Business Intelligence solutions may be utilized for an effective security strategy.

Read More

Tags: Blog, Oracle BI

KPI Partners Earns 2 Oracle Specializations in Business Intelligence

Posted by KPI Partners News Team on Thu, Mar 01, 2012 @ 02:34 PM

Specialization Designation Achieved in Business Intelligence Foundation & Business Intelligence Applications Categories

Newark, CA -- March 1, 2012 -- KPI Partners Inc., an Oracle Partner, is proud to announce that it has earned two specializations from Oracle for implementation services of Oracle Business Intelligence (BI) Foundation and Oracle Business Intelligence (BI) Applications. These specializations recognizes select Oracle partners with certified professionals who have demonstrated success in effectively implementing solutions using Oracle’s Business Intelligence Foundation and Oracle's Business Intelligence Applications which includes Oracle BI Enterprise Edition (OBIEE).

Read More

Tags: Oracle BI, News, Oracle BI Applications, Awards