Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12.2.1.2.0 calendar year is not showing the Year in which Project is scheduled and published

Received Response
1
Views
4
Comments
Gaurav_Gupta
Gaurav_Gupta Rank 1 - Community Starter
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

Dear folks,

We are not sure why the Sample dashboards in obiee is showing year from 2015 onwards, however we have scheduled the project in p6 eppm for year range of 2012 to 2014 and published with required attributes to data warehouse.
Checked the filters and list of values are shown from 2015 to 2021 in left side of the dashboard.
(Note: The other details are populating with correct numbers falling in 2015 calendar year)

Is there any hardcoding been done in sample dashboards which is restricting us to see the older period ??

If not, then any suggestions/directions to figure out the root cause here.

P.S.: Application Details:
Primavera EPPM 17.7
Primavera Analytics 17.7

Oracle Database 12.2.0.1
Microsoft Windows Server 2012 R2

Thanks,

Regards,

Gaurav Gupta

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you checked the filtering of the P6A sample reports? In the past, there was a lot of hardcoding on the sample dashboard reports.

    I suggest that you check the filters and screenshots are really useful as well.

  • Gaurav_Gupta
    Gaurav_Gupta Rank 1 - Community Starter

    @Hi Joel,

    I have attached the two images -

    OBIEE_EVDashboard.jpg : Captured from OBIEE having years in 'Year Name' prompt with values from 2015 onwards

    BIPublisher_EV.jpg: Captured from BI Publisher for the same project showing the year from 2012 as defined for project

    Let me know if you need any other details. Thanks,

    -Gaurav

  • Joel
    Joel Rank 8 - Analytics Strategist

    OK, could you check the query log files (<obiee_home>/user_projects/domains/bi/servers/obis1/logs) to see what physical SQL is being generated?

    Did you check the filters of the P6A sample earned value reports?

  • Gaurav_Gupta
    Gaurav_Gupta Rank 1 - Community Starter

    Hi Joel,

    It's been fixed..

    Solution: Refreshed the P6 extended schema's and republished it from 2010 again and it's now showing in analytics.

    Appreciate your attention.

    -Gaurav