-
Percent of total
I've got a data view where I've broken down sales into several categories. How can I get the percentage of the total sales for each of these categories in an adjacent column?
-
How to hide/ignore columns of an Excel data source when using the Smart Import Object
Is it possible to hide/ignore columns of an Excel data source if they are not relevant for the import when using the file upload of the Smart Import Object (e.g. descriptions or comments)? In the following table, columns A,B (entities) and D,E (values) have to be imported, columns C,F have to be ignored.
-
Use of Nexel
1. Abstract Nexel is a hugely powerful tool but it has its limitations, it’s important to understand when it’s appropriate to use Nexel and how best to store the original definition screen. 2. Context Use of Nexel can be hugely powerful, and in some cases necessary in order to achieve certain outcomes, however there are…
-
Managing high-volume entities
1. Abstract In complex environments, it happens to manage elements with a high volume. In such cases, it is crucial to identify the possible cascading effects on the rest of the model and what measures need to be taken when loading entities with millions of elements and evaluate in advance the possible impact on cubes,…
-
Insufficient privileges to manage this database
Hi, I am migrating a board 10 datamodel to a board 12 datamodel on a new server with an on-premise installation, I successfuly copied the database file to the board 12 database folder, I restarted the server, but when trying to upgrade the datamodel I get the following error " Insufficient privileges to manage this…
-
Temporary Cube vs Staging Cubes
1. Abstract When developers create a simple or complex procedure, they need to know that they have an advanced feature to ease their job by keeping the database simple and lean. This feature is the temporary Cubes. 2. Context Since B11’s introduction, developers can leverage the temporary Cube to store data temporarily and…
-
Process Debugger - Open Data View
Hello, In BOARD10.5, inside of the procedure debugger I could just click "Open Data View" for the step that I was on. Now - I have to either manually rebuild the data view that is being processed, or go into the procedure and copy the layout. Can we please have the ability back to simply open the data view for the step we…
-
Translation of screen folders (Localization)
Hi all, we're working with the Localization feature which works great for our purpose as we could translate entities, screen texts, screen names, and entity elements. However, as I was told by the support it is currently not possible to translate screen folders. In our case, as we work with screen folders in the menus,…
-
Divide by - Function
Hi there I have an strange issue: In the following i want to divide the values by 1000. But Board is actually dividing by 100.000:
-
Suggested Value Enhancements
It would be very useful to have some enhancements to the suggested value functionality for data entry. It is difficult to enter data quickly with the current functionality as each cell requires a click and select from a list. It would be extremely helpful for users having to do large amounts of data entry on suggested…
-
Sorting options in a Dataview
I am often missing more options when it comes to sorting the data in a Dataview. What I would love is something similar to Excel, where you can choose several columns for sorting your data. I am aware that you can choose if an entity gets sorted by ID or Description or sort data based on a cube, but there are times when…
-
Remove the capsule concept
Board is now full web solution. Therefor, is the current capsule structure still fitting? It had advantages in a desktop environment. But now, it's now lagging behind compare to other solution it terms of versatility. What we need : Every object currently in a capsule should be attached to a namespace that is store into a…
-
Quick Layout: Ability to determine which blocks can be visible/hidden to users
Hi R&D, The current quick layout configuration allows users to hide/unhide all visible blocks within the layout. I am suggesting that developers should have the option to determine which blocks appear in the quick layout configuration (same concept that exists for entities in the axes configuration). In the particular use…
-
Previous Selection
Hi all, have you also come across the desire to go back to the previous selections? Okay, Board will let you reset the selection on a specific entity and then you can select something else or you can use a vertical list and click on another member. But how cool would it be to be able to go some steps back? Example: I am…
-
Nexel Enhancement - "Auto update algorithms"
Hi fellow community members! Question: Are you using Nexel for planning screens and did you notice that changing the order of blocks in the data layout will not be reflected in the Nexel-formulas? The consequence is, that every layout change will require adjustment of the Nexel-formulas and that can become quite tiresome.…
-
How to compare the same days of a different year
Hello, I need to create a cartesian chart in order to show how much my company has sold this year and how much last year. The main problem is that we sell more on weekends, so if the first day of the year is satuarday, the year before it was friday, and it's obvious that this year performance is better than the last year's…
-
New Object: Process Mining Graph
Hi All, a while ago we at SDG have started to analyze business processes using system log files and different process mining tools. Since process mining has become quite a hype and many of our customers use Board, it would be a huge benefit to have a process graph as a new object within Board. For obvious reasons, I cannot…
-
More detailed database logging for compliance
As we grow every year and acquire bigger customers who have governmental or agency obligations, we are getting more questions around the accuracy and detail of the various Board logs. A couple of ideas based on customer feedback are outlined below: 1. The ability to show the detail if the line in the procedure completed…
-
The Board 2023 Spring Release Is Now Available
We are pleased to announce the Board 2023 Spring Release is live. This release delivers numerous improvements for all users of Board across a wide variety of business scenarios, including: Citizen End Users can easily tweak the format of values displayed in Data views and show or hide columns on the fly to customize the…
-
Suggestions for Card Object Enhancements
Suggestions for Card Object Enhancements : Request to you include some enhancements in the Card Objects 1.Date Format should be in the Calendar form If the data entry is enabled on the Date type cube in the card Object, it should show the calendar option to input the date. As of now, it is a simple input and doesn’t give…
-
BOARD INTERNAL CONNECTOR
Hi community. My environment is based on sevaral databases, mainly set by function, and there're various procedures to move data from one db to another. Such processes are managed using cubes/trees export and reload. But in my opinion it would more comfortable have a kind of "internal connector" that allows a direct…
-
Launch Broadcast command from a scheduled procedure
Hi to everyone, it would be very useful to have the possibility to launch the Broadcast command within a scheduled procedure on the On-Premise environments. Currently, the Broadcasting can only be scheduled through the appropriate scheduler in System Administration-->Broadcasting with obvious limitations such as the…
-
Exclude based on cube
Hello everyone, should it be possible to implement something not only to select based on cube but also to exclude based on cube? In the development of both screens and, mostly, procedures, this could be very helpful! Thanks in advance to anyone who will reply or join or edit my idea! Marco
-
Cube definition insights
1. Abstract Insights on cubes definition and options. 2. Context The following best practices are applicable every time a new cube needs to be created in a data model. 3. Content Some limitations and constraints but also tips and guidelines from best practices and real-life cases. Cube’s dimensions can range from one to…
-
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…
-
Make Reverse Rules have full functionality
Hi, currently Reverse Rules have the following limitations: 1) Does not work if there are multiple row entities (the normal rule still works, if the level 1 entity is not a parent hierarchie of the rule entity -> reverse rule doesn't work) 2) Only works, if "Show all" is enabled on rows 3) Reverse rule doesn‘t work if rule…
-
Direct Data Entry into a Cube in a DynaWrite
I can currently enter data into an RTF cube that is used in a DynaWrite Layout, but this is only possible if I set up a data entry enabled DataView with the RTF cube (see Add Narrative below): I would like to be able to write my text directly into the data entry enabled cube in the DynaWrite (i.e. 'Project narrative',…
-
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…
-
Dynamic time offset
There is no chance to label the layout blocks with an offset. If you want to show the previous year, the block has to be labeled with "PY" or similar. To handle it you have to implement a tempcube with the period entity and a capsule procedure which is triggered by screen open trigger like this: Then you can use the…
-
Dynamic Header Names
It would be great if the headers, mainly for dataviews, could be more dynamic. Variables like previous month, previous year(@Month, @PYMonth, @PreviousMonth) would be great!