Procedure Step : Apply Selection to Block

Hi,

is there an option / idea how to apply Time Selection : "Previous Year" to a block via a procedure?

Thanks

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited September 18

    Hi @Maik Burghardt ,

    that depends on whether you refer to "previous" from the current year or any selected year on the screen.

    The first would be rather easy with a dynamic select on the year using the option "previous period":

    This has then to be applied to the block in the layout.

    The second case requires a temporary cube where the currently selected year is populated with a 1 and all other years have 0. You would then have to calculate the desired select-year based on this cube and apply that to the layout block in question.

    Best,
    Helmut

  • Thanks Helmut for the feedback.

    I have a dynamic selector for months that would require the equivalent for previous period however only applied to a block instead of the full screen.

    I assume that the your description solely looks at the Current Date selection but not my dynamic period selector, or?

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi Maik,

    as I said - it depends.
    You can apply a selection to a block in a layout whenever the selected entity is part of the block's dimensions. First of all, you calculate the appropriate selection in a procedure and then set it using the procedure step "Apply Selection to Layou Block" (which—of course—will only be available in a capsule procedure).

    Kind regards,
    Helmut