Dynamically select the Last 12 months based on the Pager value

Efraim · 2025-01-22T18:01:04+00:00

There was an error rendering this rich post.

Hello,

I am trying to find a way to select dynamically the LTM for a bar graph in a screen that has a Month pager.

I created LTM Flag cubes and a procedure based on the example made by @Sudeep Palkar and modified it to work with months but no success. Please how can I make the procedure that sets the flag work?

I am planning to use the LTM Flag cube in setting the bar graph Layout Selection (Apply selection to block)

Find more posts tagged with

Accepted answers

Helmut Heimann

Hi @Efraim ,

imagine you had selected Nov.24 on the pager, then you should see something like this in the debugger

That would show that your procedure works correctly.

The next step would be to do that without a pager because the pager would of course restrict the data being displayed.

Where is it that you are stuck?

And please keep in mind that those cubes you're using in the procedure should be temporary/virtual cubes in the procedure, so as not to affect other users' selections.

Best,
Helmut

All comments

Helmut Heimann

Hi @Efraim ,

could you please provide screenshots of the dataflow layouts? Do you extend the calculation on "week" in dataflow (4)?
How is "T Week" populated if you run the procedeure and set a breakpoint right after step (6)?

Best,
Helmut

Helmut Heimann

Hi @Efraim ,

imagine you had selected Nov.24 on the pager, then you should see something like this in the debugger

That would show that your procedure works correctly.

The next step would be to do that without a pager because the pager would of course restrict the data being displayed.

Where is it that you are stuck?

And please keep in mind that those cubes you're using in the procedure should be temporary/virtual cubes in the procedure, so as not to affect other users' selections.

Best,
Helmut

Efraim

Thanks a lot @Helmut Heimann !
It's working fine now. I made the Start Month cube a temporary cube.
Also, I missed the Remove tree step I thought it was only applicable for the week example.

Helmut Heimann

Hi @Efraim ,

the "remove tree" action is necessary and should always apply to the dimension you want to flag. Otherwise the month you selected with the pager would still be the only one ;-)

Best,
Helmut