-
Dynamic Replenishment Model: Key Calculations & Formulas
1. Abstract Retail replenishment is the process of counting the inventory you have left in stock and reordering the right amount of stock at the right time. In other words, it's the process of ensuring that you always have sufficient inventory in store to meet customer demand. 2. Content As part of the standard Board…
-
About block type
If not a single column is displayed, the header color set in the block expression is not applied. Note that the header rules set in block style are applied. I want to apply the header color that is set in the block formula even when not a single column is displayed. The red frame in the image below reflects the green color…
-
Need to compute percentiles. How to do this in Board?
Hello, For a given set of values we need to know the percentile which corresponds to each value. Cumulated Vertical % does not seem to help but I could be missing something. Say I want to know whether a given cube value is in 75th percentile or better? Thank you
-
Add Smart import to cube analysis and Impact analysis
A simple idea this time : Currently, there is no reference to Smart Imports when a cube make cube analysis or Impact analysis in the DB. We can see the cube is included on a screen, but no reference about where. Sometimes, the loaded cube is also displayed on a dataview and then it becomes hard to see the difference. Would…
-
Maximizing your Board Support experience
Author: Björn Reuber, Community Captain and L3 Support Team Lead at Board. As a support leader with 14+ years of Board experience, one of the biggest advantages I see of our software is that you can do whatever you want with it (great!), but this might also be one of the biggest challenges from a support perspective…
-
Level 200 Module 205 Sales Actual GBP are multiplied by 1.88
The issue is related to incorrect currency conversion in module 205. I encountered the same problem as Eduardo in this thread: Even the incorrect numbers I have are EXACTLY the same as Eduardo's. What I noticed is that the incorrect numbers are multipled by 1.88 comparing to expected, correct results. My guess is, that the…
-
B14: Properties setup for Dataview
Version: 14.1 (on-prem) The new properties window for Dataviews is an upgrade, according to me. I especially like the color selections under tab Design. What I would like is to move all design options to the Design tab. Table style is more relevant in tab Design than in Data, i.e. you can color the border lines in Design…
-
Is there an ETL function for counting row?
Hi, I've got a cube that requires a line reference number as a dimension (from the load table) - I'd like to add a row counter to the ETL in the data reader where this cube is populated, but I'm not sure what the function would be (or if one exists). Does anyone know what the function is or a workaround? Thanks!
-
Yearly Cumulated Value + Detail by Year in block
Version 12.6 We have a MTD cube, with a selector of generic fiscal period (1-Jul, 2-Aug, 3-Sep…12-Jun). I have a block with MTD value with "detail by fiscal year" set and "Tme function>Yearly Cumulated Value (fiscal years checked)". No time entity in rows or columns. The MTD cube contains 6 years - all years are 0 amount…
-
SubHub - Create a new Copy from an existing User
Add the new feature "Copy settings from existing account" to the Users page inside the subscription hub. It enables to create a new account copying an existing record and changing only key data (i.e. account name and email).
-
Input in Thousands - Decimal issue
Hi, We have a Dataview to input plan in Thousands. The column on the right is the input one. And the left one, which usually is hidden, is a the real amount. The right one is the left /1000. And has an invers algorithm, the left is the right x 1000. The issue which we don't understand is the following: we add 10 units on…
-
Error On-screen selection
Hello, I am having trouble because even though I have narrowed down the entities displayed by screen selection, entities that are not selected in the data view are also displayed. There is more than one user experiencing this phenomenon, and even within the same capsule there are DataViews with and without this phenomenon.…
-
Level 200: Module 201: Training instance is completely empty
I have accessed the training instance and it is completely empty. No Data Modules or procedures. I only have a capsule that is completely empty. The next two modules appears to require/expect some level of set up already.
-
Split and Splat doubt
Hi, I have a dataview where Quarters are displayed in columns. In Q2 only two months are open. This dataview has a locking condition based on a cube that points the months that are open I have realized that when I do a input on Total Year the amount is spread on the weight of full Q2 and then this amount is spread on the…
-
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
-
How to remove the AVG letter from the table?
Hi BOARD Team, Under Configure Layout, I calculated a data block by using Average. In the table, it will always show the AVG at the front. Anyway I can remove the AVG letter from the table. I only want to display the number, but not those letters. Thanks
-
Level 300, Module 304: What is the answer for the Question 3:Update the P&L
My answer is 133779319. But it is said 'Incorrect'. Total Income in Total columns is 252,448,539 on my environment. It's same as shown in the example picture. Total Expensens in Total columns is -118,669,220 on my environment. It's same as shown in the example picture. For me, it seems that my answer 133779319 is correct…
-
Running Tasks Details
It would be very useful to see in which Data Model the action takes place within the Running Tasks.
-
Error when pasting Excel range on BOARD Dataview
Hi, We have a Dataview in BOARD, we download it to Excel and we modify a cell of the Table. Then we select and copy the whole table, and when we paste it back to BOARD we get this error message: "An unhandled error occurred (cod_ref:1714663289020)" Do you know what does it mean? How we can do a complete paste of the table…
-
Community Voices: 3 Q's with customer Thomas Ussling
Featuring: Thomas Ussling, Community Captain and Board Lead Developer at Strato AG. Welcome to Community Voices: 3 Q's—featuring a long-time Board enthusiast and dedicated customer, Thomas Ussling. We asked Thomas three questions about Board. Press play to hear what he had to say! Quick reference: 1:25 - What is a key…
-
Possibility to change Account name
I would really appreciate if you would be able to adjust the account name. We use SSO and if colleagues get married we always have to set up a new account, which is effort and also the colleague looses all adjustments, presentations made in his initial account.
-
Quick Layout : Add Flatten Option
Hello, It would be nice to be able to enable or disable flatten directly in the Quick Layout like in the screenshot below :
-
Allow Temporary Cubes to be used in If Then Else action
Quite often specific cubes are created to hold the results of a logical test that can be performed through dataflow. This cube would then be used in an If The Else procedure action to determine the actions to run based on the outcome of the test. Currently, the If Then Else action cannot use temporary cubes saved in the…
-
How to set up SAP Connector Architecture
1. Abstract This article recaps all the options available when we set up the architecture for Board cloud - SAP integrations that require the Board Connector for SAP by Theobald. In the early implementation stage of projects where Board needs to import SAP data, Board architects – or the implementation partner - and the…
-
More 'on-screen tips' formatting options in Board 14
Idea: Add additional formating options for the 'on-screen tips' on screen objects: Font/icon size → allow us to change the size of the on-screen tip button Background border → allow us to change the background border to any color (including transparant) Remove background → allow us to remove background in its entirity…
-
How to allocate with a dynamic driver
1. Abstract In a complex application, we often face the need to perform allocations based on a different driver based on the situation, in most cases it is about cost allocation. We will see in this article a step-by-step example of how to implement such a process. 2. Context Cost allocation is an important process of any…
-
Level 200 Module 209: Build Account Tree Hierarchy, Data Reader Issue? No records were loaded
Hi Team, Create the Account Tree Entities and built the relationships between them. Also Built data readers to load Entities, Members, and to establish Relationships. But when I Run the Data reader(H - Account Data Reader) no members are coming in Account Entity. Please help me to figure it out. Thanks in Advance.
-
The Font Issue in DynaWrite in Version 12.5 and Lower
Hello, I created a RTF cube and use date entry to edit it and use DynaWrite to display the content of the RTF cube, and it looks like the font for bullet point and numbering are different. If you use bullet point, then the font is set to Time New Roman, and if you use numbering, then font is set to Open Sans which is the…
-
Sorting entity members data reader not working ?
Hello I have an existing entity with 300 members that I woud like to custom sort (currently not sorted) . So I have enabled the custom sort options in entity options. Then I have created a datareader with option "sort entity" and in the file txt file I have sorted the members as expected. After running the datareader,…
-
Four tips to maximize value from the Board Community
Author: Helmut Helmann, Community Captain. The Board Community exists to support members in their platform journey. As an active member myself, today I’m sharing four tips to maximize your Community experience. Active participation maximizes the benefits of the Community The value of Community increases as we all…