Layout

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…
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…
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…
OPEN A SCREEN WITHOUT LAYOUTS REFRESH
Dear community Inhibit initial layout execution refresh is now possible only in some cases. 1) through a procedure with an action "go to screen" + option "disable initial layout execution" or through an "On open trigger" procedure. 2) Using an ATO pager 3) while developing a layout, using the option "Apply" instead of "OK"…
How can we turn off the "show all" option in columns by default ?
Hi all, everything is in the title : How can we turn off the "show all" option in columns by default ? We are deploying our reporting and encourage users to use the "configure layout" option. However very often when they use an entity by column, they complain because a lot of columns are empty. Can we turn off the "show…
HTML5: Copy & paste for objects and data layouts
Hi All, during the BoardVille-Conference in Baveno, we were shown tons of cool new features and also major technical improvements. I am pretty excited and very much looking forward to get rolling with the new versions. That said, there was one thing which my colleagues and I use very often that I couldn't see in the…
Custom ETL functions
There are a wealth of etl functions available in the ETL Function Reference, but I would like the ability to write additional custom functions which I can reference in layouts and dataflows. As as an example, I would like to define variations on the lending calculations (PMT, IPMT, FV, NPV) that use our custom business…

Layout

Discussion List