Layout

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"+"…
Procedure - DataFlow - Algorithm of dataflow (c=a*b) should show the headings of source blocks
When editing the blocks of a DataFlow LayOut, it's possible to set headings to each blocks. When saving the DataFlow, the heading of the target is displayed in the algorithm / detail, but not the heading of the sources. It could be usefull to have the headings set in LayOut for sources as well.
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…
Snap to grid option for screen design
I'm sure this has been suggested before but I haven't been able to find anything on the exchange. Myself and many of my colleagues have expressed frustration in getting objects correctly aligned. Is there a chance that a 'Snap to grid' feature could be added in future builds? Similar to how a tool like Figma (or other EPM…
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…
edit multiple blocks in a layout
have the capability to apply some setup to more blocks at the same time e.g. I have 4 blocks and I want to set 2 dec for all of them: I have to open once at a time and change setup 4 times. It would be wonderful have the capability to select more blocks and apply the same setting in 1 shot. The same in the block formatting…
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.
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
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…
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…
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.…
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…
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…
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…
Algorithm not working on a layout
Hi everybody! I am trying to figure out why a chart that I see normally on the Client does not show up on the web. When I try to load the layout it shows the message:" Oops! An error occurred". I tried to remove the two algorithms I have in my layout and without those, the chart is loaded without errors. The algorithms…
Extract Layout to Text File with Header
Hi everyone, is it possible to insert header using the function Extract to Text File? The file .csv comes out without them, but just with values and I can't find the possibility of insert them! Thanks, Federica P.
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…
Does labels using layout, ignore the format define for the displayed block ?
Hello, I need to display percentage in a label but using format to add a symbol after doesn't seems to work. I've got the following setup : The result in the label has the 2 digits unlike if used in a dataview and more important has no % symbol after. Is this combination of two features no supported?
Layout Script Tab and BQuery Macros
While exploring BOARD, I turned on the Show layout script tab feature to see what that's all about. This is under Board...Board Options. After enabling the feature, I noticed the BQuery tab show up on each of my layouts. Exploring more, I found the articles on BOARD Excel Add-in Functions and VBA Integrations.pdf and BOARD…
can we get checkbox count when data entry enabled without saving into the cube?
I have a layout enabled with data entry. when i select or deselect checkbox till i manually save/undo my backend procedure won't run . what i expected is when i click on checkbox ,my backend procedure should run on the fly and should display my count on how many checkboxes selected. right now count value is 10 and i…
Dynamic ranking functions in dataview layout
At the moment the ranking functions are computed once for the dataview and only recomputed when the screen is refreshed. I'd like to have them dynamic. They should be updated whenever the sorting is changed by the user. So the cumulated values are computed as expected by the user. That would also allow finding out whether…
Data entry and layout performance
Dear All, I have 2 questions about Layout. 1. How can enable data entry for the black cells, do i need to fill something in the back cells then they will be enable to edit. 2. When i put 3 different entities ( no relationship between them) in the row of Layout. It takes a lot of time and sometime i can't wait. Does anyone…

Layout

Discussion List