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:
Oracle E-Business Intelligence - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |