Dataview

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
Dynamic validation for data entry
I am trying to figure out how I can create a dynamic drop list for data entry on a data view. For example: An Entity gets flagged for the creation of an incident. Once flagged, various input information is required - namely: Incident Type, Incident Category and Incident Sub Category. A user is required to capture this…
Best colour for BOARD data input cells in a DataView?
I'm looking for opinions as to what colours you think are most appropriate for BOARD data input enabled cells in a DataView. As most BOARD users are probably aware, the default is a pale yellow (R255 G250 B205) background with a black text: You can of course change this default within a capsule and copy the formatting…
Disabling data entry on totals without disabling the total display
Hi all, Everything is in the title: I'm looking for a way to disable data entry on a total without removing the total itself. The dataview is a basic table to enter data at the physical cube level (no use of split & splat), and we would like to display the total of 3 lines without letting the user modify the total directly…
Keep some columns visible while the dataview scrolls
Hello, I was wondering if it is possible to freeze the first columns (cube blocks) in a dataview when scrolling ? I Have a cube detailed by month (For 5 years) and I wish to keep the total column visible. Thanks in advance
How to use block created in formula editor as a cube ?!
Hello there , I was just wondering if i could use a block created in formula editor like a cube, for example, 1. as shown in image below, i created a Block called SingleRule_Block, 2.Now i went to Layout and created a C block with Column Algorithm as a/b 3. Now when i see in the DataView, block C does not show me any…
Fine tuning Set-Trigger on DataView
We have a dataview with (for simplicity sake) 3 blocks in the layout. Each block has data entry enabled. Dataview has set-trigger defined - this procedure is executing some logic/flows with the new numbers. The logic in the procedure is assuming the that all 3 blocks have changed and logic needs to be executed for those…
Using selector on dataview with a refer-to
In dataviews where I have used a refer-to to create a sub-selection of a cube (in my example, I'm using a cube of revenue and have a reference for payment method as I want to exclude certain payment methods from my analysis), when I apply a screen selection the column with the refer-to does not have the screen selection…
How to make a line chart show data for one data point?
I am currently building a screen with time selection labels that select different periods of time and apply this selection to the data on the screen. The time labels: TODAY, THIS WEEK etc. work as intended however there is one item on the screen that does not show data when the TODAY button is clicked. DAY is on the…
Incorrect Algorithm Total on Dataview
Hey Guys, Just looking for some insight on how to solve this issue that i am having. Requirements: Has to show full Fiscal year split by months Has to have different heading for the 'actuals' months and the 'forecast' months. Actuals are locked and are only used for reference when deciding what your forecast months will…
How do I embolden the axis column heading in DataView
In a DataView where, say, there is a row for each County (as identified in Layout as an Axes, by row) - there does not appear to be a way of emboldening the axes column heading? Layout data blocks column headings are formatted through Layout\Data\Block\Format. However, Axis entities are not used in blocks, so this option…
Dynamix Axes in DataViews
Hello community, Is it possible to change the entities by row with a procedure? We want to make dynamic axis by using buttons. Kind regards Jonas
Is there an option to choose whether negative values are bracketed or have '-' prefix?
How, in Web or Desktop, can we as developers choose how to display negative values? I've found that in a DataView layout using an entity in Axis 'By Column', the negative values appear in BRACKETS. Elsewhere, where a DataView layout is using an entity in Axis 'By Row', the negative values appear with '-' prefix. It would…
DataView, creating a table help?
Is it possible to make a table as such in BOARD (image attached) Could someone guide me in terms of what I should lookout for the in the development of the dataview. I will have data for the manager, employees, employee targets, current revenue, % target ( which is a column algorithm current revenue / employee target *100)…

Dataview

Discussion List