7 Days Plus In Hijra Date When I Using Oracle Daily Business Intlligence Report Daily Business Intelligence (Doc ID 1514813.1)

Last updated on OCTOBER 14, 2023

Applies to:

Goal

Is it possible to use Hijrah dates in custom Daily Business Intelligence reports?

Creating custom dimension and custom report, the report should return 'actual date +9 Days' as the Hijrah date .
For example, if today is 17-01-1434, the Hijrah date should be 26-01-1434 this means (Days + 9)

The dimension object uses this view:
CREATE OR REPLACE VIEW <VIEW> (ID, VALUE)
AS SELECT to_char(effective_start_date,'DD/MM/YYYY','nls_calendar=''arabic hijrah''') ID,
  to_date(to_char(effective_start_date,'DD/MM/YYYY','nls_calendar=''arabic hijrah'''),'DD/MM/YYYY') VALUE
  FROM per_all_people_f
  WHERE...

The report uses this view:
CREATE OR REPLACE VIEW <VIEW> (APPL_COUNT, APPLYING_DATE, PARA_DATE)
AS SELECT count(*),to_date(to_char(effective_start_date,'DD/MM/YYYY','nls_calendar=''arabic hijrah'''),'DD/MM/YYYY') APPLYING_DATE, to_date(to_char(effective_start_date,'DD/MM/YYYY','nls_calendar=''arabic hijrah'''),'DD/MM/YYYY') PARA_DATE
  FROM per_all_people_f
  WHERE.....

The DI Global parameters are set as follows:
Enterprise Calendar =JEBE_MONTH_VAT
Data source page with source=view <VIEW>
  Columns: APPLYING_DATE, APPL_COUNT(Measure) and ARA_DATE(Dimension objects DP2).

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.