-
More detailed database logging for compliance
As we grow every year and acquire bigger customers who have governmental or agency obligations, we are getting more questions around the accuracy and detail of the various Board logs. A couple of ideas based on customer feedback are outlined below: 1. The ability to show the detail if the line in the procedure completed…
-
Suggestions for Card Object Enhancements
Suggestions for Card Object Enhancements : Request to you include some enhancements in the Card Objects 1.Date Format should be in the Calendar form If the data entry is enabled on the Date type cube in the card Object, it should show the calendar option to input the date. As of now, it is a simple input and doesn’t give…
-
BOARD INTERNAL CONNECTOR
Hi community. My environment is based on sevaral databases, mainly set by function, and there're various procedures to move data from one db to another. Such processes are managed using cubes/trees export and reload. But in my opinion it would more comfortable have a kind of "internal connector" that allows a direct…
-
Launch Broadcast command from a scheduled procedure
Hi to everyone, it would be very useful to have the possibility to launch the Broadcast command within a scheduled procedure on the On-Premise environments. Currently, the Broadcasting can only be scheduled through the appropriate scheduler in System Administration-->Broadcasting with obvious limitations such as the…
-
Exclude based on cube
Hello everyone, should it be possible to implement something not only to select based on cube but also to exclude based on cube? In the development of both screens and, mostly, procedures, this could be very helpful! Thanks in advance to anyone who will reply or join or edit my idea! Marco
-
Cube definition insights
1. Abstract Insights on cubes definition and options. 2. Context The following best practices are applicable every time a new cube needs to be created in a data model. 3. Content Some limitations and constraints but also tips and guidelines from best practices and real-life cases. Cube’s dimensions can range from one to…
-
How to show the value of different dimensioned cube only in total line
Here is something I have implemented at a customer, and I would like to share with you. It may be helpful when facing a similiar use case. Use case One cube is on a dimension Article and cotains an Order Value The second cube is on Main Class, which is more aggregated than Article and contains a Limit for the Order Value…
-
Make Reverse Rules have full functionality
Hi, currently Reverse Rules have the following limitations: 1) Does not work if there are multiple row entities (the normal rule still works, if the level 1 entity is not a parent hierarchie of the rule entity -> reverse rule doesn't work) 2) Only works, if "Show all" is enabled on rows 3) Reverse rule doesn‘t work if rule…
-
Direct Data Entry into a Cube in a DynaWrite
I can currently enter data into an RTF cube that is used in a DynaWrite Layout, but this is only possible if I set up a data entry enabled DataView with the RTF cube (see Add Narrative below): I would like to be able to write my text directly into the data entry enabled cube in the DynaWrite (i.e. 'Project narrative',…
-
Error messages in layouts more explicit than "Oops"
Hi all, Context & issue: A few months ago, we implemented a limit on reports known as "Rows Upper Limit" to prevent users from overloading the system with too big queries (usually, addind all axis of a cube to extract everything to excel...). Due to this limit, sometimes the users have a "Oops" error in their layout, but…
-
Dynamic time offset
There is no chance to label the layout blocks with an offset. If you want to show the previous year, the block has to be labeled with "PY" or similar. To handle it you have to implement a tempcube with the period entity and a capsule procedure which is triggered by screen open trigger like this: Then you can use the…
-
Dynamic Header Names
It would be great if the headers, mainly for dataviews, could be more dynamic. Variables like previous month, previous year(@Month, @PYMonth, @PreviousMonth) would be great!
-
More bigger scroll bar size
Hi, I have this request from several customers/prospects. Now, scroll bar is so small on Web client. It is difficult to hold and scroll. It should be more bigger for usability. Thanks!
-
Collapse & Drill by columns
Often we experience the need to create huge reports that contain several blocks with entities by column. This kind of layouts can generate an high number of columns, and this could have an impact on performances and usability as well. In the following example, having two cubes and two years selected, the detail by month…
-
Breakpoint & Procedure Debugger
Hi everybody, I'd like to share an idea for an improvement which will be helpful for Board consultants and developers. When we try to debug a procedure, looking for issues or investigating unexpected behaviour, we usually place breakpoint in critical steps in order to evaluate the results of dataflows, active selections,…
-
Impact analysis - Export XLSX
Hi, I find the the Impact analysis very useful but miss a crucial button namely the option to export the analysis table in Excel. Please consider incorporating it like it is used in the data layouts. Thanks in advance, T.?ulo
-
Refer a colleague to the Advocacy Program and get points when they join (200 points)
Are you enjoying the Board Advocacy Program? We hope so! We encourage you to spread the experience and joy with your colleagues. For every colleague you invite to the program that successfully joins, you will receive 200 points. Steps for participation: Your colleague will email customer_marketing@board.com with the…
-
The Use of Tab Container
1. Abstract As soon as developers face screen creation, in particular, if we are talking about reports or BI Dashboards, where usually a lot of different data has to be shown, they need to use carefully the layouts to avoid any screen object overflow and, consequently, less impactful data meaning. 2. Context In the…
-
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…
-
Data Load Guidelines
1. Abstract While developers are focused on data model creation and data integration, they need to remember that in addition to the data model structure, they have to fill this structure with data. Entities and Cubes have to be filled with meaningful data to be seen by the users. This document provides a standardized…
-
Data Transformation
1. Abstract The data transformation process can be done in three different ways: 1. with SQL transformations directly in the data source or in the Data Reader Object 2. with the out-of-the-box Board ETL function 3. after the data has been imported into Board by using the dataflow engine. The type and number of data sources…
-
Offset Rules
1. Abstract Offset rules are a type of rule which allow you to reference multiple blocks in the same layout as part of your calculation, they can be very powerful but should be used with caution. 2. Context Offset rules can be very powerful in certain circumstances but should be used with caution due to the complexity they…
-
Rule Consolidation
1. Abstract The rule is a key functionality that allows on-the-fly calculations between members of the same entity. The consolidation is a further step to physically store the result in the data model. This step is needed only in specific cases, usually when the calculated rows need to be reused as a source for following…
-
rows & columns - control execution button
It would be great if there would be a button in the rows & columns function where the user can start the execution/update of his changes —> currently BOARD is loading every step you make in there - if you made a mistake (choose wrong dimension or pull it into the wrong area) the execution in the backend/running tasks is…
-
API Related Query
Hello everyone! I wanted to know, what is the maximum number of line items that can be transferred using an API. Can anyone provide information or point me in the right direction to find out more? Thank you.
-
Forecast Screen - Show total of an algorithm switching between two cube slices
Hi, I'm currently building a forecast screen. The requirements specify the following use case: the user selects a month and yeear months up to (excluding) the selected month show the actual value months including and after the selected year show the reference value (e.g. budget or estimate) In addition, the previous year's…
-
Bug : Selecting a member on a pager is not refreshing the screen (randomly)
Hi, Randomly, when our users are clicking on member inside a pager, Board is not launching screen refresh. Users are forced to select another member and go back to to targeted member. This error is occurs quite often (like 1 member selection on 10 member selection is not launching screen refresh) I have this issue for more…
-
Transfer data from Board to SAP BW
Hello I need to send some data from a Board db to SAP BW now we're implementing this through a flat files extraction (layout export) and consequent upload to BW. Is there any other (more direct and efficient) way? SAP Connector allows write-back? thanks
-
Numbers Scaling improvement
I see the new option "Nr Scaling" in B10.8, very nice But having mixed automatic criteria may be not so nice to see Adding a choice between e.g. None / Automatic / All K / All M... would make this function very appreciated
-
Use of Number Scaling
1. Abstract A common requirement when displaying data, particularly financial data, is to use scaling – whether that’s displaying numbers in thousands, millions or whatever makes sense in order to make the displayed data more easily readable. 2. Context There are multiple ways in which scaling can be introduced when…