-
% of total
How to calculate Value/(total value in column), % ------------------------------ Vasily Feofanov Analyst Limited Liability Company "Super Brands" Russian Federation ------------------------------
-
Group Leader Application
Are you interested in taking on a leadership role as a Board Group Leader? Group Leaders take an active and visible role in setting the tone and pace for their dedicated group. As such, we recommend Group Leaders have a minimum of six-months experience with Board software before applying. Co-leaders are also encouraged!…
-
Request a New Group
New Group requests will be considered when an appropriate number of members have been solidified and a Group leader has been identified. For example, a regional Group that is planning to have in-person meetups should have at least 10 customer accounts within a reasonable traveling distance of one hour. Please note that…
-
Group Leader Guide
The Community team would like to thank you for your interest and welcome you to the role of Group Leader! This role is an exciting leadership opportunity to bring together Community members around shared interests and geographic locations. Share tips and tricks, best practices, news, and accomplishments—all while providing…
-
Level 200 Module 207: Build a Data Model and Capsule Procedure to increase the CY budget by 5%
I might have missed it, but I think the instructions are missing the part where you should multiply py actual * 1.05 to get current year budget with 5% increase. In Level 200 207 shouldn't this have Set Expression to a*1.05? In the "MAIN" group, create a "Data flow" step, in "CONFIGURE LAYOUT" use "ACT - DF - Sales LC" as…
-
Board manual
Why is it that if i wan't to read about a specific feature (how something works) i need to read it at the release notes and not in the actual manual?
-
Default setting for Relationship
Hello, When there's a parent missing to a child, the Default button becomes visible. But if there are no errors, you won't see the button. Is it possible to set the Default mapping for each Relationship from somewhere else, even if there's nothing missing at the moment? Thank you
-
Hochrechnung der Umsätze
Darf ich hier die Frage stellen, wie ich anhand eines Screenergebnisses einer Datenview automatisiert hochrechnen lassen kann? Ist sowas möglich oder nur wenn ich es ins Excel bringe?
-
Level 200: Module 206 Copy PY Actuals to CY Budget
Hi there, I am having issues with my procedures to load CY Budget from the PY Actuals. The capsule procedure begins successfully, and can see it actions the data model procedure as the timestamp updates. However, the data flow step in the Data Model procedure does not appear to run successfully, and I do not get the…
-
How to structure cubes with slow moving hierarchy
1. Abstract A common challenge in a Board Application is to fulfill the request of tracking changes in hierarchies, which by definition are the current snapshot of a relationship. This article describes how to keep track of the historical situation using a cube and dedicated entities. 2. Context Since a hierarchy in Board…
-
Missing child in Relationships
Hi, I'm trying to create a dashboard on ESG Net Zero Emission. I've picked only a particular worksheet (1a_RM_&_pack_calc_1.csv) and created entities and built relationships for them, but after running the Data Reader, I'm getting an error on Missing Child in relationships. Thanks & Regards, Kranthikumar Goli.
-
How to read dataframes from R back in Board
Hi! I am struggling to use the R calculation step. What I am trying to achieve is to read back the "output_dataframe", defined in the R script, into a Cube. It is annoying since Board keeps on signaling the R DataFrame is incorrect (marked as red) even if not log statement is displayed, so I am not able to save it and…
-
Drill Actions
1. Abstract Board offers multiple drill options, it’s important to consider the requirements when planning or setting up drill options and to design the solution accordingly. 2. Context Board offers multiple options when drilling into data, which is the right one to use depends on the specific requirements – whether the…
-
Custom Entity Relationships in Time Range
Are Custom Entities only working as a parent to the lowest level? I'm struggling with the "Current Fiscal Year" (red mark). In selection phases (i.e. a screen selection), the selection of the entity member "Current" on the "Current Fiscal Year" won't apply on the child "Fiscal Year" (member "22/23" in this case). However,…
-
How to manage cloud tasks from on premise server - Orchestrator
Hello community i'm going to move to cloud and I know it's now possible execute a board procedure through an API call. Since I have various tasks to copy files to/from the cloud, to be synchronyzed with Board procedures, I would evaluate possible solutions to manage processes that combines batches to transfer files (with…
-
Level 200 training - Is it possible to please resurrect my training environment?
-
Lack of Agility
Agility implies the ability to change course when it makes sense to do so by observing changes in our environment, responding to what we know, changing circumstances, examining, adjusting frameworks, and restructuring approaches to do so quickly and inexpensively. Agility is a core driver and target of outstanding…
-
Board Academy Level 200 training environment setup error
I am getting the following error when trying to setup the Board Training Environment for the Board Academy Level 200: Selected user account does not exist in tenant 'BOARD' and cannot access the application '93cb9be1-06ac-46e9-8cb6-ef5235d40859' in that tenant. The account needs to be added as an external user in the…
-
Selection Options in Procedures
1. Abstract Board technology allows different types of select, static, or dynamic queries. In particular, in procedures, it’s possible to choose between three methods that can seem very similar: Selection (fixed) Select Entity based on Cube Dynamic selection (from the “Select” step) Although they can give the same result…
-
Dataflow common mistakes and best practices
1. Abstract The dataflow is the main action to perform calculations between cubes, it is used in all the processes of the application, therefore it is very important to know how to set up a dataflow in the best possible way, to obtain the correct results with the best performances. 2. Context In this article, we will first…
-
Dataflow mode question (206)
hi - I am working through the L200 course. In 206 / Knowledge Check, there is the question: "What is the purpose of the clear cube step of the BUD - Initialise Budget Procedure?". The course's own correct answer is "The mapping mode on the Cube is set to ADD, which will cause the data to increase each time the procedure is…
-
How to design screens & dashboarding
1. Abstract Screen and dashboard design can at times make or break an application – if screens are poorly designed or unintuitive user engagement can be compromised from the off. There are many factors to consider when determining what constitutes a good design - from layout and ease of navigation to the amount of content…
-
Level 200, Module 205: Sales Planning Procedure
Level 200, Module 205: Sales Planning Procedure ACT - Sales Data Load Data Model Procedure Step: 4 Select "CALCULATION DOMAIN" and in the Extend calculation on new tuple for all members of section, select: "Country" and "Timestamp". Why are we extending the calculation? I am aware that it will open the dense cube dimension…
-
Board 12.6.0.1 : The JOIN function is not supported anymore
Hello, In Patch 12.6.0.1, as per the release notes : Dataflow : The JOIN function is not supported anymore and should not be used in the Dataflow configurations ⇒ Could you please explain if there is a change in the code related to JOIN() function : All dataflow with join() will now fail ? or it is for information purposes…
-
Community Roundup: August 17, 2023
The Community team is back and excited to share with you the new features we've launched and the accomplishments we've enjoyed in the last six weeks! From new tools, to streamlining navigation, to Community member outreach; we've had a busy six weeks of growth and evolution. The new features and Community accomplishments…
-
Measure Totals in Data View: Force to be a sum
Hello Community, I am running an issue with the total value in a data view and wondering if there is an easy way to solve it. I have an example below I want to calculate the $ impact on price difference (column K). For individual row the calculation is correct, not saying the total is wrong but I just want to force the…
-
Best Practices in Writing Procedures
1. Abstract Most probably every Board application will have procedures to cover interactivity by the user (e.g., navigation), perform calculations (e.g., processing plan data) or run other backend processes like creating a backup. To provide the best maintainability, quality, and robustness, some guidelines should be…
-
Level 200, Module 204
I'm at the mapping stage of H - Product Data Reader, and I can only drag the first item over and save. The remaining items (for product, product group, product category) 'bounce back' every time I try to bring them over. Wondering if anybody else is experiencing this.
-
Anyone using version / code management software in BOARD projects?
Hey community, I just saw Bob Gill linking his article World Cup 2018 to a repository on GitHub (GitHub - grobertgill/Tournament: BOARD Tournament model setup for World Cup 2018 ). This is something I have been thinking about now and then but have never tried to do. Is anyone of you using such solutions (GitHub, Subersion,…
-
Community Voices: Nicolas CHIGROS
We are excited to bring you more valuable insights from the ‘Community Voices’ series! This month, we welcome Nicolas CHIGROS—a long-time Board user from Kiwika, an EPM-specialized company and consulting partner located in France. You’ll find Nicolas active in the Board Community participating in opportunities like the…