-
Assume Zero for Loading Blanks to a Numeric Cube
Overview When loading data through an file datareader, I commonly see blanks in a CSV file. If I try to load this field to a numeric cube (Integer, Single, Double), I may see something odd. The datareader will run fine. There will not be any errors thrown. Since these fields are blank, no data is loaded, which is fine.…
-
Blockchain Datareader
Background Blockchain projects represent a new datatype with some fascinating properties. These global, distributed, decentralized, immutable ledgers use cryptography to account for digital tokens. Just as we need to pull from databases and ascii files, loading a blockchain into BOARD could prove to be a helpful tool in…
-
Excel Datareader
While I understand why CSV files can be more standardized and consistent for ETL processes, I think it's time to add Excel as an option for a datareader. A user can specify the filename, and tab name to be used for the datareader. Use Case * An excel file is produced and placed on a network share * A user clicks a button…
-
FYTD in Dynamic Select
The Idea. To allow a FYTD to date option in a dynamic select. Why. Currently a dynamic select allows the user to be able to select the YTD based on a cube or the current date. For financial reporting purposes, I believe a FYTD would be more useful so having this option would be nice. Current process. Using a series of…
-
Integrate drill through results in reports
Hi all, I want to use drill through results in dataviews and charts. If I'm not mistaken the drill through only opens a table with the results from the query. The idea is to integrate relational elements with the board elements as if they were the same. That way I can have a quick analysing tool with a small DB footprint…
-
Refresh of multiple screen/tabs
In 2 projects that we have developed in Desigual, 2 different group of users have asked us the same wish: To be able to refresh all the open tabs (since they use Board Web) at the same time, either when you perform a Data Entry or when you click a "Refresh" button. They usually work with 2-3 tabs open, using 1 of them for…
-
In-Line Drill Down (excel style drill in native BOARD)
This is idea is essentially to provide the ability/option to drill down in BOARD the same way that it works in Excel with the office Add-in. When drilling down on a layout in Excel it does it what I call 'in-line', in that it expands/inserts down to show the detail in line. It doesn't have a drill pop-up like in native…
-
Require Single Member Selection on Selector
I would like the ability to configure a Selector to require a single member selection on an Entity. Both on screen and in Interactive Selection procedure steps. Very often screens, navigation, and procedures are designed to work on one member of an entity at a time. For example a trigger in a budgeting application should…
-
enhance dataflow understanding for cubes' structures: new tab in dataflow layout
1. What is your idea? the idea is to help the developer who designs dataflows in procedures and help him understanding at a glance which entity structures from both factor and target cubes are involved in one dataflow. This understanding is very important for designing and maintening dataflows. * I would wish a new tab in…
-
Web GUI for Server Config and Adula Params
Hi All, We have the following situation: You can edit the functions od BOARD and board server via the serverconfig GUI, via boardengine.exe.config (XML), via server_config_v2.xml (XML) and via adulaparams.xml (XML). The current situation brings some challenges: * There is no GUI for BoardEngine.exe.config and…
-
display existing procedure's name while renaming it
1. What is your idea? Simplify a small task that happens sometimes : renaming existing procedures. Currently the procedure's name is always empty when I click on "rename" I wish the existing name of the procedure would be displayed, so I can directly amend it. 2. What specific problem are you trying to find a solution to,…
-
Alerts in GroupBy (WEB)
That would be nice if we could see a one single colour alert on GroupBys instead of some portions of different colours depending on the behaviour of what happens inside the GroupBy. Nowadays, only Circle option works on Web GroupBys. Figures, Blocks or BlocksOnly options don't seem to work for GroupBys on Web. You will…
-
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…
-
Custom dataview options and actions
BOARD already uses the design of having users mouse over an object and then see additional options related to that particular object. I would like the ability to add options or actions to particular objects on a screen. Maybe this is already possible, but I don’t know how to do it. If that’s the case, please let me know…
-
Transporting Entity Templates
Version 10.1.4 of the Transporter supports the transportation entity templates, but not formatting changes. New entity templates are transported. The support for entity templates feels incomplete without the ability to transport formatting changes. Se we have to continue manual transportation of template changes by copying…
-
Save Capsule as - Copy Folder
Hi Guys, Many times I had to copy one or more capsules both in my local environment or from the production to the development one. As yuo can image, big applications can have more than just few capsules. Unfortunately actually it is not possible to copy more than one capsule at time. Therefore my proposal is to add an…
-
Cube Title as a Combobox
When I view the structure and versions of a cube, the text box can be changed to change the name of the cube. This is helpful when setting up new cubes, but doesn’t facilitate reviewing multiple cubes quickly. I would like to see a selection arrow at the right end of the text box that allows a user to select a different…
-
Export Data to Excel in Flattening mode for Web client
Hi everyone, The title says it all, the "flattening" mode is very useful for users and it's not available in the web client. Current issue: * In the Web environment I want to provide users with both a nice visual (through a collapse presentation) and the possibility to export and reuse properly the data ("flatten groups"…
-
Service Windows / Maintenance
During the lifecycle of one BOARD project, we may experience the need to execute critical actions on database structure that require the exclusive access. This means we have to be sure that Users cannot access to the system and/or execute any kind of actions, especially run procedures, data entry, ... This becomes more…
-
Turn off 'Alerts' on down totals/group by
Sometimes the 'alert' on a total line doesn't make sense, and sometimes when a Dataview is collapsed and it lists ALL alerts on the 'group by' heading it become unreadable. It would be handy if we could control these to elect not to show alerts on totals and group by headings. There currently is no work around other than…
-
Home Screen choice straight through to capsule -Web
In respect to web. (I am aware this is possible on the standard client) There are particular user communities that don't need to navigate through favourites, folders, capsules to complete or see their task, examples are users who return to the same information and indeed that might be their sole use. As we grow BOARD in an…
-
Save Current Selection upgrade
Hello, i usually find myself in this situation and was hoping this idea might be helpful for everyone * What is your idea? Add a flag "Share" to the "Save Current Selection" action in order to allow this saving to survive at the end of a procedure and to be recycled in other procedures. * What specific problem are you…
-
"Hide Based On" in Layout block
Similar to the 'Locked by' option within a block, it would be handy if we also had the ability to 'Hide based on' for a block. So that if the 'based on' block is 1 this block would be hidden (as opposed to 'locked'). This would enable for a more simple hide/show of blocks in a dataview etc. This can already be done with…
-
Dynamic Selection within Layout
A good improvement would be the chance to set up a dynamic selection within Board Layout. This way you should be able to create different infromation scenarios in the same screen according to cubes parameters or current date.
-
Downtotals without grand total line
Hi everyone, As previously discussed in a forum thread with Gabriele Gallo and Paul Stegmann and in the Board support with Antonio Speca, I found myself several times in a situation where I needed downtotals in a layout, but wanted to hide the grand total line. Solutions already suggested: - disabling downtotals (not…
-
Aligning Screen objects over multiple screens
It would be nice to have the possibility to align a screen object within screen A with a screen object within screen B. At the moment it is only possible to align screen object within the same screen. Alignment over multiple screens would make it much easier to achieve consistency regarding placement of pagers, selectors,…
-
Drill Peek
When navigating a grid dataset, we already have the option to make each cell a button. From that button, we can drill to a screen or protocol for more information. Doing so opens the target in either the same tab or a new tab, changing the focus to the new screen. I think it would be nice to provide a peak tool, such that…
-
Web chat users groups
Hi all, it would be useful to create user groups to allow the division of users in their own areas. In addition to these groups it should then be possible to manage a sort of security to indicate to which groups each user should have access. This idea could be useful on large environments with a lot of users in order to…
-
Cubes tab to show Cube Entities and Sparse Structure
In bigger projects where you have a large number of cubes, it is often required to review cubes structure. i.e. Cube Entities or Sparsity. At the moment, the only way to do this is to click on Cube and open Cube structure window. It would be nice to have another column on "Cubes" tab showing Sparse structure and Entities…
-
Search field on cubes
Hi, it would be very useful if you could add a search field on the database cubes. On very large databases, it is impossible to find a specific cube easily. It is good practice to create meaningful groups and sort the cubes in alphabetical order, but sometimes this behavior is not enough. Thank you, Francesco
