-
Can I specify the position of data label and change the color?
Hi BOARD team, I had a chat as following with primary axis (Bar) and secondary axis (line). I choose to show data label for both. At some months, those two numbers will overlap. Can I force the data label for the bar showing inside the Bar? Can I choose color for the data label? It seems like it is only default to black.…
-
Raise the limit of Custom Time Entities on Time Range
Main Idea: Today, the number of Custom Time Entities is limited to 4. My idea would be to raise this limit number to at least 10. It would be great to have no limit, if possible. The last project I worked on lasted 40 days. If I had a free custom time entity, I could have saved around 3 to 4 days of work, which is a…
-
Save Time and Resources with Board
Featuring: Community Captain Sergi Fernández — Business Intelligence Consultant, Holistic Data Solutions SL. In today’s fast-paced business environment, efficiency isn’t just a luxury; it’s a necessity. Companies are constantly on the lookout for ways to optimize their processes and leverage technology to drive performance…
-
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Office Add-In losing layout
Hi, we are using the office add in, in excel to link some of our reports with board directly onto one or more excel files. These excel files would contain more than one tab with reports connected to board. What we have seen is that at random occations our reports in excel would stop updating. When we try and view the…
-
"Export to flat data file" option when using SendTo/Subscribe/Broadcast procedures
Hi, everything is in the title, most of our users export to Excel using the "flat data file" of the board add-in even if they are not using the addin. However this option is not available in the SendTo, Subscribe or Broadcast setups, which is limiting a lot the use of these functions. Can you please add it ? Thanks, Etienne
-
How to apply Dynamic selection of yesterday to Layout Block?
Hi BOARD Team, BOARD system had a default entity for Day. How can I use procedure to make a dynamic selection of Yesterday and assign this selection to a Layout Block? Thanks
-
Grand Total Group by format
Hello, It would be helpful if we could, in a layout, change the format Color and Font) of the Grand Total Group by. For now, it is not possible to identify easily the line (see capture attached) when the groups are collapsed. Thanks
-
How to show the "%" simbol in Excel Board Add in once exported from the reports?
Hi we are currently exportign reports from Board into excel with the "Microsoft Excel Workbook for BOARD Add-in" option selected. Because this setting does not allow the template to export as well, we cannot see the % signs on spesific rows in the report as we had to add them in using the template functionality. Is there a…
-
How to hide / show a row based on cell condition?
Hi BOARD Team, Is it possible for me to hide the row where all cells are in green? Basically I only want to show rows where there is Orange or Red. The logic for the color alert is If a/b < 0, then it is red. If a/b < 4, then it is Orange. Others are green. I am struggling to come up with a way to only show the row where…
-
Quality of life improvements for charts
Pretty sure there are some more points to improve within the chart component but here are 3 proposals to add, as we often see them as requirements in our projects. While it is possible to achieve the desired results with the existing toolset, it could be easier to implement and therefore also easier to explain to customer…
-
Show all values in chart labels
Hey, is there any chance, that we can tell the chart to show all the values of each series regardless of its size? Here is an example:
-
Yearly Cumulated Value + Detail by Year in block
Version 12.6 We have a MTD cube, with a selector of generic fiscal period (1-Jul, 2-Aug, 3-Sep…12-Jun). I have a block with MTD value with "detail by fiscal year" set and "Tme function>Yearly Cumulated Value (fiscal years checked)". No time entity in rows or columns. The MTD cube contains 6 years - all years are 0 amount…
-
How to create a variance on one cube detailed by version
Hi, I am trying to create a variance column based on one cube that is detailed by version. The problem that we have is we have data in one cube by different versions. We have to create a report to compare versions together but we must be able to select any versions which means I cannot create a block reference on teh cubes…
-
How to manage the leap year in comparative analysis
1. Abstract In an application life cycle it is not unusual to come across leap year management, moreover when comparative analysis are put in place. Accurate handling of leap years ensures data consistency across different timeframes, preventing discrepancies when comparing results from different years or performing…
-
Comparison between different versions or scenarios in the same report
1. Abstract During the implementation of any application, a typical request is to combine multi-scenario or multi-version information in the same view to promote delta analysis and quick data comparison. Board plays an important role due to its flexibility and allows a solution to be achieved in several ways to provide the…
-
Displaying revenue data for bissextile year with previous year function
Hello, I am facing a challenge with displaying revenue data for bissextile years when using a previous year function. We have a cube by day, and a screen selection on the current fiscal period (March2024-February2025), a dataview that shows the revenue for N and revenue for N-1 values. The issue regards the N-1 column on…
-
Dynamic and Cube-based Layout Selections
On searching the Idea Exchange there is an old suggestion: "Dynamic Selection within Layout" from 2018 by an Unknown contributor. The Idea received 47 votes - as follows: "A good improvement would be the chance to set up a dynamic selection within Board Layout. This way you should be able to create different infromation…
-
Dynamic Decimals on report views
Hi team! We've recently had two customers and a partner reach out about the request to dynamically show or not show decimal places. Right now, it currently requires work arounds that involve layout adjustments or duplicated screens. We would like to request the ability to adjust the decimals we are viewing on a report…
-
Save filter values in selection
We would like to have the ability to set a permanent filter value when a selection is made on a screen. This selection should remain even if the entity values are deleted. This is currently not the case. For example, if customer XYZ is currently filtered on the screen and the customer is deleted from the entity, the filter…
-
PDF Export - Suppress blank pages
Issue: When exporting reports using the Export PDF feature, subscription, or broadcasting, there are blank pages that the customer doesn't want. Proposed Solution: Add an option in the export PDF setup to automatically suppress blank pages - like the "Preview page" and "Select" ones. In one of our cases, for example, this…
-
Repeat by Cube Feature
The "Repeat by Cube" feature is a transformative tool that addresses the challenges of report bursting when exporting data. By organizing and pairing related entities within a cube, it enables users to manage and analyze data more effectively, significantly enhancing the efficiency of report generation. This innovative…
-
Board as reporting tool for controlling
Hello, Our controlling population would like to have an unique tool for reporting. So that they would like to import data from different sources not only for building budgets but also to exposing it in different reports, making multi-source reports, for example. Is this a good practice ? Don't we risk to have performances…
-
Drill-down feature on a chart
The idea is to enhance interaction with charts, enabling navigation of the entity tree. As a front end user, I would like to be able to expand (and also aggregate) on the default dimension set in the graph. In order to give an idea of the use cases, I am thinking at this kind of competitor's feature: power BI drill down on…
-
Fix Entity in Quick Layout
Would be great if we could fix dimensions within the quick layout. This is very important to allow mid flexibility within the quick layout function. Its specially important when we have a rule within one of the dimensions, that must always be there to be able to display data correctly.
-
Mandatory dimensions / consistency checks in quick layout
Context - When designing data entry screens, we are often in the situation where we want to give a maximum flexibility to the end user to choose the most relevant axis. Quick layout is great for that. Issue - However we often have the situation where at least one dimension is mandatory, otherwise figures don't make sense.…
-
Reporting Layer: Optimize a report
1. Abstract Users are more and more demanding and are looking for the right balance between the correctness of the result and the scalability of the solution at the same time. Improving response time has always been a top priority, therefore the purpose of this document would be to explain the main best practices to apply…
-
How to dynamically display the user selected value when a data view is set as master object
On the left I have a P&L hierarchy driven report set as master object. When I click on a row, the charts on the page change. I would like to display the current row that was click on in the master object. Trying this, no luck: @Selection_Ex(Layout="P&L", Block=" ") Version 12.6 Thanks! Matt
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…