Dynamic selection in procedure
Hi Community,
I'm struggling with a procedure I'm creating.
I ask the user to select a month and I do a dataflow using this month.
Then I need to get the month following the selected month if not December. I'm not sure how to do that.
Could you help me please ?
Answers
-
Hello Aurore Lb,
If you are using the standard Time dimensions, I can see 2 solutions in you're dataflow:
- in the block you want next month, you can use a positive offset in the Time functions tabs to get the next month. However December will get you next January. You may use a entity column and a column algorithm with an "if" statement if you need to get a different value for December.
- An alternate solution would be to use a Dynamic Offset in The DataFlow process. In that case you need to load a cube with 1 for each month (expect maybe december)
Regards
1 -
Hello Aurore Lb
i think with first solution suggest by Nicolas CHIGROS you don't have problems, because you can use 'if then else' in 'GoTo' tab of Configure Action in the procedure.
In 'if then else' you can use a 'REFER TO SELECT', so you can select all month without December and call a group with the offset of month, else call a group without offset.
Regards
Andrea
1 -
Hello Nicolas CHIGROS and Andrea Florio,
Thanks for your answers.
I managed to make it work with the 2nd solution. I created a flag cube with dimension Month and 1 as value except for December.
I then put an if-then-else statement checking the value of the flag cube for the month previously chosen.
If the value is 1, the procedure enters in a group where there is a dataflow using the dynamic offset on the target cube to select the following month.
About the 1st solution I didn't manage to use the period offset function on the target cube.
2
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP