-
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?
-
Flat data table for enduser
There should be a possibility for endusers to adjust a data table to a flat data table by theirselves. Due to the quick layout (and the possibility to drag several entities in the rows) it might be useful to adjust a "normal" table to a flat data table in play mode for a better overview.
-
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…
-
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…
-
change table/dataview from pivot to flat list
We are regularly getting the question from users if it's possible to change the standard BOARD pivoted table to a flat list. I know this functionality also from other BI-Tools and it would be great if the user can decide via dataview-menu if he wants to have a flat list shown. Default can be still the pivoted view, but the…
-
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…
-
more Comment-formatting/placement options
We are having several management reports (basically P&L structure) which need to get commented by all subsidiaries. This commenting needs to be done in an extra table below the main data view (columns not possible due to a lot of columns and scrolling to the right is not an option). This makes it a bit difficult to find…
-
Rows & Columns - add all entities
Adding possible entities (and its hierarchy) to the Rows & Columns is time consuming. Here are three suggestions to make it less time consuming. Give option to set all possible entities as default in the whole environment. When selecting a Data View in the screen (design mode), give the option to enable all possible…
-
"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…
-
Activate number scaling when using DataView Search
currently activated number scaling (e.g. Thousands) is getting deactivated when you use the search function in a dataview It would be great if the set (defined) number scaling remains the same and is not changing. It's pretty irritating at the moment.
-
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…
-
Broadcasting: Subject, CC, BC and Body
Dear BOARDville citizen, we are not happy with the current Broadcasting function (using BOARD 10.3). Currently we are using Broadcasting to inform our user about updated report/screen in BOARD. For example at the beginnen of each month we are informing our cost center responsibles about an updated report after the…
-
Checkbox column in Smart Import
Hi, I am building a page with a smart import object, and we would like to have a column that is a checkbox. Is this possible? I have not been able to find a setting for this. Alternatively, we will use a dropdown Yes/No picklist, so we do have a plan B, but I wanted to confirm if this is possible or not. Thank you,…
-
How to show the value of different dimensioned cube only in total line
Here is something I have implemented at a customer, and I would like to share with you. It may be helpful when facing a similiar use case. Use case One cube is on a dimension Article and cotains an Order Value The second cube is on Main Class, which is more aggregated than Article and contains a Limit for the Order Value…
-
The Use of Tab Container
1. Abstract As soon as developers face screen creation, in particular, if we are talking about reports or BI Dashboards, where usually a lot of different data has to be shown, they need to use carefully the layouts to avoid any screen object overflow and, consequently, less impactful data meaning. 2. Context In the…
-
rows & columns - control execution button
It would be great if there would be a button in the rows & columns function where the user can start the execution/update of his changes —> currently BOARD is loading every step you make in there - if you made a mistake (choose wrong dimension or pull it into the wrong area) the execution in the backend/running tasks is…
-
Forecast Screen - Show total of an algorithm switching between two cube slices
Hi, I'm currently building a forecast screen. The requirements specify the following use case: the user selects a month and yeear months up to (excluding) the selected month show the actual value months including and after the selected year show the reference value (e.g. budget or estimate) In addition, the previous year's…
-
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
-
"Refresh-Layout - Button" for Presentations
We switched by end of last week to the 12.5. Version, which brought the number scaling functionality. As a workaround we used in the last 2 years a TEC_Divisior-Entity which enabled us already to have a kind of number scaling feature —> BUT: every DataView contained a lot of blocks just for making this possible. With the…