-
Downloading/Extracting files to selected folder
Cloud, Version 12.6 It would be convenient if you could choose where you download/extract files. Today, Extracting an Entity ends up in the not accessible C:\. My suggestion is that the file is downloaded to your "Download" folder on your Computer ("My Documents") or that a File Explorer opens up and you can select where…
-
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.
-
Is there a way to default the naming convention of exported excel tabs to code for the entity 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 and not the desired code of the entity.
-
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…
-
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…
-
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…
-
Default setting for Relationship
Hello, When there's a parent missing to a child, the Default button becomes visible. But if there are no errors, you won't see the button. Is it possible to set the Default mapping for each Relationship from somewhere else, even if there's nothing missing at the moment? Thank you
-
How to structure cubes with slow moving hierarchy
1. Abstract A common challenge in a Board Application is to fulfill the request of tracking changes in hierarchies, which by definition are the current snapshot of a relationship. This article describes how to keep track of the historical situation using a cube and dedicated entities. 2. Context Since a hierarchy in Board…
-
Extract/Import Trees Unsorted
Hello, I'm sure any admin of BOARD has faced the issue needing to refresh Development Cubes/Entities with new info from Production. I'm sad to say that this process is FAR less straightforward than it would seem. It is very frustrating to always have to follow the steps of : A) Remove all sorting of entities (Production)…
-
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…
-
Entity with many levels - suggestions
Hello, We have a new customer that has an Account dimension with nine levels (!). It's an Unbalanced Hierarchy. Before we start to build too many objects depended on the Account entity/entities, we would like to ask this creative Community for input and knowledge sharing. This object(s) should fulfill our need of: -…
-
Entity Definition - Concatenation or not
1. Abstract In complex applications, we often face a situation where we have too many dimensions structuring the cubes. In such cases, it is necessary to evaluate the impacts on the usability of the application, and to measure the risks on the overall performance. In case of performance issues, one of the possible…
-
"Expand Above" in Data View
Hello, Version: B12.6 In data views with more than one entity per row, headers are automatically added for each entity used. Like so: However, if we want to have the summation going [b]down[/b], a subtotal at the bottom is required. This means that we end up with an empty header row, which just takes up space. My…
-
Show "Entity used in selection"
1. What is your idea? The Idea is, to show in the Entity list of the database a hint, if this entity is used in a selection (like “in use in a cube”). In addition, there should be information on which elements the selection are based on. Also where the selection is set (which Screen, Layout, etc.) 2. What specific problem…
-
How to Format a Report and Create Entity Members
1. Abstract Financial statements often require indentation of account names, and special formatting of account names, values, column headers, totals & subtotals. Such formats may include highlighting, bordering, adding prefix/suffix, number formatting, and more. The dataview object can be fully customized leveraging…
-
Auto Max Item Number
1. Abstract One of the initial steps of the development phase in a project is the creation of entities. The most important property of an Entity is the Max Item Number which needs to be defined carefully, considering the effect it has on the performance of the application. 2. Context One of the entities’ most important…
-
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,…
-
Multiple Cubes or Measure Entity
1. Abstract Using a measure as a dimension in a Cube should always be weighted based on the aim. The balance between the Cube size and Cube proliferation, how the measure will be shown in a layout, and any calculation between different measures. Board exploits a multidimensional and a multi-Cube database. When designing…
-
Relationship
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…
-
Display internal Entity member ID
1. What is your idea? The Idea is, to display in the entity section of the database the internal ID of Entity members. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Board technology saves any selection on entity members on the internal ID of the entity…
-
How to Edit the Max Item Number
1. Abstract The Entity ‘Max Item Number’ is used to reference data stored in a Cube version. It determines how the data pages are physically stored and influences performance as much as dataflow execution. 2. Context The amount of master data will increase during an application lifetime, so having a review process of the…
-
Relationship - Scanning for Errors
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…
-
How to Remove Obsolete Entity Members
1. Abstract Are you allowed to delete Entity items? What should you consider when deleting an Entity? There are different options to make deletions, like Entity extract or reload, or assigning to a dedicated dummy parent. It’s important to understand the best way to do it since both solutions have different effects. 2.…
-
How to Change the Entity Order
1. Abstract An Entity sort is a parameter set when you create the Entity, which can be updated during the development phase. It may be necessary to evaluate the addition of new members or re-evaluate the order of the elements. In this case, it’s suggested to use a dynamic sorting mechanism based on a Cube and, in other…
-
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…
-
Unassigned Entities (time entities in the entities menu)
Hi, I've just encountered an issue in a customer I haven't seen in some time: a database which its time entities suddently show up in the Entities menu, on the bottom part of the list, inside a group tagged as "Unassigned entities". - Board version: 9.0.3 - Database was created from scratch 2 weeks ago - Database contains…
-
Enhance the Availability of the Layouts to the Mask
Hi team, I have an enhancement request below. Request: Enable Data Layout in the Mask Purpose: Display the Entity Member regardless of its number Background: I was trying to output the entity which has only one member using label, but it says "All" if the entity has only one member. I received the suggestion from the…
-
Unbalanced Hierarchies for Columns
Is there is way to get unbalanced hierarchies on columns? For example, if I have the following structure: + Organisation --+ Locaiton ----+ Business And I have only one Business at a particular Location, I don't want to see a column with the Business, then a sub-total of the one business with identical figures. Any way to…
-
Combing data from two Entity Trees
I use board 10.5 + webclient. I have data in Cube X that I need to transfer to Cube Y. Entity Costcenter - Root level has 450 entities that match to 50 entities in Employee - Costcenter. I use a Select in the dataflow for the PL account to only write in 1 certain account in the PL. When I know excute the dataflow the data…