-
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 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 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…
-
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…
-
Standard "integrated" copy function for e.g., Versions, Scenarios etc.
Hi all, it would be great to have a integrated copy function. Use Case: During a planning cycle we want to copy a Version 1 into a Version 2 (Entity in a Cube). Therefore, we have to create a procedure, define temporary cubes without the entity Version, add for nearly each cube a step with temporary cube not dimensioned…
-
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…
-
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…