-
Entity Editor
Dear all, I would like to have an entity editor and a data view - where I enter assignments between the members of two entities using the data entry function - on the same screen. The entity members that are created in the entity editor should also appear on this data view. However, the problem is that only the members…
-
Add Subtotals Support in Export Data Set feature for Unbalanced Entities
Currently, when exporting a Data Set from a cube that includes an unbalanced entity, the subtotals of that entity’s members are not included in the export. I suggest enhancing the Export Data Set feature to properly support subtotals for unbalanced hierarchies thanks
-
How to rename or alias header title column Dataview for entities located in axes not in data block?
I want to ask about how to rename or alias header title column Dataview? Because I have no found of solutions about it inside official documentation. Thank you previously.
-
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…
-
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…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
Edit Max Item Number
Hello, I noticed that it is not always possible to edit the Max Item Number of an entity. In which cases the max item number is locked ? Is there a way to change this behaviour ? Thanks for your help. Ian
-
"Select All" Button in Selector Object
It would be great to have a "Select All" button or option within the selector object to streamline the process of managing elements or members, especially when dealing with large lists. This feature would allow us to quickly select all items with a single click, saving time and reducing repetitive tasks. Additionally, it…
-
Native User Entity/Dimension
Ask/Idea It would be great to have a native database entity containing a member for all licensed users within the data model - to be exclusively used for cubes containing user selections that can be dynamically applied/passed through screens. Current Situation Currently you can create a custom User Entity and use the…
-
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…
-
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).