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
------------------------------