Board Community

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…

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…

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.

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…

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…

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

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…

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…

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…

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…

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:…

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…

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?!

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…

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…

The Board Community invites you to join us in celebrating International Women’s Day (IWD) 2023! This year’s theme is #EmbraceEquity and recognizes that equity isn’t just a nice-to-have, it’s a must-have. A critical component of this year’s campaign is education—recognizing that Equity and Equality, while often used…

With the recent launch of our new Board Community experience, we'd like to pull back the curtain and introduce the team that helped make this migration possible and successful! It is with great pleasure we introduce our Board Community team. With a diverse background in customer success, content management, marketing,…

We need a way to collect data from different platforms to load into Board. Fivetran would be a good option, but there is no Board Connector. Mainly it is about marketing data. What do we pay for advertising for etc? Does anyone have experience on this. An alternative would also be helpful.

The question below relate to a cloud installation of Board (v 12.4) Is it possible with a procedure (Extract cube) to write the file to a path locally on the user's computer. Shouldn't write the file to Azure Storage.

In local, I am able to drill down and extract the layout via Excel. I am not able to do the same in the web. The layout from which I drill down consists of a cube (hide) and an algorithm within which there is an image that I click on to drill. Could you help me? Attached are three screenshots which may be useful. The first…

Hi everyone, I wanted to put a question regarding the best practice that we follow with regard to masters (e.g., store master) or transaction files (e.g., sales file). E.g., 1) The date format for date code is YYYY for year, YYYYMM for year-month) & YYYYMMDD (year-month-day). 2) There should not be any breakage in linear…

Hello all, hope you are fine and doing well! I have following question: Can someone tell me how to easily adapt DataFlows with a similar configuration? Right now I have an entity with 100 items and I'd like to create a comparison cube with that entity (ACT,BUD,FC,PY). Each comparison has its own cube and I like to filter…

Dear all, to implement a safety stock application on BOARD I need to use these functions related to normal distribution: NORMINV and NORMSDIST. I would kindly ask you: 1. Are these functions available only for Nexel and not for dataflow? 2. I was able to use NORMINV on Nexel but NORMSDIST does not work, is it supported? I…

Hi all, I was keen on reading about the topic "Zero-Based Budgeting". Can anyone help me with any study materials or maybe the link to the webinar we had recently? Following is the link, for ref: A New Age of Zero-Based Budgeting (Thursday, Feb 25 2021) | Board Warm Regards Farifta Sanam Bora Business Consultant Simbus…

Hello everyone, I'm using v.10.5.0 and I've come across the following problem: I have a layout in the client, with some selectors. I have exported the excel file, which I can connect to Board via Add-in. Then I have created a procedure which refreshes that excel, with "apply data selection" enabled (see image). But the…

1. Abstract When saving data entry on a Screen, either the data entry Tick can be used or a separate save button. We’ll discuss which should be used, depending on several different variables. 2. Context Use of ‘on data entry’ triggers and save procedures are valid and applicable in different cases. To determine which…

Is anyone else having problems launching Academy in Google Chrome? I'm on Mac if that makes any difference.

Good Morning Everyone Some of our users are experiencing a problem where they can refresh data from Board in Excel, however when they try and drill into it nothing happens. Have any of you experienced similar problems, and was there anything you could do to fix it? We're using Board 10.0.1 and Excel 2010. Many Thanks…

Good Morning Everyone Some of our users are experiencing a problem where they can refresh data from Board in Excel, however when they try and drill into it nothing happens. Have any of you experienced similar problems, and was there anything you could do to fix it? We're using Board 10.0.1 and Excel 2010. Many Thanks…

Dear all, Maybe some of you have met the same issue: i would like to create a connection or a ROLAP cube to a ".csv" file stored in Shared Storage drive (GUI = microsoft azure) provided with full cloud version of Board (currently using 10.6). I could use the Shared Storage with:* Data Reader to load data in a cube (using…