-
How can I flag all periods between 2 dates?
Hi, I need to load some discount values from a table in SQL but the table does not have a month column. Instead, we have 2 separate columns; for Start Date and End Date. In normal circumstances, I would just take the last value from each of these dates and subtract the two lists, leaving me with the period between being…
-
Calculate data flows on GPU (ILGPU)
With machine learning, for example Tensorflow, it is possible to perform calculations on a CPU or GPU. Powerful GPUs are often used for this in order to achieve a significant performance gain. Idea: Calculating data flows in Board using a GPU. I could imagine that this is possible using ILGPU. ILGPU is a new JIT…
-
Nexel when transitioning to Web Capsules
Hi, I'm having an issue with existing Nexel layouts transitioning capsules from Client to Web (now on Board 10.7) - every time the procedure is ran (which includes 'Save data entry' step) Nexel doesn't save to the cube anymore (it only contains the values we prepopulate the cube with to give us a base). My current work…
-
About the steps marked "Call procedure" in the procedure
Hello. When I executed a step within a procedure that called another procedure, the message in the attached image appeared and the step was not executed. I put the steps of the procedure I wanted to call in the procedure that was calling it, and the procedure ran without any problems. Why does this error occur? If anyone…
-
How to extract entities in code with cube extraction
Hello. I'm currently failing to reload the data because the input data in the cube is extracted with the description rather than the code. I think the problem could be solved if the data could be output in code. I would like some advice as I am currently facing this issue and don't know how to resolve it. I'm sorry that…
-
How to loop procedures
1. Abstract When developing business logic in board applications it sometimes becomes necessary to perform calculations individually for each Member of an Entity. In Board, this can be achieved through different means. This document is to review different methods of “looping” and their use cases. 2. Context During the…
-
dataflow with factor cube having less dimensions than target is not considered in text algorithm
Hello, I try to transfer text comments (no rich text) from one cube to the next one "filtered" by some matrix cube. This picture shows the dataflow factors (two factor cubes, one target cube): The target cube has 8 dimensions. These 8 dimensions are partly present in the factor cubes: cube a: 7 out of 8 dimensions cube b:…
-
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…
-
How to use period by period recursion
1. Abstract This article will highlight the advantages of seamlessly incorporating a native functionality, like the “Period by Period recursion” function, within a business context. It illustrates how this integration simplifies tasks, boosts scalability, and optimizes maintenance, providing practical insights for its…
-
Level 200, Module 209, Build Actual Expense Data, Step 16
Hello Board Academy, I've started to have problems at the step 16. After the sub-step 'Run the "2. Publish Data" Procedure twice, in Play mode, for each "Country". (use the Country selector)' I have an empty Data View object after clicking on '2. Publish Data' label. I've checked everything, and I didn't find a mistake.…
-
Dataflow Algorithm Visibility and Optimization (HBMP / Tuples ...)
Enable users to visually inspect dataflow algorithms in the procedure without executing the entire process and reviewing database logs. Additionally, provide automated suggestions for optimizing dataflow performance based on usage patterns and efficiency opportunities. This feature enhances performance management within…
-
Data Flow functions
I would suggest two new functions in a procedure Data Flow. A setting in the step that would make the dataflow work similar to the Data Reader setting "Replace Time Slice". This would sometimes reduce the need to pre-clear the cube before repopulation in the datafloe. A setting in the step that would mimic the Data entry…
-
Data flow: Copy cube down to a more granular one
Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one. The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be…
-
Temporary Entity
Just like we have temporary cubes in procedures sometime we need dummy entites of one or two members may be more depending upon calculations, so like temporary cubes how about having temporary entites??
-
Calculate difference between two dates?
Hi there, I am trying to calculate the difference between two dates as part of a dataflow, which has previously worked, but is no longer working after the 12.6 update. This is a smaller subset of a larger calculation, but have narrowed down the issue to be related to the dates. You can note below the cubes have different…
-
Procedure - DataFlow - Algorithm of dataflow (c=a*b) should show the headings of source blocks
When editing the blocks of a DataFlow LayOut, it's possible to set headings to each blocks. When saving the DataFlow, the heading of the target is displayed in the algorithm / detail, but not the heading of the sources. It could be usefull to have the headings set in LayOut for sources as well.
-
Transferring data directly from one database to another
Situation: Assume that planning takes place in different databases for various reasons. Now the results of the planning are to be merged into one database. One possibility is to extract the data from the planning databases into a CSV and read it back into the reporting database. Request: It would be nice to have a function…
-
How to manage BoM explosion
1. Abstract For the production of an item, different materials/ingredients are used. For the production of these materials/ingredients, other materials are required. In the BoM Explosion, all materials of the different levels are written to one level. This article describes an approach within Board – based on a project…
-
How to flow data among blob cubes using dataflow procedures ?
.
-
Split a Yearly amount in Months according to Start Date and End Date
Dear All, 'Hope you're fine! I'm looking for splitting a full year amount between months according to a Start Date and End Date. For now, I identified 4 cubes: see below. All cubes have the 3 dimensions: Scenario / Company / Product Full Year amount (single: at Year level) Start Date (Date: at Year level) End Date (Date:…
-
Latest Value Per Month
I have a cube by Employee, Cost Center and Day. I would like to populate a cube which is by Employee, Cost Center and Month with the latest value (as close to the last day of the month as possible) for each Employee, Cost Center combination as shown by screenshot. Doing an extract reload unfortunately does not work as…
-
How to do multi level allocation
1. Abstract A Multi-Level cost allocation is an important process of any business, it plays a huge role in the decision-making process, and that’s why we must design it in the best possible way. The Multi-Level cost allocation consists of applying a classic allocation but with the possibility that an element can be at the…
-
Allocation with Board
1. Abstract Board is a great platform for building a planning and budgeting model and it accommodates large and complex allocation models. Board can process a lot of data in a short amount of time. The platform is also very flexible and allows the full customization of your allocation model. 2. Context Board is a great…
-
IF THEN ELSE
In the if-then-else step in procedure, A feature can be added where we can compare the value of two cubes instead of just numbers. It might save lot of efforts.😀
-
Net Present Value
Hello, I've been trying to find documentation on the Time Function Net Present Value - what it does and how it works. Can't find any documentation. The function seems to be available in a Dataflow, but not in a Dataview. Do you know? Thank you
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…