Dataview

Flex Grid - Opening fully collapsed
Note - Ignore this, found the solution! Is there a way to configure the flex grid so when you load the screen it loads fully collapsed to enhance speed?
Hide specific rows
Hi BOARD Community, I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot. With…
B14: Adjust the DataView Layout Editor - Configure a drill on last block option missing
Hi @Product Management Team, I think it would be great if the possibility to configure a drill action on a block in a dataview was available on every block. The last block in a layout can't be configured due to the "preview" button which obscures this feature: Best, Helmut
Data View Configuration Options : zoom out, zoom in and change the scrollbar size
Hello, I’m looking for more configuration options in Dataview. Specifically, I’d like to increase the scrollbar size and explore the possibility of zooming out, similar to Excel, to view more columns in the table. If these options aren't available, is there any alternative? For exmple, could the Dataview be placed inside a…
Dynamic Data View Block Headings?
Hi, I would like to ask everyone: what options do we have when we wish for dynamic headers in our data views? My client is still in Board12, but we have a Board14 upgrade planned for the near future. Specific issue: the client would like to have a report that has dynamic headers with regards to months and versions. There…
Split&Splat functionality extension to even/repeated distribution
Hi, I wish to have the split&splat functionality broadened, so it is not only able to split values according to the existing proportions, but have the ability to repeat the value, or to spread it evenly onto all leaf elements that are open for data entry. It would be excellent if developers could set what kind of…
Show certain layout blocks as single column, even with entities by column
Sometimes you'd want a certain block displayed as a single column an others displayed per element in the entities by column. This could for example be a budget for the year and than the actuals by month. The way we have always achieved this is kind of an awkward work-around. For the block that should be a single column we…
Hide blank records when Data Blocks alignment is Vertical
Hi Board Team, Normally, we will use the FILTER to hide blank records. But once I changed the Data Block ALIGNMENT to vertically, the filter is not working any more. How can I hide blank records when Data Block alignment is vertical? Thanks My Axis properties are NOT selected as Show all. Thanks a lot
Selection of values in a block based on another block
I would like to offer the following functionality and wonder if achieving it in Board is possible. As per below table, for each line item the user would categorise the line item with an object Type in block b. This is a block of type entity where user selects the object type from the dropdown. Based on the selection made…
How to use Nexel to select custom time periods
1. Abstract While conducting reporting, the essential requirement often arises to compare data across various time periods. This article introduces a method that enables users to choose a specific custom timeframe directly on the screen. Using a designated cube, users can dynamically select pre-defined custom periods. 2.…
Add the option to vertically align column headers
Hi Team, whenever we build screens for presentation purposes (this applies to other screens as well, but the setting is of much higher value in presentations), we notice the behaviour that column headers for blocks using "detail by" or where the block's heading is set to "@selection" are not vertically centered but rather…
Improve formatting capabilities for Unbalanced Hierarchies in Row Templates
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
Enable Data Entry on Flex Grid
Greetings, A good idea to enable data entry on flex grid. thanks
Data Entry performed - make the information about pending changes available to developers
The trigger action on a DataView can call a procedure to process any changed values—but, this will allways process the information row by row, meaning that the trigger action will be performed for each row in the DataView that has been altered, and this can be pretty time-consuming. You can, of course, use a label or…
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…
Allow for filtering in dataviews to work alongside aggregated functions such as 'distinct count'
Hi! Currently I believe that all filters in a data view are disregarded when a cube in the data view has the aggregation function - 'distinct count' enabled. We have found a work around (as we were using this to find averages), however this functionality would still be very useful in the future and in other use cases.…
Error On-screen selection (cont.)
We're facing the same problem as this issue, but I have not been able to solve it with the same workaround. I am having trouble because even though I have narrowed down the entities displayed by screen selection, entities that are not selected in the data view are also displayed. I have certainly created paent-child…
how to trigger a procedure from dataview cell based on another datablock
Hello, I know from the Board manual https://www.boardmanual.com/board14/capsules/screens/objects/data-view/using-a-dataview.htm#data-view-drill-anywhere that i can trigger a procedure from a dataview single cell. Drill-Procedure If a Drill-Procedure has been configured on the Data View, select a cell and click the Drill…
Error that table borders are not displayed
Hello. I have a problem where some of the borders on the left side of the data view I am creating are not visible. Please see the attached image for details. The left border is not displayed for industries colored in yellow. In another data view with the same template and settings, the borders are displayed correctly. For…
B14: Properties setup for Dataview
Version: 14.1 (on-prem) The new properties window for Dataviews is an upgrade, according to me. I especially like the color selections under tab Design. What I would like is to move all design options to the Design tab. Table style is more relevant in tab Design than in Data, i.e. you can color the border lines in Design…
Error On-screen selection
Hello, I am having trouble because even though I have narrowed down the entities displayed by screen selection, entities that are not selected in the data view are also displayed. There is more than one user experiencing this phenomenon, and even within the same capsule there are DataViews with and without this phenomenon.…
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
Blocking Data Entry in Grand Total, while leaving data Open for Subtotals in DataView ?
Hello everyone, Any tips on blocking data entry for grand total but keeping it open for subtotals in a DataView? Thanks!
About data view color settings
Hello I would like the text color to be red if the value in the data view is negative, and black if it is greater than or equal to 0.With the settings in the attached image, the 0 character color is gray instead of black, and the negative numbers are also light red and dark red. Ideally, I would like to display numbers…
Multiple Down/Sub Total Rows in a single Data View
Dear Community, I would like to propose the addition of multiple sub/down total rows in a single data view. It would allow for not only a sum row at the bottom of each data set but also an Average row or other analytical calculations that summarize the data. This would give users a more detailed and versatile summary of…
Show Currency/Unit of Measure next to values
we are having since years requirements that we want to show the currency next to a value or the unit of measure next to a quantity. e.g. Material xy —> purchasing order quantity 1.000 M (meters) No consultant was able to show me a solution so far. But I know this working in other tools (e.g. QlikView).
How to see detailed Totals when you have two dimension on rows
Hi, We have a Dataview where we have two entities on rows: Region and RL, like follows: The Total row adds all the rows, which is OK for the region but has no sense for the RLs. Is there a way that I could have the Total region detailed by RL? Thanks
SVG-Icons for Entities
I suggest the possibility to add own SVG icons to entities. This makes it possible to display them instead of or in addition to code/description in selectors, diagrams and dataviews. This option is particularly interesting for grouping entities, workflow entities or other static entities. It is important that these can be…
About Grand Total
Q1. I want to change the notation of grand total to, for example, total year. Is there any way? (Yellow part) Q2. Can I apply the rule to Grand Total? (Green part) Now, I have set the following rules. c=(b/a)%, f=(e/d)% I want to set the same rules for grand total, as shown below. i=(h/g)%

Dataview

Discussion List