-
dataview algorithm block: how to set summary mode to 'no total'?
Hello, I am wondering how to hide the total value in a dataview for a block of type algorithm. This is actually possible for a block of type cube: but i don't see it for a block of type algorithm: Do i oversee some options in the block settings within the layout window ? as a workaround, i play with foreground and…
-
Advanced Smart Import
1. ABSTRACT The Smart Import object facilitates the upload of data (master data, transactional data) to Board. Before, Dataviews with line number entities or CSV blob cubes with export/import procedures were required to upload the data. In addition, a complex check logic (if implemented at all) was required to detect wrong…
-
Enable Dynamic Resolution of @Week in Algorithm Names When Using Block Reference in Data Views
When creating a Data View with block references, dynamic naming using @Week does not currently work as expected . For example: Setup: Data Block A: Block reference to Week 31 Data Block B: Block reference to Quantity for Week 31 Algorithm Block C: Calculates A / B with a block reference to Week 31 and is named Price@Week…
-
Flag total to flag also the memebers even without data
I think it would be nice to have an option in the data entry menu to allow users to fill in all the children of a parent in the layout, even if they are empty. This is useful when you have the parent and children entities by row. This is especially relevant when using the checkbox appearance of the column.
-
Level 200: Module 216: I am not able to scroll down and view the net income, total expenses
I have got all the functional test right but at the end I am not able to view the Net income, Total Expenses and other details. Is there any wrong in my P and L rules, I have attached my P and L rule also
-
History of changes for each tuple
Many other tools (e.g. Anaplan in the example below) offer the possibility to right-click on any cell of any report and "drill-through" on a table containing the history of changes for that specific record. The MVP of this is feature: Would be extremely valuable to increase transparency and explainability for both…
-
Flexgrid: Aggregation Rules definition per Entity members/KPIs
We lack the possibility to define different aggregation rules and levels for different items of the same entity. For example: We have an entity "KPI" We have some Ratios in our KPIs Ratios need to be calculated at the granularity level that is currently displayed on the Flexgrid In Flexgrid, calculations are being…
-
Flexgrid Headers
How can we remove these annoying aggregation functions indication from the Flexgrid Headers? It makes it impossible to fit columns to the needed width without making the header unreadable. I would also be fine with the possibility to wrap the header text. Moreover, the possibility to use @Selection in the header has…
-
Board taking so much time for export text cubes and large size mdb cubes , is there any way ?
Board 14.4 is taking almost 2 hrs for extracting a text or large size mdb cube . Is there any way that i can make extract faster. I have tried using extract cube and dataset both , i didnot found a solution yet.
-
Presentation reports / expandable bar
A request for the bar in the presentation view to be ‘expandable' i.e., so that it can be extended to display the full names of the reports.
-
Limit Drill Down Entities settings library
Board allow to limit drill down entities list in a single data view. It would be nice to have the capability to save such settings (like happen for selection bookmarks) to be used in other data views linked to same database / cubes
-
Year-End Value While Retaining Month Drilldown
Good afternoon, I am trying to create a graph that displays the year-end value. At the same time, I want to maintain the ability to drill down by month and see all the preceding monthly values. Does anyone know a method to achieve this in the graph? Thank you.
-
Flex Grid header colors
G'morning all, Previously, I was able to have different background colors on a Flex Grid header so that text input to the filter box in each column is visible (first screenshot). Now, the header background is only one color which isn't helpful when a user inputs text to filter. Yes, I have matched all colors between the…
-
💡 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…
-
Waterfall Chart
Hi Team, I have created a waterfall chart as shown below. The end user would like to display both the values and the percentages. However, I haven’t found any settings that allow both to be shown simultaneously. I attempted to use the Tooltip feature to display the percentages, but that didn’t work either. Is there a way…
-
Struggle to understand NEXEL
Hi BOARD Team, After reading through the manual, I still cannot understand how NEXEL reference works. In our production system: Active cell is 5.6. Formula is =[@b;-1;*]/AVERAGEIF([@b;-5;*]:[@b;-5;+12],">0"). My understanding: [@b;-1;*] pointing to 7,162. Is it correct? [@b;-5;*]:[@b;-5;+12] pointing to Demand layer for 12…
-
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…
-
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…
-
Representation of a diagram
Hello everyone I have the following initial situation (see also the attachment): I want to create a chart in which I have to expand a cube after an entity, but not the other cubes. I solve this via detail by on the cube in the layout. However, the problem is that I want the values of this expanded cube to be displayed…
-
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…
-
Question about Label
Hi all, I'm trying to figure out how to cancel the label's animation. I'm using the label to partially cover an image by adjusting its opacity, but whenever my cursor hovers over the label, it lights up based on the label's color. before and after do we have other Object to use it or some setting for the label? thanks 😀
-
Account Set up
Hello Community! My boss/Board expert just left, and I have a simple question for your experts out there! Where can I go to see how an account is calculated in the P&L? Thank you for your help!
-
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…
-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
-
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…
-
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.
-
Adding Blank Rows that Mesh with Block Format
Hello! I'm working to enhance our current P&L report to improve vertical readability. I'm doing this by adding "Blank" members to the entity used in the by row configuration underneath key metric milestones (ex: Total Rev, Total COS, GP, etc.) No problems there; However, the formatting is clashing with block format since…