-
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…
-
Drilldown then export to Excel - how to work backwards?
When you drilldown on Board, then export to Excel, how do you restrospectively found out what you drilled down on? Effectively, the layout is filtered but the filter does not appear on the Sheet Selection, Workbook Selection, or Selection tab on the Layout. If you copy the layout back to Board, the hidden filter is still…
-
Copy Favorites from one server to another
Hi, we are updating our version and want to upgrade our server in the same step. What I would like to do, is to copy all settings (like favorites, presentations etc.), that the users have setup for themselves, to the new server. The users should basically not notice, that we have changed anything (except newer design, new…
-
What is an efficient way to calculate rolling average in a data flow?
Hi experts, I am reaching out to seek opinion on the most efficient way to calculate a rolling average based on current and prior months values in a data flow. Curious to know if using the time function period offset -1, -2, -3 etc. can be the only way to calculate this or if peope have found other ways that are maybe more…
-
What is the impact of switching a user from User(password) to User(Windows/LDAP/SAML) ?
Dear all, I'm wondering if any of you already has an experience with this kind of operation: Currently I have around 40% of my users which belong to a newly acquired company, where the Active Directory infrastructure is not merged with ours yet. To create them without waiting I had to create a specific password:…
-
BOARD 11 Randomizer Tool
WHAT WAS THE RANDOMIZER TOOL. To those that knew of it, and before BOARD 11, the Randomizer Tool was hugely powerful, allowing test models of production offerings to be created in as little as five minutes (once you knew the fields and cubes to obfuscate). Simply put, it turns real data into random data. Image 1 shows the…
-
Block(s) copy in layout/dataview
1) Copy&Paste a block is really usefull because configure each one is really wasted time comsuming (ReferTo, TimeFunctions, Format, etc...) as it is possible in Desktop client. 2) Also, copy&Paste block format would save lot of time 3) As now it is possible to copy&paste several steps in a procedure, why it is not…
-
ASSIGN the SAME COLOR CODING TO the SAME ENTITY MEMBERS ACROSS CHARTS
* What is your idea? It should be possible to assign a “standard” color to each entity member at a “capsule” or “environment” level. This coloring schema should be retained across all the different charts those items are displayed in. Therefore, similarly for what happens in Corporate Designer, when a certain item is added…
-
ADHOC Report Builder
The Idea. I would like to ask for the community to vote for the idea of an adhoc report builder for the daily user. I am aware that this idea, in various guises, has already been suggested, most recently by swathi mp in his question here. And here are some others: Adam Elvin 05 Nov 2017 Conditional Display of Columns -…
-
Google Analytics in Board
Hi all, We are bringing into Board some very basic Google Analytics data via the Data Pipeline and SQL (Visit, Bounce, Transactions etc) just wondered if anybody else is bringing in GA data? Which prompts a couple of questions; * Are you doing the same way? * If yes, are you bringing in richer data than above and what does…
-
Alerts in DataView - Not available in vertical Alignment
Hi together, I have created a DataView and wanted do display an alert on the numbers. If the Block orientation is set to vertical, it does not show the alarm. Only if set to horizontal… WHY?!
-
Board Beyond 2023: It’s time to ignite the Intelligent Planning revolution
For the first time in three years, we’re bringing the Board community together in person to discuss all things planning. We’re beyond excited (😉) for a day of visionary speakers, sneak peeks at upcoming product enhancements, interactive solution sessions, and the networking opportunity of the year. Best of all, Board…
-
Relationship
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…