Locked by on row totals is always applied

François FALCON

Hello,

We have one cube, with the month by column and with a "total row".
It is in Data Entry mode with a "locked by".

This locked by is conditional to a workflow cube: If the current process is validated, then the detail and total must be locked, otherwise the detail and total can be entered and we should be able to use the lock & spread.

However, I notice that the total is always locked.
If I remove the locked by, it works.

The structure is as follows

			Jan	Feb	March	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec	TOTAL
(a)	Locked by if (b) is not 0	Monthly Cube	10	10	10	10	10	10	10	10	10	10	10	10	120
(b)	Hidden	Workflow cube	0	0	0	0	0	0	0	0	0	0	0	0	0

Is this a normal behaviour?
Do you have any ideas for a workaround?
If I display the total on another block, it doesn't work because the spread functionality is lost.

Thanks in advance for your help

François

------------------------------
François FALCON
Manager
Satriun France
France
------------------------------

Björn Reuber

Hello François,

which version are you using? I just did a short test in Board 2023 Spring version and was not able to reproduce the behavior. I used Product group instead of Month:

Regards

Björn