-
Saving @Selection_Ex() result
Hi all, We are working on new functionalities for cost allocations, where we will need to store the explicit selection made by the user. This selection can be done on 1, 2 or 3 different trees, containing up to 30 entities each. I don't want to store the resulting selection at the lowest level of the allocation driver…
-
YoY Growth Calculation - Dataflow
Hello, I am trying to create a dataflow that would apply a % growth YoY (See example table below with 2% YoY growth). There would be a data entry say on 2025 and then it will trigger the YoY Growth calculation. I tried using the "Period by period recursion" but it is applying the % growth on MoM. Can anyone please help on…
-
Dataflow common mistakes and best practices Pt. 2
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…
-
How to flag periods between two dates
1. Abstract In some cases, calculations are only valid within a defined time period with a specific start and end date. Therefore, it’s crucial to first identify this period to ensure the calculation is applied accurately. 2. Context Many business processes rely on calculations between two dates. For example, calculating…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
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…
-
Procedure Dataflow
I have a cube at los level and I want to take that cube's values to the planning level of different LOSs. Considering los, sbu, sub sbu and competency are in relation and competency being the smallest and los being the largest. How could i do that
-
Unbalanced Hierarchies - Allowing "selection mode" configuration in dataflow and export
Hello everyone, Yes, this is my first post on the community. Following internal advices and multiple external feedbacks I'm sharing this Idea that seems to never been raised. My idea is to allow a developer to configure the default behavior expected on an unbalanced entity selection, only by configurating option mode to…
-
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??
-
dataflow problem
Hi All, i have a problem with a calculation between 2 cubes First of all, i want update the cube B (5 dimension) using the value of Cube A (2 dimension \the other 3 dimension i used the filter in the procedure) without delete the other part of the cube B. the Algorithm use the cube A and B explained before. The reason of…
-
save quarter value in a monthly cube
Hi all, I have a cube with a Quarter dimension, and I want to transfer the value to a Monthly cube, specifically in the last month of each quarter. I tried with the dataflow but each month of quarter will be populated. I hope you can help me Andrea
-
Speed up procedure development with virtual cubes “on the fly”
Hi @Product Management Team , at the moment, every time you realise that you need an additional virtual cube, you have to exit edit mode, switch to options, create a new virtual cube, save it, save the procedure, switch back to edit steps mode. And only then you can define the new data flow. It would be much better if a…
-
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…
-
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…
-
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 ?
.