Skip to main content

Hello!

I want to transfer values from one quarter to another, based on certain conditions written by IFF...] and I am using filter and select as shown below:

pfilter: 'Actuals & Dimensions (Datahub)'::Quarter.'Quarter -1']
/Select: 'Actuals & Dimensions (Datahub)'::Quarter-1])))

However, when switching the switchover date, the values that I moved from Q to Q+1 will not be in Q+1 anymore. do you have an idea of a better clean way to code this?

Thank you very much :))

Hi Thierry,

 

what is the structure of your source metric ?

 

ps: I don’t think you need to have both FILTER AND SELECT. SELECT does the filter.

Hello,

The metric is a number metric with 4 dimensions and the source metric is the same with the same dimensions. I have tried to delete FILTER but the data is incorrect when I do so.

Thank you for your help !

My point:

  • if you are doing this on actuals, then switchover shouldn’t matter
  • if you are doing this on a forecast version, then you want the number to go away if in actuals it did not happen

Hi, we are doing it on forecast and we want the numbers that we moved from Q → Q+1 to stay in Q+1 when the switchover date changes to Q+2, do you see that possible?

Thanks!

of course !

what you lack is that your shift should be done on the Actuals version, not the forecast. that’s why I asked you the structure: one of this dimension is the version ?

pfilter: 'Actuals & Dimensions (Datahub)'::Quarter.'Quarter -1']
/Select: 'Actuals & Dimensions (Datahub)'::Quarter-1]
"select:Versions.”Actuals”])))

Reply


Ask your question here!

Terms & ConditionsCookie settings