Block hidden if

Hervé BEURET

Hello,

I have a layout with 3 blocks. All have data entry available. I would like to display the third block only if the user has selected a specific entity.
Let's say my entity is the year, I would like to display the block "c" only if the user has selected the year 2022.
If the year is not 2022 i would like to see only the blocks "a" and "b".
That should be automatic and not through a manual action from the user.

Thanks

Hervé


------------------------------
Hervé BEURET
Senior Controller, Budget & Control
FONDATION INSEAD
France
------------------------------

Helmut Heimann

Hi @Hervé BEURET,

first of all, you'd need to untick the "show all" option for the columns.
Secondly, your third block will need to be an algorithm that represents the cube's data on the condition that the selection is set according to your needs (i.e. if(<select>, x,0) where "x" represents your cube's data). Since this new block is an algorithm you'd have to use an inverse algorithm in order to write the data entered by the user to the data-entry cube (you might consider using Nexel writeback, here).

Kind regards
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------

Hervé BEURET

Thanks @Helmut Heimann
I would probably need more help on that inverse algorithm.

Currently I have my algorithm in block "f" and my original cube in block "e" :



thanks

Herve


------------------------------
Hervé BEURET
Senior Controller, Budget & Control
FONDATION INSEAD
France
------------------------------
-------------------------------------------

Hervé BEURET

That works now.

Thanks

------------------------------
Hervé BEURET
Senior Controller, Budget & Control
FONDATION INSEAD
France
------------------------------
-------------------------------------------

Helmut Heimann

Nice, great to hear that

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------