Best Of

I don't have such a simple solution, but depends on the cube structure:

If the cube is by year a mere offset of -3 should do the trick

if the cube is by month you should use a offset -36

if the cube is by day the offset -1096 (because it includes a leap year)

The offset is always applied at the cube physical level so if you want to avoid the one by day (that may change depending on the leap year) you may create a version by year or month.

Otherwise if the cube is by day and you want to avoid reviewing the offset in 2020 you may create two cubes, one with offset -1096 and the other -1095, depending on the selected year you may show one or the other with an algorithm.

Honestly i would go with the version in this case

Antonio

Hello Etienne,

You can drill down using the first column of the dataview.

I understand that you prefer to drill using the cell containing the Material code.

You can make the material column very narrow and hide it, then use an entity block material and put it in first position.

In the layout options set a drill action for the entity block.

Now you can drill using the material column.

The negative effect of this is that, when you will export to excel you will see the material column twice.

I think you should open a wish for expanding the drill area also to the second column if the dataview is flattened.

Hope this is clear enough,

Antonio