Dataview

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…
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…
Data Entry on Total effecting only unlocked months
Hey Guys, I'm just looking for some help on how to optimize this dataview. Right now the view is pretty basic. Block 1: The cube to data enter into, by Account by Month by Cost Center, Locked by Cube in block 2. Block 2: A cube to flag which months to locked, by month. I want to be able to enter a value into the total…
Option to hide automatically lines without values in a dataview
Context Very often in a dataview, we face the following situation: * we want to display a P&L value as a % of sales, in a separate column. * to do this, we configure a hidden columln with a "ReferTo" option on the Sales. * then setup a column with a/b, to display the %. Issue In this kind of situation, if a P&L line is…
Summarising Data that requires Row Algorithms
Hey Community, I've been having trouble working out how to display summarised data that requires row calculations. Below is some samples of outputs that I would like: Example 1: A control dashboard that shows the total of number of accounts matching a certain condition in a label. Getting a label to simply contain the…
Report - Save "Expand/collapse" option
Situation AS-IS: * We have a REPORT with some rows, that are divided into groups * A Screen Selection is applied * We choose to "Expand ( + )", or "Collapse ( - )" only some groups in the report. Problem: * We change Screen Selection * Now, as a consequence of this change in Screen Selection, the option "Expand" (or…
How to rename column title in the Layout || Nexel ?
Hi, The following DataView shows the salary per employee. My last column which is called « Total » represents the average per employee. In the Layout, I change « sum » by « average ». So, my problem is : the result on the display is ok but the title is still « Total » instead of « Average » or something I would like. For…
How to display only one column in a "show-all columns" dataview
Hi all, I'd have a question about to display only the first column (the first month) in a dataview with the entity month in column and the show-all column selected. The dataview is composed of several cubes that I want to display every month, I need the “show-all” cause the data entry must be possible at each level by the…
@Selection_Ex for Multidatabase Screens
When you are actually using the @Selection_ex function on Multidatabase Screens, it is only working for the main database of your screen. It would be creat enabling @Selection_ex for all used Databases in Multidatabase Screens, perhaps that you have to insert the Database Name into the @Selection_ex syntax or something…
Prevent DataView from refreshing/redraw when cell is edited
I want to stop the DataView from refreshing/redraw every time a cell is edited since i have a Save button setup for Saving and other functions
How can I round an input number in the dataview
I have a dataview in which I want sales persons to add the number of quantities that they will sell per month. For this I only want them to be able to enter whole numbers and not decimals. With the validation rule I am already able to set that the number should be zero or higher (so negative numbers are not allowed),…
DataView Cubes not shown by columns
Hi all, I'm showing a cube by Ledger account (By Row) and by year (By Column) for some financial figures. In addition to this, I would like to add a text cube for comments based on Rows (Ledger Accounts). My problem is, that the comments cube is shown for each year when I add it into my data view. But I only want to show…
DataView - Update a column when another column is changed
My requirement is the keep the change DateTime in a cube and this is updated when the user changes another column's value. For example - when the user updates column "A" (Linked to Cube A), the column "B" (Linked to Cube B) should get updated with the current date time
Images/pictures from URL in dataview
I want to use dynamically pictures from URL sources in screens, dataviews, label. The dataview could profit a lot from it - right now pictures used in the Column Algorithm can only reference images out of the capsule. If URLs could be used as a source, much more dynamism would be possible, also leading to leaner capsule.…
ALERT WITH TEXT
Hi community, is it possible have an alert in a dataview with a cube text Regards Andrea

Dataview

Discussion List