Best Of
Re: Level 300, Module 305, Product and Driver Mapping Data View Object Dataview Setup
Yes, you're right, @Marcus Smith ! My issue was with the Data reader configuration. Reconfiguring and rerunning it resolved the problem. The second issue was due to the 'Show all' option being checked in the axis settings. Thanks again for your help.
Re: Level 300, Module 305, Product and Driver Mapping Data View Object Dataview Setup
Never mind, I figure it out.
Thanks For your help!
‘Run as administrator’ feature: What you need to know
Featuring: Community Captain Björn Reuber, Product Support Tech Lead, Board
In my 15 years as a Board support tech lead, one of the most misunderstood features I’ve experienced is the ‘Run as administrator’ option for selections. Many people mistakenly believe that it will apply only to the entities mentioned in the step, rather than to everything. I’ve seen numerous implementations based on this incorrect understanding of what is, in fact, a pretty simple feature. Let’s explore together.
If we consider the selection sequence at runtime (learn more), we can simplify this in two different areas—the security selections and the ‘runtime’ selections. Now we can consider that the ‘Run as administrator’ option is just skipping the first part, so only the runtime selections were kept. So, depending on the selection made during runtime, we might get a different result.
Let's consider we have 10 Cost Centers: Cst_Ctr_1 … Cst_Ctr_10, Department (IT, Finance, HR, Services, Production), Country (US, DE, IT, FR, ES).
A user has a security selection on 3 Cost Centers (1-3) and 2 Departments (IT, Finance). Furthermore, I use some tech cubes to visualize the “real” selection and check those with an Administrative Account without selection.
Scenario 1)
User selects Cost Center Cst_Ctr_1, Cst_Ctr2 Department IT and Countries US, DE.
Reset selection on Entity (with run as administrator) leads to following result:
- Country: active selection Cost Center Cst_Ctr_1, Cst_Ctr2, Department IT.
- Cost Center: active selection ALL Cost Center (1-10), Department IT and Countries US, DE.
Scenario 2)
User selects no Cost Center, Department IT and Countries US, DE.
Reset selection on Entity (with run as administrator) leads to following result:
- Country: active selection ALL Cost Center (1-10), Department IT.
- Cost Center: active selection ALL Cost Center (1-10), Department IT and Countries US, DE.
The reason for the different behavior is that we have the security selection AND a user based selection (which is reducing the amount of cost centers).
We also need to consider that the ‘Run as administrator’ feature is only working UNTIL the next selection step (independent on the nature of the select action) OR the next user interaction. Please keep in mind that the Debugger is always considered as a user interaction.
So, if we had a Reset Selection on Cost Center with “Run as administrator” and, after this, a selection step on Year without “Run as administrator”, the security would be introduced again.
Summary:
- “Run as administrator” is always skipping the full security selection (not only a part of it).
- Selection can be done in security and user space at the same time, so this needs to be considered during procedure design.
- Security is re-introduced with the next user interaction OR selection without "Run as administrator."
_______________________________________________________________________________________
You might also like:
Mastering Debugging in Board: A Core Skill for Developers
Enhancing Knowledge Sharing with Attollo Board Compass
Debugging and Favorite Board Features
________________________________________________________________________________________
Thank you, Björn, for sharing your insights as a Community Captain!
Questions? Let us know in the comments section.
Re: 2025 April Badge of Impact
The Board Academy has been really helpful with clear, easy-to-follow content. The certification covers the specifics of board governance well, and I keep learning new things even after going through it a few times. Big thanks to the team behind it! By the way, when's the next certification coming out? I’m ready for it hehe
Re: Virtual Cubes Management
Hi @Andrea Pasqualini, I second the suggestion to allow grouping temporary cubes! As you mentioned, there are times when we have many temporary cubes in procedures, and organizing them into logical groups would be incredibly helpful. This would be especially useful in those instances when someone other than the original developer needs to debug the procedures.
Re: Substitution Formula in message
Thanks Helmut,
I just tried your solution and it still didn't work but I have realised the error was mine.
At some point the default data model changed and it was running off a different one.
The confusing thing is that the debugger was showing the correct selections from the data model associated with the screen (and the model I was intending the procedure run on) but the procedure itself was operating on a different data model.
I appreciate the help nonetheless, I will check this out in the future.
2025 April Badge of Impact
Happy April! This month's Badge of Impact focuses on Board's incredible Academy and the wealth of knowledge that can be gained from it. Our Academy is your go-to resource where you can find courses to enhance your skill and expertise to get results from Intelligent Planning with Board, and we'd love to get your feedback on it as you earn your April Badge of Impact.
Thank you to our fantastic March badge earners for their contributions, @Fethi ZERARA, @Samir Jones, @Mads Meissner, @Nico Weber, @Mindy Waltz and @Karry Schupp. Awesome feedback as usual, and remember that it's never too late to reply to a past month's prompt!
2025 brings big plans for Community Captains program. If you're interested in joining the ranks of our Captains, please comment 'I'm interested' below, and we'll follow up with you directly. If you're a frequent contributor to the Badge of Impact program—you've already got what it takes to be a Captain. Expand your knowledge share, and join the Captains!
Interested in learning more? Check out these recent Badge of the Month/Impact responses:
April question of the month
Academy: How has the Board Academy improved your Board practice?
Added challenge: Call out a specific key learning from the training, or share one of the hardest challenges that you overcame to pass? Share your feedback in the comments and earn yourself the April badge.
And if you've taken, and completed, our latest Advanced Developer course, let us know your thoughts on it below as well.
Re: 2025 April Badge of Impact
The Board Academy significantly enhanced my ability to design and optimize financial planning and reporting solutions. One of the most valuable learnings was mastering data flow optimization — ensuring efficient data transformations and minimizing processing times in complex Board applications.
A key challenge I overcame during the training was handling large-scale data processing while maintaining performance. By applying best practices in algorithm efficiency and cube structuring, I was able to streamline calculations and improve execution speed. This experience has directly translated into building more scalable and high-performing Board solutions in my projects.
Re: Is there a way to only show one direction of procedure link in Impact Analysis
Hi Edward,
I’ve come across the same issue when working with procedure-to-procedure analysis. I usually export the data to Excel for further analysis, but when I want to filter on one direction inside Impact Analysis, I use a simple filter like:
Object Equals "Name of the procedure that contains the call procedure"
This helps me isolate only the outgoing calls from that procedure and avoid seeing the reverse (duplicate) links.
Akrem
Re: YoY Growth Calculation - Dataflow
Hi @Efraim,
As Bart correctly explained above, the "Offset" function will reference a specified number of periods based on the dimensions of your cube. In your case, since the cube is dimensioned by Month, you'll need to set the offset to -12 in order to reference the same month from the previous year for each Month in the cube. If your cube were dimensioned by Year, an offset of -1 would suffice.
Kind regards,
Hamza