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

Oracle Analytics Cloud and Server

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

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

Received Response
52
Views
6
Comments
3174977
3174977 Rank 5 - Community Champion

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 !

Answers

  • Hi,

    3174977 wrote:
    
    It should retreieve data for 2015 right ? 
    

    Well, not right ...

    You must know how you built your time dimension, you must know how you modeled it.

    So is it right to get 2014 data when selecting a 2015 fiscal year? Yes, just because that's what you created as data and as model.

    OBIEE will never guess things, it only use the data you have and the model you provided to answer your queries, so you probably have a look at what your data source contains, what kind of physical query OBIEE generate and try to identify where the mistake is.

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi Gianni,

    I checked in the database for that table. so there the calendar date says 04/02/1995 and the fiscal year says 1996.. So since this is how it is there in database in the report it is retrieving like that ?

    By any chance is it possible for us in the report to show for whichever fiscal year the user selects for that particular year to retrieve the data..

    Thanks !

  • So you are saying your time dimension is built in that way (a fiscal year return calendar dates of the previous year) and you want to change that?

    Well ... the answer you have it: change the time dimension.

    What is the point in having a fiscal year column if it's not the values you want?

    It's not OBIEE role to fix data modelling / ETL issues ...

  • 3174977
    3174977 Rank 5 - Community Champion

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

  • 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
    3174977 Rank 5 - Community Champion

    Hi Gianni,

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