-
Performance analysis tool to find out why a dataview report loading very slow?
Hi BOARD team, I built a simple data view report using Tab. Couple of tables are loading much slower comparing to others. The table is simple and highly summarized. Is there a tool in BOARD we can use to find out why certain reports take much longer to load? Thanks a lot
-
Level 200 : 210 No Data on Expense Planning Data Views
Hello, I am struggling to populate data into both the Annual and Monthly Data views. I have gone through all the steps again. I have also re-run all data readers and the BUD - Initialize Budget procedure, but my view is still empty, and hence failing functional testing. My currency selector also shows 2/2 instead of 1/1 as…
-
Enable Data Entry Validation Rules Based on Other Dataview Blocks
Hello Community, Currently, data entry validation rules in Board are limited to conditions within the same data entry block. This limits our ability to implement advanced validation scenarios that depend on other layout blocks. I propose adding the capability to define validation rules that reference values from other…
-
Add an comment field for each block inside a Layout
Hi Community, I would like to suggest a new feature for Layouts in Board: the ability to add comments to each bloc 🎯 Purpose: This would help developers document the purpose or logic behind each bloc directly in the Layout, without needing external documentation or complex naming conventions. The comment would be visible…
-
Option to hide automatically lines without values in a dataview
Context Very often in a dataview, we face the following situation: * we want to display a P&L value as a % of sales, in a separate column. * to do this, we configure a hidden columln with a "ReferTo" option on the Sales. * then setup a column with a/b, to display the %. Issue In this kind of situation, if a P&L line is…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
Calculate Mix including Subtotals
Hi there, how can I calculate percentage mix including subtotals? At the moment it is calculated by group. The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years. However I need it by year. Thanks maik
-
💡 Feature Idea: Enable Tooltip Compatibility with 'Detail By'
Hello Community Currently, when using the tooltip feature together with the 'Detail by' option, the tooltip only appears on the total row, not on the individual detailed rows. 👉 Interestingly, when the entity is placed by columns, the tooltip works as expected and displays correctly for each column value. It would be great…
-
Sorting in Data view with Detail by
Hi can someone shade some light into sorting logic with "Detail by" activated? a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview When I move it to spot - b - I can see Occ TY by Year - However now the order of the other columns is screwed. Any idea how to fix this? Thanks Maik
-
Maximum Data Blocks within a Data View
This takes me back to excel days. I'm currently at FD with data blocks and I'm blocked from adding any more in. Is there an upper limit? Has anyone had this same issue or never gotten to this many blocks? Build is in B14.2. I'm trying to add algorithms in not additional data blocks. Doing this with right-click add rather…
-
Issues with 'Detail by' sorting feature
This issue has popped up in the layout editor after I added an entity in the configure drill down. The data is tying out correctly for all my data blocks, the only issue now is when I try to drill down on a specific P&L line. The drill down shows every member in the entity rather than the specific line I am trying to drill…
-
Board 14 - Confusing design tooltip border in layout
Hi, When hovering over tooltips in a layout, a confusing triangle shape appears. This shape can be misinterpreted as indicating additional information about a specific field (e.g., 'Measure Type' in the attached screenshot), which is not its function. Can the triangle shape be removed?
-
Dynamic Visibility of a cube / data block in a data view
Hi, is there any possibility to steer the visibility of a cube / data block in a data view? I want to achieve that I can steer on an admin scree, if a certain cube/data block is visible in a data view on another screen. I know that you can steer the dynamic visibility of the whole data view, but I need it for a certain…
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
Skipped rows of Cube value of 0
Hi guys, I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null. Anyone have some ideas or solutions about this one? Thanks previously
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
Suggestions for Chart and Data View Enhancements
Hi Team, Here are a few suggestions for improvements in the Charts and Data Views: Additionally, when the "Auto-Range" feature is enabled for the axis, the value range adjusts correctly, but in some cases, markers get cropped. It would be helpful to either adjust the auto-range logic to ensure markers remain fully visible…
-
Column Entity Always Show the Total Members and Not Display the Actual Value in Dataview
I want to know the causes of why my Part Number column entity always show the total members and not display the actual value? Did I have some mistakes in mapping my cubes? FYI : Cube (Mixing Ratio)→ Have 3 entities mapped into it (Part Number, Plant FG, Supplier/Cost Center) And here captures of my settings in Layout…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Algorithms
Hi, is there a possibility / syntax to refer a algorithm block (using the formula “rt(x)” or “dt(x)”) to only one or more certain columns and not to every(!) column of the entity that is set in the column axis? Can somehow specific entity members be adressed? I want to achieve that there are different color alerts for…
-
Entity Editor
Dear all, I would like to have an entity editor and a data view - where I enter assignments between the members of two entities using the data entry function - on the same screen. The entity members that are created in the entity editor should also appear on this data view. However, the problem is that only the members…
-
Show/Hide Column Dataview like drill down rows?
I want to know that how can I show/hide column Dataview like drill down rows like this picture below. Anyone have an idea?
-
Data entry on if-function with inverse algorithm
Hello, I have no values in the column HR (Forecast) in some months. I would like to pre-populate these cells with a small number (here, for example, 5) in a new column to enable the cells to be filled by manual data entry. I have used an If function to fill the column: h= if(g=0,5,g). How can I create an inverse algorithm…
-
How to rename or alias header title column Dataview for entities located in axes not in data block?
I want to ask about how to rename or alias header title column Dataview? Because I have no found of solutions about it inside official documentation. Thank you previously.
-
What is the best-practice approach for data entry on multiple years per tab?
Scenario: (Board 12.6) Screen selection 18 months: (October 2025 - March 2027) 3 tabs (2025 / 2026 / 2027), in each of which only the corresponding months should be ready for input Is there an alternative to an algorithm that multiplies the data by a month cube and stores the data input inversely? Cube A (Month): 2025: 1…
-
Numbered Axis
Is there a way to number the axis similar to an excel spreadsheet? Maybe I am missing something, but I cannot find any details on this in the reference manual or on here.
-
Ability to present the dimension flagged in a cube as an output on a block
This may be a bit more challenging but if there was an ability to present the name of the member flagged rather than showing the value of 1 when a cube has more than 2 dimensions. Eg asset 1 is mapped to jan, when asset is in the rows, have an option where i can select "month" as an output in the block settings, similar to…