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

Question

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

Gaurav_Gupta · Answer

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

Joel Acha · Answer

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 · Answer

@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