-
Check all related objects in Impact Analysis
It would be useful if the Impact Analysis would show all related objects. Here are examples where Impact Analysis are missing related objects. Entities —> Entity Format Cubes —> Rules Data Reader —> Capsule Procedure Data Model Procedure —> Capsule Procedure Capsule Procedure —> Rules
-
Edit Code in Entity Editor
It's great that the User can edit the Description in the Entity Editor. It would also be useful if the Developer can give rights to edit the Code as well.
-
Set duration for a popup notification
It would be useful to have the possibility to set the duration for the popup notification. For better user experience, in some cases I don't want to use the non-popup notification, where the user needs to click "ok" to continue. But using the popup notification, sometimes you barely have enough time to read the…
-
Opening Balance Roll Forward over all future Periods
Currently Board has no "native" Opening to Closing balance function. Currently this can be handled using Nexel or using two cell blocks and a formulae to reference the block before. The first alternative using Nexel works but is tricky to set up and is associated with a specific view. The second is worse as the roll over…
-
Localization - possibility to Import/Export text in localization file
Hi all, It would be useful to have the ability to import text into the localization file or maybe Export the file instead. If the text I'm loading matches, then it performs the replacement in all the languages I'm importing, if it doesn't exist in the collect it is ignored. Thanks
-
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…
-
Total Last Value function
Total Last Value function – the Customer would like the “total” functionality to be extended and include a last value option (i.e., the total line should show the final number of a time series). Currently only SUM/MIN/MAX/AVG/CALCULATED are available. In the picture below the total should show 3 (last value of the series)
-
Adding "Apply entity selection to screen"
Hey, when e.g. using "fake" selectors on screens to add different selections based on cube like currency on a country selection etc. you always have to use the "Apply selection to screen" option. This "apply selection to screen" then always overwrites the "default" selection when resetting selections on different entites…
-
Summary Algorithm NOTOTAL for Column Algorithm (Layout)
Hi all, it would be great to have the same function (NOTOTAL) for column algorithm as in the data selection. Attached you will find a screenshot. Use Case: Column algorithm calculates a percentage of a data selection. Down totals for data selection are required, but down totals for column algorithm in this case makes no…
-
Smart Import tick/save - change to "Import"
The Smart Import has a tick button to import the lines. This button has a tooltip that says "Save". This is not true, it isn't saving, it is importing. Can you please allow for this button to be changed to "Import" or at least if the tooltip could be changed from save to import, at least that would help a little. It's…
-
Rich text box, could the toolbar be docked please
Currently when using the rich text box there is a floating toolbar. The toolbar is nice, there's bold, underline, etc... but because it floats over the top of the text box, it can obscure the text while the user is typing. It is annoying to have to move it. To improve the user experience please dock the floating toolbar in…
-
(SOLVED) Count contents of a BLOB cube
*** See solution in comments below *** Original Idea: I would like to be able to count the contents of BLOB cubes - I want to know how many records they hold and I want to compare this information. To give some context. I have a blob cube which contains property images. Not all properties have images. For those that do,…
-
IF THEN ELSE
In the if-then-else step in procedure, A feature can be added where we can compare the value of two cubes instead of just numbers. It might save lot of efforts.😀
-
Drill Through - footer conditions in query
For now its possible to define 'Where' conditions only. It would be helpful to define footer conditions too. Examples: GROUP BY ORDER BY LIMIT FETCH FIRST X rows only ... Applicationexample: Our users can do a drill through on P&L Lines and can get all booking details --> its a large table in datawarehouse. In some cases…
-
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…
-
Option of restricting elements for selectors
Up to now, for a selector, there was only the possibility to display all elements or only the active elements. However, I had the requirement in many projects that the selectable elements should be restricted depending on other filtering. Reasons could be for example: Elements of entities are no longer valid, but should…
-
Number Scaling - formatting options
The new function is pretty good - but it would be really good, if there would be some formatting options for the number scaling —> e.g. k instead of K or T instead of K etc. Also deactivating the suffix would be great - so just having the value without K/M/B
-
Database Security / Transporter
Hi All, it would be really useful if the Board Transporter Tool would consider and work also with the Database Security Profiles. There are many alternatives (especially for customers working with the Subscription Hub) but it would be a great enhancement. Thanks, federico
-
Enhance user experience by adding search functionality
Sometimes, when working with databases providing more than just a couple cubes or entities, finding the cube or entity you're looking for in the drop-down lists can be pretty cumbersome when no search function is available. Consider this example from the action library for calling a procedure If, however, developers would…
-
Extract Cubes in Parquet-File
1. What is your idea? Board has multiple steps to extract data from cubes: Extract Cube Export Data View to file Export Dataset Extract all cubes All these steps save data as text or csv-files. We could save disk-space and increase performance by using parquet-files. Head-to-head comparison CSV Parquet Row-based storage…
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…
-
Option to Hide Tabs
Dear all, The tab container is probably one of the most used objects across many applications and in my experience an absolute customer and user favourite. Sometimes, it is necessary to remove tabs for a certain situation but you want to keep the contained dataview for future use. Saving a backup screen, deleting the tab,…
-
Default Entity Member Labeling Convention to Excel Tab upon Export
When exporting a Board screen to excel and choosing to page by a given entity that within Board has been set to "code" as the default setting for that entity, the exported tab pages within the excel document appear as the description of the entity member and not the desired code of the entity member. It would be helpful to…
-
Codes and customer description in multiple columns.
Need to bring codes and descriptions in axes of the layout separately as individual items rather than single item. The requirement is to have the codes and descriptions of the multiple entities in separate columns rather than code or desc or both in 1 column for each entity in the axes. This also resolves the sequencing…
-
Possibility to define datetime function formatting
ISSUE: Datetime is always restricted to the cultural settings of the user (or in some cases the computer) that uses it. This could cause issues when, for example, an export of a cube that has a timestamp in it (that was created using datetime) is expected to arrive in certain formatting, but a user with a different culture…
-
Hide Screen List configurable depending on users
hide screen list options is a ON/OFF option it could be useful have the capability to deactivate it for some users (e.g. administrators or process owners for an application). It could be made on different levels: as default, in security profile settings (e.g for administrators) at capsule level, defining exceptions on some…
-
Close Message Option
It would be great if the option existed to close the informative Board messages that appear on the screen (example below). Although they only appear for 3-4 seconds, it can be frustrating when trying to work quickly as sometimes the next button you want to click is behind this message. It would be helpful to be able to…
-
Automation possibilty for "Sparsity Optimization"
We very much appreciate the new sparsity optimization feature that makes manual export/import obsolete. It would be great if this function could also be automated. There are use cases in which plan data is cleared or zeroed out again, for example, but the sparsity remains full. Therefore, it would be very helpful if the…
-
Deleting entity elements made easy
There is already a guide on "How to remove obsolete entity members". However, this process should be much easier. It would be great if entity members can be deleted easily by hand. Especially, in big databases that would be a huge relief because it wouldn't be necessary to reload the entity and cubes. As a bonus, it would…
-
"Min" and "Max" as aggregation-functions
It would be very helpful to be able to select "Min" and "Max" as aggregation-functions on an entity, in addition to the existing "distinct count", "average" and "sum" (see second screenshot). Right now it is possible to display the min- and max-values as a row total (see lower dataview in the first screenshot), but not if…
