Can substitution variables be used in a dataflow?
I have a data reader that is reading data from a database. I have included it in a database process. I would like to add a data flow step in my process to save the @datetime to a text cube. We can then display the correct time that this process last run on appropriate screens to let users know when the load was last run. I thought something like the column algorithm below would work, but no luck so far. Thanks for your help!
Answers
-
-
Hello Bob Gill,
If it still does not work, try also to take off the flag on "high performance mode" option.
ciao,
federico
2 -
A side mark on this.
In older versions (I believe before 10.1): this type of dataflow worked in high-performance mode.
In newer versions: this type of dataflow works only when high-performance is disabled.
Therefore, I would suggest you to immediately deactivate the high-performance mode, even when working with older versions to avoid problems when upgrading the software.
All the best,
Jonathan4 -
Hi all,
you can find more layout algorithms in this article BOARD Layout Algorithm Syntax
These are available to be used both in algorithm blocks and in the dataflow.
Hope this helps!
Ciao,
Gabriele
4 -
It seems this works well for text datatypes, but I'm having a challenge saving the value as a date datatype. My goal is to save 2/1/2018 to my date cube as the last date this process ran.
- The first column algorithm (a) uses @datetime and returns 2/1/2018 6:48:06 PM as text
- The second column algorithm (b) uses @date and returns 2/1/2018 as text
- The third column algorithm (c) refers to (b) and doesn't return anything as a date
- The fourth column algorithm (d) saves a date to a date cube
I've been referring to the substitution formula reference to try and find a way to save the current date to a date cube, but no luck so far. Am I missing something? Thank you for your help.
For now, I'll just use a text cube, but I thought I would pose the question to see if the community can help me learn the right way to do this.
0 -
Hi Bob Gill,
in that case I'd propose you'd use something like <TargetCube> = today() - assuming your Target ist a Date-Cube.
Best Reagrds
Helmut
1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 158 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
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP