-
Add in "Layout settings" an option for the user to select how to display entity members.
Hello @Product Management Team , I would like to share an idea from a customer that could be helpful for dataviews. I don't think I found another article with the same precise request. Functional requirement and known limitation : Let the "User" visualize the entity members "by row" (or "by column") with a different…
-
Unbalanced Hierarchies - Allowing "selection mode" configuration in dataflow and export
Hello everyone, Yes, this is my first post on the community. Following internal advices and multiple external feedbacks I'm sharing this Idea that seems to never been raised. My idea is to allow a developer to configure the default behavior expected on an unbalanced entity selection, only by configurating option mode to…
-
Can you calculate with an entity?
Hi, you can display entities in a Dataview, but can you also calculate a new value with these entities in an algorithm, as you do with cube values? We want to multiply a cube value and an entity value within a Dataview. Is this possible in an algorithm? Kind regards
-
Temporary Entity
Just like we have temporary cubes in procedures sometime we need dummy entites of one or two members may be more depending upon calculations, so like temporary cubes how about having temporary entites??
-
Configuring Entity Selections to Apply Only to Charts, Not Data View Grid
Hello Team, I have a page with entity selectors, corresponding charts, and a data view. However, I need these selections to apply only to the charts, not to the data view grid. In other words, they should not sync with the grid. How can I implement this?
-
Best practice data import and update CSV
Hello, I'm new to the board world and am having a bit of a hard time finding the right way to import weekly updated data from a .csv file. What would be the correct/best procedure to import the data and update it weekly. I'm really missing the common thread, where should I start? First create the entities or cubes or data…
-
mirrored Leaf in unbalanced Hierarchie
The unbalanced hierarchy is a strong function. Unfortunately, it is only possible to aggregate using a single tree. Hierarchy nodes Description Root Node A node that is not assigned under any node and has no parent node (predecessor). Node A node that has successors, which means all nodes except for leaves. Leaf A node…
-
Dynamic Data View Block Headings?
Hi, I would like to ask everyone: what options do we have when we wish for dynamic headers in our data views? My client is still in Board12, but we have a Board14 upgrade planned for the near future. Specific issue: the client would like to have a report that has dynamic headers with regards to months and versions. There…
-
How to calculate % of current month using Days cube
Hi Board Team, I would like to calculate how many percent is passed for the current month. Basically, use today's date divides no.of.days in the current month. For example, today is 9th Oct. I would like to achieve the calculation of 9 divides 31, which is 29%. Can I use BOARD default time entity Day and Month to achieve…
-
Best practice to reduce Max Item Number for Entity
Hi Team, We created an Entity with Max Item Number = 1000. It is too high. I want to reduce the Max to 300. If I want to make this change directly in Production environment, what are the steps? If I reduce the max from 1000 to 300, do I need to re-run data reader or anything else? Thanks
-
Entity 'Copy' feature should be made available, apart from the 'Replicate' feature.
Hi, I hope this IDEA finds you all good and helpful. This IDEA concerns a simple feature that is currently not available in the Board application and making this available can help solving many issues related to the Incorrect reports and data. Cause of IDEA: Many users use the 'Replicate' feature, thinking that they are…
-
Setting time range and time entity relationships
Once a year, I plan a task to extend the time range by one year. I tried extending it by a year, which resulted in unexpected changes to the time entity relationships. In the example below, the number of child entities Month for FY=2023 should remain 12, but has become 3. Before the time change After the time change I have…
-
B14 - Less clicks, less blocking popups
Board 14 requires in some parts too many clicks which slows down the process working with e.g. the data model. An example - Adding an entity: B12: +Entity (1st click), Save Changes (2nd click), Next Entity … B14: + (1st click), Entity (2nd click), Create (3rd click), Wait approx. 3,5s for Popup to disappear, Close (4th…
-
Error On-screen selection (cont.)
We're facing the same problem as this issue, but I have not been able to solve it with the same workaround. I am having trouble because even though I have narrowed down the entities displayed by screen selection, entities that are not selected in the data view are also displayed. I have certainly created paent-child…
-
Error that table borders are not displayed
Hello. I have a problem where some of the borders on the left side of the data view I am creating are not visible. Please see the attached image for details. The left border is not displayed for industries colored in yellow. In another data view with the same template and settings, the borders are displayed correctly. For…
-
Is there an ETL function for counting row?
Hi, I've got a cube that requires a line reference number as a dimension (from the load table) - I'd like to add a row counter to the ETL in the data reader where this cube is populated, but I'm not sure what the function would be (or if one exists). Does anyone know what the function is or a workaround? Thanks!
-
Error On-screen selection
Hello, I am having trouble because even though I have narrowed down the entities displayed by screen selection, entities that are not selected in the data view are also displayed. There is more than one user experiencing this phenomenon, and even within the same capsule there are DataViews with and without this phenomenon.…
-
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
-
Level 200 Module 209: Build Account Tree Hierarchy, Data Reader Issue? No records were loaded
Hi Team, Create the Account Tree Entities and built the relationships between them. Also Built data readers to load Entities, Members, and to establish Relationships. But when I Run the Data reader(H - Account Data Reader) no members are coming in Account Entity. Please help me to figure it out. Thanks in Advance.
-
Show Currency/Unit of Measure next to values
we are having since years requirements that we want to show the currency next to a value or the unit of measure next to a quantity. e.g. Material xy —> purchasing order quantity 1.000 M (meters) No consultant was able to show me a solution so far. But I know this working in other tools (e.g. QlikView).
-
SVG-Icons for Entities
I suggest the possibility to add own SVG icons to entities. This makes it possible to display them instead of or in addition to code/description in selectors, diagrams and dataviews. This option is particularly interesting for grouping entities, workflow entities or other static entities. It is important that these can be…
-
Entity editor
If you place the Entity Editor and the Data View on the same page, you will not be able to see the contents of the Data View. How do I put them on the same page?
-
Data flow: Copy cube down to a more granular one
Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one. The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be…
-
Add sorting information to Entity-Export
We currently get information about the members of an entity to be extracted as Code/Member for standard entities and Code/Member/Parent for UBHs. Unfortunately, although there is an option to sort entity members by "Custom" (and we can import the sorting order for those entities), the sorting order information is missing…
-
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. It would be ideal if the Default button would be visible at all times, or maybe have an overview window (like the Normalize window), where you could set up the default mapping. In the…
-
Quickly adding/dragging of Entities or Cubes within the Mapping page of DataReader
Just to make life easy, we should have a checkbox beside each entity/cube which should allow the developer to select multiple entities or cubes with the help of ☑ or [Ctrl + select], and then drag it at once. This should be applicable for all versions including Board 14.
-
How to use Unbalanced Hierarchy
1. Abstract A common requirement when structuring hierarchies in Board is to create an unbalanced hierarchy, Board facilitates this with a dedicated feature “Unbalanced Hierarchies”. 2. Context Unbalanced hierarchies can be a very useful addition to a Board solution; however, how to define and maintain them requires some…