When I am using the fiscal year as current year it is showing previous year data in the report

Question

Hi All,

We are using dates, fiscal year, fiscal quarter & fiscal month in our reports and created dashboard prompts for the same.. When I select the fiscal year as 2015 the report is showing data from jan 1st 2014 to dec 31st 2014. It should retreieve data for 2015 right ? why is it going one year ago and showing ? Any suggestions please

Thanks !

3174977 · Answer

Hi Gianni,

I will talk with data architect on this.. Thanks for the update.

Gianni Ceresa · Answer

Challenge the ETL process populating the data: who decided to apply that logic? Is it used somewhere?

If the answer is "yes" you have another problem: in your organisation there are 2 different rules for "fiscal date", and this is an issue as the role of OBIEE is to provide a unified enterprise model, so with 2 rules ... one of the 2 must change name or rule.

3174977 · Answer

Thanks Gianni ! Yeah that is how the table is modeled and data is populated in database.