Dataview

Enable Data Entry Lock on Grant/Group total to work onDataview with more than 2 Entities in Axes
Hi Team, It would be really great if the Data entry lock can be enabled for the Group Total or Grant Total cell. And the Split and Splat should work on the the group level first and then to the individual cells. Currently even if you lock 1 total on the lowest group total, then the entire group/Grant total is disabled. In…
Search Option in Dataview should not results into disabling the number scaling
Hi Team, Currently, when using the Search option on a Dataview, it filters only that row, and simultaneously, it disables the Number scaling. As the number scaling option can be changed by the user, the disablement of Number scaling upon the use of the search option should be avoided. Additionally, as you can see, the…
Customization on "TOTAL" Cell
I believe it would be helpful to have the ability to customize the word that appears in the bottom left cell of the data view, or usually the "TOTAL" cell. When nexel formulas are placed in the grand total column, this bottom left cell automatically changes from displaying the word "TOTAL" to "SUMMARY". This can be…
Axis properties in Data View - Members display
In a Data View, the following options to display the members of an entity exist per row and per column: Default, Code, Description, Code and description. In addition it would be helpful if this could be selected per entity if necessary.
Detail By - Column Headers not showing
Hi all, I wonder if anyone has any experience with the detail by column names not appearing? In the example below I am detailing by this entity "Hub Source Stock Location" and the screen has 3/10 selected currently. In my dataview, I am able to view the 4 columns (which is correct, the 3 from the selection and a total…
AutoFill on Dataview Columns
Hi! I was wondering if we could add a Fill Handle (similar to Excel) that would allow users to easily enter data in a multiple of cells within the same column, without the need to use lock and spread. This would work similarly to the (>) keyboard shortcut that already works for filling a row in Board > Fills cells to the…
Update decimals numbers
Currently it is possible to display 2 decimal places, although the tool has many more loaded behind it. The problem is that if when updating a number, the first 2 decimals are the same, but it changes from 3 onwards, Board does not update the number because it considers it the same.
Linking Scroll Bars - DataViews
How can we ensure that dataviews move simultaneously together if they are of the same width ? For example I would want the 3 bottom columns to move at the same time as the top as they are linked, but as it's 3 v 1 it tends to go out of sync.
Separating Code & Description - Axis Setting
I was wondering whether it would be possible to add an option to separate the code and description of entities added to the axis setting. With the hack mentioned in this post, the sequence of the breakdown of the data via the entities is not respected. Currently I am using the code setting in the axis setting and adding…
Ability to have the vertical border showing on the groups headers
currently it is not possible to see the vertical border on the groups as they are header borders. Ability to have this vertical border across the entire column
How to dynamically display the user selected value when a data view is set as master object
On the left I have a P&L hierarchy driven report set as master object. When I click on a row, the charts on the page change. I would like to display the current row that was click on in the master object. Trying this, no luck: @Selection_Ex(Layout="P&L", Block=" ") Version 12.6 Thanks! Matt
Drill Anywhere Options: "Drill To" vs "Go To"
1 . Abstract The Drill Functions provide several interactive options, which are: Drill anywhere, Drill-down, Drill-to screen, Drill-procedure. In design mode, interacting with the ‘Drill-to screen’ feature, either in a Data View or in a Chart, there are some notable differences regarding ‘Drill-to screen’ and ‘Go-to…
Number Scaling - formatting options
The new function is pretty good - but it would be really good, if there would be some formatting options for the number scaling —> e.g. k instead of K or T instead of K etc. Also deactivating the suffix would be great - so just having the value without K/M/B
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…
Data Entry in column
in long tables we have have an option of using ">" for multiple data entry for each row how about an option to enter multiple data in each column????
How to convert Board tickbox to a flag in Excel
Does anyone know how we can convert the tickbox column from an xlsx file into a binary flag? When I make column b = a, I get the same whether the column is empty or not. A user exported the file so I'm not sure if they can enter the layout to change the column appearance. Thanks
IBCS Standards
I would like to suggest to enrich the dataview and graph settings to help building a BOARD application using reporting standards as suggested by the IBCS® standards (International Business Communication Standards). These standards aim at providing a consistent reporting set for the user, so that he can very quickly know…
How to move columns in Reports?
Hi, I need to build a report where the row entity is in the second column. So in essence I need to show actuals data then the row entity then the rest of the columns. What I have tried was to bring in the row entity into the layout section of the report but noe any template styling is not applied to the entity. See the…
Using Unbalanced Hierarchy and standard entity together
I have an unbalanced hierarchy ( P&L Reporting) which has multi-levels Level 1 — Level2 — — Level 3 Another entity is Account which has all the base-level accounts in it. Level 3 of the unbalanced hierarchy is linked to the Account entity where multiple accounts have a relationship with a single Level 3 member. I have a…
Do not replicate entities when we flatten the entities by row
When we have multiple entities by row and we flatten at a certain level, we would like not to replicate the members of an entity and merge the cells with this entity, as in the image attached.
Maintain cursor in the selected dataview cell after screen refresh
In large dataviews with many columns, when a user has a cell selected (in one of the columns to the right after scrolling the dataview), we would like them to be able to run a procedure from a button, and that after a screen is refreshed, the dataview would not jump back to the first column, but would show the dataview as…
Enhance Excel-Addin Layout Execution
In last couple of releases export functionality was taken to the next level. Bulk data export via Bulk Insert, Export Dataset or even via the API interface now make it possible to export more than just an ordinary layout. It would be great if this kind of layout execution could be adapted for the Excel add-in as well, so…
How to rename the detail by Column Headers?
Hi, As seen in the image below we have a data view with a column that is detailed by year. What is happening is that because we are using detail by Year in the second column, "Prior Year Of 2023", The problem is that, that column is looking at 2022 data. So we need to remove the 2023 out of that column. How can we do this?
Identify level of unbalanced hierarchy members in a dataview
Hi all, is there a option/variable etc. to identify the level of unbalanced hierarchy members (set by row) in a dataview? Example: Entity Sales Level A 100 1 B 50 2 C 50 2 C1 50 3 Thanks for you help. Kind regards, Atilla
Can´t export flat data table
Hi, since a few days we can´t export all views into a flat data table. Only a few views can be exported as a flat data table. At all the other views the option is missing by "Export data as xlsx" . We didn´t make any updates. At the moment we use the Version 12.3, Revision: 1.1.71740. Anyone know this problem and has a…
Add all entities to the Quick Layout?
Hello, Is there a way to add all entities, used in the related cubes, to the Quick Layout? So far I have only managed to add one entity at the time. This gets very time consuming when you have many Data Views. I saw a post in the Idea Exchange, suggesting the possibility to add the entity hierarchy. That would also save…
"Expand Above" in Data View
Hello, Version: B12.6 In data views with more than one entity per row, headers are automatically added for each entity used. Like so: However, if we want to have the summation going [b]down[/b], a subtotal at the bottom is required. This means that we end up with an empty header row, which just takes up space. My…
Enhance the DataView Layout SORT function
Currently DataView layouts can only sort by ONE block/entity. It would be helpful to be able to apply a sort using several blocks. For example, where a client's data has 3 levels - eg Site, Floor, and Work Area and you wish the report to sort by Site, then Floor then Work Area descriptions, and the date the Work Area was…

Dataview

Discussion List