Layout

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…
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

Discussion List