Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

YTD wrong values on year level

User294199May 22 2020 — edited May 29 2020

Hi,

i have following problem.

I have following analisys:

pastedImage_1.png

The result is correct. Quantità YTD, for example for February Month is the sum of Quantity for January and February and so on. The total of Quantita YTD è 288.950.856

It should be the value of Quantità Ytd for Year 2017, but when i drop Month level, the result of Quantita YTD is :

pastedImage_2.png

instead 288.950.856

Strange thing is that the YTD is the value of December 2017.

I have setted my rpd hierarchy as following:

pastedImage_3.png

Anno level settings:

pastedImage_4.png

The anno field contains values 2010, 2011,2012,2013 and so on

Mese level settings:

pastedImage_5.png

The AnnoMese field contains the concatenation of the year with the month: for ex. 201001, 201104

The Mese fields contains values January, February, March and so on...

Giorno level settings:

pastedImage_6.png

The DataAS400 field contains values 20100201, 20110406 and so on.

What's the error on hierarchy? Can you help? It's quite urgent.

Regards
This post has been answered by Gianni Ceresa on May 22 2020
Jump to Answer
Comments
Post Details
Added on May 22 2020
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
316 views