Basic concepts of OBIEE:

What is OBIEE?
OBIEE stands for Oracle Business Intelligence Enterprise Edition, which is introduced by Oracle Corporation. Mainly it is a set of business intelligence tools. Oracle Business Intelligence Enterprise Edition or OBIEE is also termed as OBI EE Plus. The key competitors of OBIEE are Microsoft BI, SAS Institute, IBM Cognos, SAP AG Business Objects.
OBIEE is an open, complete and architecturally unified business intelligence tool. It has some useful features like ad hoc query and analysis, reporting, OLAP (online analytical processing), scorecards and dashboard etc.
Sometimes OBIEE is used interchangeably with Oracle Business Intelligence Applications (OBIA), which is a pre-built BI and data warehousing system built on the OBIEE technology stack, however OBIEE is the platform whereas OBIA is an application that uses the platform. The OBI EE Plus incorporates the components of the toolset to include a service-oriented architecture, an analytic, data access services, and calculation infrastructure, semantic business model, metadata management services, a security model and user preferences, and administration tools.
Main features of OBIEE
  • Graphical reporting
  • Scheduled report generation
  • Ad hoc query and analysis also
  • Gives global support
  • Hierarchy piercing
  • It can connect to other sources like Excel, XML, Oracle OLAP, MS Analysis services, Essbase etc.

Get Age between two Days in OBIEE Report

For Getting Age between two dates we use SQL Query as :

datediff(d, startdate, enddate) as Age

However default date format in OBIEE is Timestamp. So you need timestamp function (Available under Calendar/Date Function Heading) to get required result.

Syntax:

TIMESTAMPDIFF(interval, timestamp1, timestamp2)

Where:
interval is the specified interval. Valid values are:

SQL_TSI_SECOND

SQL_TSI_MINUTE


SQL_TSI_HOUR


SQL_TSI_DAY


SQL_TSI_WEEK


SQL_TSI_MONTH


SQL_TSI_QUARTER


SQL_TSI_YEAR

timestamp1 and timestamp2 are any valid timestamps.

Example
For Number of Days between two days:
TimestampDiff(SQL_TSI_DAY, “FROM_DATE_COLUMN”, “TO_DATE_COLUMN”)

For Number of Days till current date:
TimestampDiff(SQL_TSI_DAY, “FROM_DATE_COLUMN”, CURRENT_DATE)

*You can also use this function for getting age difference for other time dimension attributes as week, quarter, month or year. All you need to do is change first attribute i.e ‘interval’ & other attribute’s accordingly.