Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
When I am using the fiscal year as current year it is showing previous year data in the report

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.
0 -
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 !
0 -
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 ...
0 -
Thanks Gianni ! Yeah that is how the table is modeled and data is populated in database.
0 -
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.
0 -
Hi Gianni,
I will talk with data architect on this.. Thanks for the update.
0