Dynamic Selection on Time Period Question

Alan

Hi,

I have a question regarding report selectors. When you go to the selector and select a time period say "weeks" you are able to click "Dynamic selection" button. This option allows you to show "Enable Dynamic selection" on current date or based on cube with option of period, year to date, previous period and offset. However, it doesn't let you do a period range say last 13 weeks.

How do I do a dynamic selection where it is" current date" and I can get the report to show the last 13 weeks of data? so i select current data and then the selector knows to select this week plus the previous 12 weeks.

We have a report that we want to have an auto email send but we need to have the data show the last 13 weeks but we can't figure out how to do this automatically and are currently manually updating and sending the report.

I am not technical so if we need to do something with a cube can you provide instructions for v12?

Thanks,

Alan

Sudeep Palkar

Hi Alan,

Currently there is no way for a "native" range selection of a screen. If you would like to work with a range, you always need to select individually entities (using cube selections or custom time entities).

You could build the following simple procedure to flag the cube for 13 weeks (current week + last 12 weeks)

For demonstration, I have used two cubes, both by week.

1st cube ‘Week Flag’ can be flag for the current week using step 3 and 4 (In calculation domain, check on extend on week)

2nd cube ‘T Week’ can be flag for the start of the time range i.e. 13 weeks back from the current week

Step 7 DF will flag the 13 weeks that could be used for dynamic selection weeks

Final outcome

Hope this helps. Let me know if you need any more details.

Regards,

Sudeep Palkar

Alan

Thank you for this information and steps. Questions.

1. Will this be automatically updated every week or do I need my admin to turn on a process to rerun the procedure every week?

2. when I add this to my reports do I add it in the "Layout" or in the "section" as part of the "dynamic selection" where it has an option to pick a cube.

3. Is this a feature that will be added at some point? would be super helpful.

Thanks,

Alan

Zayaan Wasif

Hi Alan,

Looking at Sudeep's solution, here are my thoughts on your inquiries :

1. The procedure will need to be executed every week in order for the correct weeks to be flagged based on the current week. There are multiple ways to automate this - you could use the Task Scheduler tool found in the Cloud Admin Portal of your environment in order to set a weekly cadence at which this procedure executes. Alternatively, if there are any weekly data loads and/or batches that are already scheduled to execute, you can also add a 'Call Procedure' step to those that runs the above along with the weekly batch. Additionally, if users will be using a label to navigate to the screen where this layout exists, you can place a 'Run Procedure' step on that label/button so clicking on it executes the procedure before taking the user to the screen.
2. You can add a dynamic selection to the screen selection - a dynamic selection on the 'Week' entity on the 'Week Flag' cube should flag the relevant weeks. Layouts on the screen would update to reflect the flagged weeks accordingly.
3. I can see how a more dynamic built-in approach to flagging certain time-ranges would be useful - I'd suggest making a post on the Community Idea Exchange (https://community.board.com/categories/idea-exchange) - the Product Team monitors the Idea Exchange routinely and if an Idea does gain enough traction, it may be considered for a future release.

Let me know if you have any questions!

Alan

Thank you