Hi Gianni, resolved!!!. I added a hidden Month column. In this way at year level, for each year, OBIEE calculates the sum of monthly YTD. in my example 288.950.856 for year 2017. Thank you Regards. 

Hi Gianni, so at year level there isn't difference between Quantità and Quantità YTD?. If I want what i expect (288.950.856 at year level) i have to use another function and not ToDate? Thanks

Hi, i use: Oracle Business Intelligence 11.1.1.7.140715 OS: Windows 7 Professional 64 bit Browser: Firefox 73.0.1 (64 bit) Regards

Thanks a lot!!!! I marked as Exact Answer Giancarlo

Hi, an important thing is that Year and Month aren't static but dinamic. They can be chosen by user using two prompts. So the user can select multiple years and months, or only particular month. So, for year 2020 I can have only January, February, Avril month. So need a single measure column that automatically OBIEE…

Hi, nothing is changed. Where I have to see to resolve the problem? In the Catalog Manager weblogic has already Full Control to Shared Folder. Thanks

Ok. I have opened a new thread " "Error when i try to save a report in Shared Folder" . Could you give me an answer there? Thanks

Hi Christian, but i have the error when I try to save in Shared Folder. I don't, as normal the up level (root folder). The catalog tree starts with Shared Folder level. However how can I resolve the error? Thanks

Hi, can you tell me what privileges I have to assign to save in shared folder top level? Also with weblogic I see error "Unable to save in the root folder'. Also could you tell me what privileges I have to assign to user to see the item FILTERS in the New Menu? Thanks

I want reproduce following query: SELECT ABAN8 AS RPAN8; ABALPH AS RPALPH; right( trim( ABALKY ); 8 ) AS COLUMN0002; RPMCU; right( trim( RPMCU ); 3 ) AS COLUMN0006; MCDL01; sum ( CASE WHEN RPDCT in ( 'RI'; 'RM'; 'U8' ) THEN RPAAP / 100 ELSE 0 END ) AS RPAAP; sum ( CASE WHEN RPDCT = 'IF' THEN RPAAP / 100 ELSE 0 END ) AS…