Block Reference Automation

Jason Ferguson

Hello

Does anyone know if a Blocks Reference can be attached to a "Pager" Selector.

Currently I have a screen with a week ending Selector, when changed I have to go into to the 'Data View' to manually change one of the blocks so the Reference only displays information for the last day of that week and change another block so that it only shows information for the last day of the previous week.

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
------------------------------

Sebastian Gurt

Hi @Jason Ferguson,

you could probably achieve that result using the function "Apply selection to a layout block".
You would need to start a procedure with your first selection (either use the pager trigger or a button/lable with an interactive selection) apply that to the first block using the procedure step mentioned above and then perform the second selection based on cube (you probably need to create a mapping cube or find some dataflow logic to mark the necessary day) and apply that selection to the second block.

Hope this helps.

BR

Sebastian


------------------------------
Sebastian Gurt
Consultant Team Leader
Board International
Germany
------------------------------
-------------------------------------------

Jason Ferguson

Thanks, sounds a bit complicated. Its point in the right direction where I will need to start researching.

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
------------------------------
-------------------------------------------

Etienne CAUSSE

Hi,
Using triggers and "apply selection to block" in a procedure makes it possible, however a great improvement would be to be able to link a pager / selector directly to a block.
This would allow for example to let the user select two phases / periods / entities for comparison within a very specific layout.
Anybody had this kind of need before ?

------------------------------
Etienne CAUSSE
Finance Project Manager
France
------------------------------
-------------------------------------------

Alessio Biondi

Hi @Etienne CAUSSE,
I found this kind of need in the Fashion industry, where you need to compare a measure (e.g. Sales) of the current season against the so-called counter-season (two seasons back in the past).
Given that you cannot apply Board built-in time functions because it's not a time dimension, I usually set an aggregation of the Season dimension for reporting purposes.
Current season will be managed with the screen selection, the counter-season will be retrieved using a refer to. Setting the filters on the aggregation gives you flexibility to let the user change all the reporting with just one setting.
But this is always a unique setting in the database, across all users.
If you want to let the users freely change you need to use the "apply selection to block" feature because the procedure applies the refer to in the layout blocks only for that specific user. You can trigger the procedure with the pager, inheriting the user choice and managing the "apply selection to block" steps coherently.

Hope it helps


------------------------------
Alessio Biondi
Consultant
K.GROUP SRL
Italy
------------------------------
-------------------------------------------