-
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.
-
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…
-
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: -…
-
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
*NEW - includes video demonstration. Build Along with Board Follow along as we bring this step-by-step guide to life. https://player.vimeo.com/1103609560 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…
-
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…
-
How to Edit the Max Item Number
*NEW - includes video demonstration. 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…
-
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…
-
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…
-
Can I export an Entity row template?
Is it possible to export/migrate Entity row templates across Board environments e.g. from Dev to Production? Or to a replicate entity of the original? We have a KPI entity consisting of over 1000 different measures so it would be good to have a way of managing this other than backing up and restoring the entire database. I…
-
Can we create Relationship between two Entities coming from Different Data source, yet sharing the S
Hello All, I have got an interesting situation in Board currently, i am using Board 10.3. Generally Entity Codes are used as mapping points while creating relationship between different entities, right ?! Now my situation is as follows: I have an Entity being populated from Data Source: SQL Database, consider like this:…
-
Count selected members of an entity in procedures
Hi, is it possible to count the selected members of an entity in a procedure? I want to use it as a button function in a screen. For example, the procedure is supposed to find out when the current user calls the procedure, how many salesmen are available. Kind regards Jonas