Year To Date measure

Question

Hi,

I have worked on OBIEE for 2 days and I have my first problem. In my dashboard I have an analysis in which different column values are showed, splitted by months. My purpose consist in having a year to date calculation of each items, does someone can help me please ?

I wish to obtain, if I select February, sum values of the two months of the year

Thank you forward

Kind regards,

Luigi

Gianni Ceresa · Answer

The function just replace the measure itself, so in your case I would say you replace the "Sale Amount"."Order" by the TODATE(...) inside FILTER.

Didn't check the generated physical query but there anyway many chances the result will be the same if you do TODATE(FILTER....) instead in a normal "simple" analysis.

[Deleted User] · Answer

Luigi_Gif wrote: I am sorry but it's my third day on oracle BI

And you immediately came here. You did everything right that you can do right. Welcome!

Luigi_Gif · Answer

Ok Gianni, thanks a lot for your help; now it seems working. I am sorry but it's my third day on oracle BI  . A last dubt... I want to insert TODATE function into "Actual" column (the 6th from the left of my picture) that has a formula such as: FILTER("Sale Amount"."Order" USING ("Scenario"."Scenario" = 'Actual' AND "Account"."Child"='TOT'))

can you advise me how can i better insert todate function into ?

I am so please for your help

Luigi