-
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…
-
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
-
Dynamic validation for data entry
I am trying to figure out how I can create a dynamic drop list for data entry on a data view. For example: An Entity gets flagged for the creation of an incident. Once flagged, various input information is required - namely: Incident Type, Incident Category and Incident Sub Category. A user is required to capture this…
-
Deciphering DataEntry.log
The file DataEntry.log in Dataset\Log collects all dataentry values done by the user. It records original value and new value. Each line holds data related to one change. For some Selections I need to figure out what the ACTUAL values of selections are: e.g. the file records "Selections on db <DBName> - Entity: 15,…
-
Consolidated view of Infocubes by Entity
Is there a way to visualize in a consolidate view all the Infocubes that use an specific Entity? For example, I would like to know all the Infocubes that are related to the "Channel" Entity.