-
Mandatory dimensions / consistency checks in quick layout
Context - When designing data entry screens, we are often in the situation where we want to give a maximum flexibility to the end user to choose the most relevant axis. Quick layout is great for that. Issue - However we often have the situation where at least one dimension is mandatory, otherwise figures don't make sense.…
-
GeoMap improvements
compared to geo maps in other bi tools (Qlik, Tableau etc.) - the BOARD object is way to clumsy and underperforming. More design options like have a kind of head map per country/region instead of bubbles. Also more available maps (not only google maps and one other) would be great.
-
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…
-
Master Layout : Add option to ignore a master layout
My Idea : Add the feature to "Ignore master object" for object like dataview / graph etc… My Context : Currently when designing a screen for an object to ignore a master layout you have to set a selection directly into the layout of the screen. However that doesn't allow users to view data matching their screen selection…
-
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…
-
Reporting Layer: Optimize a report
1. Abstract Users are more and more demanding and are looking for the right balance between the correctness of the result and the scalability of the solution at the same time. Improving response time has always been a top priority, therefore the purpose of this document would be to explain the main best practices to apply…
-
Order of filtering in Layout Selection window overrides Custom Sort order ranking on Entities
Hi, I noticed that my custom sort for this entity was not being followed on the data view the way I ranked it in the data model (image 1). It took me a while to realise, but I wanted to make it aware that the order of ranking in the layout selection window overrides the Custom Sort. This is misleading. I believe the Custom…
-
Hardcode 'down total' formula to prevent it from referring to another block.
Hi, I've been having an issue where my 'Sales Mix (%)' calculation refers to a moving block from the layout, instead of maintaining the 'down total' function. To calculate 'Sales Mix (%)', I am using the algorithm: (Sales/Down Total (Sales))*100 or c/dt(c)% in the below example. The issue I am having is that the data view…
-
Add setting to allow horizontal display of "@Selection" substitution formula
In the image below, I'd like to display all of the selections horizontally on the grey banner, which is not possible using the substitution formula "@selection". Current workaround is to create multiple labels for each entity selected (8 in this example) and individually place them side by side on the banner which can be…
-
Excel AddIn Documentation
Hi Boardies We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible. The problem is following: A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should…
-
Is it possible to add a "+" symbol in front of positive values?
Using the image above as an example, is it possible to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? (as this is requested in multiple views) I understand it's possible to add a prefix in block formatting however that wouldn't recognise a value as <>0 so it would place a"+"…
-
Feature to add a "+" symbol in front of positive values only.
Currently this can only be achieved by using text algorithms, which can be very time consuming and difficult to manage across multiple screens/objects. Using the image below as an example, can we add a feature to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? I understand…
-
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…
-
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.
-
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…
-
WEB configure Layout : authorize copy of block and change of cube
Hi all, Maybe somebody else mentioned this already but just to be sure... we are currently testing and explaining to some key users the benefits of version 10.5 for the configure layout in the web version. Two key features of the client are missing : * the possibility to copy a block to a new block; * the possibility to…
-
Why do my Excel Layout connection disappear?
When using the Excel Add-In and create layouts within my workbook, when re-opening the workbook with er file gets corrupted or the layout "disappears" and I have to recreate it. Has anyone else seen this issue? / know a way to solve? Thanks
-
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…
-
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…
-
Error messages in layouts more explicit than "Oops"
Hi all, Context & issue: A few months ago, we implemented a limit on reports known as "Rows Upper Limit" to prevent users from overloading the system with too big queries (usually, addind all axis of a cube to extract everything to excel...). Due to this limit, sometimes the users have a "Oops" error in their layout, but…
-
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…
-
How To Add New Entity Members From Data View On HTML5 Client
To enable users to insert new entity member without letting them access the databade, I used to enable the option insert new member from the settings of a data view. This option then allowed me to click on the insert member button at the top left corner of the data view and then insert the new entity member as shown here…