-
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)%
-
Dynamic and Cube-based Layout Selections
On searching the Idea Exchange there is an old suggestion: "Dynamic Selection within Layout" from 2018 by an Unknown contributor. The Idea received 47 votes - as follows: "A good improvement would be the chance to set up a dynamic selection within Board Layout. This way you should be able to create different infromation…
-
Copy/Paste Individual blocks from a layout
Hi, It'd be useful to copy and paste individual blocks from one object's layout to another, carrying forward any block references/functions applied to that particular block. This would remove the need to duplicate the same work across multiple objects requiring that same cube; making it more efficient to develop objects…
-
Enhancing Data Entry: Refer-To & Layout Selections
We suggest adding the ability to modify data entry cubes in a data view when refer-to and/or layout selections are present. This would allow for: Simplifying the design of data entry templates Reducing the size of the data model as it would require fewer cubes. Implementing this feature would not only enhance user…
-
How to do top-down allocation of an integer value
1. Abstract The article explains a possible method to ensure that top-down allocation of an integer value generates integer details through the redistribution of decimals. 2. Content In this example, we have a cube QTY [Year, Customer, Product] which is planned at a high level [Year, Product, Country] where Country is the…
-
Data view formatting
Hi, I want to format the heading of a Dataview and a I don't find how to do it: I want to get all the blue headings from the below screenshot in green. I have tried to do it through the Block Format but I could only modify what it already appears in green. And I also tried to do it thought the Templates but I could only…
-
Having the Ability to Drill Down When Using Vertical Block Alignment in the Data View
Hello Currently, the drill-down feature is unavailable when using vertical alignment in the Data View. I suggest adding this functionality in the upcoming updates to enhance efficiency and improve the overall user experience. Thanks, Akrem
-
Multiple subtotal lines in a granular data view
We're a homebuilding company and have a granular data view of our Gross Margin Analysis. It lists all of our addresses by community with their respective prices/costs/etc. Currently, we're only able to display one subtotal line for each community. However we would like to show multiple: Total, Average, etc. Has anyone…
-
Select a row template per block to overwrite the row header template
Dear all, It's usual to have a row header format and a column format (for data) that are different. It would be nice to be able to apply to Blocks another format / template than the row headers.
-
Indipendent display mode by each entity in axis
It would be amazing have the capability to choose display mode (code, desc, both) indipendently by each entity set in the axis thanks
-
Allow more detailed formatting of dataview
Currently the "Block Format" options allow to edit the style of single blocks, headers and total values. However, it is not possible to change the style of some dataview elements such as specific cells and total labels. It could be useful if the developer could, for example, set the "total" dataview labels in bold or…
-
Sub Total to be shown after use of Search Option in Dataview
Hi Team, The said feature should be similar to Excel Subtotal(Array[],9) formula, to show the sub total of only searched Items. thanks, Aniket
-
Excel Clipboard like capability while copy pasting the data from Excel to Board Dataview
Hi Team, the copy paste from excel to Board keeps only the values that are actually visualized into the Excel cell. e.g if you copy cell showing 1.2 into Board, then it will copy 1.2 only. But the cell may have a value like "1.22343242353452". This is the issue when we were working with client where they see data in…
-
Column sorting and filtering for the end user
Hi, it is often the case that Board replaces a previous Excel solution. In Excel there is the useful function that a filter can be placed over the columns with the help of which the user can sort in ascending or descending order. He or she can also set value filters there, for example, that only rows larger > or smaller <…
-
Sorting Rows - Keep Top setting for more than one dimension
We have several requirements with keep top setting AND showing more that one dimension in the dataview. It seems like this function only works as long as there is only one dimension in the rows. E.g. I'd like to have the Top 25 Materials sorted on Sales-Cube desc. on a material level - and as second information I would…